I am trying to display non column values from three non related tables by using object data source. Is it possible if not what is the option. Please help I am new to asp.net 2.0

Hi there,

What do you mean with "display non column value"? Where do they come from if they don't come from a column?

Also, it would really help if you'd explain what you need help with. Data access and object data source controls are a broad topic, so unless we know what you need to know, we can't be of much help.

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004

let me explain you, I have three tables say table1,table 2, table3,
I want to display the column value id from table1, name from table 2 and company name from table3. Can I use single object data source to display them in grid view

<asp:GridView ID="GridView1" runat="server" DataSourceID="ObjectDataSource1" AutoGenerateColumns="false" AllowPaging="true" GridLines="Both">
        <Columns>
            <asp:BoundField DataField="Company" HeaderText="Company" SortExpression="Company" />
            <asp:BoundField DataField="# of Notes" HeaderText="# of Notes" SortExpression="# of Notes" />
            <asp:BoundField DataField="# of Downloads" HeaderText="# of Downloads" SortExpression="# of Downloads" />
        </Columns>




    </asp:GridView>

    <asp:ObjectDataSource selectMethod="displayCust" ID="ObjectDataSource1" runat="server"></asp:ObjectDataSource> Can i user selectMethod="displayCust" for all three tables. If yes please explain, if not what is the option

Yes you can.

In your code layer create a class that has the properties that you want to display. Then fire a SELECT statement against your database that gets the data from these three tables, possibly using a join.
In the object, copy the fields from the database (from a SqlDataReader for example) into your custom objects and return those objects to the ASPX page.
The GridView then displays the fields from the objects.

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004

not sure have faint idea can you help me out, step by step what will I do on page load, compclass, DBclass and vb class

Well, actually, I can't. That's quite a lot you are asking. The way you asked your question now sounds like you are asking me to your job... ;)

You may want to read up a bit about class design, data access, object orientation and controls like the ObjectDataSource control.

Maybe this is a good start: http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=416

People on this forum are more than willing to help with specific problems. However, you'll need to read and experiment a lot yourself as well.....

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004

I have your book asp.net instant results.Can you provide me an example, where can I find similiar kind of thing, so that I can I apply it. Thanks I will appreciate your help

The BugBase app does a lot with custom business objects. The stored procedures then access multiple tables.

Also the article I linked to should provide you with a lot of useful information.

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004