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

get returned row from stored procedure in c#

Nanu answered on April 10, 2023 Popularity 1/10 Helpfulness 1/10

answer get returned row from stored procedure in c#

get returned row from stored procedure in c#

Comment

Employee test = new Employee();
            try
            {
                Employee tmpRecord = new Employee();

                SqlConnection connection = new SqlConnection(_configuration.GetConnectionString("EmployeeAppCon"));

                SqlCommand command = new SqlCommand("insert_data", connection);
                command.CommandType = System.Data.CommandType.StoredProcedure;
                connection.Open();
                command.Parameters.AddWithValue("@Employee_name", objEmployee.EmployeeName);
                command.Parameters.AddWithValue("@Department", objEmployee.Department);
                command.Parameters.AddWithValue("@Email", objEmployee.EmailId);
                SqlDataReader reader = command.ExecuteReader();

                while (reader.Read())
                {
                    test.EmployeeId = int.Parse(reader["employeeID"].ToString());
                    test.EmployeeName = reader["employeeName"].ToString();
                    test.Department = reader["department"].ToString();
                    test.EmailId = reader["emailId"].ToString();
                }
                
            }
            catch (Exception e)
            {

                throw;
            }
            return  test;

Popularity 1/10 Helpfulness 1/10 Language csharp

Source: Grepper

Tags: c# get procedure row

Link to this answer
Share Copy Link

Contributed on Apr 10 2023

Nanu

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

get returned row from stored procedure in c#

Contents

More Related Answers

get returned row from stored procedure in c#

Grepper

Documentation

Social

Legal

Contact

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