回复： Re: .Net Controls On Front Panel (DataGrid) Not Displaying Data

[Big Hank]

Charles,

You have many way to do this, ADO, ODBC, OLEDB, and SQL Client.

First what are you connecting to....

If It's only MS SQL Server 2000 or Newer the SQL Client Best.

If it's Active X Only connection then ADO is the Best Choose but Slow.

The ODBC is an older verision of OLEDB Connection And this is the General Connection.

ADO is a cheap warpper of OLEDB, and OLEDB is faster that ADO.

OLEDB can connection to SQL Server, But not with the speed and ADV. functions of SQL Client.

The ADO is found in ADODB .Net Library

The rest is found in System.Data .Net Library

I use the OLEDB to talk to Access and SQL Server and didn't what to develop two difference connection.

This "Fill Data Grid" is a simple form of what happens in the SubVI.

There are alot opt. for the connection and Auto Complete Update, Insert, and Delete Commands, other Functions

That is not the purpose of this Tread.

Maybe someone should start a Tread on .Net System.Data and Databases in .Net 

[02040032200]

Hi,

i have got the solution for it.

i have displayed all the data from SQL server databse on a form using .NET object.

See the attachment.

[Big Hank]

What Attachment?

Check it, I don't see an attachment.

[钟]

Using BindingContext and DataGridView's DataBindings.Add Method , It works, but DataGridView can not input Chinese! It display Chinese well.

[smercurio_fc]

Please do not ask the same exact question on three different threads. Same question here.

[Dipsy]

can you please post the code?

Thanks.

[smercurio_fc]

Which code are you referring to, and whom are you asking? There's been several bits of code posted in this thread.

[Dipsy]

I was asking about the code for data display on .NET datagrid.

But fortunately i got the solution on the discussion forum in other link.

Thanks.

[MehakD]

Dev,

Could you post the link to the solution you found? It would be helpful for all who stumble by this discussion forum.

Thanks

Mehak 

[Dipsy]

Hi Mehak,

Here is the code attachment of what I have developed for displaying SQL database values into .NET Datagrid.

Hope this is the one you are looking for..

Message Edited by ddddddddddddddddddddd on 09-12-2008 10:27 AM