Tring to insert date into SQL server Db
Here is my code:
<tr>
<td align="right" valign="top" ><B>Date: </B></TD>
<TD valign="top"><Input class="text3" input type="text" maxLength="12" id="txteffdt" name="date1" size="9" value="<%= FormatDateTime(now(),2)%>">
<A href="javascript:ShowCalendar(document.myForm.date img1,document.myForm.date1,null, '<%= FormatDateTime(DateAdd("yyyy", -1, now()),2)%>', '<%= FormatDateTime(DateAdd("yyyy", 1, now()),2)%>')" onclick=event.cancelBubble=true;>
<IMG align=top border=0 height=21 id=dateimg1 src="cal/calendar.gif" style="POSITION: relative" width=34></A></td>
</tr>
oCom17.Parameters.Add("@txteffdt", system.Data.SqlDbType.datetime, 12).value = txteffdt.text
I get this error message:
BC30456: 'value' is not a member of 'System.Web.UI.WebControls.TextBox'.
If I add runat="server" the popup calander locks up
can anyone give me any ideas
|