text block

no one is there to ans my que hmmmmmmmm

hi siri,

U cannot display all the customer id in a text box rather u can use data grid to display all the records,
Here i give the coding for displaying in datagrid,
Copy datagrid from tool box and place it in ur form
in button click event try this code,


SqlConnection con1 = new SqlConnection("Server=LocalHost;DataBase=DatabaseName;Uid=sa;Pwd=sa");
con1.Open();
SqlCommand cmd3 = new SqlCommand("select customerId from TableName", con1);
DataTable t = new DataTable();
SqlDataAdapter dr = new SqlDataAdapter(cmd3);
dr.Fill(t);
this.DataGrid1.DataSource = t;
this.DataGrid1.DataBind();
con1.close();


In think the code will help u




Thanks
Naresh

thanku naresh