Interested to Buy Any Domain ? << Click Here >> for more details...
How to get the new oledb connection of oracle in database
programming?
- 1 Answers
- 4026 Views
- I also Faced
- E-Mail Answers
Answer Posted / srikant dwibedi
using OLEDB connection we can connect the MS-ACCESS,Sql
Server,Oracle.
here i given the coding for connect the oledb connection
OleDbConnection con = new OleDbConnection();
con.ConnectionString="Provider=Microsoft.Jet.OleDb.4.0;Data
Source=databasenamewithpath;";
con.Open();
then u can use the dataset or datareader
OleDbCommand cmd = new OleDbCommand(sql,con);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
OleDbDataReader reader;
reader = cmd.ExecuteReader();
OleDbDataAdapter oda = new OleDbDataAdapter(sql,con);
DataSet ds = new DataSet();
oda.Fill(ds,"tablename");
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to read data with the sqldatareader ?
Which is better entity framework or ado.net?
Does executenonquery return a value?
What is difference between entity framework and ado.net?
Why do we need ado.net?
How do you find the count of records in a dataset?
What is aggregating data ?
What is csdl entity framework?
What is a data control clerk?
What is the executescalar method?
How does ado.net work?
What is ado.net in vb net?
What is Data Provider?
Explain the difference between data reader and data adapter?
What is ole data type?
