how to add sqldatasource to gridview which is having data without override?

Question

I am new to .Net application development. I'm working on a project using MS Access. In my application I have one Gridview with unbound data. I have one SQL Datasource which I bind to Gridview dynamically. When I bind that SQL Datasource to the Gridview the existing data is overridden. Instead of overriding I want to append the rows to the existing rows in Gridview.

gzaxx · Accepted Answer · 2013-07-17 10:33:52Z

1

You can't do that. Best fix would be not to use SqlDataSource and get data from db, merge it with existing and bind it to grid.

answered Jul 17, 2013 at 10:33

gzaxx

17.6k2 gold badges40 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vidhya Sagar Reddy · Accepted Answer · 2013-07-17 10:35:22Z

1

That was doing the right thing; It definitely overrides the previous data. In that case, you need to create a dataset and append the newly fetched table data to the existing table in the dataset.. :)

answered Jul 17, 2013 at 10:35

Vidhya Sagar Reddy

1,6411 gold badge14 silver badges26 bronze badges

Comments

Soner Gönül · Accepted Answer · 2013-07-17 10:41:11Z

1

You can't.

Gridview can have only one datasource at time. Every time you try to bind another datasource, it always overrides the existing one.

One of the best option is to use JOIN if these datasource are in same database.

Check also:

ASP.NET tips: Display resultset from Multiple DataTable

answered Jul 17, 2013 at 10:41

Soner Gönül

99.1k103 gold badges224 silver badges375 bronze badges

Comments

Md. Parvez Alam · Accepted Answer · 2013-07-17 10:50:41Z

1

create a view with multiple data datable a sample code is below

jv = New JoinView(ds.Tables!Ord, _
     "OrderID,CustomerID,EmployeeID,OrderDate,CustOrd.CompanyName Company,CustOrd.ContactName Contact,CustOrd.ContactTitle Position,EmpOrd.FirstName,EmpOrd.LastName", _
     "EmployeeID<5", "OrderDate")
DataGrid1.DataMember = ""
DataGrid1.DataSource = jv

for more info go through

http://support.microsoft.com/default.aspx?scid=kb;EN-US;325682

answered Jul 17, 2013 at 10:50

Md. Parvez Alam

4,6086 gold badges58 silver badges120 bronze badges

Collectives™ on Stack Overflow

how to add sqldatasource to gridview which is having data without override?

4 Answers 4

Comments

Comments

You can't.

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

You can't.

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related