getting a value from a SqlDataReader 2

[AT76]

Hi,

I'm executing a SQL String that gets the Top 1 value from a column. This value is of type int. I would like to save this value to a variable to be displayed later in a prompt (DisplayValue). Here's my code:

int DisplayValue;
string strSQL = "SELECT TOP 1 VALUE FROM LIST";
SqlCommand cmd = new SqlCommand(strSQL, conn);

//Create/Populate the DataReader
SqlDataReader dr;
dr = cmd.ExecuteReader();

I'm not sure how to pass dr to "DisplayValue". I have tried using:

DisplayValue = dr.GetValue();

But have not been successful. Any advice will be greatly appreciated! Thanks!!!

 

[dvannoy]

You can try this (VB)

DisplayValue = dr("Value")

 

[ca8msm]

Assign a variable (in the section that does the Response.Write) from the example in faq855-5662


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[jbenson001]

Since you are returning only one value, I would use
yourvar = cmd.ExecuteScalar

Jim

 

[Guru7777]

You can either do (C#)

//Create/Populate the DataReader
SqlDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
DisplayValue = dr.GetValue(0);
}

or do as JimBenson suggested.

----------------------------------------

TWljcm8kb2Z0J3MgIzEgRmFuIQ==

 

[AT76]

Thanks to everyone!!!

 

[jbenson001]

glad to help