. NET (C #) connecting various databases-Highlights

1.c# Connecting to access
Program code:
-------------------------------------------------------------------------------

using System.Data;
using System.Data.OleDb;
..

string strconnection= "provider=microsoft.jet.oledb.4.0;";
Strconnection+[email protected] "Data Source=c:begaspnetnorthwind.mdb";

OleDbConnection objconnection=new OleDbConnection (strconnection);
..

Objconnection.open ();
Objconnection.close ();

--------------------------------------------------------------------------------

Explain:

Connecting to an Access database requires importing additional namespaces, so it is essential to have the top two using commands!

Strconnection This variable contains the connection string needed to connect to the database, he specifies the data provider to use and the data source to use.

"Provider=Microsoft.Jet.OLEDB.4.0;" Refers to the data provider, which uses the Microsoft Jet engine, the data engine in access, which is connected to the database of access.

"Data Source=c:\begaspnet\northwind.mdb" is the location of the source, and his standard form is "Data Source=mydrive:mypath\myfile.mdb".

Ps:
1. The "@" symbol after "+ =" Prevents the "\" in subsequent strings from resolving to escape characters.
2. If the database file you want to connect to is in the same directory as the current file, you can also connect using the following method:
strconnection+= "Data source=";
Strconnection+=mappath ("Northwind.mdb");
This will save you from writing a lot of things!
3. Be aware that the parameters in the connection string are separated by semicolons.

"OleDbConnection objconnection=new OleDbConnection (strconnection);" This is the use of a defined connection string to establish a linked object, the future operation of the database we have to deal with this object.

"Objconnection.open ();" This is used to open the connection. At this point, the connection to the Access database is complete.
--------------------------------------------------------------------------------

2.c# Connecting to SQL Server
Program code:
--------------------------------------------------------------------------------

using System.Data;
using System.Data.SqlClient;
..

string strconnection= "user id=sa;password=;";
strconnection+= "Initial catalog=northwind; Server=yoursqlserver; ";
strconnection+= "Connect timeout=30";

SqlConnection objconnection=new SqlConnection (strconnection);
..

Objconnection.open ();
Objconnection.close ();

--------------------------------------------------------------------------------

Explain:

The mechanism for connecting to a SQL Server database is not much different from the mechanism for connecting to access, except for changing the parameters in the Connection object and the connection string.

First, the namespaces used to connect to SQL Server are not "System.Data.OleDb", but "System.Data.SqlClient".

Next is his connection string, we introduce a parameter (note: The parameters are separated by semicolons):
"User Id=sa": The authenticated user name for the connection database is SA. He also has an alias "UID", so this sentence we can also write "Uid=sa".
"Password=": The authentication password for the connection database is empty. His nickname is "pwd", so we can write "pwd=".
Note here that your SQL Server must already have a username and password to log in, or you cannot log in in such a way. If your SQL Server is set to Windows logon, you do not need to use "User ID" and "password" here. Such a way to log in, and you need to use "TRUSTED_CONNECTION=SSPI" to log in.
"Initial Catalog=northwind": The data source used is the database "Northwind". His nickname is "database", this sentence can be written as "Database=northwind".
"Server=yoursqlserver": Use a server named "YourSQLServer". His nickname is "Data Source", "Address", "Addr". If you are using a local database and you have defined an instance name, you can write as " server= (local) \ instance name, or, if it is a remote server, replace "(local)" with the name or IP address of the remote server.
"Connect timeout=30": The connection time-out is 30 seconds.

In this case, the constructor used to establish the connection object is: SqlConnection.
--------------------------------------------------------------------------------

3.c# Connecting Oracle
Program code:
--------------------------------------------------------------------------------

usingSystem.Data.OracleClient;
usingSystem.Data;

//On the form, add a button calledButton1, double-clickButton1, enter the following code
Private voidButton1_Click (Objectsender, System.EventArgs e)
{
stringconnectionstring= "Data source=sky;user=system;password=manager;";//Write connection string
OracleConnection conn=NewOracleConnection (ConnectionString);//Create a new connection
Try
{
Conn. Open ();
OracleCommand Cmd=conn. CreateCommand ();

cmd.commandtext= "SELECT * from MyTable";//Write it down here .SQLStatement
OracleDataReader Odr=cmd. ExecuteReader ();//Create aOracledatereaderObject
while(ODR. Read ())//read data, ifODR. Read ()return tofalse, it means the end of the recordset.
{
Response.Write (ODR. Getoraclestring (1). ToString ());//output Field1, this number is the field index, how to use the field name still needs to be researched
}
Odr. Close ();
}
Catch(Exception ee)
{
Response.Write (EE. Message); //If there is an error, output the error message
}
finally
{
Conn. Close (); //Close Connection
}
}

-------------------------------------------------------------------------------

4.c# connecting MySQL
Program code:
--------------------------------------------------------------------------------

usingMysqldrivercs;

// establishing a database connection
mysqlconnection Dbconn;
Dbconn =NewMysqlconnection (Newmysqlconnectionstring ("localhost", "MySQL", "Root", "", 3306). asstring);
Dbconn.open ();

// Execute Query Statement
Mysqlcommand Dbcomm;
Dbcomm =Newmysqlcommand ("Select Host,user from User", dbconn);

// reading Data
Mysqldatareader dbreader = Dbcomm.executereaderex ();

// Show Data
Try
{
while(Dbreader.read ())
{
Console.WriteLine ("Host = {0} and User = {1}", dbreader.getstring (0), dbreader.getstring (1));
}
}
finally
{
Dbreader.close ();
Dbconn.close ();
}

//To close a database connection
dbconn.close ();

--------------------------------------------------------------------------------

5.c# Connecting IBM DB2
Program code:
--------------------------------------------------------------------------------

Oledbconnection1.open ();
//Open a database connection
Oledbdataadapter1.fill (DataSet1, "Address");
//fill in the data that is obtainedDataSet
Datagrid1.databind ();
//binding Data
Oledbconnection1.close ();
//Close Connection

//Increase Database Data
in theWeb Formnumber of fields added to theTextBox, and aButton, increase the key for this buttonClickThe response event code is as follows:

This. Oledbinsertcommand1.commandtext = "Insertsintosaddress (NAME,
EMAIL, age, ADDRESS) VALUES
(' "+textbox1.text+" ', ' "+textbox2.text+" ', ' "+textbox3.text+" ', ' "+textbox4.text+" ') ";
OleDbInsertCommand1.Connection.Open ();
//Open Connection
Oledbinsertcommand1.executenonquery ();
//Perform theSQLStatement
OleDbInsertCommand1.Connection.Close ();
//Close Connection 

--------------------------------------------------------------------------------

6.c# connecting Sybase
Program code: (OLE DB)
--------------------------------------------------------------------------------

provider=sybase.aseoledbprovider.2;initial catalog= database name; User id= username; data source= source; Extended properties= ""; Server NAME=IP address; Network Protocol=winsock; Server Port address=5000;

. NET (C #) connecting various databases-Highlights