Invoke function with stored procedure as parameter

user_9798574 0
Viewed 214

I have the following function in C# which is working fine

private void AddQueue()
{
    SqlConnection conn = forconnection();
    conn.Open();

    SqlCommand cmd = new SqlCommand("spInsertFormIssue",conn);
    cmd.CommandType = CommandType.StoredProcedure;
    cmd.Parameters.Add("@Qdatetime", SqlDbType.DateTime).Value = DateTime.Now;

    cmd.ExecuteNonQuery();

    conn.Close();          
}

Now I want the same function but with different stored procedure, I want to reuse this function with another stored procedure.

How do I pass stored procedure as argument?

stored-procedures function sql-server c#
2 Answers

You can get the stored procedure name and parameters from request argument.

Like this:

private void AddQueue(string spName, List<SqlParameter> SqlParameters)
{
    ...
    SqlCommand cmd = new SqlCommand(spName, conn);
    ...

    if (SqlParameters.Count > 0)
           cmd.Parameters.AddRange(SqlParameters.ToArray());

    ...
}

And you can call it like this:

List<SqlParameter> sqlParameters = new List<SqlParameter>();
sqlParameters.Add(new SqlParameter("@Qdatetime", SqlDbType.DateTime) { Value = DateTime.Now });

AddQueue("spInsertFormIssue", sqlParameters);
user_45887560

Just pass name of the stored procedure as parameter:

string procedureName = "spInsertFormIssue";
private void AddQueue(string procedureName)
    {
        SqlConnection conn = forconnection();
        conn.Open();
        SqlCommand cmd = new SqlCommand(procedureName,conn);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@Qdatetime", SqlDbType.DateTime).Value = DateTime.Now;
        cmd.ExecuteNonQuery();
        conn.Close();          
    }
user_97522750
Related