nokia1200
سه شنبه 14 آذر 1391, 19:34 عصر
دوستان من برای حذف از کد زیر استفاده میکنم اما نمیدونم چرا خطا میده مشکلش کجاست
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
sqlDataAdapter1.DeleteCommand.Connection = sqlConnection1;
sqlDataAdapter1.DeleteCommand.CommandText = "delete from ali where (id=@i)";
sqlDataAdapter1.DeleteCommand.Parameters.Add("@i", SqlDbType.Int);
long s;
s = (long)dataGridView1.SelectedRows[0].Cells[0].Value;
sqlDataAdapter1.DeleteCommand.Parameters["@i"].Value = s;
sqlConnection1.Open();
sqlDataAdapter1.DeleteCommand.ExecuteNonQuery();
sqlConnection1.Close();
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
sqlDataAdapter1.DeleteCommand.Connection = sqlConnection1;
sqlDataAdapter1.DeleteCommand.CommandText = "delete from ali where (id=@i)";
sqlDataAdapter1.DeleteCommand.Parameters.Add("@i", SqlDbType.Int);
long s;
s = (long)dataGridView1.SelectedRows[0].Cells[0].Value;
sqlDataAdapter1.DeleteCommand.Parameters["@i"].Value = s;
sqlConnection1.Open();
sqlDataAdapter1.DeleteCommand.ExecuteNonQuery();
sqlConnection1.Close();