getting the data from more than one table

[kalyanilovesme]

hi,

i have three tables named types,books,artcles

types consist of books,artcles

books consist of title,authorname,userid(means book title and author of the book)
articles consist of title,authorname,userid(means articletitle and author of the article)


i have a datagrid ...names of the columns are in the datagrid is

type,userid,title,author


if he enters the data in the book.the type should be book and the book title should come in the title column along with userid and author name in the respective columns.

and same for article also.

how can i write the query for" if it is book,then in the title column book title has to come" in the datagrid
how can i write the query for" if it is article,in the title column article title has to come" in the datagrid

and howe can i bind this to datagrid

[dip_developer]

hi,

i have three tables named types,books,artcles

types consist of books,artcles

books consist of title,authorname,userid(means book title and author of the book)
articles consist of title,authorname,userid(means articletitle and author of the article)


i have a datagrid ...names of the columns are in the datagrid is

type,userid,title,author


if he enters the data in the book.the type should be book and the book title should come in the title column along with userid and author name in the respective columns.

and same for article also.

how can i write the query for" if it is book,then in the title column book title has to come" in the datagrid
how can i write the query for" if it is article,in the title column article title has to come" in the datagrid

and howe can i bind this to datagrid

I dont think you are very much clear about your requirement......
Tell me who will chhose the type??
From where the type will be chosen???

I suggest you the following......
Take a combobox to choose type.....On SelectedIndexChanged event of the combobox set your sql query like this....

 Dim cType as String 
Dim strSql as String
Select Case cType 
Case "Book"
strSql ="SELECT  title,authorname,userid FROM book"
Case "Article"
strSql ="SELECT  title,authorname,userid FROM article"
End Select
 

now execute the query......fill a dataset...and bind your grid with this dataset......or altenatively you can use a datareader too...