C # connection to Oracle!

Oracle using System.Data.OleDb;

Create a new class (Parameters for database connections):

public static string Getoracledbconnstr ()
{
Database connection
String tempuser= "System", temppassword= "ANDYSTARMKMK", tempdatasource= "Andy";
String tempstrcon= "PROVIDER=ORAOLEDB.ORACLE.1; Persist security Info=false; " +
"User id=" +tempuser+ "; Password= "+temppassword+";D ata source= "+tempdatasource;
return Tempstrcon;
}

To set the Click event:


private void Button1_Click (object sender, System.EventArgs e)
{
String Strsql= "select * from Scott.aa";
String Tempstrcon=form1.getoracledbconnstr ();
String tempstrcom= "select * from Scott.aa";
OleDbConnection tempmyconn=new OleDbConnection (Tempstrcon);
DataSet tempmydataset=new DataSet ();

OleDbDataAdapter tempmycommand=new OleDbDataAdapter (tempstrcom,tempmyconn);
Tempmycommand.fill (Tempmydataset);
Tempmyconn.open ();
DataGrid1.DataSource =tempmydataset;



OleDbCommand tempcommand=new OleDbCommand (strsql,tempmyconn);
Tempcommand.executenonquery ();
Tempmyconn.close ();

}

Attention:

1. Parameters required to connect to the database:

OleDbConnection used to establish a connection

DataSet data is cached in memory by creating a table in memory that is consistent with the database

OleDbDataAdapter for updating data sources

OleDbCommand used to execute SQL commands

2. The connection should be closed immediately after completion of the connection.