Dataset Updation

[Vinod I]

Hi Team,
I want to use DataSet in my ASP.Net application extensively.

Scenario is,
I am showing Data Set in one of my ASP.Net Page and changing row & column
values thru Page. After that I want to send this changed DataSet to Server
side and want to use "DataAdapter.Up date" to commit the change into
Database.

Is this possible ?

Please let me know with code.

Thanks in advance.

-Vinod

[Kikoz]

Part of some of my classes (hope it'll give you a clue
where to go):

public static void UpdateDataTable (DataTable
dataTable,SqlCo nnection conn,string sql,params object[]
parameters)
{
SqlCommand comm = PrepareCommand
(conn,sql,param eters);
SqlDataAdapter da = new SqlDataAdapter( comm);
DataSet ds = new DataSet();
da.Fill(ds);
SqlCommandBuild er cb = new SqlCommandBuild er(da);
UpdateDataTable (ds.Tables[0],dataTable);
da.Update(ds.Ta bles[0]);
}
public static SqlCommand PrepareCommand( SqlConnection
connection,stri ng sql, params object[] parameters)
{
SqlCommand comm = PrepareCommand( sql,parameters) ;
if( connection.Stat e == ConnectionState .Closed )
connection.Open ();
comm.Connection = connection;
return comm;
}
public static SqlCommand PrepareCommand( string sql,params
object[] parameters)
{
SqlCommand comm = new SqlCommand(sql) ;
Regex re = new Regex
(@"(@\w+)",Rege xOptions.ECMASc ript);
MatchCollection mParams = re.Matches(sql) ;
for( int g=0; g < mParams.Count && g <
parameters.Leng th; g++ )
comm.Parameters .Add(mParams
[g].Value,paramete rs[g]==null?DBNull.V alue:parameters[g]);
return comm;
}
sql string is a select statement used to populate dataset
which gives that Table.

Regards.

-----Original Message-----
Hi Team,
I want to use DataSet in my ASP.Net application extensively.
Scenario is,
I am showing Data Set in one of my ASP.Net Page and changing row & columnvalues thru Page. After that I want to send this changed DataSet to Serverside and want to use "DataAdapter.Up date" to commit the change intoDatabase.

Is this possible ?

Please let me know with code.

Thanks in advance.

-Vinod
.

[Vinod I]

Hi Kikoz,

Thanks for the reply.

But I was looking for something else,

I repeat, I have a Dataset "DS1" in my ASP.Net page. Now I want to submit
back this Dataset to the Datalayer at Server side and Commit the Changes.
How I will make the dataadapter and attach to the dataset in this case as I
don't have the dataadapter which created to populate the dataset.

In windows applications, we used to send back the Dataset along with
Dataadapeter. How to do it in ASP.Net ?

If there is any alternative suggestions, let me know.

Thanks,

-Vinod


"Kikoz" <an*******@disc ussions.microso ft.com> wrote in message
news:04******** *************** *****@phx.gbl.. .

Part of some of my classes (hope it'll give you a clue
where to go):

public static void UpdateDataTable (DataTable
dataTable,SqlCo nnection conn,string sql,params object[]
parameters)
{
SqlCommand comm = PrepareCommand
(conn,sql,param eters);
SqlDataAdapter da = new SqlDataAdapter( comm);
DataSet ds = new DataSet();
da.Fill(ds);
SqlCommandBuild er cb = new SqlCommandBuild er(da);
UpdateDataTable (ds.Tables[0],dataTable);
da.Update(ds.Ta bles[0]);
}
public static SqlCommand PrepareCommand( SqlConnection
connection,stri ng sql, params object[] parameters)
{
SqlCommand comm = PrepareCommand( sql,parameters) ;
if( connection.Stat e == ConnectionState .Closed )
connection.Open ();
comm.Connection = connection;
return comm;
}
public static SqlCommand PrepareCommand( string sql,params
object[] parameters)
{
SqlCommand comm = new SqlCommand(sql) ;
Regex re = new Regex
(@"(@\w+)",Rege xOptions.ECMASc ript);
MatchCollection mParams = re.Matches(sql) ;
for( int g=0; g < mParams.Count && g <
parameters.Leng th; g++ )
comm.Parameters .Add(mParams
[g].Value,paramete rs[g]==null?DBNull.V alue:parameters[g]);
return comm;
}
sql string is a select statement used to populate dataset
which gives that Table.

Regards.

-----Original Message-----
Hi Team,
I want to use DataSet in my ASP.Net application

extensively.

Scenario is,
I am showing Data Set in one of my ASP.Net Page and

changing row & column

values thru Page. After that I want to send this changed

DataSet to Server

side and want to use "DataAdapter.Up date" to commit the

change into

Database.

Is this possible ?

Please let me know with code.

Thanks in advance.

-Vinod
.