Author: milindsaraswala | Posted on: 11/18/2009 7:21:08 AM | Views : 330

I am using .net 1.1 I am using Query into MS SQl Server below is the code but it gives error on MakeDate function


Dim cn As New SqlConnection(System.Configuration.ConfigurationSettings.AppSettings("connstring")) Dim Query As String = "" Dim Query2 As String = "Select @@Identity" Query = "Insert into Customer (Name,Date,FlightNo,DepartingTo,ArrivingFrom,ContactNo,MobileNo,Email,Others,TransactionType) Values(" Query = Query & "'" & txName.Text & "'," Query = Query & "'" & MakeDate(DPC_txDate.Text) & "'," Query = Query & "'" & txFlightNo.Text & "'," Query = Query & "'" & txDepartingTo.Text & "'," Query = Query & "'" & txArrivingFrom.Text & "'," ...

Go to the complete details ...