http://www.vbex.ru/index.php?action=history&feed=atom&title=VB.Net%2FDatabase_ADO.net%2FMySQL
VB.Net/Database ADO.net/MySQL - История изменений
2026-04-05T12:26:04Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://www.vbex.ru/index.php?title=VB.Net/Database_ADO.net/MySQL&diff=658&oldid=prev
в 16:40, 26 мая 2010
2010-05-26T16:40:06Z
<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://www.vbex.ru/index.php?title=VB.Net/Database_ADO.net/MySQL&diff=659&oldid=prev
Admin: 1 версия
2010-05-26T12:44:47Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==MySQL Connection String==<br />
<br />
<br />
<br />
<source lang="vbnet"><br />
Imports System<br />
Imports System.Data<br />
Imports MySql.Data.MySqlClient<br />
<br />
Module MySqlConnect<br />
Sub Main()<br />
Dim connString As String = "Database=Test;Data Source=localhost;User Id=root;Password=mypassword"<br />
Dim conn As New MySqlConnection(connString)<br />
Try<br />
conn.Open()<br />
Console.WriteLine("Connection Opened")<br />
Console.WriteLine("Connection Properties")<br />
Console.WriteLine("- ConnectionString : {0}", conn.ConnectionString)<br />
Console.WriteLine("- Database : {0}", conn.Database)<br />
Console.WriteLine("- DataSource : {0}", conn.DataSource)<br />
Console.WriteLine("- ServerVersion : {0}", conn.ServerVersion)<br />
Console.WriteLine("- State : {0}", conn.State)<br />
Catch ex As MySqlException<br />
" Display error<br />
Console.WriteLine("Error: " & ex.ToString())<br />
Finally<br />
" Close Connection<br />
conn.Close()<br />
Console.WriteLine("Connection Closed")<br />
End Try<br />
End Sub<br />
End Module<br />
<br />
</source><br />
<br />
<br />
==MySql.Data.MySqlClient Demo==<br />
<br />
<br />
<br />
<source lang="vbnet"><br />
Imports System<br />
Imports System.Data<br />
Imports MySql.Data.MySqlClient<br />
<br />
Module MySqlConnect<br />
Sub Main()<br />
Dim connString As String = "Database=Test;Data Source=localhost;User Id=root;Password=mypassword"<br />
Dim conn As New MySqlConnection(connString)<br />
Try<br />
conn.Open()<br />
Console.WriteLine("Connection Opened")<br />
Console.WriteLine("Connection Properties")<br />
Console.WriteLine("- ConnectionString : {0}", conn.ConnectionString)<br />
Console.WriteLine("- Database : {0}", conn.Database)<br />
Console.WriteLine("- DataSource : {0}", conn.DataSource)<br />
Console.WriteLine("- ServerVersion : {0}", conn.ServerVersion)<br />
Console.WriteLine("- State : {0}", conn.State)<br />
Catch ex As MySqlException<br />
" Display error<br />
Console.WriteLine("Error: " & ex.ToString())<br />
Finally<br />
" Close Connection<br />
conn.Close()<br />
Console.WriteLine("Connection Closed")<br />
End Try<br />
End Sub<br />
End Module<br />
<br />
</source></div>
Admin