این کد موقع اجرا روی خط cmlogin.ExecuteNonQuery(); تو قسمت else پیغام خطا می ده عکس خطا هم ضمیمه کردم.
for (int j = 0; j < dG_Vkalar.Rows.Count - 1; j++)
{
tbl_mojoodiTableAdapter.FillBy_code_kala(dS_main.T bl_mojoodi, (int)dG_Vkalar.Rows[i].Cells["code_kala"].Value);
if (tblmojoodiBindingSource.Count > 0)
{
SqlConnection connection = new SqlConnection(anbardari.Properties.Settings.Defaul t.ConnectionSetting);
SqlCommand cmlogin = new SqlCommand();
connection.Open();
cmlogin.CommandType = CommandType.Text;
cmlogin.CommandText = "update tbl_mojoodi set enterNum=enterNum+ '" + dG_Vkalar.Rows[j].Cells["num"].Value.ToString() + "' where code_kala= '" + dG_Vkalar.Rows[j].Cells["code_kala"].Value.ToString() + "'";
cmlogin.Connection = connection;
cmlogin.ExecuteNonQuery();
connection.Close();
//"update tbl_mojoodi set enternum=enternum+ " + dG_Vkalar.Rows[i].Cells["num"].Value.ToString() + " where code_kala= " + dG_Vkalar.Rows[i].Cells["code_kala"].Value.ToString();
//code Sunm +Update
}
else
{
SqlConnection connection = new SqlConnection(anbardari.Properties.Settings.Defaul t.ConnectionSetting);
SqlCommand cmlogin = new SqlCommand();
connection.Open();
cmlogin.CommandType = CommandType.Text;
cmlogin.CommandText = "insert into tbl_mojoodi set enterNum='" + dG_Vkalar.Rows[j].Cells["num"].Value.ToString() + "' where code_kala= '" + dG_Vkalar.Rows[j].Cells["code_kala"].Value.ToString() + "'";
cmlogin.Connection = connection;
cmlogin.ExecuteNonQuery();
connection.Close();
//code insert
{
{
ضمیمه 75273
