How to get oledb connection?
Answers were Sorted based on User's Feedback
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");
i hope that these are enough.
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / guest
oledb provid universal connection strintg .using oledb we
can conntect to any data base.
Is This Answer Correct ? | 2 Yes | 2 No |
What are the differences between OLEDB and SQLClient Providers?
What is the difference between data reader and data adapter?
What is acid in ado.net?
Write steps of retrieving data using ado.net ?
What is dataset object? Explain the various objects in dataset.
How can we check that some changes have been made to dataset since it was loaded?
Explain how to bind the controls(best practice) comboboxes to the data in the dataset?
ADO and ADO.NET differences ?
How to bind the controls(best practice) comboboxes to the data in the dataset?
How to store data in memory?
Explain the difference in an abstract class and an interface?
What are the ado.net objects?