Inserting new row into a DataTable available in Dataset without using SQL Queries
cn = new SqlConnection("Server=Dbserver2;Database=NorthWind;User Id=sa;Password=bit");
da = new SqlDataAdapter("Select * from Categories",cn);
ds = new DataSet();
da.Fill(ds,"Categories");
da.TableMappings.Add("Table","Categories");
SqlCommandBuilder cb = new SqlCommandBuilder(da);
DataRow dr = ds.Tables[0].NewRow() ;
dr["CategoryName"] = "testbyGan";
dr["Description"]="Some Time";
ds.Tables[0].Rows.Add(dr);
da.Update(ds,"Categories");