using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Data.SqlClient; public partial class DomHost_ClientMailingList : System.Web.UI.Page { SqlDataAdapter adp; DataTable dtMailList = null; DataTable dt = new DataTable(); SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["connectionstring"].ConnectionString); protected void Page_Load(object sender, EventArgs e) { if (Session["MailingList"] != null) { dtMailList = (DataTable)Session["MailingList"]; } mailingList(); Session["MailingList1"] = dt; btnpreview.Attributes.Add("onclick", "javascript:OpenfSecondOrd1()"); } void mailingList() { for (int i = 0; i < dtMailList.Rows.Count; i++) { adp = new SqlDataAdapter("Select Id,ClientName,ContactP,Email,Phone1,Mobile,Address from tbl_ClientMaster Where Id =" + dtMailList.Rows[i]["ClientID"] + "", con); adp.Fill(dt); } DlClientList.DataSource = dt; //DgClient.DataSource = ds.Tables["clt1"]; DlClientList.DataBind(); } }