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
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