Grid View - Displaying Data-bound Checkbox

Question

Hi,   I am using a grid view on my aspx page.   I want to display Field text along with the checkbox.   example:   There is a database table as follows   PatientSymptoms ++++++++++++++++++++ SymptomId (1, 2, 3, ...... N) SymptomName (Symptom A, Symptom B, ...... Symptom X)   A patient will be shown list of symptoms in a grid, he has to select the symptoms which apply to his situation.   [ ] Symptom A [x] Symptom B [ ] Symptom C [ ] Symptom D   Now, I want to associate, the checkbox with the "SymptomId" field   and I can't figure out how.   I am using the following code   ' />   Notice that, I can't figure out the property whcih should be associated with the TYPE_P_ID, so I have written WhichProperty for understanding   Any comments on what is the better way to do it? thanks

Mageshwaran R · Answer

Hi, Please refer the below link, it might helps you https://www.aspsnippets.com/Articles/Populate-bind-CheckBox-in-GridView-from-database-in-ASPNet-using-C-and-VBNet.aspx

Hussain Hashimi · Answer

I am getting the following error when I set the property as
' />
System.InvalidCastException
HResult=0x80004002
Message=Specified cast is not valid.
Source=App_Web_mzf1miik
StackTrace:
at ASP.generalsymp_aspx.__DataBinding__control17(Object sender, EventArgs e) in E:\vstudio\c#\webApps\CancerWebApp2\CancerWebApp\CancerWebApp\generalsymp.aspx:line 75
While the code where I am trying to get the SymptomId is as follows:
foreach (GridViewRow row in Symptoms1.Rows)
{
CheckBox chk = (CheckBox)row.FindControl("chkIsTrue1");
if (chk != null && chk.Checked)
{
if (chk.Checked)
{
//get the ID of the Symptom
s = chk.Attributes["Checked"].ToString();
i = System.Convert.ToInt32(s);
cmd.CommandType = System.Data.CommandType.Text;
Response.Write(s);
//insert the ID into the table PatientSymptoms
//insertCommand = "INSERT INTO PatientSymptoms VALUES (" + i + "," + (string)Session["user_id"] + ")";
//cmd.CommandText = insertCommand;
//cmd.Connection = con;
//cmd.ExecuteNonQuery();
}
}
}
so basically, I have a table, called "Symptoms" which will display to the user,
when the user selects some symptoms, it will be saved in Patient Symptoms table.
which will look as follows:
PatientSymptoms
+++++++++++++++++++
PatientSymptomID      PatientID      SymptomId
1                                   1                   3
2                                   1                   4
3                                   1                   5
4                                   2                   3
thanks

Sivakumar Koneti · Answer

see this you get clarity    https://www.aspsnippets.com/Articles/Populate-bind-CheckBox-in-GridView-from-database-in-ASPNet-using-C-and-VBNet.aspx

Jignesh Kumar · Answer

Hi Hussain,   Please try below link where its exactly matching your requirement,   " chkIsTrue2 "  runat= "server"  Checked= ' TYPE_P_ID ") %>'  />     https://www.aspsnippets.com/Articles/Populate-bind-CheckBox-in-GridView-from-database-in-ASPNet-using-C-and-VBNet.aspx

Ronika Jency · Answer

Bind as below code for check box   ' />

Gajendra Jangid · Answer

Hello dear,
Please have a look at below link
https://www.aspsnippets.com/Articles/Populate-bind-CheckBox-in-GridView-from-database-in-ASPNet-using-C-and-VBNet.aspx