Provider?

Closed
Jaya - Jun 23, 2011 at 04:35 AM
Ambucias
Posts
47362
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
September 1, 2021
- Jun 23, 2011 at 04:48 AM
Hello,


Actually i am using first time oracle data base acces,and i want to access HR database.
i want to ask what will be provider and data source mean?

i had used code as following
string source = "provider=;data source=ORCL;user id=HR;password=HR";
string Command = "select * from Employees";
OleDbCommand Cmd = new OleDbCommand();
OleDbConnection Con = new OleDbConnection(source);
Con.Open();
Cmd.CommandText = Command;
OleDbDataReader Myreader = new OleDbDataReader();
Myreader.Read();
while (Myreader.Read())
{
Console.WriteLine(mReader.GetString(0) + ":" + mReader.GetInt32(1));
}
Con.Close();


Note:-how i can use this data to fill grid

1 reply

Ambucias
Posts
47362
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
September 1, 2021
11,284
Jun 23, 2011 at 04:48 AM
Greetings,

Bare in mind that before any answer given on the forum, you should know that there are volunteers who give their time trying to solve user problems.

Therefore, it is specifically requested from Kioskea forum users to show their respect. For this, the use of polite expressions is a minimum.
https://ccm.net/contents/948-terms-of-use-for-ccm-respect-for-others#politesse

To say please, thank you, appreciate, grateful, etc... is common courtesy when you want something, especially help!

You must re-write and repost your message respecting the politeness charter.

We trust that you understand.

Moderator
0