Retrieve Data from SQL to Checkboxlist winform

Kinjal Sonachhatra

7y5.6kVisual Basic .NET

DAL:

string str = "select * from Employee where Id=" + e.eID + "";

SqlCommand cmd = new SqlCommand(str, con);

DataTable dt = new DataTable();

SqlDataAdapter adp = new SqlDataAdapter();

adp.SelectCommand = cmd;

adp.Fill(dt);

string[] s = new string[] { };

if (dt.Rows.Count >= 0)

{

//e.eHobbies = dt.Rows[0]["Hobbies"].ToString(); //checkboxlist

e.eGender = dt.Rows[0]["Gender"].ToString(); //radiobutton

e.eName = dt.Rows[0]["Name"].ToString(); //Textbox

e.eMobile = dt.Rows[0]["Mobile"].ToString(); //Textbox

e.eCity = dt.Rows[0]["City"].ToString(); dropdownlist

e.eEmail = dt.Rows[0]["Email"].ToString(); //Textbox

}

con.Close();

return dt;

Here I have Issue about query that which query can I use for getting values from SQL to checkbox list. I want to checked the items which is already stored in database but i have confusion about query as well as code that how to get all things properly. Hobbies are belongs to CheckboxList. As well as I want to select radiobutton from database.

Thanks in Advance

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kinjal Sonachhatra7y ago
Thanks all who gave his time and support.
I have done my project.
Thanks again.
0
Sagar Pandurang Kap7y ago
Hi Kinjal,

For Retrieve Data from SQL to Checkboxlist winform :-
https://www.aspsnippets.com/Articles/Bind-Populate-CheckedListBox-from-Database-using-DataTable-DataSet-in-Windows-Application-using-C-and-VBNet.aspx

For Retrieve Data from SQL to RadioButtonList winform :-
https://www.c-sharpcorner.com/forums/how-to-retrieve-data-from-database-to-radio-button

Hope it helps........
-1
Kinjal Sonachhatra7y ago
private void btnInsert_Click(object sender, EventArgs e)
{
try
{
Entity ent = new Entity();
ent.eEmail = txtEmail.Text;
// ent.eHobbies = Convert.ToString(checkboxHobbies.CheckedItems);
//ent.eImage = Convert.ToString(image.Image);
ent.eMobile = txtMobile.Text;
ent.eCity = ddlCity.Text;
ent.eName = txtName.Text;
if (radioMale.Checked == true)
{
ent.eGender = "Male";
}
else
{
ent.eGender = "Female";
}
if(checkboxHobbies.CheckedItems.Count>0)
{
for (int i = 0; i < checkboxHobbies.CheckedItems.Count; i++)
{
if (ent.eHobbies == "")
{
ent.eHobbies = checkboxHobbies.CheckedItems[i].ToString();
}
else
{
ent.eHobbies += "," + checkboxHobbies.CheckedItems[i].ToString();
}
}
}
MemoryStream ms = new MemoryStream();
image.Image.Save(ms, image.Image.RawFormat);
byte[] img = ms.ToArray();
ent.eImage = img;
BAL bal = new BAL();
bal.Save(ent);
txtEmail.Text = txtMobile.Text = txtName.Text = "";
ddlCity = null;
lblID = null;
foreach (int i in checkboxHobbies.CheckedIndices)
{
checkboxHobbies.SetItemCheckState(i, CheckState.Unchecked);
}
if (radioMale.Checked == true)
{
radioMale.Checked = false;
}
else
{
radioFemale.Checked = false;
}
DAL dal = new DAL();
DataTable dt = dal.Display(ent);
gvData.DataSource = dt;
}
catch
{
MessageBox.Show("Enter Value");
}
}

DAL

string str = "Insert into TierCRUDwithImage (Name,Gender,Email,City,Mobile,Hobbies,Image) values ('" + e.eName + "','" + e.eGender + "','" + e.eEmail + "','" + e.eCity + "','" + e.eMobile + "','" + e.eHobbies + "',@IMG)";
con.Open();
cmd = new SqlCommand(str, con);
cmd.Parameters.Add("@IMG", SqlDbType.VarBinary,8000).Value = e.eImage;
// cmd.Parameters.AddWithValue("@IMG", e.eImage);
int a = cmd.ExecuteNonQuery();
con.Close();

This is full code of Inert value,
now i want to fetch value from sql which is comma separated in Hobbies Column,
and checked those items into checkboxlist by ID.
0
Laxmidhar Sahoo7y ago
1. string str = "select * from Employee where Id=" + e.eID + "";
2. SqlCommand cmd = new SqlCommand(str, con);
3. Dataset ds = new Dataset();
4. SqlDataAdapter adp = new SqlDataAdapter();
5. adp.SelectCommand = cmd;
6. adp.Fill(ds);
7. string[] s = new string[] { };
8. if (ds.tables[0].Rows.Count >= 0)
9. {
10. //e.eHobbies = ds.tables[0].Rows[0]["Hobbies"].ToString(); //checkboxlist
11. e.eGender = ds.tables[0].Rows[0]["Gender"].ToString(); //radiobutton
12. e.eName = ds.tables[0].Rows[0]["Name"].ToString(); //Textbox
13. e.eMobile = ds.tables[0].Rows[0]["Mobile"].ToString(); //Textbox
14. e.eCity = ds.tables[0].Rows[0]["City"].ToString(); dropdownlist
15. e.eEmail = ds.tables[0].Rows[0]["Email"].ToString(); //Textbox
16. }
17. con.Close();
18. return ds.tables[0];
0

Jignesh Kumar7y ago

Hi Kinjal,

Please find below links,

https://www.c-sharpcorner.com/blogs/bind-checkboxlist-and-get-the-selected-items-in-asp-net-c-sharp

https://forums.asp.net/t/1760616.aspx?How+to+get+the+current+selected+item+value+in+CheckBoxList+C+

https://stackoverflow.com/questions/18924147/how-to-get-values-of-selected-items-in-checkboxlist-with-foreach-in-asp-net-c/18924206

https://www.aspsnippets.com/Articles/Get-Selected-Text-and-Value-of-ASPNet-CheckBoxList-using-C-and-VBNet.aspx

Kinjal Sonachhatra7y ago

Hello Jignesh,

Thanks for your answer and time.

I have already mentioned that I want to just checked the items which is already store in database by Insert Query.

Now I want to get those Checkboxlist values from database and checked that items.

So Please suggest that.

These links also not working properly.

Jignesh Kumar7y ago

Could you please share you gridview code ?

Kinjal Sonachhatra7y ago

Hello, Jignesh

Thanks for your time and answer.

These links i have checked but not working properly.

I have used DataGridView for displaying data.

From that I want to fetch data to Checkboxlist.

Jignesh Kumar7y ago

Hi Kinjal,

Which control you are using to display values ? could you please provide more detail on question ?

Please find below link which will give you reference,

https://www.aspforums.net/Threads/200411/Check-CheckBoxes-based-on-database-value-using-C-in-ASPNet/

https://forums.asp.net/t/1859270.aspx?Check+the+Checkbox+in+gridview+based+on+db+value