zareei_ta
سه شنبه 25 مرداد 1390, 12:53 عصر
ایراد این کد چیه که عمل اپدیت را انجام نمیده
cn.ConnectionString = StrConnection;
cmd.CommandType = CommandType.Text;
cmd.Connection = cn;
cmd.CommandText = "update Groups set GroupName=(N'" + txtGroup.Text.Trim() + "'),SubGroupName=(N'" + txtSubGroup.Text.Trim() + "') where (GroupName=('" + GroupGridView.SelectedRow.Cells[0].Text + "')and SubGroupName=(N'" + GroupGridView.SelectedRow.Cells[1].Text + "')) ";
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
lblInfo.Text = ".تغییرات مورد نظر اعمال شد";
txtGroup.Text = "";
txtSubGroup.Text = "";
BindGrid();
cn.ConnectionString = StrConnection;
cmd.CommandType = CommandType.Text;
cmd.Connection = cn;
cmd.CommandText = "update Groups set GroupName=(N'" + txtGroup.Text.Trim() + "'),SubGroupName=(N'" + txtSubGroup.Text.Trim() + "') where (GroupName=('" + GroupGridView.SelectedRow.Cells[0].Text + "')and SubGroupName=(N'" + GroupGridView.SelectedRow.Cells[1].Text + "')) ";
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
lblInfo.Text = ".تغییرات مورد نظر اعمال شد";
txtGroup.Text = "";
txtSubGroup.Text = "";
BindGrid();