Comments by Mahar Tanvir

Mahar Tanvir 21-Jun-16 2:48am View

at the end line error is occured "String was not recognized as a valid DateTime"

Sub GetDetails(ByVal id As String)

Try
Dim sqlDetails As String = Nothing

sqlDetails = " SELECT [ID],[Branch],[generator],[readingdate],[timeon],[timeoff],"
sqlDetails += "[PrevReading],[CurrReading], "
sqlDetails += " CreatedBy,CreateDate,ModifiedBy,ModifyDate FROM [generator] Where ID= " & id

Dim dr As DataRow = objglb.GetDRow(sqlDetails, glbFunctions.strVUDBCon)
If Not dr Is Nothing Then
at end line error occured and error is "String was not recognized as a valid DateTime"
ViewState("ID") = dr("ID").ToString
ddlBranch.Value = dr("Branch").ToString()
ddlgenerator.SelectedValue = dr("generator").ToString()

txtreadingdate.Text = dr("readingdate").ToString()

Mahar Tanvir 15-Jun-16 3:51am View

txtreadingdate.Text = dr("readingdate").ToString() at that line when i subbmit in format of "dd/MM/yyyy" then error is occured

Mahar Tanvir 27-May-16 0:45am View

all are has varchar datatype and except date has only date

Mahar Tanvir 27-May-16 0:41am View

kindly send me dummy program for programming .am new in development and am learning myself

Mahar Tanvir 26-May-16 7:53am View

is it correct form to use to build sql Command with connection string?
Con = New SqlConnection("Data Source=VU-IT-INTERN1;Initial Catalog=fuelsystem;User ID=sa;Password=123")

Try
Con.Open()
Cmd = New SqlCommand("DELETE FROM fuel Where Fuel_Id='" & txtfillingid.Text & "' AND GenID='" & txtGeneratorId.Text & "' AND F_date='" & txtDate.Text & "' AND S_F_reading='" & txtBeforefilling.Text & "' AND E_F_reading='" & txtAfterfilling.Text & "' AND Total_Feul='" & TxtTottal.Text & "'", Con)

Mahar Tanvir 26-May-16 7:44am View

Sir as You above says that"Do not concatenate strings to build a SQL command"
kindly told me about connection and command how i should do it

Comments by Mahar Tanvir (Top 6 by date)