i need to check Multicheckedlistbox with checked items

Zakir Ahamed

9y957Windows Forms

hi friends,

i am developing winforms i have issue:

this is my code:

private void GvCategory_CellDoubleClick(object sender, DataGridViewCellEventArgs e)

{

try

{

indexRow = e.RowIndex;

DataGridViewRow row = GvCategory.Rows[indexRow];

txtcategory.Text = row.Cells[1].Value.ToString();

//txtcategory.ReadOnly = true;

btncategory.Text = "Update";

rbyes.Checked = true;

if (txtcategory.Text != " ")

{

try

{

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["RetailTestConnection"].ConnectionString);

con.Open();

string query = String.Format("Select [Item_Id]='{0}' order by Item_Id", Convert.ToInt32(txtcategory.Text));

SqlCommand cmd = new SqlCommand(query,con);

SqlDataReader dr = cmd.ExecuteReader();

string[] s = new string[] { };

while (dr.Read())

{

s = dr.ToString().Split(',');

}

int Length = s.Length;

for (int i = 0; i < Length; i++)

// for (int i = 0; i <= 1; i++)

{

string fetr = s[i];

for (int j = 0; j <= clbbrand.Items.Count - 1; j++)

{

if (clbbrand.Items[j].ToString() == s[i])

{

clbbrand.SetItemChecked(j, true);

break;

}

catch (Exception ex)

{

MessageBox.Show(ex.Message.ToString());

}

catch (Exception ex)

{

MessageBox.Show(ex.Message.ToString());

}

the list value is not geting , how i get the values to showed a checkbox saved and updated in time whatever values i saved i will showed in already i will cheked items..

i need immediate reply...

5 Replies

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

Rahul9y ago
As much as I could understand your question, I wrote code which I have copied below working for me on double click in the grid row. Is it still not working for you? I am not sure about your question.

Still, you have doubt, send me an email with your project attachment @ [email protected]. I will look into it and will revert you back.

Thanks
Zakir Ahamed9y ago
this code for double click in grid:

private void GvCategory_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
try
{
int indexRow = e.RowIndex;
DataGridViewRow row = GvCategory.Rows[indexRow];
txtcategory.Text = row.Cells[0].Value.ToString();
btncategory.Text = "Update";
if (!string.IsNullOrEmpty(txtcategory.Text.Trim()))
{
try
{
string members = row.Cells[1].Value.ToString();
string[] s = members.Split(',');
int Length = s.Length;
foreach (int i in clbbrand.CheckedIndices)
{
clbbrand.SetItemCheckState(i, CheckState.Unchecked);
}
for (int i = 0; i < Length; i++)
{
string fetr = s[i];
for (int j = 0; j <= clbbrand.Items.Count - 1; j++)
{
if (clbbrand.Items[j].ToString() == s[i])
{
clbbrand.SetItemChecked(j, true);
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
Rahul9y ago
Zakir, I created a temp project looking at your attached form and wrote some code to check items under checkedList, when the user clicks double time on datagridview. Code is below -

private void Form1_Load(object sender, EventArgs e)
{
DataTable dt = new DataTable("table1");
dt.Columns.Add(new DataColumn() { ColumnName = "Class", DataType = typeof(string) });
dt.Columns.Add(new DataColumn() { ColumnName = "Members", DataType = typeof(string) });
DataRow dr = dt.NewRow();
dr["Class"] = "MCA";
dr["Members"] = "Raju,Ravi";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["Class"] = "MBA";
dr["Members"] = "Jyoti,Ravi,Rakesh";
dt.Rows.Add(dr);
GvCategory.DataSource = dt;
}
private void GvCategory_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
try
{
int indexRow = e.RowIndex;
DataGridViewRow row = GvCategory.Rows[indexRow];
txtcategory.Text = row.Cells[0].Value.ToString();
btncategory.Text = "Update";
if (!string.IsNullOrEmpty(txtcategory.Text.Trim()))
{
try
{
string members = row.Cells[1].Value.ToString();
string[] s = members.Split(',');
int Length = s.Length;
foreach (int i in clbbrand.CheckedIndices)
{
clbbrand.SetItemCheckState(i, CheckState.Unchecked);
}
for (int i = 0; i < Length; i++)
{
string fetr = s[i];
for (int j = 0; j <= clbbrand.Items.Count - 1; j++)
{
if (clbbrand.Items[j].ToString() == s[i])
{
clbbrand.SetItemChecked(j, true);
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}

Hope it helps.

Thanks.
Zakir Ahamed9y ago
Hi friend,

i will send form design and .cs code.

code.cs:
// clbbrand
//
this.clbbrand.CheckOnClick = true;
//this.clbbrand.SelectionMode = Select.One;
this.clbbrand.FormattingEnabled = true;
this.clbbrand.Location = new System.Drawing.Point(226, 87);
this.clbbrand.Name = "clbbrand";
this.clbbrand.Size = new System.Drawing.Size(242, 79);
this.clbbrand.TabIndex = 5;

do you have solution please frwrd me immediately
Rahul9y ago
Hi Zakir,

Can you send your form designer files also? I can not know about what controls you are uisng in your gridview, what controls you have on your form with the .cs code only provided above.

Send your project grid project, might be I could help you.