Hi,
Please refer below code.
C#
string connectionString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
SqlConnection con = new SqlConnection(connectionString);
for (int i = 0; i < 5; i++)
{
using (SqlCommand cmd = new SqlCommand("ProcedureName"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@EMPLOYEE_NAME", "ahmad");
cmd.Parameters.AddWithValue("@EMPLOYEE_AGE", "12years");
cmd.Connection = con;
con.Open();
cmd.ExecuteScalar();
con.Close();
}
}
VB
Dim connectionString As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
Dim con As New SqlConnection(connectionString)
For i As Integer = 0 To 4
Using cmd As New SqlCommand("ProcedureName")
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.AddWithValue("@EMPLOYEE_NAME", "ahmad")
cmd.Parameters.AddWithValue("@EMPLOYEE_AGE", "12years")
cmd.Connection = con
con.Open()
cmd.ExecuteScalar()
con.Close()
End Using
Next
I hope this will help you out.