Here the SP contain input param @yy,@ww,@dd,@shift,
and output param is @ddd. I want to get the @ddd after exection.
How to specify param for putput here?
sqlConnection1.Open()
queryString1 = "tableA"
sqlCommands = New SqlCommand(queryString1, sqlConnection1)
sqlCommands.CommandType = CommandType.StoredProcedure
sqlCommands.Parameters.Add(New SqlParameter("@yy", SqlDbType.VarChar))
sqlCommands.Parameters("@yy"
.Value = ddlfy.SelectedItem.Text
sqlCommands.Parameters.Add(New SqlParameter("@ww", SqlDbType.VarChar))
sqlCommands.Parameters("@ww"
.Value = ddlww.SelectedItem.Text
sqlCommands.Parameters.Add(New SqlParameter("@dd", SqlDbType.VarChar))
sqlCommands.Parameters("@dd"
.Value = ddldw.SelectedItem.Text
sqlCommands.Parameters.Add(New SqlParameter("@shift", SqlDbType.VarChar))
sqlCommands.Parameters("@shift"
.Value = ddlshift.SelectedItem.Text
......
yyy = sqlCommands.ExecuteScalar
|