http://nfex.ru/index.php?action=history&feed=atom&title=Csharp%2FCSharp_Tutorial%2FADO.Net%2FMySql
Csharp/CSharp Tutorial/ADO.Net/MySql - История изменений
2026-04-29T21:48:58Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://nfex.ru/index.php?title=Csharp/CSharp_Tutorial/ADO.Net/MySql&diff=6464&oldid=prev
в 15:31, 26 мая 2010
2010-05-26T15:31:53Z
<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;">Версия 15:31, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
http://nfex.ru/index.php?title=Csharp/CSharp_Tutorial/ADO.Net/MySql&diff=6465&oldid=prev
Admin: 1 версия
2010-05-26T12:19:09Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==ODBC MySqlConnection==<br />
<br />
<br />
<br />
<source lang="csharp">using System;<br />
using System.Drawing;<br />
using System.Collections;<br />
using System.ruponentModel;<br />
using System.Windows.Forms;<br />
using System.Data;<br />
using Microsoft.Data.Odbc;<br />
public class MainClass : System.Windows.Forms.Form<br />
{<br />
private System.Windows.Forms.DataGrid dataGrid1;<br />
public MainClass()<br />
{<br />
InitializeComponent();<br />
}<br />
private void InitializeComponent()<br />
{<br />
this.dataGrid1 = new System.Windows.Forms.DataGrid();<br />
((System.ruponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();<br />
this.SuspendLayout();<br />
// <br />
// dataGrid1<br />
// <br />
this.dataGrid1.DataMember = "";<br />
this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;<br />
this.dataGrid1.Location = new System.Drawing.Point(0, 8);<br />
this.dataGrid1.Name = "dataGrid1";<br />
this.dataGrid1.Size = new System.Drawing.Size(376, 288);<br />
this.dataGrid1.TabIndex = 0;<br />
// <br />
// MainClass<br />
// <br />
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);<br />
this.ClientSize = new System.Drawing.Size(384, 302);<br />
this.Controls.AddRange(new System.Windows.Forms.Control[] {<br />
this.dataGrid1});<br />
this.Load += new System.EventHandler(this.MainClass_Load);<br />
((System.ruponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();<br />
this.ResumeLayout(false);<br />
}<br />
[STAThread]<br />
static void Main() <br />
{<br />
Application.Run(new MainClass());<br />
}<br />
private void MainClass_Load(object sender, System.EventArgs e)<br />
{<br />
string connectionString = @"Driver={MySQL};SERVER=localhost;DATABASE=NorthwindMySQL;";<br />
OdbcConnection conn= new OdbcConnection(connectionString);<br />
conn.Open();<br />
OdbcDataAdapter da = new OdbcDataAdapter ("SELECT CustomerID, ContactName, ContactTitle FROM Customers", conn); <br />
DataSet ds = new DataSet("Cust"); <br />
da.Fill(ds, "Customers");<br />
dataGrid1.DataSource = ds.DefaultViewManager;<br />
conn.Close();<br />
}<br />
}</source><br />
<br />
==Use OdbcDataAdapter to read data from ODBC MySql connection==<br />
<br />
<br />
<br />
<source lang="csharp">using System;<br />
using System.Drawing;<br />
using System.Collections;<br />
using System.ruponentModel;<br />
using System.Windows.Forms;<br />
using System.Data;<br />
using Microsoft.Data.Odbc;<br />
public class MainClass : System.Windows.Forms.Form<br />
{<br />
private System.Windows.Forms.DataGrid dataGrid1;<br />
public MainClass()<br />
{<br />
InitializeComponent();<br />
}<br />
private void InitializeComponent()<br />
{<br />
this.dataGrid1 = new System.Windows.Forms.DataGrid();<br />
((System.ruponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();<br />
this.SuspendLayout();<br />
// <br />
// dataGrid1<br />
// <br />
this.dataGrid1.DataMember = "";<br />
this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;<br />
this.dataGrid1.Location = new System.Drawing.Point(0, 8);<br />
this.dataGrid1.Name = "dataGrid1";<br />
this.dataGrid1.Size = new System.Drawing.Size(376, 288);<br />
this.dataGrid1.TabIndex = 0;<br />
// <br />
// MainClass<br />
// <br />
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);<br />
this.ClientSize = new System.Drawing.Size(384, 302);<br />
this.Controls.AddRange(new System.Windows.Forms.Control[] {<br />
this.dataGrid1});<br />
this.Load += new System.EventHandler(this.MainClass_Load);<br />
((System.ruponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();<br />
this.ResumeLayout(false);<br />
}<br />
[STAThread]<br />
static void Main() <br />
{<br />
Application.Run(new MainClass());<br />
}<br />
private void MainClass_Load(object sender, System.EventArgs e)<br />
{<br />
string connectionString = @"Driver={MySQL};SERVER=localhost;DATABASE=NorthwindMySQL;";<br />
OdbcConnection conn= new OdbcConnection(connectionString);<br />
conn.Open();<br />
OdbcDataAdapter da = new OdbcDataAdapter ("SELECT CustomerID, ContactName, ContactTitle FROM Customers", conn); <br />
DataSet ds = new DataSet("Cust"); <br />
da.Fill(ds, "Customers");<br />
dataGrid1.DataSource = ds.DefaultViewManager;<br />
conn.Close();<br />
}<br />
}</source></div>
Admin