dualshck012
Active member
Why i'm getting this problem? 'ArgumentOutOfRangeException' was unhandled' in line #5.
- An unhandled exception of type 'System.ArgumentOutOfRangeException' occurred in mscorlib.dll
- Additional information: Index was out of range. Must be non-negative and less than the size of the collection.
- An unhandled exception of type 'System.ArgumentOutOfRangeException' occurred in mscorlib.dll
- Additional information: Index was out of range. Must be non-negative and less than the size of the collection.
C#:
private void Sett_icts_DGV_prodAssign_CellValueChanged(object sender, DataGridViewCellEventArgs e)
string prodid;
int prodid1;
{
prodid = Sett_icts_DGV_prodAssign.Rows[e.RowIndex].Cells["prodassignid"].Value.ToString();
if (prodid == "")
{
prodid1 = 0;
}
else
{
prodid1 = Convert.ToInt32(Sett_icts_DGV_prodAssign.Rows[e.RowIndex].Cells["prodassignid"].Value.ToString());
}
if (prodid1 == 0)
{
conn2.Open();
string query601A = "INSERT INTO ihsasprodassign(prodassigndesc, prodassignkey, prodassigndte, prodassigntme, prodassignstat) VALUES('" + Sett_icts_DGV_prodAssign.Rows[e.RowIndex].Cells["prodassigndesc"].Value.ToString() + "' , '" + Convert.ToInt32(Sett_icts_DGV_prodAssign.Rows[e.RowIndex].Cells["prodassignkey"].Value.ToString()) + "' , '" + DateTime.Now + "','" + DateTime.Now + "', 'A')";
cmda = conn2.CreateCommand();
cmda.CommandType = CommandType.Text;
cmda.CommandText = query601A;
cmda.ExecuteNonQuery();
conn2.Close();
}
else
{
conn2.Open();
string query601B = "UPDATE ihsasprodassign set prodassigndesc='" + Sett_icts_DGV_prodAssign.Rows[e.RowIndex].Cells["prodassigndesc"].Value.ToString() + "', prodassignkey='" + Convert.ToInt32(Sett_icts_DGV_prodAssign.Rows[e.RowIndex].Cells["prodassignkey"].Value.ToString()) + "',prodassignmod='" + DateTime.Now + "' WHERE prodassignid=" + mysqlconstring.prodid1 + "";
cmda = conn2.CreateCommand();
cmda.CommandType = CommandType.Text;
cmda.CommandText = query601B;
cmda.ExecuteNonQuery();
conn2.Close();
}
}