Datasource from string

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

Is it possible to create a datasource for dataview control for an sql
string?

Thanks

Regards
 
John,

A dataview is not a control, it is a view on the datatable.

Cor
 
John,

Not really. You need to create a new datasource that uses your sql string:

Dim sql as String = "SELECT * FROM Table1"
Dim con as String = "Data Source=Northwind;Initial Catalog=Table1;Integrated
Security=True"
Dim ds as DataSource = new DataSource(sql, con)

The code above is untested, though. I think it needs the sql connection
string, but I could be mistaken.

Hope that helps!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DataView as DataSource 6
Filling a ComBox manually with DisplayMember and ValueMember 2
Determining the DataViewRow that was clicked in a DataGridView 1
Datatable as bindingsource datasource 1
CurrencyManager 1
adding extra items on top of ComboBox DataSource 6
sorting gridview question 6
Hard-Coding Vs Coding for Dynamic Header 0

Back
Top