How can I fetch an inserted multiple checkboxes value in view format ?

See more:

C#

Hi

I want to perform an insert the data and view the data . I had few multiple checkboxes in my form. I inserted the data in database now i need to view the inserted datas. Pls give me suggestion.



Thank you.

What I have tried:

private void button1_Click(object sender, EventArgs e)
{
if (validate()==1)
{

con.Open();
string query = "insert into general_ward values (@fno,@rtype,@tbed,@incharge,@abed,@specialites)";
cmd = new SqlCommand(query, con);
cmd.Parameters.Add("@fno",textBox1.Text);
cmd.Parameters.Add("@rtype", comboBox2.Text);
cmd.Parameters.Add("@tbed", textBox2.Text);
cmd.Parameters.Add("@incharge", textBox3.Text);
cmd.Parameters.Add("@abed", textBox4.Text);
string s = spl();
cmd.Parameters.Add("@specialites", s);
cmd.ExecuteNonQuery();
MessageBox.Show("Data Added");
cmd.Dispose();
con.Close();
}
}





private void button2_Click(object sender, EventArgs e)
{
con.Open();
SqlCommand cmd = new SqlCommand ("select * from general_ward where fno='"+textBox1.Text+"'",con);
SqlDataReader dr = cmd.ExecuteReader();
if(dr.Read())

{
string aa = dr["specialites"].ToString();
string[] a = aa.Split('/');
foreach(Control cc in this.Controls)
{
if(cc is CheckBox)
{
CheckBox spl = (CheckBox)cc;
for(int j=0;j<a.length;j++)>
{
if (a[j].ToString()==spl.Text)
{
spl.Checked= true;
}
}
}
}
}
con.Close();
}