how to pass valus to SqlDataSource's parameters

[Esperanza Ramos]

Hi, All:

I am trying to use SqlDataSource.Update() to save records.

<

asp:SqlDataSource ID="sdsUpdateAll" runat="server" ConnectionString="<%$ ConnectionStrings:ConnString %>">
<UpdateParameters>
<asp:Parameter Name="billed" Type="DateTime" ConvertEmptyStringToNull="true" />
</UpdateParameters>
</asp:SqlDataSource>

and:

sdsUpdateAll.UpdateCommand =

string.Format("update MyTable set  Billed = @billed " + ...

sdsUpdateAll.Update();

My question is: How to pass a value, say '5/10/2008', into parameter @billed.

thanks.

Stanley

[Esperanza Ramos]

Hi, All:

Thanks.  I solved the situation by using stored procedures.  sorry.

Stanley

[Shanmug]

Hi All,
I'm also having a same kind of problem. I'm using the SqlDataSource and Select Command with Parameters in the .aspx itself. I need to pass one of my Session values as the parameter value in the WHERE Clause of the Select statement in the Select Command. How can I pass the server side Session value in the .aspx?