TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Behrouz Hosseini
NA
72
0
Executing Several SqlCommands in a Single OracleConnection
Apr 29 2011 4:08 AM
Hi
Can you please let me know if I execute several sql query with one open connection?
For example if I have a code like following:
using System;
using System.Data;
using Oracle.DataAccess.Client;
class OracleCommandSample
{
static void Main()
{
string constr = "User Id=scott;Password=tiger;Data Source=oracle";
OracleConnection con = new OracleConnection(constr);
con.Open();
string cmdQuery = "select ename, empno from emp";
// Create the OracleCommand
OracleCommand cmd = new OracleCommand(cmdQuery);
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
// Execute command, create OracleDataReader object
OracleDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
// output Employee Name and Number
Console.WriteLine("Employee Name : " + reader.GetString(0) + " , " +
"Employee Number : " + reader.GetDecimal(1));
}
// Clean up
reader.Dispose();
cmd.Dispose();
con.Dispose();
}
}
Can I create another OracleCommand and run it? like:
string cmdQuery = "select ename, empno from emp";
string cmdQuery2 = "select age from emp";
// Create the OracleCommand
OracleCommand cmd = new OracleCommand(cmdQuery);
// Create the Second OracleCommand
OracleCommand cmd = new OracleCommand(cmdQuery2);
// or even more????
Can you please let me know that if it is ok? I also need your help to create a boolean to check if the connection is open or not? I tried severla method but I could'nt run it.
What I am thinking is creating a GenConnection() method and just calling it one time.is this a good idea?
Thanks for your time
Reply
Answers (
1
)
table 0 not found
Pop Up window opens and closes immediately