Storing wrong value "System.data.datarowview" in table.

public void InsertSusCode()
        {

            for( i=0;i            {

                    if (con.State == ConnectionState.Closed)
                    {
                        con.Open();
                    }

                    string[] s = new string[lstcsuspectcode.SelectedItems.Count];
                    s[i]= lstcsuspectcode.SelectedItems[i].ToString();
                    string str="insert into casesuspect1(suspect_code) values('"+s[i]+"')";
                    SqlCommand cmd = new SqlCommand(str, con);
                    int r = cmd.ExecuteNonQuery();
                    if (r > 0)
                    {
                        MessageBox.Show("Suspect INSERTED SUCCESSFULLY.");
                    }
            }
        }

The above code stores value System.Data.DataRowView in the table casesuspect1? It should store the multiple selected items in list box. The suspectcode list box displays suspects name. So is there any mistake in the code? Any other suggesstion is also welcomed.

1 Reply

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

Vulpes14y ago
I'd guess from the error message that your ListBox is bound to a DataTable.

If that's the case, I'd try replacing this line:

s[i]= lstcsuspectcode.SelectedItems[i].ToString();

with these:

DataRowView drv = (DataRowView)lstcsuspectcode.SelectedItems[i];
s[i] = drv[lstcsuspectcode.DisplayMember].ToString();
0