Breaking News: Grepper is joining You.com. Read the official announcement!

sql command to execute stored procedure with parameters c#

Add Answer

Rasel Ahmed answered on May 15, 2021 Popularity 9/10 Helpfulness 4/10

answer sql command to execute stored procedure with parameters c#

related sql server execute stored procedure with parameters

related sql server execute stored procedure with table parameter

sql command to execute stored procedure with parameters c#

Comment

private static string connectionString = ConfigurationManager.ConnectionStrings["TestDB"].ConnectionString;
static SqlConnection conn = null;

public static void OpenConnection()
{
  conn = new SqlConnection(connectionString);
  conn.Open(); // open the connection
}

public static void CloseConnection()
{
  if (conn != null)
  {
    conn.Close(); // close the connction
    conn.Dispose(); // destroy the connection object
  }
}


// Open database connection before operation

// to insert or update table data:
string queryString = @"pr_insert_update";
SqlCommand command = new SqlCommand(queryString, conn);

SqlParameter TaskIdParam = new SqlParameter();
SqlParameter CreatedByIdParam = new SqlParameter();

TaskIdParam.ParameterName = "@TaskId";
TaskIdParam.SqlDbType = SqlDbType.Int;
TaskIdParam.Value = int.Parse(taskId.ToString());
command.Parameters.Add(TaskIdParam);

CreatedByIdParam.ParameterName = "@CreatedById";
CreatedByIdParam.SqlDbType = SqlDbType.Int;
CreatedByIdParam.Value = int.Parse(createdById.ToString());
command.Parameters.Add(CreatedByIdParam);

command.CommandType = CommandType.StoredProcedure;

command.ExecuteNonQuery();

// ======================================================
  string sql = "INSERT INTO TableName(Column1, Column2) " +
"VALUES(@Column1, @Column2)";

 using (SqlCommand cmd = new SqlCommand(sql, conn))
 {
   cmd.Parameters.AddWithValue("@Column1", "TestValue");
   if (String.IsNullOrEmpty(myObject.Column2))
     cmd.Parameters.AddWithValue("@Column2", DBNull.Value);
   else
     cmd.Parameters.AddWithValue("@Column2", myObject.Column2);
   
    cmd.CommandType = CommandType.Text;
    cmd.ExecuteNonQuery();
 }

//--------------------------------------------------------------
// ------------------ To get query data ------------------------  
List<string> emailNames = new List<string>();

 string queryString = @"pr_get_data";
SqlCommand command = new SqlCommand(queryString, conn);
SqlParameter TaskIdParam = new SqlParameter();

TaskIdParam.ParameterName = "@TaskId";
TaskIdParam.SqlDbType = SqlDbType.Int;
TaskIdParam.Value = int.Parse(taskId.ToString());
command.Parameters.Add(TaskIdParam);

command.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
  string emailName = null;
  if (reader["EmailName"] != null && reader["EmailName"] != DBNull.Value)
  {
    emailName = reader["EmailName"].ToString();
  }

  emailNames.Add(emailName);
}


-------------------------------------------------------- 
int id = 1;  
string queryString = @"SELECT * FROM TableName WHERE Id = " + id + " ";

SqlCommand command = new SqlCommand(queryString, conn);
SqlDataReader reader = command.ExecuteReader();

while (reader.Read())
{
  var id = Int32.Parse(reader["Id"].ToString());
}

Popularity 9/10 Helpfulness 4/10 Language csharp

Source: Grepper

Tags: c# command execute parameters procedure sql

Link to this answer
Share Copy Link

Contributed on Jul 28 2022

Rasel Ahmed

0 Answers Avg Quality 2/10

Closely Related Answers

sql server execute stored procedure with parameters

Comment

CREATE PROCEDURE dbo.uspGetAddress @City nvarchar(30) AS
SELECT * FROM Person.Address WHERE City = @City

EXEC dbo.spGetAddress @City = 'Bordeaux'

Popularity 10/10 Helpfulness 5/10 Language sql

Source: www.mssqltips.com

Tags: execute

Link to this answer
Share Copy Link

Contributed on May 15 2021

VasteMonde

0 Answers Avg Quality 2/10

sql server execute stored procedure with table parameter

Comment

DECLARE @data ObjectList
INSERT @data (Id) VALUES (1)
EXEC GetData @data

Popularity 9/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: execute

Link to this answer
Share Copy Link

Contributed on Aug 31 2023

Yawning Yak

0 Answers Avg Quality 2/10

sql command to execute stored procedure with parameters c#

Contents

More Related Answers

sql command to execute stored procedure with parameters c#

Closely Related Answers

sql server execute stored procedure with parameters

sql server execute stored procedure with table parameter

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.