Hi,
I am not sure if this is the right place to post this. But here i go.
I am trying to fill a datatable from oracle with the primary key &
constraints info. But what ever i try the PrimaryKeys array is always
returned nothing. I have seen few post on similar problem but not one
has a solution i can find.
Here's my code. Plain & Simple.
**--------------------------------------------------------------------------**
cn.ConnectionString = "Provider=MSDAORA.1;Password=password;User
ID=userid;Data Source=Oracle02;Persist Security
Info=True;hostname=ipaddress;port=1521"
cn.Open()
Dim dAdapter As New OleDbDataAdapter
dAdapter.SelectCommand = New OleDbCommand("Select * From
myTable", cn)
'//create CommandBuilder
Dim cmdBuilder As New OleDbCommandBuilder(dAdapter)
'//create DataSet
Dim dSet As New DataSet
dAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey
dAdapter.FillSchema(dSet, SchemaType.Source, "myTable")
dAdapter.Fill(dSet, "myTable")
MessageBox.Show("Column Count: " +
dSet.Tables("myTable").PrimaryKey.Length.ToString())
**--------------------------------------------------------------------------**
dSet.Tables("myTable").PrimaryKey is always returned nothing. The table
i am using has primary key & constraint.
Thanks in advance for ur help,
Sudhir
|