The following exception occured in the DataGridView:

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";

}
}

Tags: DataGridView