<EditFormSettings EditFormType="Template">
<FormTemplate>
<table id="Table2" cellspacing="2" cellpadding="1" width="100%" border="0">
<tr class="EditFormHeader">
<td colspan="2" style="font-size: small"><b>Account Details</b></td>
</tr>
<tr>
<td valign="top">
<table id="Table3" width="350" border="0" class="module">
<tr>
<td>Code:</td>
<td>
<asp:TextBox ID="txtClientAccount" runat="server" Text='<%# Bind( "ClientAccount" ) %>'></asp:TextBox>
</td>
</tr>
<tr>
<td>Description:</td>
<td>
<asp:TextBox ID="txtAcctDescription" runat="server" Text='<%# Bind( "Description" ) %>' Width="300px"></asp:TextBox>
</td>
</tr>
</table>
</td>
<td valign="top">
<table id="Table1" width="350" border="0" class="module">
<tr>
<td>
<table id="Table4" width="350" border="0" class="module">
<tr>
<td>Status:</td>
<td><asp:DropDownList ID="ddlStatus" runat="server" SelectedValue='<%# Bind("AccountStatus") %>' AppendDataBoundItems="True">
<asp:ListItem Text="" Value=""></asp:ListItem>
<asp:ListItem Text="Active" Value="Active"></asp:ListItem>
<asp:ListItem Text="Inactive" Value="Inactive"></asp:ListItem>
</asp:DropDownList>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="right" colspan="2">
<asp:Button ID="btnCancel" Text="Cancel" runat="server" CausesValidation="False" CommandName="Cancel"></asp:Button>
</td>
</tr>
</table>
</FormTemplate>
</EditFormSettings>
<
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