Assign values from SQL Server procedure to variable in c#?

Question

Here is my code in Microsoft Visual Studio ASP.NET MVC4 using C#

int numRows = new SqlCommand("execute getRows", con);

Error message:

Cannot implicitly convert type 'System.Data.SqlClient.SqlCommand' to 'int'

Am I missing a step? Like do I have to do an ExecuteReader() type of thing?

I can't find a good resource on using SQL commands in ASP.NET MVC 4.

I know NOT to use string concatenation b/c of SQL injection, so I'm trying to use SQL Server stored procedure.

Here is the procedure:

CREATE PROCEDURE getRows
AS
BEGIN
    select COUNT(*) 
    from myTable 
    where Status = 1
END

Note: I have tried casting with (int) and with Int.Parse. I assume it has something to do with reading it? Or with making getRows procedure have an output?

ExecuteScalar() will help you in this case.

Giorgi Nakeuri
– Giorgi Nakeuri

2015-09-22 04:41:50 +00:00
Commented Sep 22, 2015 at 4:41 — Giorgi Nakeuri
– Giorgi Nakeuri, Commented Sep 22, 2015 at 4:41
Yes that worked! Thank you

Kabir Peshawaria
– Kabir Peshawaria

2015-09-22 04:47:06 +00:00
Commented Sep 22, 2015 at 4:47 — Kabir Peshawaria
– Kabir Peshawaria, Commented Sep 22, 2015 at 4:47

Backs · Accepted Answer · 2015-09-22 04:40:15Z

4

It's a little more complicated:

SqlConnection sqlConnection1 = new SqlConnection("Your Connection String");
SqlCommand cmd = new SqlCommand();
SqlDataReader reader;

cmd.CommandText = "StoredProcedureName";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = sqlConnection1;

sqlConnection1.Open();

int numRows = (int)cmd.ExecuteScalar();

sqlConnection1.Close();

More information.

answered Sep 22, 2015 at 4:40

Backs

25k5 gold badges66 silver badges92 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Assign values from SQL Server procedure to variable in c#?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related