473,834 Members | 2,050 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Title / Subject :using Oracle In Vb.net

1 New Member
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.
Jun 23 '07 #1
1 1416
shweta123
692 Recognized Expert Contributor
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.
Jun 25 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

7
3582
by: Will | last post by:
On the subject of Data Warehouses, Data Cubes & OLAP…. I would like to speak frankly about Data Warehouses, Data Cubes and OLAP (on-line analytical processing). Has it dawned on anyone else that these buzz words were created by some geek who decided to take a stab at marketing? Knowing that to the backwoods manager who knows little of technology that new innovative names for old concepts would help to sale their products. I mean...
7
2245
by: Will | last post by:
On the subject of Data Warehouses, Data Cubes & OLAP…. I would like to speak frankly about Data Warehouses, Data Cubes and OLAP (on-line analytical processing). Has it dawned on anyone else that these buzz words were created by some geek who decided to take a stab at marketing? Knowing that to the backwoods manager who knows little of technology that new innovative names for old concepts would help to sale their products. I mean...
50
5939
by: MozillaCensorsMe | last post by:
Hello, While I haven't finished my wonderful tutorial to save the world, I do have a simple question. What's the difference between h1 and the title tag? For me it seems as though both can be used interchangebly. For example, the articles on my site (andkon.com) have the same title as h1. Comments?
4
18484
by: Richard Trahan | last post by:
(This is a repost -- the original got tucked away into an old thread because I used the same Subject name.) I'm trying to change the document title to add an asterisk when the document becomes "dirty", as seen on editor applications. I use the code below. Venkman shows that everything looks as expected. The last line is for the debugger, which indicates that the title is changed, but it does not display.
14
4620
by: Del Ferguson | last post by:
Group, New to this list. I just found out that FireFox does not display the img alt attribute the same way IE does. I use both browsers to verify that my pages are readable. Dumb me for not reading all of the reference document. With this is mind, I need a way to display text in a title attribute, dynamically. I don't like the idea of going through 100+ pages and making the changes every time a load new images. Is it possible to...
4
15411
by: DU | last post by:
I am looking for opinions on the issue of length of title attribute. First of all, the current HTML 4.01 spec is rather vague on this issue... at least, it isn't explicit nor normative. The HTML 4.01 spec and WAI mention "short message", "short description", "advisory title", "informative link title" for the title attribute. Personally, I think that having a more than 128 characters tooltip does not meet the original goals of the HTML...
5
1368
by: DFS | last post by:
I got 0 responses to my "Opinions on db structure" post. That's painful. Answer this time or I'll post it again... 8>) Thanks. ==================================================== I'm creating an Access 2003 field-based survey tool. The field users (50 of them) submit survey results each week to a master db at the HQ.
3
4748
by: DexHex | last post by:
Hi, I am stumpt. Is there anyway to set the background image on a webpart title?
3
1220
by: musosdev | last post by:
Hi guys I'm using a MasterPage for my website rebuild (vs2005, .net2, c#). I want to be able to control the Title element, both on the MasterPage and the Content pages. For example, on each page I want the following to appear for the Title.. SITENAME - some page related title
1
10550
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10220
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9332
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7760
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6957
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5627
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4427
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3981
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3083
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.