The following exception occured in the DataGridView:
System.ArgumentException: DataGridViewComboBoxCell Value is not valid.
To replace this default dialog please handle the DataError Event.
i have a datagridview and in datagridview two fill combobox from database but when i select combobox value in second row the above following error occured...in c# windows application....
and plz ans send me my email address..
my email is msv.svm@gmail.com
so plz help me...
private void sample_Load(object sender, EventArgs e)
{
SqlCommand cmd = new SqlCommand("Select CatID, CatName from CategoryMaster", cnn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(dt);
Column1.DataSource = dt;
Column1.DisplayMember = "CatName";
Column1.ValueMember = "CatID";
}
private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == 0)
{
string catID = dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();
SqlCommand cmd1 = new SqlCommand(@"SELECT ProdID, ProdName FROM ProductMaster WHERE CatID ='" + catID + "' ", cnn);
SqlDataAdapter da1 = new SqlDataAdapter(cmd1);
DataSet ds1 = new DataSet();
dt1.Clear();
da1.Fill(dt1);
dataGridView1.Rows[e.RowIndex].ErrorText = String.Empty;
Column2.DataSource = dt1;
Column2.DisplayMember = "ProdName";
Column2.ValueMember = "ProdID";
}
}