Всем добрый день.
Проблема с изменением записи.
Пишу следующее:
String Author,Name,City,Printer,YearPrint,CountPage,ISBN,Comment,IdType;
Author = Authortbx2.Text;
Name = Nametbx2.Text;
City = Citytbx2.Text;
Printer = Printertbx2.Text;
YearPrint = Yeartbx2.Text;
CountPage = CountPagetbx2.Text;
ISBN = ISBNtbx2.Text;
Comment = Commenttbx2.Text;
IdType = TypeLitddl2.SelectedValue;
String Filter = "IdLiterature = "+IdLit;
SqlDataAdapter sqladaptSR = new SqlDataAdapter ("SELECT * FROM tSuggestedReading WHERE IdLiterature="+IdLit,sqlCommonConnect);
sqladaptSR.SelectCommand.CommandText ="SELECT * FROM tSuggestedReading WHERE IdLiterature="+IdLit;
DataSet dsSR = new DataSet ();
SqlCommandBuilder cmdSR = new SqlCommandBuilder (sqladaptSR);
sqladaptSR.Fill (dsSR,"tSuggestedReading");
DataColumn [] keys = new DataColumn [1];
keys[0] = dsSR.Tables["tSuggestedReading"].Columns["IdLiterature"];
dsSR.Tables["tSuggestedReading"].PrimaryKey = keys;
dsSR.Tables["tSuggestedReading"].Rows[0]["Author"] = Author;
sqladaptSR.Update (dsSR.Tables["tSuggestedReading"]);

Выдает следующую ошибку:
Exception Details: System.InvalidOperationException: Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information.