ExecuteScalar()

Question

Hi,

I'm having trouble getting the return data from the ExecuteScalar() Command.

What conversion do i have to do to display it in say messagebox?

This is what i've got and it doesn't work!

Thanks,    

Code Snippet

 private void button1_Click(object sender, EventArgs e)
        {
            string Connstr;
            string sql = "SELECT TOP 1 User_ID FROM CS_Users";
            String r = "a";
                      Connstr = @"Data Source=JON-DB04294BD9C\SQLEXPRESSMAIN;Initial Catalog=Vision_CS_DB;Integrated Security=True";

            using (SqlConnection conn = new SqlConnection(Connstr))
            {
                conn.Open();
                

SqlCommand cmd = new SqlCommand(sql, conn);
                r = (string)cmd.ExecuteScalar()

MessageBox.show(r)

                 conn.Close();

            }
        }

 

Answer 1

What exactly does not work? Do you get an error? Do you have something in the table you wanna select form?

 

Answer 2

I want to get the return value from the executeScalar command into a variable that i can use somewhere else.

i keep getting the error saying cannot convert into string

Answer 3

Jon1s wrote:

I want to get the return value from the executeScalar command into a variable that i can use somewhere else. i keep getting the error saying cannot convert into string

That's probably because that ID you wanna get is not a string, but a int. Modify the variable you're getting it into to int.

Answer 4

Cool,

Fixed it i just need to convert the value returned from the executescalar to a string

string r = Convert.Tostring(cmd.executescalar() );
messagebox.show(r)


Thanks for your help

Jon

Answer 5

Jon1s wrote:

Cool, Fixed it i just need to convert the value returned from the executescalar to a string string r = Convert.Tostring(cmd.executescalar() ); messagebox.show(r) Thanks for your help Jon

It was my pleasure. Thank you for marking your own post as answer.