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

Answer 1

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";

Answer 2

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 :'(

Answer 3

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" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

    <title></title>

</head>

<body>

    <form id="form1" runat="server">

    <div>

    

    

        <br />

    

    

        <asp:GridView ID="GridView2" runat="server" CssClass="Grid" Width="90%" 

            AutoGenerateColumns="False" CellPadding="4" ForeColor="#333333" 

            GridLines="None">

            <AlternatingRowStyle BackColor="White" />

        <Columns>

        <asp:TemplateField HeaderText="ID" visible="false">

        <ItemTemplate>

        <asp:Label ID="lblID" runat="server" Text='<%# Eval("ID") %>'></asp:Label>

        </ItemTemplate>

        </asp:TemplateField>

        <asp:TemplateField HeaderText="Serial Number" SortExpression="SerialNumber">

        <ItemTemplate>

        <asp:Label ID="lblSerialNumber" runat="server" Text='<%# Eval("SerialNumber") %>'></asp:Label>

        </ItemTemplate>

        </asp:TemplateField>

        <asp:TemplateField HeaderText="Asset Model">

        <ItemTemplate>

        <asp:Label ID="lblAssetModel" runat="server" Text='<%# Eval("AssetModel") %>'></asp:Label>

        </ItemTemplate>

        </asp:TemplateField>

        <asp:TemplateField HeaderText="Categories">

            <EditItemTemplate>

                <asp:DropDownList ID="DropDownList1" runat="server" 

                    DataSourceID="SqlDataSource2" DataTextField="CategoryName" 

                    DataValueField="CategoryID">

                </asp:DropDownList>

                <asp:SqlDataSource ID="SqlDataSource2" runat="server" 

                    ConnectionString="<%$ ConnectionStrings:RegConnectionString %>" 

                    SelectCommand="SELECT * FROM [Category]"></asp:SqlDataSource>

            </EditItemTemplate>

        <ItemTemplate>

        <asp:Label ID="lblCategories" runat="server" Text='<%# Eval("Categories") %>'></asp:Label>

        </ItemTemplate>

        </asp:TemplateField>

        <asp:TemplateField HeaderText="Date Purchased">

        <ItemTemplate>

        <asp:Label ID="lblDatePurchased" runat="server" Text='<%# Eval("DatePurchased") %>'></asp:Label>

        </ItemTemplate>

        </asp:TemplateField>

        <asp:TemplateField HeaderText="Date Received">

        <ItemTemplate>

        <asp:Label ID="lblDateReceived" runat="server" Text='<%# Eval("DateReceived") %>'></asp:Label>

        </ItemTemplate>

        </asp:TemplateField>

        <asp:TemplateField HeaderText="Condition">

        <ItemTemplate>

        <asp:CheckBox ID="chkGood" runat="server" AutoPostBack="True" Text="Good" />

        <asp:CheckBox ID="chkDamage" runat="server" AutoPostBack="True" Text="Damage" />

        </ItemTemplate>

        </asp:TemplateField>

        <asp:TemplateField HeaderText="Notes">

        <ItemTemplate>

        <asp:Label ID="lblNotes" runat="server" Text='<%# Eval("Notes") %>'></asp:Label>

            <asp:TextBox ID="TextBox1" runat="server" AutoPostBack="True"></asp:TextBox>

        </ItemTemplate>

        </asp:TemplateField>

        </Columns>

            <EditRowStyle BackColor="#7C6F57" />

            <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />

            <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />

            <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />

            <RowStyle BackColor="#E3EAEB" />

            <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />

            <SortedAscendingCellStyle BackColor="#F8FAFA" />

            <SortedAscendingHeaderStyle BackColor="#246B61" />

            <SortedDescendingCellStyle BackColor="#D4DFE1" />

            <SortedDescendingHeaderStyle BackColor="#15524A" />

        </asp:GridView>

       

    

        <br />

        <asp:Button ID="Button1" runat="server" Text="Save" onclick="Button1_Click" />

    

    

    

    

    

        <br />

        <br />

        <asp:SqlDataSource ID="SqlDataSource3" runat="server" 

            ConnectionString="<%$ ConnectionStrings:RegConnectionString %>" 

            SelectCommand="SELECT * FROM [Asset]"></asp:SqlDataSource>

        <br />

    

    </div>

    </form>

</body>

</html>

        

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!!!

Answer 4

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<Total_Rows;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 [e-mail].
i will check it out....

Answer 5

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();

    }

Answer 6

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<Total_Rows;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. */
        }
}

Answer 7

thanks for your response! :)
According to your coding, then i have wrong coding in asp there as follow:

 <asp:TemplateField HeaderText="condition">

        <ItemTemplate>

        <asp:CheckBox ID="chkGood" runat="server" AutoPostBack="True" 

                                oncheckedchanged="chkGood_CheckedChanged" Text="Good"/>

        <asp:CheckBox ID="chkDamage" runat="server" AutoPostBack="True" 

                                oncheckedchanged="chkDamage_CheckedChanged" Text="Damage"/>

        </ItemTemplate>

        </asp:TemplateField>

Then, where i have did wrong in this coding? 
How to make 1 ID (Chk_Condition) with 2 checkboxes?

thank u :)

Answer 8

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<Total_Rows;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. */
        }
}