Thursday, 20 August 2015

How to call stored procedure with parameters in VB.Net

cmd = New SqlCommand

        With cmd
            .Connection = con
            .CommandType = CommandType.StoredProcedure
            .CommandText = "ProProdDaily" //(StoreProcedure Name)
            .Parameters.Add("@vFDate", SqlDbType.DateTime).Value = frmRptProductionOpt.dtpProRptFDate.Text
            .Parameters.Add("@vTDate", SqlDbType.DateTime).Value = frmRptProductionOpt.dtpProRptTDate.Text
            .ExecuteNonQuery()
        End With