hello i want to display data from multiple tables with multiple rows using repeater control in asp.net using c#?
how its possible tell me as soon as possible ...???
If you are using Visual Studio, the easiest way is to drop a repeater control on the page and use the data source wizard to populate the repeater control.
Do you know how to write a SQL query that includes joins so that you can query data from multiple tables?
I'm thinking that the easiest way to grab information from multiple tables is to create a view in the SQL server.
And from your code you can call upon that as if it was a single normal table.
All the mixing and matching using joins is handled by the server, so you don't have to concerns yourself so much about it in code.
The only drawback is that you can't modify the view in any way. Only read.
thankx alot i got it....