hiya.
i'v have a datagrid but i want to populate it with data from two tables, is that possible?

{
        DBAnslutning();
        strSQL = "SELECT artNr, produktNamn, farg, langd, antal, pris FROM Kundvagn WHERE Kundvagn.kundNr ='" + Session["Knr"].ToString() + "';";
        strSQL2 += "SELECT Summa, Frakt FROM FraktKostnad WHERE FraktKostnad.kundNr ='" + Session["Knr"].ToString() + "';";
        objDataAdapter = new OleDbDataAdapter(strSQL, objConnection);
        objDataAdapter = new OleDbDataAdapter(strSQL2, objConnection);
        objDataSet = new DataSet();

        objDataAdapter.Fill(objDataSet, "Kundkorg");

        dgLista.DataSource = objDataSet;

        dgLista.DataBind();

        objConnection.Close();


        return objDataSet;

}
thus far it doesent work?

plz help.

You have to fill 2 tables using your 2 adapters. You should have some kind of join condition to relate the data properly.. Using one select.

Jim

thx for your answere.

but how will i do that?

I am very new to all of this.

objDataAdapter.Fill(objDataSet, "Kundkorg");
objDataAdapter2.Fill(objDataSet, "Table2");