|
|
|
|
how do insert data using dataset..
Category : Asp.Net by arun
Posted on 11/10/2008
|
|
i want insert data using dataset . can any tell me code...
advance thanks
arun
|
|
Answers
|
| mohan on 13/10/2008 | hi arun,
see the below code, its useful for you,
using System;
using System.Data;
using System.Data.SqlClient;
class testClass
{
static void Main()
{
string connectionString = "…";
string query = @"select * from testTable";
SqlConnection sqlConn = new SqlConnection(connectionString);
try {
SqlDataAdapter daTest = new SqlDataAdapter();
daTest.SelectCommand = new SqlCommand(query, sqlConn);
SqlCommandBuilder cb = new SqlCommandBuilder(daTest);
DataSet dsTest = new DataSet();
daTest.Fill(dsTest, " testTable");
DataTable dtTest = dsTest.Tables["testTable"];
// Add a row
DataRow newRow1 = dtTest.NewRow();
newRow["col1"] = "a";
newRow["col2"] = "b";
dtTest.Rows.Add(newRow1);
daTest.Update(dsTest, " testTable");
}
catch(Exception e)
{
}
finally
{
sqlConn.Close();
}
}
}
Thanks
Mohan.
|
|
Post Answer
|
|
|
|
|
Copyright©2008 Dot Net Gallery. All Rights Reserved.| Privacy Policiy | Contact
|