Inserting Datetimepicker in SQL Database

[cravish]

Hi,
I have a problem while inserting Datetimepicker value into Sql database.The value which gets inserted in database is 01/01/1900 which is the wrong one ,as I wanted today or current date to get inserted in database.
i am using VB.Net 2003 as my front-end and MS SQL 2000 as my back-End.
Please help me....

[dip_developer]

Hi,
I have a problem while inserting Datetimepicker value into Sql database.The value which gets inserted in database is 01/01/1900 which is the wrong one ,as I wanted today or current date to get inserted in database.
i am using VB.Net 2003 as my front-end and MS SQL 2000 as my back-End.
Please help me....

i have some question..
Are you picking date from datetimepicker??
Do you want to insert Today's date everytime???Then why are you using datetimepicker if the date is fixed???

two possibilities.....
1.If you are picking date from datetimepicker then use the following code

Dim myDate as Date
myDate=myDatepicker.Value

while inserting write code like...........
Insert into myTable (mDate) Values (#" & myDate & "#)

2. if you only want to insert current date then use getdate() method
like...
Insert into employee values (4,'John',25, getdate())

[cravish]

i have some question..
Are you picking date from datetimepicker??
Do you want to insert Today's date everytime???Then why are you using datetimepicker if the date is fixed???

two possibilities.....
1.If you are picking date from datetimepicker then use the following code

Dim myDate as Date
myDate=myDatepicker.Value

while inserting write code like...........
Insert into myTable (mDate) Values (#" & myDate & "#)

2. if you only want to insert current date then use getdate() method
like...
Insert into employee values (4,'John',25, getdate())

I am picking date from datetimepicker.But after taking your suggestion i am getting this error for date 23/08/2007 "The name #23 is not permitted in this context.Only constant,expressions,or variable are allowed here.Column names are not permitted".One thing i forgot to specify is the datatype for date in database which is smalldatetime.

[dip_developer]

I am picking date from datetimepicker.But after taking your suggestion i am getting this error for date 23/08/2007 "The name #23 is not permitted in this context.Only constant,expressions,or variable are allowed here.Column names are not permitted".One thing i forgot to specify is the datatype for date in database which is smalldatetime.

Please post your code......

[cravish]

Please post your code......

strQry = "insert into gin_mst(GINDate,GinNo,........,userId,LCNo)"
strQry = strQry & "values(#" & Format(myDate, "dd/MM/yyyy") & "#,'" & Trim(strGINNo) & "',.........,'" & userId & "','" & Trim(cmbLcNo.Text) & "')"
mycommand = New SqlCommand(strQry, myConnection)
ra = mycommand.ExecuteNonQuery


this is the Queery which i am using to insert date.

[dip_developer]

strQry = "insert into gin_mst(GINDate,GinNo,........,userId,LCNo)"
strQry = strQry & "values(#" & Format(myDate, "dd/MM/yyyy") & "#,'" & Trim(strGINNo) & "',.........,'" & userId & "','" & Trim(cmbLcNo.Text) & "')"
mycommand = New SqlCommand(strQry, myConnection)
ra = mycommand.ExecuteNonQuery


this is the Queery which i am using to insert date.

I have forgotten about sql-server.....very very sorry...
try

"insert into gin_mst (GINDate) values('" & Format$(dtpicker.value,
"dd.mm.yyyy") & "')"

[cravish]

I have forgotten about sql-server.....very very sorry...
try

"insert into gin_mst (GINDate) values('" & Format$(dtpicker.value,
"dd.mm.yyyy") & "')"

I tried what you have suggested but still its storing 01/01/1900 in database.

[shiponeye1]

Hi, just try with that.

datetime dMyDate=dtpPicker.value

cmdInsert="INSERT INTO MyTable(MyDate) VALUES('" & dMyDate.ToString("dd MMM yyyy") & "')"

you can insert any date in this format.

!!! SHIPON !!!

[cravish]

Hi, just try with that.

datetime dMyDate=dtpPicker.value

cmdInsert="INSERT INTO MyTable(MyDate) VALUES('" & dMyDate.ToString("dd MMM yyyy") & "')"

you can insert any date in this format.

!!! SHIPON !!!

Yes i know.... but i am using smalldatetime as my data-type.
If i use the above query it give an error for datatype i.e
"The conversion of char data type to smalldatetime resulted in out-of-range smalldatetime value.The statement has been teminated."

[spidervb]

@shiponeye1
its work ,,,, thanks :)