[Atomika3000]

I am trying to get the results of an SQL SELECT query, and then seperate the columns and put them into seperate labels.

my query is

Quote

SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=E:\dCoffeeInfo.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
SqlCommand selection = new SqlCommand("SELECT * FROM tCoffee WHERE CoffeeName = '" + selected + "'", conn);

conn.Open();
selection.ExecuteNonQuery();
SelectedOrigin.Text =
conn.Close();

It should fetch this data as an example:

Quote

1 | After Dinner | Medium | Africa | 8 | 10000 | <image>

i want them spit into the following labels

Quote

<not needed> | Name Label | Strength Label | Origin Label | Price Label | Quantity Label | ImageBox

Hope that makes sense

~Jack

[NavilShah]

the simpler way is to store the output into data table and then assign the values to label

for example

Label1.Text = dt.rows[0][0].ToString();
Label1.Text = dt.rows[0][1].ToString();
.
.
.
.
.
.
Labeln.Text = dt.rows[0][n].ToString(); // n no of Label

Try this it would really work....

[Atomika3000]

hang on, i should probably explain better, i am getting the contents of the "selected" variable from another page via a session...
explained better here

its coming from a grid view on the other page, into the session, then into a variable, and then used in a query to get the rest of that row...

will that still work?

[Nakor]

Can you post the full code for what you are currently trying along with whatever errors you are getting? Just the code from where you're getting the value from session up to where you are trying to put the values into the labels should be enough.

[Ninjato]

Atomika3000, on 21 March 2011 - 04:39 AM, said:

conn.Open();
selection.ExecuteNonQuery();
SelectedOrigin.Text =
conn.Close();

ExecuteNonQuery() method will only execute the query and in return will provide you with no. of rows affected, so there is no scope of fetching the data using ExecuteNonQuery() method. To fetch data from the SELECT Query use SqlDataReader, that will make you understand to show them onto Label Control.

You need to create an instance how class SqlDataReader and initialize it by calling ExecuteReader() method of SqlCommand Object.

[Atomika3000]

ok, i understand that i have to use the "ExecuteReader()" method, but i'm still not sure how to get the results from the Reader() into seperate labels. the MSDN website is a little confusing

Getting The Name From a GridView, Into a Session And Then Redirecting Page

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
        {
            GridViewRow row = GridView1.SelectedRow;
            Session["Selected"] = row.Cells[1].Text;
            Response.Redirect("Information.aspx");
        }

This next part happens on a new page

Getting The Rest Of The Row, And Filling The Other Labels

string selected;

        protected void Page_Load(object sender, EventArgs e)
        {
            SelectedItem.Text = (string)Session["Selected"];
            selected = (string)Session["Selected"];
            SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=K:\dCoffeeInfo.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
            SqlCommand selection = new SqlCommand("SELECT * FROM tCoffee WHERE CoffeeName = '" + selected + "'", conn);

            conn.Open();

            SqlDataReader reader = selection.ExecuteReader();

            while (reader.Read())
            {
                Console.WriteLine(String.Format("{0}, {1}", reader[0], reader[1]));
            }

            reader.Close();
        }

Hope this helps

This post has been edited by Atomika3000: 22 March 2011 - 03:57 AM

[Nakor]

try something like this

while (reader.Read())
{
    Label1.Text = reader["column_name1"].ToString();
    Label2.Text = reader["column_name2"].ToString();
    Label3.Text = reader["column_name3"].ToString();
}

Hopefully it's obvious, but if not, you need to change "column_name#" to the actual name of the column in your database you are wanting to put into that label. And change the names of the labels to match the labels in your application.

[Atomika3000]

Brilliant, thanks!