How to pass an DataSet

[Duong Nguyen]

Hello!
I have a WebMethod like this

[WebMethod]

public void MakeOrder(DataSet ds)

{

try

{

// insert into order details

foreach (DataRow dr in ds.Tables[0].Rows)

{

cmd = new SqlCommand("OrderDetails_Insert", conn);

cmd.CommandType = CommandType.StoredProcedure;

parms = new SqlParameter[4];

parms[0] = new SqlParameter("@OrderID", SqlDbType.BigInt);

parms[0].Value = 1;

parms[1] = new SqlParameter("@ProductID", SqlDbType.Char, 10);

parms[1].Value = dr["@ProductID"].ToString();

parms[2] = new SqlParameter("@Qty", SqlDbType.Float);

parms[2].Value = Convert.ToSingle(dr["Qty"]);

parms[3] = new SqlParameter("@Price", SqlDbType.Money);

parms[3].Value = Convert.ToSingle(dr["Price"]);

foreach (SqlParameter p in parms)

cmd.Parameters.Add(p);

if (conn.State != ConnectionState.Open)

conn.Open();

cmd.ExecuteNonQuery();

}

}

catch {}

finally

{

conn.Close();

}

}

Then I call this method from my application. Everything seems to be OK. But
when I check my Database (into where the web-method must insert data from
dataset ), I got nothing here.

I wondered if I must call my Web-Method by Value (not be reference), is it
true? If true, so how to do it? Pls help me

Thanks you!

--
Contact:
Bauman Moscow State Technical University
Russia, Moscow 105005
Tel: [phone]
ICQ: 160-223-078
YM: Chipheo2k

[Martin Kulov [MVP]]

"Duong Nguyen" <Du*********@mail.ru> wrote in message
news:e9**************@TK2MSFTNGP03.phx.gbl...

Then I call this method from my application. Everything seems to be OK.
But when I check my Database (into where the web-method must insert data
from dataset ), I got nothing here.

Hi Duong,

check if you are accessing the correct table. If you have multiple tables in
the dataset, the table that you are looking for may be not with index 0.

Regards,

--
Martin Kulov
http://www.codeattest.com/blogs/martin

MVP, MCT, MCSD, MCPD

[MACH II]

I think it would be a good idea to check the return value after executing the
Query. Read below for return results.

For UPDATE, INSERT, and DELETE statements, the return value is the number of
rows affected by the command. For all other types of statements, the return
value is -1. If a rollback occurs, the return value is also -1.
"Duong Nguyen" wrote:

Hello!
I have a WebMethod like this

[WebMethod]

public void MakeOrder(DataSet ds)

{

try

{

// insert into order details

foreach (DataRow dr in ds.Tables[0].Rows)

{

cmd = new SqlCommand("OrderDetails_Insert", conn);

cmd.CommandType = CommandType.StoredProcedure;

parms = new SqlParameter[4];

parms[0] = new SqlParameter("@OrderID", SqlDbType.BigInt);

parms[0].Value = 1;

parms[1] = new SqlParameter("@ProductID", SqlDbType.Char, 10);

parms[1].Value = dr["@ProductID"].ToString();

parms[2] = new SqlParameter("@Qty", SqlDbType.Float);

parms[2].Value = Convert.ToSingle(dr["Qty"]);

parms[3] = new SqlParameter("@Price", SqlDbType.Money);

parms[3].Value = Convert.ToSingle(dr["Price"]);

foreach (SqlParameter p in parms)

cmd.Parameters.Add(p);

if (conn.State != ConnectionState.Open)

conn.Open();

cmd.ExecuteNonQuery();

}

}

catch {}

finally

{

conn.Close();

}

}

Then I call this method from my application. Everything seems to be OK. But
when I check my Database (into where the web-method must insert data from
dataset ), I got nothing here.

I wondered if I must call my Web-Method by Value (not be reference), is it
true? If true, so how to do it? Pls help me

Thanks you!

--
Contact:
Bauman Moscow State Technical University
Russia, Moscow 105005
Tel: [phone]
ICQ: 160-223-078
YM: Chipheo2k