Executing stored procedure

Below code showing how to fetch data using Stored Procedure in C# programming language.


SqlCommand cmd1 = new SqlCommand("[wmb_Register]", con);
  cmd1.CommandType = CommandType.StoredProcedure;
  cmd1.Parameters.Add("@flag", SqlDbType.Int).Value = 0;
  cmd1.Parameters.Add("@Username", SqlDbType.NVarChar).Value = Uname.ToString();
  cmd1.Parameters.Add("@Password", SqlDbType.NVarChar).Value = Pwd.ToString();
  cmd1.Parameters.Add("@Firstname", SqlDbType.NVarChar).Value = Fname.ToString();
  cmd1.Parameters.Add("@Lastname", SqlDbType.NVarChar).Value = Lname.ToString();
  cmd1.Parameters.Add("@Email", SqlDbType.NVarChar).Value = Email.ToString();
  cmd1.Parameters.Add("@Phno", SqlDbType.NVarChar).Value = Phno.ToString();
  cmd1.Parameters.Add("@status", SqlDbType.Bit).Value = 0;
  cmd1.Parameters.Add("@subscribed", SqlDbType.NText).Value = 0;
            //cmd1.Parameters.Add("@ID", SqlDbType.NVarChar).Value = 0;

  SqlParameter idParameter = new SqlParameter("@UserID", SqlDbType.Int);
  idParameter.Direction = ParameterDirection.Output;
  cmd1.Parameters.Add(idParameter);

  cmd1.ExecuteNonQuery();
  ID = Convert.ToInt32(idParameter.Value);
 return ID;