Interested to Buy Any Domain ? << Click Here >> for more details...
how can we display records in single datagrid using two
datasets in different place?
- 2 Answers
- 7921 Views
- Global Computer, Honeywell, I also Faced
- E-Mail Answers
Answer Posted / ruby
we can do it using merge method of dataset.
but for that bot the tables must have same no. of columns , same fields and their respective datatypes.
also both the data table's name must be same("Table1" of both the datasets)
Sub BindGrid()
Dim myConnection as New SqlConnection (strConn)
Dim DS1 As DataSet
Dim DS1 As DataSet
Dim MyCommand As SqlDataAdapter
MyCommand = new SqlDataAdapter("exec s_get_table1", MyConnection)
DS1 = new DataSet()
MyCommand.Fill(DS1, "Table1")
MyCommand = new SqlDataAdapter("exec s_get_table2", MyConnection)
DS2 = new DataSet()
MyCommand.Fill(DS2, "Table1")
// Then using MERGE function of dataset we can merge both the datasets like
ds1.merge(ds2)
//binding with grid
MyDataGrid.DataSource=DS1.tables(0).DefaultView
MyDataGrid.DataBind()
End Sub
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Explain different types of validators in asp.net?
What are the main requirements for caching?
Are cookies client side or server side?
What is asp according to you?
What are the types of caching in asp.net?
What is route in web api?
What is state management techniques in asp.net?
How do you remove duplicates without using remove duplicate stage?
How can you ensure a permanent cookie?
How can we access static variable?
How you can add an event handler?
What is the full form of asp.net?
What is asp.net response object?
Explain how cookies work. Give an example of cookie abuse.
What is Difference between Production Serves and Development Servers? And Suppose, m adding/deleting C# file in a project based on the Specific Requirement. These Files are Automatically updated in Production Servers? So Which tool is needed to do This One?
