How to call a SQL server Stored Procedure from a C# Data Object

Hello Edward,

Please find below n example for Datareader for get data from database,

            // Connection string to your SQL Server
            string connectionString = "YourConnectionStringHere";

            // Create a SqlConnection
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                // Open the connection
                connection.Open();

                // Create a SqlCommand
                using (SqlCommand command = new SqlCommand("YourStoredProcedureName", connection))
                {
                    // Set the command type to Stored Procedure
                    command.CommandType = CommandType.StoredProcedure;

                    // Add parameters if your stored procedure has any
                    // For example:
                    // command.Parameters.AddWithValue("@ParameterName", parameterValue);

                    // Execute the stored procedure
                    SqlDataReader reader = command.ExecuteReader();

                    // Process the results if necessary
                    while (reader.Read())
                    {
                        // Access data using reader
                        // For example: string value = reader.GetString(0);
                    }
                }
            }

Example for ExecutiveNonQuery for Insert, Update, Delete,

        string connectionString = "your_connection_string_here";
        string storedProcedureName = "your_stored_procedure_name";

        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            using (SqlCommand command = new SqlCommand(storedProcedureName, connection))
            {
                command.CommandType = CommandType.StoredProcedure;

                // Add parameters if your stored procedure has any
                command.Parameters.Add(new SqlParameter("@ParameterName", parameterValue));

                try
                {
                    connection.Open();
                    int rowsAffected = command.ExecuteNonQuery();

                    Console.WriteLine($"Rows Affected: {rowsAffected}");
                }
                catch (Exception ex)
                {
                    Console.WriteLine("Error: " + ex.Message);
                }
            }

Please refer this link which will help you out,

https://www.c-sharpcorner.com/article/crud-operation-in-c-sharp-windows-application-using-store-procedure/