473,320 Members | 1,722 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Combobox with oracle database

Hi

I try to fill a combobox with a dataset. I see the data in the dataset, but when i try to bind this dataset with a combobox. The list is fill only whith this message "System.Data.DataRowView". That was my code, can you help me.

Thanks!

Tr

'Create connection object
Dim strConnNorthwind As String = "Provider=oraoledb.oracle;User Id=sigrem; " &
"Data Source=sigrem.metis;password=adminsigrem
Dim cnPubs As OleDbConnection = New OleDbConnection(strConnNorthwind
Dim PubsDA As New OleDbDataAdapter("SELECT * FROM Projet", cnPubs
Dim dsAuthors As New DataSe
PubsDA.Fill(dsAuthors, "Projet"
Dim dvAuthors As DataView = dsAuthors.Tables("Projet").DefaultVie
With cboPub
.DataSource = dvAuthor
.DisplayMember = "NoProjet
End Wit
'With lstTes
' .DataSource = dvAuthor
' .DisplayMember = "NomUsager
'End Wit
'cboPubs.SelectedIndex = -
'cnPubs.Dispose(
'PubsDA.Dispose(
Catch ex As Exceptio
MsgBox(ex.Message, MsgBoxStyle.Information, Me.Text
End Try
Nov 20 '05 #1
2 2677
Hi Antoine,

I don't see direct something, however the most change you have is that
"NoProjet" is not the name in the datatabel, it is case sensetive you know.

Did you know that those "with" statements are seldom used here anymore in
this newsgroup.
It's your choise of course, however for the typed characters you do not have
to do it, there are now more characters than without it.

However that was not the question, I hope the first sentence helps you.

Cor
Nov 20 '05 #2
Are you sure the datacolum names are correct? This is oftne the problem.
"Antoine" <an*******@discussions.microsoft.com> wrote in message
news:5F**********************************@microsof t.com...
Hi,

I try to fill a combobox with a dataset. I see the data in the dataset, but when i try to bind this dataset with a combobox. The list is fill only
whith this message "System.Data.DataRowView". That was my code, can you
help me.
Thanks!!

Try

'Create connection objects
Dim strConnNorthwind As String = "Provider=oraoledb.oracle;User Id=sigrem; " & _ "Data Source=sigrem.metis;password=adminsigrem"
Dim cnPubs As OleDbConnection = New OleDbConnection(strConnNorthwind) Dim PubsDA As New OleDbDataAdapter("SELECT * FROM Projet", cnPubs) Dim dsAuthors As New DataSet
PubsDA.Fill(dsAuthors, "Projet")
Dim dvAuthors As DataView = dsAuthors.Tables("Projet").DefaultView With cboPubs
.DataSource = dvAuthors
.DisplayMember = "NoProjet"
End With
'With lstTest
' .DataSource = dvAuthors
' .DisplayMember = "NomUsager"
'End With
'cboPubs.SelectedIndex = -1
'cnPubs.Dispose()
'PubsDA.Dispose()
Catch ex As Exception
MsgBox(ex.Message, MsgBoxStyle.Information, Me.Text)
End Try

Nov 20 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Suresh Tri | last post by:
Hi all, I am interested in extracting the class or jar files which are stored as java stored procedures in Oracle. But I want to know if these are stored as references to external files in...
2
by: Seung Y. Kim | last post by:
Hi everyone. I am having a big performance issue with my ASP application with Oracle database. The application itself is a very database-generic one, so I can switch from Access to SQLServer...
0
by: Daisy | last post by:
Download Oracle Data Provider for .NET (http://otn.oracle.com/tech/windows/odpnet/index.html) today to empower your .NET applications with the Oracle Database! Try out the new features for XML...
0
by: Daisy | last post by:
To empower your .NET web services with the Oracle Database, download Oracle Data Provider for .NET (ODP.NET) from : http://otn.oracle.com/tech/windows/odpnet/index.html Try out the new features...
1
by: Hai Ly Hoang \(MT00KSTN\) | last post by:
Hi, I'm an Oracle newbie. I've just created a table in Oracle with CREATE TABLE. Now, in C#, how to connect to database and get my table ? Thanks
6
by: ´ï´ï | last post by:
How to connect asp.net with Oracle Database? Where and How to? Thanks very much.
2
by: Mark Brown | last post by:
I'm trying to access an Oracle database vb.net. I found several examples. I tried following each one, but I get the same error no matter what I try. I don't really understand what the error means...
10
by: Reedsp | last post by:
Version: MSAccess 2003 SP2 Explination: I have a database that connects to an oracle database. I have setup an ODBC connection under the System DSN tab in the ODBC Source Administrator. The...
0
by: Jack | last post by:
Training Classes for Oracle10g, 9i, 8i Certification training in Oracle10g and 9i: DBA, Developer, Discoverer. training conducted at your location worldwide. Courseware licensing also available....
0
by: Winder | last post by:
Training Classes for Oracle10g, 9i, 8i Certification training in Oracle10g and 9i: DBA, Developer, Discoverer. training conducted at your location worldwide. Courseware licensing also available....
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.