im searching for a single row result with 3 columns all of which i want to paste into a single asp:label.

is it better to get the data using datareader or dataset?

if datareader howto access all datareader items using
 For Each Item In

do help..


ps: is it possible to share/inherit the classes between different codebehind files say between common.vb & finance.vb

Why you want to "paste" the search result to label control? Isn't it good to display the result using DataGrid control?

DataReader is the faster technique for reading data from database if compared to other method. Anyhow, I still do not have any idea yet in fetching data using DataReader, I use only DataAdapter together with DataSet.

The following is the sample coding that I have tried, you can use it as alternative way for this moment until there is the one who may advice you on how to access all the DataReader item using foreach loop. Here is the coding:

void Page_Load(object sender, EventArgs e)
{
    if (!Page.IsPostBack)
    {
        string conn = "server=(local);database=Northwind;" +
                        "integrated security=true;";

        string queryString = "select * from Products";

        SqlConnection DbConn = new SqlConnection(conn);

        SqlCommand DbComm = new SqlCommand(queryString, DbConn);

        SqlDataAdapter Adapter = new SqlDataAdapter();

        Adapter.SelectCommand = DbComm;

        DataSet dataSet = new DataSet();

        Adapter.Fill(dataSet, "Products");

        for (int i = 0; i < 5; i++)
        {
            if (i < 4)
                Label1.Text += dataSet.Tables["Products"].Rows[0][i].ToString() + "," + " ";
            else
                Label1.Text += dataSet.Tables["Products"].Rows[0][i].ToString();
        }

        Label1.DataBind();
  }
}

the point is i only have one result say like the shipping address field of a company .. & i wanted it when i create a new purchase order.. in such a situation whats the logic in using a datagrid?

the following code is ok if i know the exact no. of fields in the sql return .. but in my case i made a function to which i give the sql statement and it returns the single result as string . . since i dont have a choice for the time being im using ur code ... thanx hlchuah77

ps:i use vb.net