в 15:31, 26 мая 2010

2010-05-26T15:31:19Z

Admin: 1 версия

2010-05-26T11:42:47Z

1 версия

Новая страница

==OleDbConnection connection: ConnectionString, Database, DataSource, ServerVersion and State==

<source lang="csharp">
using System;
using System.Data;
using System.Data.OleDb;
class AccessConnect {
static void Main()
{
string connString = @"provider = microsoft.jet.oledb.4.0;data source = Employee.mdb;";
OleDbConnection conn = new OleDbConnection(connString);
try
{
conn.Open();
Console.WriteLine("Connection opened.");
Console.WriteLine("Connection Properties:");
Console.WriteLine("\tConnection String: {0}", conn.ConnectionString);
Console.WriteLine("\tDatabase: {0}",conn.Database);
Console.WriteLine("\tDataSource: {0}",conn.DataSource);
Console.WriteLine("\tServerVersion: {0}", conn.ServerVersion);
Console.WriteLine("\tState: {0}", conn.State);
} catch (OleDbException e) {
Console.WriteLine("Error: " + e);
} finally {
conn.Close();
Console.WriteLine("Connection closed.");
}
}
}

</source>

==OleDbConnection: ConnectionString property==

<source lang="csharp">
using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.OleDb;
class MainClass {
public static void Main() {
using (OleDbConnection con = new OleDbConnection()) {
con.ConnectionString = "Provider=SQLOLEDB;" +
@"Data Source=.\sqlexpress;" +
"Initial Catalog=Northwind;" +
"Integrated Security=SSPI";
con.Open();
if (con.State == ConnectionState.Open) {
Console.WriteLine(" Connection String = " +
con.ConnectionString);
} else {
Console.WriteLine("OleDbConnection failed to open.");
Console.WriteLine(" Connection State = " + con.State);
}
}
}
}
</source>

==OleDbConnection: Database==

<source lang="csharp">
using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.OleDb;
class MainClass {
public static void Main() {
using (OleDbConnection con = new OleDbConnection()) {
con.ConnectionString = "Provider=SQLOLEDB;" +
@"Data Source=.\sqlexpress;" +
"Initial Catalog=Northwind;" +
"Integrated Security=SSPI";
con.Open();
if (con.State == ConnectionState.Open) {
Console.WriteLine(" Database = " + con.Database);
} else {
Console.WriteLine("OleDbConnection failed to open.");
Console.WriteLine(" Connection State = " + con.State);
}
}
}
}
</source>

==OleDbConnection: DataSource==

<source lang="csharp">
using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.OleDb;
class MainClass {
public static void Main() {
using (OleDbConnection con = new OleDbConnection()) {
con.ConnectionString = "Provider=SQLOLEDB;" +
@"Data Source=.\sqlexpress;" +
"Initial Catalog=Northwind;" +
"Integrated Security=SSPI";
con.Open();
if (con.State == ConnectionState.Open) {
Console.WriteLine(" Database Source = " + con.DataSource);
} else {
Console.WriteLine("OleDbConnection failed to open.");
Console.WriteLine(" Connection State = " + con.State);
}
}
}
}
</source>

==OleDbConnection: ServerVersion==

<source lang="csharp">
using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.OleDb;
class MainClass {
public static void Main() {
using (OleDbConnection con = new OleDbConnection()) {
con.ConnectionString = "Provider=SQLOLEDB;" +
@"Data Source=.\sqlexpress;" +
"Initial Catalog=Northwind;" +
"Integrated Security=SSPI";
con.Open();
if (con.State == ConnectionState.Open) {
Console.WriteLine(" Server Version = " + con.ServerVersion);
} else {
Console.WriteLine("OleDbConnection failed to open.");
Console.WriteLine(" Connection State = " + con.State);
}
}
}
}
</source>

==OleDbConnection: State==

<source lang="csharp">
using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.OleDb;
class MainClass {
public static void Main() {
using (OleDbConnection con = new OleDbConnection()) {
con.ConnectionString = "Provider=SQLOLEDB;" +
@"Data Source=.\sqlexpress;" +
"Initial Catalog=Northwind;" +
"Integrated Security=SSPI";
con.Open();
if (con.State == ConnectionState.Open) {
Console.WriteLine(" Connection State = " + con.State);
} else {
Console.WriteLine("OleDbConnection failed to open.");
Console.WriteLine(" Connection State = " + con.State);
}
}
}
}
</source>

==OleDbConnection string==

<source lang="csharp">
using System;
using System.Diagnostics;
using System.Drawing;
using System.Collections;
using System.ruponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;
using System.Data.OleDb;
public class MainClass {
static void Main() {
try {
OleDbConnection cnOleDb = new OleDbConnection("Provider=SQLOLEDB.1;Password=pw;Persist Security Info=False;User ID=admin;Initial Catalog=biblio;Data Source=betav9;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=BETAV9;Use Encryption for Data=False;Tag with column collation when possible=False");
cnOleDb.Open();
} catch (OleDbException exOleDb) {
MessageBox.Show(exOleDb.Message);
} catch (Exception ex) {
MessageBox.Show(ex.Message);
}
}
}
</source>

==Read data from ole db connection==

<source lang="csharp">
using System;
using System.Data.OleDb;
public class ReadFromOleDb
{
[STAThread]
static void Main(string[] args)
{
String sConn = "provider=sqloledb;server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI";

String sSQL = "select id, firstname, lastname from Employee";
OleDbConnection oConn = new OleDbConnection(sConn);
oConn.Open();
OleDbCommand oCmd = new OleDbCommand(sSQL, oConn);
OleDbDataReader oReader = oCmd.ExecuteReader();
int idxID = oReader.GetOrdinal("id");
int idxFirstName = oReader.GetOrdinal("firstname");
int idxLastName = oReader.GetOrdinal("lastname");
while(oReader.Read()) {
Console.WriteLine("{0} {1} {2}",
oReader.GetValue(idxID),
oReader.GetValue(idxFirstName),
oReader.GetValue(idxLastName));
}
}
}

</source>

← Предыдущая	Версия 15:31, 26 мая 2010
(нет различий)

Csharp/C Sharp/Database ADO.net/OleDbConnection - История изменений

в 15:31, 26 мая 2010

Admin: 1 версия