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 mail,vist,phone, another checkboxlist contains jan,feb,.......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 mail,and visit is checked in first checkboxlist, and feb,apr,Dec is checked in 2nd checkboxlist. i should retive FebComments,aprcomments,decComments 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 code,coz 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 line,ok 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 CheckboxList,ok.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

how to retieve checkbox list selected value from datatable adapter

Answers (3)