Gridview rowdatabound for checkboxlist

Question

0.00/5 (No votes)

See more:

Sir I am using a checkboxlist in my gridview edit item template.
There is a problem. I am not getting the previously checked value in my checkboxlist in edititem template on edit mode. I want to update records.
Please help. Thanks in advance..

value is saved in this format in database
"Gym ,Park ,Lift ,Security ,Club House ,Swimming pool ,Water Storage ,Power Backup ,Reserve Parking ,Vaastu Complaint" and i want on edit command of gridview these values to bind in checkboxlist...

Update code and query

C#

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        string Property_ID = Convert.ToString(GridView1.DataKeys[e.RowIndex].Values["Property_ID"]);

        DropDownList ddlpropfor = (DropDownList)GridView1.Rows[e.RowIndex].FindControl("ddlpropfor");
        string propfor = Convert.ToString(ddlpropfor.SelectedItem);

        TextBox PName = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtpname");
        string pname = PName.Text;

        DropDownList PropertyType = (DropDownList)GridView1.Rows[e.RowIndex].FindControl("ddlpropertytype");
        string ptype = Convert.ToString(PropertyType.SelectedItem);

        DropDownList PropertyAge = (DropDownList)GridView1.Rows[e.RowIndex].FindControl("ddlpropertyage");
        string pAge = Convert.ToString(PropertyAge.SelectedItem);


        DropDownList Postedby = (DropDownList)GridView1.Rows[e.RowIndex].FindControl("ddlpostedby");
        string postedby = Convert.ToString(Postedby.SelectedItem);


        DropDownList City = (DropDownList)GridView1.Rows[e.RowIndex].FindControl("ddlcity");
        string city = Convert.ToString(City.SelectedItem.Value);

        DropDownList Locality = (DropDownList)GridView1.Rows[e.RowIndex].FindControl("ddllocality");
        string locality = Convert.ToString(Locality.SelectedItem.Value);

        TextBox Address = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtaddress");
        string address = Address.Text;

        TextBox Pincode = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtpincode");
        string pincode = Pincode.Text;

        TextBox Price = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtprice");
        string price = Price.Text;

        DropDownList Bedroom = (DropDownList)GridView1.Rows[e.RowIndex].FindControl("ddlbedrooms");
        string bedroom = Convert.ToString(Bedroom.SelectedItem);

        TextBox Area = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtarea");
        string area = Area.Text;

        CheckBoxList Ame = (CheckBoxList)GridView1.Rows[e.RowIndex].FindControl("chklamenities");
        string ame = Convert.ToString(Ame.SelectedItem);


        TextBox Features = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtfeatures");
        string features = Features.Text;

        TextBox Date = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtdate");
        DateTime date = Convert.ToDateTime(Date.Text);
        //DateTime date = DateTime.TryParse(Date.Text); 

        TextBox ImageName = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtimgname");
        string imgname = ImageName.Text;

        TextBox ImagePath = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtimgpath");
        string imgpath = ImagePath.Text;

        
        TextBox Name = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtname");
        string name = Name.Text;

        TextBox Email = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtemail");
        string email = Email.Text;

        TextBox Mobile = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtmob");
        string mobile = Mobile.Text;

        TextBox PriceWords = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtpwords");
        string pricewords = PriceWords.Text;

        CheckBox Active = (CheckBox)GridView1.Rows[e.RowIndex].FindControl("chkactive");
        string active = Convert.ToString(Active.Checked);


        SqlConnection con = new SqlConnection(str);
        string strQ = "update tbl_Post_Property set Property_For = '" + propfor + "',Property_Name='" + pname + "',Property_Type = '" + ptype + "',Property_Age = '" + pAge + "',Posted_By='" + postedby + "',City_Id = '" + city + "',Locality_Id='" + locality + "',Address = '" + address + "',Pincode = '" + pincode + "',Price='" + price + "',Bedroom='" + bedroom + "',Area='" + area + "',Amenities='" + ame + "',Key_Features='" + features + "',Date_Posted='" + date.ToString("dd-MMM-yyyy") + "',ImageName='" + imgname + "',ImagePath='" + imgpath + "',Name='" + name + "',Email='" + email + "',Mobile='" + mobile + "',PriceWords='" + pricewords + "', IsActive = '" + active + "'  where Property_ID='" + Property_ID + "'";
        SqlCommand cmd = new SqlCommand(strQ, con);
        con.Open();
        cmd.ExecuteNonQuery();
        lblmessage.Text = "Record Updated Successfully";
        GridView1.EditIndex = -1;
        Filldata();
    }

RowDatabound Code

C#

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        DataRowView drv = e.Row.DataItem as DataRowView;
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            if ((e.Row.RowState & DataControlRowState.Edit) > 0)
            {
                DropDownList propertyfor = (DropDownList)e.Row.FindControl("ddlpropfor");
                propertyfor.SelectedItem.Text = Convert.ToString(drv[1]);

                DropDownList ddltype = (DropDownList)e.Row.FindControl("ddlpropertytype");
                ddltype.SelectedValue = Convert.ToString(drv[3]);

                DropDownList ddlage = (DropDownList)e.Row.FindControl("ddlpropertyage");
                ddlage.SelectedItem.Text = Convert.ToString(drv[4]);

                DropDownList ddlpostedby = (DropDownList)e.Row.FindControl("ddlpostedby");
                ddlpostedby.SelectedItem.Text = Convert.ToString(drv[5]);

                DropDownList ddlcity = (DropDownList)e.Row.FindControl("ddlcity");
                ddlcity.SelectedValue = Convert.ToString(drv[6]);

                DropDownList ddllocality = (DropDownList)e.Row.FindControl("ddllocality");
                ddllocality.SelectedValue = Convert.ToString(drv[7]);

                
                DropDownList ddlbedroom = (DropDownList)e.Row.FindControl("ddlbedrooms");
                ddlbedroom.SelectedItem.Text = Convert.ToString(drv[11]);

                //CheckBoxList chkb = (CheckBoxList)e.Row.FindControl("chklamenities");
                //chkb.SelectedValue = drv[13].ToString();

                CheckBoxList chkb = (CheckBoxList)e.Row.FindControl("chklamenities");
                string ame = "";
                foreach (ListItem li in chkb.Items)
                {
                    if (li.Selected)
                    {
                        ame += li.Text + ",";
                    }

                }
                ame = ame.TrimEnd(',');


                CheckBox chk = (CheckBox)e.Row.FindControl("chkactive");
                chk.Checked = Convert.ToBoolean(drv[22]);

                
               


            }
        }
    }

This is ths code how I am saving checkboxlist values from front end to database

C#

String Ame = "";
                for (int i = 0; i < chklamenities.Items.Count; i++)
                {
                    if (chklamenities.Items[i].Selected)
                    {
                        Ame += chklamenities.Items[i].Value + " ,";
                    }
                }
                Ame = Ame.TrimEnd(',');

this my gridview design

XML

<asp:TemplateField ControlStyle-Width="600px" HeaderText="Amenities">
                       <ItemTemplate>
                           <asp:Label ID="lblame" runat="server" Text='<%#Eval("Amenities")%>'></asp:Label>
                       </ItemTemplate>
                       <EditItemTemplate>
                      <asp:CheckBoxList ID="chklamenities" runat="server" CellPadding="1" RepeatColumns="5"
                   RepeatDirection="Horizontal">
                   <asp:ListItem>Gym</asp:ListItem>
                   <asp:ListItem>Park</asp:ListItem>
                   <asp:ListItem>Lift</asp:ListItem>
                   <asp:ListItem>Security</asp:ListItem>
                   <asp:ListItem>Club House</asp:ListItem>
                   <asp:ListItem>Swimming pool</asp:ListItem>
                   <asp:ListItem>Water Storage</asp:ListItem>
                   <asp:ListItem>Power Backup</asp:ListItem>
                   <asp:ListItem>Reserve Parking</asp:ListItem>
                   <asp:ListItem>Vaastu Complaint</asp:ListItem>
               </asp:CheckBoxList>
                       </EditItemTemplate>
                   </asp:TemplateField>

Posted 21-Nov-12 20:09pm

Raj.Rautela

Updated 21-Nov-12 21:26pm

v7

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mohd. Mukhtar · Answer 1 · 2012-11-21T20:33:00

Solution 1

Hi Raj,

Update your code as below.

C#

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
   DataRowView drv = e.Row.DataItem as DataRowView;
   if (e.Row.RowType == DataControlRowType.DataRow)
   {
      if ((e.Row.RowState & DataControlRowState.Edit) > 0)
      {
         CheckBoxList chkb = (CheckBoxList)e.Row.FindControl("chklamenities");
         string ame="";
         foreach (ListItem li in chkame.Items)
         {
            if(li.Selected)                    
            {
                ame += li.Text + ",";
            }
                    
         }
         ame = ame.TrimEnd(",");
      }
   }
}

Posted 21-Nov-12 20:33pm

Mohd. Mukhtar

Comments

Raj.Rautela 22-Nov-12 3:17am

sir i tried what u told but still not working for me.i'hv updated my question pls have a look...thanks sir

Mohd. Mukhtar 22-Nov-12 3:21am

Please update full methos where you are have written update query.
string strQ = "update tbl_Post_Property set Amenities='" + ame + "' where Property_ID='" + Property_ID + "'";

Raj.Rautela 22-Nov-12 3:28am

sir i'hv updated my question have a look

Mohd. Mukhtar 22-Nov-12 3:33am

Raj you should try below code.
in place of CheckBoxList Ame = (CheckBoxList)GridView1.Rows[e.RowIndex].FindControl("chklamenities");
string ame = Convert.ToString(Ame.SelectedItem

you need to try
CheckBoxList Ame = (CheckBoxList)GridView1.Rows[e.RowIndex].FindControl("chklamenities");
string ame="";
foreach (ListItem li in chkame.Items)
{
if(li.Selected)
{
ame += li.Text + ",";
}

}
ame = ame.TrimEnd(",");

Raj.Rautela 22-Nov-12 3:59am

sir for update it worked but onedit command previously entered values are not retrived in checkboxlist

Mohd. Mukhtar 22-Nov-12 4:03am

hmmm Ok.

Mohd. Mukhtar 22-Nov-12 4:17am

See the below answer.

Mohd. Mukhtar · Answer 2 · 2012-11-21T22:15:00

Solution 2

Please see the below row data bound method.

C#

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
   DataRowView drv = e.Row.DataItem as DataRowView;
   if (e.Row.RowType == DataControlRowType.DataRow)
   { 
      string Property_ID = Convert.ToString(GridView1.DataKeys[e.RowIndex].Values["Property_ID"]);
      CheckBoxList chkb = (CheckBoxList)e.Row.FindControl("chklamenities");
      string query = "Select Amenities FROM tbl_Post_Property where Property_ID='" + Property_ID + "'";
      SqlConnection con = new SqlConnection(str);
      SqlCommand cmd = new SqlCommand(query, con);
      con.Open();
      DataSet ds = new DataSet();
      SqlDataAdaptor da= new SqlDataAdapter(cmd);
      da.fill(ds);
      if(ds.Table[0].Rows.Count>0)
         string ame = ds.Table[0].Rows[0]["Amenities"];
      foreach (ListItem li in chkb)
      {
        if(ame.Contains(li.Text))                    
        {
           li.Selected = true;        
        }                    
      }
    }
   }
}

Posted 21-Nov-12 22:15pm

Mohd. Mukhtar

Updated 21-Nov-12 22:17pm

v2

Comments

Raj.Rautela 22-Nov-12 5:33am

sorry sir its not working for me...

Mohd. Mukhtar 22-Nov-12 5:38am

What error you are getting here?

Raj.Rautela 22-Nov-12 5:46am

there are 3 errors
1)
'System.Web.UI.WebControls.GridViewRowEventArgs' does not contain a definition for 'RowIndex' and no extension method 'RowIndex' accepting a first argument of type 'System.Web.UI.WebControls.GridViewRowEventArgs' could be found (are you missing a using directive or an assembly reference?)

2)
'System.Data.DataSet' does not contain a definition for 'Table' and no extension method 'Table' accepting a first argument of type 'System.Data.DataSet' could be found (are you missing a using directive or an assembly reference?)

3)
foreach statement cannot operate on variables of type 'System.Web.UI.WebControls.CheckBoxList' because 'System.Web.UI.WebControls.CheckBoxList' does not contain a public definition for 'GetEnumerator'

Mohd. Mukhtar 22-Nov-12 6:03am

1. insted of Convert.ToString(GridView1.DataKeys[e.RowIndex].Values["Property_ID"]);
you can use bound field to get Property_ID
2. add using System.Data
3.foreach (ListItem li in chkb.Items)

Raj.Rautela 22-Nov-12 6:16am

sir i got 1 solution soved my prblm by this..but thanks for your help sir.thanks a lot
DataRowView drv = e.Row.DataItem as DataRowView;
if (e.Row.RowType == DataControlRowType.DataRow)
{

if ((e.Row.RowState & DataControlRowState.Edit) > 0)
{
CheckBoxList chkame = (CheckBoxList)e.Row.FindControl("chklamenities");
string[] strSplitArr = ((DataRowView)e.Row.DataItem)["Amenities"].ToString().Split(',');
foreach (ListItem oItem in chkame.Items)
{
for (int i = 0; i < strSplitArr.Length; i++)
{
if (oItem.Value == strSplitArr[i].Trim())
{
oItem.Selected = true;
break;
}
}
}
}
}

Mohd. Mukhtar 22-Nov-12 6:21am

Good :-)