Hello all,
I have written code for Updtaing the user information for a specific row.But when i run this code i am getting Run time Exception "InvalidOperationException" And Message "Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information."Am i doing anything wrong in code?
public static DataSet getUserInfo() { DataSet ds = new DataSet(); string connectionstring = " "; SqlConnection con = new SqlConnection(connectionstring); SqlCommand cmd = new SqlCommand(@"select FirstName from User_Info",con); SqlDataAdapter sda = new SqlDataAdapter(cmd); SqlCommandBuilder scb = new SqlCommandBuilder(sda); sda.Fill(ds); //Before Change Console.WriteLine("\n\t"+ds.Tables[0].Rows[1]["FirstName"]); ds.Tables[0].Rows[1]["FirstName"] = "Sam"; //Update in Database sda.Update(ds); //After Change Console.WriteLine("\n\t" + ds.Tables[0].Rows[1]["FirstName"]); return ds;
}
Please help me out to resolve this problem.And please tell where i get tutorials for this Ado.Thanks 4 ur help.