Saving in SQL db data from Calendarextender and Maskededitextender

[=?Utf-8?B?ZWdzZGFy?=]

Hello, I'm trying to save data from textboxes that are connected to a
calendarextende r and masketeditexten der in my SQL db and it is doing it, the
problem is with the date and the money fields in the db.



This is my query colected from my form:

Insert into Propuesta (idprospecto, Objeto, fecharecibo, fechaentrega,
idusuario, idestado, presupuestocop, presupuestousd ) values ('1', 'esta es
la prueba para la empresa de telecomunicacio nes de bogota, del sector publico
y con el id 1', 10/14/2008, 10/14/2008, 22222222, 1, '5.657', '123.456')

this is the data saved for the date and money and smallmoney fields:

01/01/1900 12:00:00 am for both and 5,6570 and 123,4560 for money and
smallmoney respectively.

This is the code:

<asp:TextBox ID="TxtFechaRec ibo" runat="server" Style="position : static"
Width="70px"></asp:TextBox>

<img id="btndate" src="Images/date.png" style="position : static" />

<cc1:CalendarEx tender ID="CalendarExt ender1" runat="server"
TargetControlID ="TxtFechaRecib o" PopupButtonID=" btndate">

</cc1:CalendarExt ender>


*************** *************** *************** *************** *************** *************** *************** *************** *************** **********

<asp:TextBox ID="TxtCOP" runat="server" Style="position : static"
Width="121px"></asp:TextBox>

<cc1:MaskedEdit Extender ID="MaskedEditE xtender1" runat="server"
TargetControlID ="TxtCOP"

Mask="9,999,999 ,999"

MaskType="Numbe r"

InputDirection= "RightToLef t"

DisplayMoney="L eft"

AcceptNegative= "None">

</cc1:MaskedEditE xtender>



How can I solve this?

[Hans Kesting]

Re: Saving in SQL db data from Calendarextende r and Maskededitexten der

egsdar explained :

Hello, I'm trying to save data from textboxes that are connected to a
calendarextende r and masketeditexten der in my SQL db and it is doing it, the
problem is with the date and the money fields in the db.
>
>
>
This is my query colected from my form:
>
Insert into Propuesta (idprospecto, Objeto, fecharecibo, fechaentrega,
idusuario, idestado, presupuestocop, presupuestousd ) values ('1', 'esta es
la prueba para la empresa de telecomunicacio nes de bogota, del sector publico
y con el id 1', 10/14/2008, 10/14/2008, 22222222, 1, '5.657', '123.456')
>
this is the data saved for the date and money and smallmoney fields:
>
01/01/1900 12:00:00 am for both and 5,6570 and 123,4560 for money and
smallmoney respectively.

Do *not* write out the query (search for "sql injection"), but use
parameters to supply the values. Then you can use a DateTime or decimal
value directly, without string conversions.

Hans Kesting

>
This is the code:
>
<asp:TextBox ID="TxtFechaRec ibo" runat="server" Style="position : static"
Width="70px"></asp:TextBox>
>
<img id="btndate" src="Images/date.png" style="position : static" />
>
<cc1:CalendarEx tender ID="CalendarExt ender1" runat="server"
TargetControlID ="TxtFechaRecib o" PopupButtonID=" btndate">
>
</cc1:CalendarExt ender>
>
>
*************** *************** *************** *************** *************** *************** *************** *************** *************** **********
>
<asp:TextBox ID="TxtCOP" runat="server" Style="position : static"
Width="121px"></asp:TextBox>
>
<cc1:MaskedEdit Extender ID="MaskedEditE xtender1" runat="server"
TargetControlID ="TxtCOP"
>
Mask="9,999,999 ,999"
>
MaskType="Numbe r"
>
InputDirection= "RightToLef t"
>
DisplayMoney="L eft"
>
AcceptNegative= "None">
>
</cc1:MaskedEditE xtender>
>
>
>
How can I solve this?