how to retieve checkbox list selected value from datatable adapter

Question

how to retieve checkboxlist selected value from dataset

sa san · Answer

its ok with ur answer but i would like 2 elbrate example with u. checkboxl ist contains mailvistphone another checkboxlist contains janfeb.......dec. based on two selection i wanted to retive particular commnts(field name in database). report_table AccSlno JanMail JanVisit JanPhone JanComments FebMail FebVisit.........DecMail DecVisit a1 1 2 3 xyz 1 2 1 2 a1 0 2 0 nocomments 0 0 0 2 if mailand visit is checked in first checkboxlist and febaprDec is checked in 2nd checkboxlist. i should retive FebCommentsaprcommentsdecComments where FebMail=1aprMail=1DecMail=1FebVisit=2aprVisit=2DecVisit=2

Arshad · Answer

Hi.Niradhip.how r u? I hope u will be fine.Dude there is some changes in your codecoz that guy is looking for to Bind the Data in the checkBoxList not in DataGrid. SAN in that code every thing is fine but Add one more lineok that has given below CheckBoxList1.DataSource=ds; CheckBoxList1.DataTextField=column name of your table; CheckBoxList1.DataBind(); It will give that particular Colum in to your CheckboxListok.Thanks Regards Arshad Khan

Niradhip Chakraborty · Answer

Retrieve selectedValue from database: protected void Button1_Click(object sender EventArgs e) { string co = Data Source=localhost\sqlexpress;Initial Catalog=pubs;Integrated Security=True; System.Data.SqlClient.SqlConnection sqlconnect = new System.Data.SqlClient.SqlConnection(co); System.Data.SqlClient.SqlCommand sqlcommand = new System.Data.SqlClient.SqlCommand(); sqlcommand.CommandText = select project from test; sqlcommand.Connection = sqlconnect; System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(); da.SelectCommand = sqlcommand; DataSet ds = new DataSet(); sqlconnect.Open(); sqlcommand.ExecuteNonQuery(); da.Fill(ds); GridView2.DataSource = ds; GridView2.DataBind(); sqlconnect.Close(); } niradhip