How to get the new oledb connection of oracle in database
programming?
Answer / 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 |
What is an orm, and why would you use one instead of plain old ado.net?
Is datareader faster than datatable?
How to identify the controls which can be used for binding data?
how to keep track of index in listbox items.
What is the difference between the clone() and copy() methods of the dataset class?
Why is stored procedure used in ado.net?
once data is fetched into dataset connection gets closed. but in datareader connection is always maintained...then why datareader is fast and mainly recommended ?
Explain the difference in record set and dataset?
How we can provide data to ado.net?
Difference between sqlcommand and sqlcommandbuilder?
What are the ado.net objects?
Is entity framework better than ado.net?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)