Error Conversion failed when converting date and/or time from character string

[mrprogman]

Tengo el siguiente codigo..me marca error cuando hago la consulta..


Conversion failed when converting date and/or time from character string

alguien sabe por que pueda ser.?..gracias


Dim DS2 As DataSet
Dim MyConnection2 As SqlConnection = New SqlConnection("Data Source=xx.xx.xx.xx;Initial Catalog=xx;User ID=xx;Password=xxx")
MyConnection2.Open()
Dim MyCommand2 As SqlDataAdapter
Dim suborden2 As String


MyCommand2 = New SqlDataAdapter("select SUM (VENTA) from SALES2 where SID =1 and [idate] >= @idate", MyConnection2)
Dim dt As New DataTable
MyCommand2.SelectCommand.Parameters.AddWithValue(" @idate", DateTimePicker1.Text)


DS2 = New DataSet()
MyCommand2.Fill(DS2, "venta")
Label1.Text = DS2.Tables(0).Rows(0)(0).ToString()
'DataGridView1.DataSource
MyConnection2.Close()

[Aquaventus]

Hola mrprogman, en qué linea de todo ese código se cae tu aplicación? Saludos!.

[mrprogman]

Dim DS2 As DataSet
Dim MyConnection2 As SqlConnection = New SqlConnection("Data Source=xx.xx.xx.xx;Initial Catalog=xx;User ID=xx;Password=xxx")
MyConnection2.Open()
Dim MyCommand2 As SqlDataAdapter
Dim suborden2 As String


MyCommand2 = New SqlDataAdapter("select SUM (VENTA) from SALES2 where SID =1 and [idate] >= @idate", MyConnection2)
Dim dt As New DataTable
MyCommand2.SelectCommand.Parameters.AddWithValue(" @idate", DateTimePicker1.Text)


DS2 = New DataSet()
MyCommand2.Fill(DS2, "venta") ****************Aqui marca el error
Label1.Text = DS2.Tables(0).Rows(0)(0).ToString()
'DataGridView1.DataSource
MyConnection2.Close()

[Aquaventus]

Ok, ahora tu campo idate de tu tabla que tipo es?

[mrprogman]

el campo es tipo Datetime

[Aquaventus]

Trata de hacer el siguiente cambio y nos cuentas :

Código vb:

MyCommand2.SelectCommand.Parameters.AddWithValue(" @idate", DateTimePicker1.Text)
 

a esto

Código vb:

MyCommand2.SelectCommand.Parameters.AddWithValue(" @idate", Convert.toDatetime(DateTimePicker1.Text))
 

Saludos!.

[cristiantorres]

Si haces.

Código vb.net:

MyCommand2.SelectCommand.Parameters.AddWithValue(" @idate", DateTimePicker1.Value)
 

Usas la propiedad value para obtener la fecha.

[drako_darpan]

Hola que tal, en VB casi no lo e usado, pero en C# seria algo asi:

sFecha = DateTimePicker1.Value.Year.ToString() + "-" + DateTimePicker1.Value.Month.ToString().PadLeft(2, '0') + "-" + DateTimePicker1.Value.Day.ToString().PadLeft(2,'0' );

Y eso lo mandas al SP.