Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Jan 18, 2013 12:24 PM by geniusvishal
Jan 13, 2013 01:52 PM|LINK
I want t show data in gridview from two tables, also want to update the command from gridview edit command.
Jan 13, 2013 02:40 PM|LINK
Did you chek this article I think it could be helpful for what I understood that you want to perfomr with the GridView.
Jan 13, 2013 03:24 PM|LINK
i am talking here about two tables, i know how to do if i am using 1 table.
Jan 13, 2013 03:27 PM|LINK
When you say to table do you mean that you get the data from both create a third one and use that one as a DataSource of your GridView?
Jan 18, 2013 08:25 AM|LINK
For your issue, you can try to write a stored Procedure which can be used to update data to two tables at first. Then set the UpdateCommand as stored Procedure as follows:
Jan 18, 2013 08:33 AM|LINK
you can create a dataview from 2 tables and then use it as datasource for grid
Jan 18, 2013 09:16 AM|LINK
If ,in the both tabel any common field available ,then you can use join for selecting Data from Both Tabel.
Jan 18, 2013 12:24 PM|LINK
Create two dataset for two different datasource... Then join this using
Dataset.Merge() Method ... Display this joined dataset as the datasource of your gridview..