میشه علت این کارت رو توضیح بدی؟واسه چی میخوای اول Select کنی و بعد Insert?
البته واسه انجامش باید ی چیزی مثل اینو بنویسی احتمالا
command.CommandText = "SELECT * FROM Customer WHERE CustomerID =" + _customerID;
customerDataAdapter.SelectCommand = command;
customerDataAdapter.SelectCommand.ExecuteNonQuery( );
command.CommandText = "INSERT INTO Customer (CustomerID, FirstName, LastName, " +
"Address, PhoneNumber1, phoneNumber2, CustomerDetail, CustomerSince) VALUES (" + _customerID + ", '" +
_firstName + "', '" + _lastName + "', '" + _address + "', '" + _phoneNumber1 + "', '" +
_phoneNumber2 + "', '" + _customerDetail + "', '" + _customerSince + "')";
command.ExecuteNonQuery();