How to save the result of a SQL query in a variable in c#?

Question

I want to try to save the result of this query (I want to get the value of the primary key) into a variable in c# of a MDB database but I don't know how I can do it:

SELECT @@identity FROM Table

I've tried this but it doesn't work:

int variable;

    variable = cmd.CommandText("SELECT @@IDENTITY FROM TABLE");

PD: It isn't all the code, I have a problem only with this part.

generally speaking, you EXECUTE your query, which returns a statement handle, from which you fetch one or more rows of result data. — Marc B
– Marc B, Commented May 26, 2015 at 20:44
What object is cmd? IDbCommand has a CommandText property, but no method by that name. — Tim
– Tim, Commented May 26, 2015 at 20:49

Aram · Accepted Answer · 2015-05-26 20:45:08Z

2

You can use this snippet:

 SqlCommand command = new SqlCommand(
          "SELECT @@IDENTITY FROM TABLE",
          connection);
        connection.Open();

        SqlDataReader reader = command.ExecuteReader();

        if (reader.HasRows)
        {
            while (reader.Read())
            {
                Console.WriteLine("{0}\t{1}", reader.GetInt32(0),
                    reader.GetString(1));
            }
        }

answered May 26, 2015 at 20:45

Aram

5,7572 gold badges33 silver badges44 bronze badges

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

Comments

vmg · Accepted Answer · 2015-05-26 20:45:00Z

0

Is it complete code? You just created command object, but didn't open the connection and did not run the command.

using (SqlConnection conn = new SqlConnection(connString))
{
      SqlCommand cmd = new SqlCommand("SELECT @@IDENTITY FROM TABLE", conn);
        try
        {
            conn.Open();
            newID = (int)cmd.ExecuteScalar();
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.Message);
        }
 }

answered May 26, 2015 at 20:45

vmg

10.6k15 gold badges67 silver badges91 bronze badges

Collectives™ on Stack Overflow

How to save the result of a SQL query in a variable in c#?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related