Provider?

Closed
Jaya - Jun 23, 2011 at 04:35 AM
Ambucias Posts 47310 Registration date Monday February 1, 2010 Status Moderator Last seen February 15, 2023 - 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
Related:

1 response

Ambucias Posts 47310 Registration date Monday February 1, 2010 Status Moderator Last seen February 15, 2023 11,164
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/apps-sites/internet-archeology/ccm/10131-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