DataAdapter

[Shalini Noronha]

Hi

I use a DataAdapter. To which is pass a Stored Proc and
Connection

SqlDataAdapter DA = new SqlDataAdapter("storedProd",Conn);
how do i pass parameters to my stored proc

Kindly Help

[S. Justin Gengo]

Shalini,

You should create a SqlCommand object

SqlClient.SqlCommand SqlCommand;
SqlCommand.CommandText = "storedProd";
SqlCommand.CommandType = CommandType.StoredProcedure;
SqlCommand.Parameters.Add(New SqlClient.SqlParameter("@MyFirstParameter",
[Value As Object]);
SqlCommand.Parameters.Add(New SqlClient.SqlParameter("@MySecondParameter",
[Value As Object]);

SqlCommand.Connection = Conn

SqlDataAdapter DA = new SqlDataAdapter(SqlCommand);

Sincerely,

--
S. Justin Gengo, MCP
Web Developer

Free code library at:
[url]www.aboutfortunate.com[/url]

"Out of chaos comes order."
Nietzche


"Shalini Noronha" <shalini_maria@yahoo.com> wrote in message
news:032901c35d19$4e32e630$a301280a@phx.gbl...

> Hi
>
> I use a DataAdapter. To which is pass a Stored Proc and
> Connection
>
> SqlDataAdapter DA = new SqlDataAdapter("storedProd",Conn);
> how do i pass parameters to my stored proc
>
> Kindly Help