EDN Admin
Well-known member
So I have an application that queries a database for something like a social security number. Originally, the connection was established programmatically using ODBC. Now, I want to use the data source option built into Visual Studio. My
question is, when it comes time to use my data source, how do I insert my SQL string and execute the command. I am returning data not to a table, but instead to form controls, but that part is already fine. All that I want to change is to have
the Oracle Database built in.
Update:
The way that this connection is working is it creates a new odbcConnection and uses a connection string specified in the code. I would rather use the Data Connection that I have set up in the Server Explorer. How do I do this? Right now,
Conn is a new odbcConnection, but what would my Data connection be? I just need some guidance and Im sure that I will be able to figure this out.
View the full article
question is, when it comes time to use my data source, how do I insert my SQL string and execute the command. I am returning data not to a table, but instead to form controls, but that part is already fine. All that I want to change is to have
the Oracle Database built in.
Update:
The way that this connection is working is it creates a new odbcConnection and uses a connection string specified in the code. I would rather use the Data Connection that I have set up in the Server Explorer. How do I do this? Right now,
Conn is a new odbcConnection, but what would my Data connection be? I just need some guidance and Im sure that I will be able to figure this out.
View the full article