alsam
asked on
converting datetime picker value in vb.net
Hi,
I'm trying to conver datetime picker value dd.mm.yyyy into yyyy.mm.dd and pass it as param value in my vb.net code to execute delete command.
Unfortunatelly it does not work this way. Can someone help me...
Thanks
I'm trying to conver datetime picker value dd.mm.yyyy into yyyy.mm.dd and pass it as param value in my vb.net code to execute delete command.
Unfortunatelly it does not work this way. Can someone help me...
Thanks
Dim cmd As New System.Data.SqlClient.SqlCommand()
cmd.Connection = cn
cmd.CommandType = CommandType.Text
cmd.CommandText = "DELETE FROM BAL_SHEET WHERE DATE_VAL = @date_val"
cmd.Parameters.Add("@date_val", SqlDbType.NVarChar)
cmd.Parameters("@date_val").Value = Format(Me.DateTimePicker2.Text.ToString,"YYYY.MM.DD"))
cmd.ExecuteNonQuery()
cmd.Parameters("@date_val" ).Value = Format(Me.DateTimePicker2. Text.ToStr ing,"YYYY/ MM/DD")
my mistake, better use the following:
Dim cmd As New System.Data.SqlClient.SqlCommand()
cmd.Connection = cn
cmd.CommandType = CommandType.Text
cmd.CommandText = "DELETE FROM BAL_SHEET WHERE DATE_VAL = @date_val"
cmd.Parameters.Add("@date_val", SqlDbType.NVarChar)
cmd.Parameters("@date_val").Value = Format(Me.DateTimePicker2.Text.ToString,"YYYY-MM-DD"))
cmd.ExecuteNonQuery()
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
wrong again, that will do it:cmd.Parameters("@date_v al").Value = Format(Me.DateTimePicker2. Text.ToStr ing,"yyyy/ mm/dd"))
ASKER
It returns
Syntax error converting datetime from character string.
Syntax error converting datetime from character string.
Have you tried my solution?
is this doesn't work???
cmd.Parameters("@date_val" ).Value = Format(Me.DateTimePicker2. Text.ToStr ing("yyyy/ mm/dd"))
cmd.Parameters("@date_val"