http://vbex.ru/index.php?title=VB.Net_Tutorial/Database_ADO.net/OleDbConnection&feed=atom&action=historyVB.Net Tutorial/Database ADO.net/OleDbConnection - История изменений2024-03-28T21:22:50ZИстория изменений этой страницы в викиMediaWiki 1.30.0http://vbex.ru/index.php?title=VB.Net_Tutorial/Database_ADO.net/OleDbConnection&diff=3576&oldid=prev в 16:40, 26 мая 20102010-05-26T16:40:30Z<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 16:40, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>http://vbex.ru/index.php?title=VB.Net_Tutorial/Database_ADO.net/OleDbConnection&diff=3577&oldid=prevAdmin: 1 версия2010-05-26T12:56:03Z<p>1 версия</p>
<p><b>Новая страница</b></p><div>==Create OleDbConnection to Access database==<br />
<br />
<br />
<br />
<source lang="vbnet">Imports System.Data<br />
Module Test<br />
Sub Main()<br />
Dim sConnectionString, sSQL As String<br />
<br />
"SQL Connection String<br />
sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\yourdatabase.mdb"<br />
sSQL = "SELECT Title FROM yourTable"<br />
Dim conn As New System.Data.OleDb.OleDbConnection(sConnectionString)<br />
Dim cmd As New System.Data.OleDb.OleDbCommand(sSQL, conn)<br />
Dim dr As System.Data.OleDb.OleDbDataReader<br />
conn.Open()<br />
dr = cmd.ExecuteReader()<br />
Do While dr.Read()<br />
System.Console.WriteLine(dr.Item("Title"))<br />
Loop<br />
dr.Close()<br />
conn.Close()<br />
End Sub<br />
End Module</source><br />
<br />
==Create OleDbConnection to Sql server==<br />
<br />
<br />
<br />
<source lang="vbnet">Imports System.Data<br />
Module Test<br />
Sub Main()<br />
Dim sConnectionString, sSQL As String<br />
<br />
"SQL Connection String<br />
sConnectionString = "Provider=SQLOLEDB.1;User ID=sa;Initial Catalog=YourDataBase;Data Source=(local)"<br />
sSQL = "SELECT Title FROM yourTable"<br />
Dim conn As New System.Data.OleDb.OleDbConnection(sConnectionString)<br />
Dim cmd As New System.Data.OleDb.OleDbCommand(sSQL, conn)<br />
Dim dr As System.Data.OleDb.OleDbDataReader<br />
conn.Open()<br />
dr = cmd.ExecuteReader()<br />
Do While dr.Read()<br />
System.Console.WriteLine(dr.Item("Title"))<br />
Loop<br />
dr.Close()<br />
conn.Close()<br />
End Sub<br />
End Module</source><br />
<br />
==Using sql statement==<br />
<br />
<br />
<br />
<source lang="vbnet">Option Strict On<br />
Imports System.Data<br />
Imports System.Data.OleDb<br />
Public Module UsingStatement<br />
Public Sub Main()<br />
Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=NorthWind.mdb")<br />
Dim cmd As New OleDbCommand<br />
Dim dr As OleDbDataReader<br />
Using conn<br />
conn.Open<br />
cmd.rumandText = "Select * From Customers"<br />
cmd.rumandType = CommandType.Text<br />
cmd.Connection = conn<br />
dr = cmd.ExecuteReader()<br />
If dr.HasRows Then<br />
Do While dr.Read()<br />
" Get first and last name of customer<br />
Console.WriteLine(CStr(dr.Item(1)) & " " & CStr(dr.Item(2)))<br />
Loop<br />
Else<br />
Console.WriteLine("The table has no rows.")<br />
End If<br />
End Using<br />
End Sub<br />
End Module</source></div>Admin