How to save the selected checkbox value in gridview to db?

Question

Good day~

I have a problem that cracked my head for a week!
I have a GridView and checkboxes for every each row and a Save button. My GridView contains Serial Number, Type of Asset and Condition. I have 2 checkboxes for "Condition" which are Good or Damage. So, for example, i tick on the checkbox of Good for every each row and click save button. The problem comes!

I DO NOT know how to save the value of checkbox(Good) that i have tick!!!

Can you help me on this? please~~~ Your help is appreciated!!! thank you so much

Pankaj Rawat · Answer

Well for the checkbox problems. protected void ChkBox_Good_CheckedChanged(object sender EventArgs e) { CheckBox chkboxGood = (CheckBox)sender; GridViewRow row = (GridViewRow)chkboxGood.NamingContainer; int id = row.RowIndex; CheckBox chkbox2 = (CheckBox)GridView1.Rows[id].FindControl(ChkBox_Damage); if (chkboxGood.Checked == true) chkbox2.Checked = false; } protected void ChkBox_Damage_CheckedChanged(object sender EventArgs e) { CheckBox chkboxDamage = (CheckBox)sender; GridViewRow row = (GridViewRow)chkboxDamage.NamingContainer; int id = row.RowIndex; CheckBox chkbox2 = (CheckBox)GridView1.Rows[id].FindControl(ChkBox_Good); if (chkboxDamage.Checked == true) chkbox2.Checked = false; } and to save Data protected void btnSubmit_Click(object sender EventArgs e) { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[ApplicationServices].ConnectionString)) { int result = 0; conn.Open(); int row_Count = GridView1.Rows.Count; for (int i = 0; i { try { Label lblAssetModel = (Label)GridView1.Rows[i].FindControl( lblAssetModel ); CheckBox chkGood = (CheckBox)GridView1.Rows[i].FindControl(ChkBox_Good); CheckBox chkDamage = (CheckBox)GridView1.Rows[i].FindControl(ChkBox_Damage); string Attribute_Name = txtAttribute.Text.Trim(); bool Condition; if (chkGood.Checked == true) Condition = true; else Condition = false; SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = Insert into FeeAttribute (Name IsYearly) values (@Attribute_Name @Condtion); cmd.Parameters.Add(@Attribute_Name System.Data.SqlDbType.NVarChar).Value = Attribute_Name; cmd.Parameters.Add(@Condtion System.Data.SqlDbType.Bit).Value = Condition; int success_Count = cmd.ExecuteNonQuery(); result = result + success_Count; } catch { } } conn.Close(); } } now here i am saving data from labelif you want to save data from textboxes or dropdown find the control and then retrieve data from it. / ************ / please inform if you problem gets solved and marked is as Marked Answer;

xin yi · Answer

the checkboxes has successfully done which only allow 1 checkbox is tick the text in the textbox and the value of checkbox is saved but they are saved in new row. And the value of checkbox saved is in word of true or false instead of Good or damage. why? i left not much time to finish it sir :'(

xin yi · Answer

hm... dont know why failed delivery an email to you. nvm i post it here Good day sir I have attach my gridview to you. And here is my coding for the button save: protected void Button1_Click(object sender EventArgs e) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings[RegConnectionString].ConnectionString); con.Open(); String insCmd = Insert into Asset (Notes Condition) values (@Notes @Condtion); SqlCommand insertUser = new SqlCommand(insCmd con); insertUser.Parameters.AddWithValue(@Notes textbox.Text); //Here my problem. i do not know how to write the coding on this part to save my data into database insertUser.Parameters.AddWithValue(@Condition ); //Here my problem. i do not know how to write the coding on this part to save my data into database int Total_Rows = GridView2.Rows.Count; for (int i = 0; i { CheckBox Chk_Good = (CheckBox)GridView2.Rows[i].FindControl(chkGood); CheckBox Chk_Damage = (CheckBox)GridView2.Rows[i].FindControl(chkDamage); bool Is_Condition_Good = Chk_Good.Checked; bool is_Condition_Damage = Chk_Damage.Checked; string Good_value = string.Empty; if (Is_Condition_Good) { Good_value = Good; } string Damage_value = string.Empty; if (is_Condition_Damage) { Damage_value = Damage; } /* Save Record in your Database. */ } } Secondly I having an error on the coding you provided for me to create Checkbox Checked Change event for both the checkboxes. (I have attached a print screen for you too) here is my asp coding for the gridview: AutoGenerateColumns=False CellPadding=4 ForeColor=#333333 GridLines=None> '> '> '> DataSourceID=SqlDataSource2 DataTextField=CategoryName DataValueField=CategoryID> ConnectionString=  SelectCommand=SELECT * FROM [Category]> '> '> '> '> ConnectionString=  SelectCommand=SELECT * FROM [Asset]> Sorry that interrupt you for so many days. I am a beginner for this ASP.NET. Appreciate that helping me on this. thank you so much!!!

Pankaj Rawat · Answer

for the Problem that u are able to select both the checkboxes create Checkbox Checked Change event for both the checkboxes. protected void ChkBox1.CheckedChange(object senderEventArgs e) { checkbox chkbox1=(Checkbox)sender; GridViewRow row = (GridViewRow)chkbox1.NamingContainer; int id = row.RowIndex; checkbox chkbox2=(checkbox )gridview1.Rows[id].FindControl(chkeckbox2ID); if(chkbox1.checked==true) chkbox2.checked=false; } similarly create the checked change event for second checkbox. and the problem u are not able to save the detailsPlease check your code that what exactly are you trying to save.is it a bool value(True or False) or String. protected void Btn_Save_Click(object senderEventArgs e) { int Total_Rows=gridview1.rows.Count; for(int i=0;i { CheckBox Chk_Good=(CheckBox)gridview1.rows[i].FindControl( chkGood); CheckBox Chk_Damage=(CheckBox)gridview1.rows[i].FindControl( chkDamage ); bool Is_Condition_Good= Chk_Good.Checked; bool Is_Condition_Damage=Chk_Damage.Checked; /* If you want to save Bool value in your database*/ /* just save the Above values Is_Condition_Good and Is_Condition_Damage.*/ /* if you want to save string Values */ string Good_Value=string.empty; if( Is_Condition_Good ) Good_Value =Good string Damage_Value=string.empty; if( Is_Condition_Damage) Damage_Value=Damage; /* Save Record in your Database. */ } } if u still find problem you can send me your code(save button click) at pank1703@yahoo.com. i will check it out....

xin yi · Answer

it is free error but whenever i finished tick the checkboxes and press save button there nothing happen in the database. it is my coding for database wrong? Secondly why i can tick 2 checkboxes at the same time? not suppose that only 1 checkbox can be ticked for 1 row? can help checking on my coding? here it is: public partial class Asset_Tracking : System.Web.UI.Page { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[RegConnectionString].ConnectionString); protected void Page_Load(object sender EventArgs e) { if (!Page.IsPostBack) { LoadGridView(); //Page loads for first time } } private void LoadGridView() { SqlDataAdapter adap = new SqlDataAdapter(select * from Asset conn); DataSet ds = new DataSet(); adap.Fill(ds); GridView2.DataSource = ds; GridView2.DataBind(); }

Pankaj Rawat · Answer

Well if you have two checkboxes then protected void Btn_Save_Click(object senderEventArgs e) { int Total_Rows=gridview1.rows.Count; for(int i=0;i { CheckBox Chk_Good=(CheckBox)gridview1.rows[i].FindControl( chkGood); CheckBox Chk_Damage=(CheckBox)gridview1.rows[i].FindControl( chkDamage ); bool Is_Condition_Good= Chk_Good.Checked; bool Is_Condition_Damage=Chk_Damage.Checked; string Good_Value=string.empty; if( Is_Condition_Good ) Good_Value =Good string Damage_Value=string.empty; if( Is_Condition_Damage) Damage_Value=Damage; /* Save Record in your Database. */ } }

xin yi · Answer

thanks for your response! :) According to your coding then i have wrong coding in asp there as follow: oncheckedchanged=chkGood_CheckedChanged Text=Good/> oncheckedchanged=chkDamage_CheckedChanged Text=Damage/> Then where i have did wrong in this coding? How to make 1 ID (Chk_Condition) with 2 checkboxes? thank u :)

Pankaj Rawat · Answer

Hello Xin suppose your grid Gridview1 has Checkbox Chk_Condition. on Button click first you find your checkbox control and then checked whether you have selected the value or nor. protected void Btn_Save_Click(object senderEventArgs e) { int Total_Rows=gridview1.rows.Count; for(int i=0;i { CheckBox Chk_Condition=(CheckBox)gridview1.rows[i].FindControl(Chk_Condition); bool condition =Chk_Condition.checked; /*Here bool condition will have the value.if you checked your checkbox (means Good)the value will be True else False.*/ string Value=string.empty; if(condition) Value=Good else Value=Damage; /* Save Record in your Database. */ } }