Search English (United States)  தமிழ் (இந்தியா)
Tuesday, January 06, 2009 ..:: Forum ::.. Register  Login
 
  Forum  General Discuss...  Computers and C...  Inserting new row into a DataTable available in Dataset without using SQL Queries
Previous Previous
 
Next Disabled
New Post 6/11/2008 10:18 AM
  Ganesh Kumar
29 posts
No Ranking




Inserting new row into a DataTable available in Dataset without using SQL Queries  (India)

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");


Ganesh Kumar
 
Previous Previous
 
Next Disabled
  Forum  General Discuss...  Computers and C...  Inserting new row into a DataTable available in Dataset without using SQL Queries
Copyright 2007 by technicalganesh.com   Terms Of Use  Privacy Statement
DotNetNuke® is copyright 2002-2009 by DotNetNuke Corporation