To bind check box list value to grid view based on value of sp list item

Question

1.00/5 (1 vote)

See more:

SharePoint2013

I used row data bound to get value form list item to grid view controls.For radio-list it works fine but for checkbox list and drop-down list selected value should be checked on grid view corresponding controls.
I debugged the conditions every thing works fine but I can't find selected values on grid-view while editing.
Grid view was implemented on visual web part.

Please let me know where to check and what to do.

What I have tried:

My code:
protected void grid_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow && grid.EditIndex == e.Row.RowIndex)
{

string id = grid.DataKeys[e.Row.RowIndex].Value.ToString();

RadioButtonList rb = (RadioButtonList)e.Row.FindControl("RadioButtonList1");
CheckBoxList chkdept = (CheckBoxList)e.Row.FindControl("CheckBoxList1");
DropDownList ddl = (DropDownList)e.Row.FindControl("DropDownList1");
SPWeb currentWeb = SPContext.Current.Web;
SPList lst = currentWeb.Lists["Employee"];
SPListItem item = null;
item = lst.GetItemById(Convert.ToInt32(id));

string rd = item["Gender"].ToString();

string ex = item["Experience"].ToString();
string replace = ex.TrimStart(';', '#').TrimEnd(';', '#');
string qul = item["Qualification"].ToString();
ddl.Items.FindByText(qul).Selected = true;

if (rd == "Male")
{
rb.Items.FindByText(rd).Selected = true;
}

else if (rd == "Female")
{
rb.Items.FindByText(rd).Selected = true;

}

if (replace == "1-2year")
{
chkdept.Items.FindByText(replace).Selected = true;

}
else if (replace == "2-5year")
{

chkdept.Items.FindByText(replace).Selected = true;

}
else if (replace == "5-10year")
{

chkdept.Items.FindByText(replace).Selected = true;
}

}
}

Posted 5-Feb-17 0:06am

narengowtham

Updated 6-Feb-17 0:02am

Add a Solution

Comments

Karthik_Mahalingam 5-Feb-17 7:08am

is it throwing any error?
check the case of the item text and the selected text.

narengowtham 5-Feb-17 7:16am

It's not throwing a error,for radio button I can set the value it work's fine and for checkbox list it checks conditions and it not getting into the chkdept.Items.FindByText(replace).Selected = true;

narengowtham 5-Feb-17 7:18am

I checked with bound values and field name every thing fine.

Karthik_Mahalingam 5-Feb-17 7:18am

does the item present in the checkbox list

narengowtham 5-Feb-17 7:21am

<asp:TemplateField HeaderText="Gender" ItemStyle-Width="10" ItemStyle-Wrap="False">
<ItemTemplate >
<%# Eval("Gender") %>

<edititemtemplate>

<asp:RadioButtonList ID="RadioButtonList1" runat="server" RepeatDirection="Horizontal" >
<asp:ListItem Value="1">Male
<asp:ListItem Value="2" >Female

<asp:TemplateField HeaderText="Experience">
<itemtemplate>
<%# Eval("Experience") %>

<edititemtemplate>
<asp:CheckBoxList ID="CheckBoxList1" runat="server">
<asp:ListItem Value="0" Text="1-2year">
<asp:ListItem Value="1" Text="2-5year">
<asp:ListItem Value="2" Text="5-10year">

My share point lsitem column name Experience choice field
Same as
1-2year
2-5year
5-10year.
But on grid view check box value shows with;,#
special chracter.
2-5year

Karthik_Mahalingam 5-Feb-17 7:25am

remove the special characters from code and try.

narengowtham 5-Feb-17 7:26am

Let me check it.

Karthik_Mahalingam 5-Feb-17 7:27am

else you append the special character for the selected item, either ways it should work.

narengowtham 5-Feb-17 7:32am

No changes happened on grid view for checklist column.
It might be taking just only the radio button list while clicking on edit.

narengowtham 5-Feb-17 7:34am

on my code upto here
if (rd == "Male")
{
rb.Items.FindByText(rd).Selected = true;
}

else if (rd == "Female")
{
rb.Items.FindByText(rd).Selected = true;

}
is good but for check list and droplist i am not getting selected values.

narengowtham 5-Feb-17 7:36am

In specific I can share screen shots if u not mind through email

1 solution

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)

narengowtham · Answer 1 · 2017-02-06T00:02:00

I tried little bit of debugging, then found solution.

if (replace == "1-2year")
{
/*chkdept.Items.FindByText(replace).Selected = true;*/
instead of above code just replaced with this
chkdept.Items[0].Selected = true;

}
else if (replace == "2-5year")
{

chkdept.Items[1].Selected = true;

}
else if (replace == "5-10year")
{

chkdept.Items[2].Selected = true;
}

string ex = item["Experience"].ToString();

Also while getting list item in string object from choice field check box List Share Point.On default it comes with space like : "2-5 year" instead of "2-5year".So I passed with string with space worked perfectly.