radcheckedlistbox

Vivek Joy

11y3.1kVisual Basic .NET

first is my database by using this code i have stored the values for checked items.

private void updatesegments()

{

SqlCommand cmd = new SqlCommand();

for(int j=0;j < ChckListBxSegments.Items.Count;j++)

{

if (ChckListBxSegments.Items[j].CheckState == Telerik.WinControls.Enumerations.ToggleState.On)//togglestate has 3 modes .When it is set to on then only it will enter into it

{

Program.StrSql = "Update QbGeneralLookup set ActiveFlag = 3 Where LookupId = 7 and Description ='" + ChckListBxSegments.Items[j].Value + "'";

cmd.Connection = Program.QbAppDbCon;

cmd.CommandText = Program.StrSql;

cmd.ExecuteNonQuery();

}

now i need to display to the checkbox as whether it is checked or not according to the value that stored

10 Replies

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

Vivek Joy11y ago
thankz sir but i get the answer due to my sir
Raja T11y ago
Hi, Good job vivek joy
Vivek Joy11y ago
hi everyone i get the solution .
Thank you all for helping me
private void selectgenerallookup()
{

SqlCommand cmd = new SqlCommand();
Program.StrSql = "select Description from QbGeneralLookup Where ActiveFlag='3'";
cmd.Connection = Program.QbAppDbCon;
cmd.CommandText = Program.StrSql;
cmd.ExecuteNonQuery();
//DataTable dt = new DataTable();
SqlDataReader QbReader4 = cmd.ExecuteReader();
int i = 0;
while (QbReader4.Read())
{
//int indexx = ChckListBxSegments.Items.IndexOf(QbReader4["Description"].ToString());
//if (indexx >= 0)
//if (QbReader4["Description"] == ChckListBxSegments.Items[i].Value)
for (i = 0; i <= ChckListBxSegments.Items.Count; i++ )
{
if(ChckListBxSegments.Items[i].Text==QbReader4["Description"].ToString())
{
ChckListBxSegments.Items[i].CheckState = Telerik.WinControls.Enumerations.ToggleState.On;
break;
}
// i++;
}
}

QbReader4.Close();

}
Vivek Joy11y ago
My requirement is when active flag =3 then that checkbox shold be checked.

the code should be in c#
Vivek Joy11y ago
I required is when active flag =3 then that checkbox shold be checked.
Sabyasachi Mishra11y ago
See the attached demo.Save the checked items in the textarea by comma separation and do your task.
Find the attached demo in Fiddel.Click on checkbox and see

Demo
Raja T11y ago
Hi, Please refer bellow url

http://demos.telerik.com/aspnet-ajax/button/examples/radiosandcheckboxes/defaultcs.aspx
Raja T11y ago
Hi, Please Checkout
Vivek Joy11y ago
doesnt work
sir can suggest me diffferent example.
Raja T11y ago
Hi,try like

DataSet ds = new DataSet();
ds = asvc.executeQuery("select sno,(' '+ PSTAGE_NAME) as PSTAGE_NAME from PSP_PSTAGES_CATEGORY order by PSTAGE_ID asc", 0);
RadListBox1.DataSource = ds;
RadListBox1.DataTextField = "PSTAGE_NAME";
RadListBox1.DataValueField = "sno";
RadListBox1.DataBind();

foreach (RadListBoxItem i in RadListBox1.Items)
{
   string itmval = i.Value;
   if( itmval=="Dbvalue")
   {
         i.Enabled = false;
         i.Checked = true;
    }
}