Code:
clsobjact.InsertData("insert into Customer(Date)values('" & Format(System.DateTime.Today.Date, "MM/dd/yyyy") & "')")
Monty sing
Last Activity: Jan 17 '12, 06:08 AM
Joined: Jan 14 '12
Location:
-
Dear NeoPa i Checked the Date Keyword in my Sql server DB but it's not showing anytype of error as you said Date is reserved keyword. I m using the below query for Checking.
-
I think your Connection is already open and you are trying to reopen it that's cause the error is showing
use code to check the state of database whether is open or closedLeave a comment:
-
Use above code on SelectedIndexCh anged EventCode:Private Sub ComboBox_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox.SelectedIndexChanged ComboSecond.items.add(ComboFirst.Items.Item(Me.ComboFirst.SelectedIndex) End sub
Leave a comment:
-
The Sql Server save Date in above format so use this and he datatype in DB should be Datetime. Try above queryCode:"INSERT INTO usr_problem_list(trouble_no, date, user, notes)VALUES(" & Text30.Value & ",'" & Format(System.DateTime.Today.Date, "MM/dd/yyyy") & "', '" & user_name & "', '" & txtNotes & "')"Leave a comment:
-
SQL server VS2005 Between Date problem
I am facing problem while fetching a data from SQL server DB
below is a query i'm executing
This query was working correct 2 days back but today i executed the same query and showing below errorCode:select * from Customer where(OrderDate BETWEEN '02/01/2012' and '14/01/2012') and (Item='Dell')
"The Conversion of char datatype to a datetime datatype resulted in an out-of-range datetime value"
...
No activity results to display
Leave a comment: