regarding datagrid

[nagalakshmibasireddy]

hello, I have used two datasets for two tables and i have to pass these two datasets into datagrid.. i am using sqlserver 2000 plz help in this regarding, Thanks & Regards, Nagalakshmi -- modified at 6:16 Wednesday 21st December, 2005

[Roy Heil]

OK. What's the problem? Do you need to know how to bind a dataset to a datagrid? Are you having problems switching to the second dataset? Are you trying to bind both datasets to the datagrid at the same time? Roy.

[aarvee53]

Firstly I am not clear why you are trying to use two datasets. In my experience a single dataset se globally for the application will meet all the needs and is of course much easier to administer and control. You can keep adding and removing tables from them as and when you need it. That apart, if you want to just attach the datatable to the datagrid set it as the datasource of the grid. On the other hand, if you want to extract data from both the datasets and present it in a single datagrid, then I am afraid you must first extract the required info from the datasets in to a single table and then datasource it to the grid. Hope this helps. Varadarajan R

[mcgann]

What kind of database are you using? 1.SQL Server 2.MS Access Paul