Title / Subject :using Oracle In Vb.net

[ganesh061974]

TITLE / SUBJECT :USING ORACLE IN VB.NET

1.I AM USING VB.NET TO CONNECT A REMOTE ORACLE DATABASE. I AM GETTING.IT CONNECTED TO THE DATABASE.
Then I created a DATASET using the connection.I the Dataset I have created a tableadhapter which will get the value from the DropDown list.I have put the SQL command as "Select emp_no,emp_name from emp_mast where emp_no='&emp_no '".But after this the table adapter does accept the required value to the query.Thus no result is generated.

[shweta123]

Hi,

Please specify your code details if you are getting error anywhere.

If you want to fill the dataset here it is,

Dim con as new Oledb.Connectio n
con.connections tring=''....... ......."
con.open

'Here you will your sql query
sql=".......... ....."
Dim da new oledb.DataAdapt er(sql,con)
da.fill(ds)

for i as integer=0 to da.tables(0).ro ws.count
'Process data here
next
con.close

Thanks

TITLE / SUBJECT :USING ORACLE IN VB.NET

1.I AM USING VB.NET TO CONNECT A REMOTE ORACLE DATABASE. I AM GETTING.IT CONNECTED TO THE DATABASE.
Then I created a DATASET using the connection.I the Dataset I have created a tableadhapter which will get the value from the DropDown list.I have put the SQL command as "Select emp_no,emp_name from emp_mast where emp_no='&emp_no '".But after this the table adapter does accept the required value to the query.Thus no result is generated.