Alguien me podria decir como asignarle parametros a la consulta de este codigo ,especificamente la fecha..?
Dim DS2 As DataSet
Dim MyConnection2 As SqlConnection = New SqlConnection("Data Source=192.168.200.20;Initial Catalog=Ventas;User ID=sa;Password=stm01")
MyConnection2.Open()
Dim MyCommand2 As SqlDataAdapter
Dim suborden2 As String
MyCommand2 = New SqlDataAdapter("select SUM (VENTA)from SALES2 where SID =1 and idate>='2012-10-31' ", MyConnection2)
'----------------------------------------------para que quede asi.
MyCommand2 = New SqlDataAdapter("select SUM (VENTA)from SALES2 where SID =1 and idate>=@fecha ", MyConnection2)
'---------------------------------------------
DS2 = New DataSet()
MyCommand2.Fill(DS2, "venta")
Label1.Text = DS2.Tables(0).Rows(0)(0).ToString()
'DataGridView1.DataSource
MyConnection2.Close()