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

xin yi

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

8 Replies

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

Pankaj Rawat13y ago
Accepted 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 < row_Count; 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 label,if 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 yi13y ago
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 yi13y ago
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 < Total_Rows; 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:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Asset_Tracking.aspx.cs" Inherits="Asset_Tracking" %>







AutoGenerateColumns="False" CellPadding="4" ForeColor="#333333"
GridLines="None">

DataSourceID="SqlDataSource2" DataTextField="CategoryName"
DataValueField="CategoryID">

ConnectionString="<%$ ConnectionStrings:RegConnectionString %>"
SelectCommand="SELECT * FROM [Category]">










ConnectionString="<%$ ConnectionStrings:RegConnectionString %>"
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 Rawat13y ago
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 sender,EventArgs 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 details,Please 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 sender,EventArgs 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 [email protected].
i will check it out....
xin yi13y ago
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 Rawat13y ago
Well if you have two checkboxes, then

protected void Btn_Save_Click(object sender,EventArgs 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 yi13y ago
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 Rawat13y ago
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 sender,EventArgs 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. */
}
}