http://nfex.ru/index.php?action=history&feed=atom&title=ASP.NET_Tutorial%2FADO.net_Database%2FMySQL
ASP.NET Tutorial/ADO.net Database/MySQL - История изменений
2026-04-29T15:00:00Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://nfex.ru/index.php?title=ASP.NET_Tutorial/ADO.net_Database/MySQL&diff=2681&oldid=prev
в 15:30, 26 мая 2010
2010-05-26T15:30:57Z
<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:30, 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=ASP.NET_Tutorial/ADO.net_Database/MySQL&diff=2682&oldid=prev
Admin: 1 версия
2010-05-26T11:56:46Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>== Execuate insert command against MySQL database==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="csharp"><br />
<%@ Page Language="C#" %><br />
<%@ import Namespace="System.Data" %><br />
<%@ import Namespace="System.Data.Odbc" %><br />
<script runat="server"><br />
void Page_Load(object sender, EventArgs e) {<br />
string ConnectionString = ConfigurationSettings.AppSettings["MySQLConnectString"];<br />
OdbcConnection myConnection = new OdbcConnection(ConnectionString);<br />
<br />
try{<br />
string CommandText = "INSERT Publisher (PublisherName, PublisherCity, PublisherContact_Email, PublisherWebsite) VALUES ("New Publisher", "a", "a@a.ru", "http://www.a.ru")";<br />
OdbcCommand myCommand = new OdbcCommand(CommandText, myConnection);<br />
<br />
myConnection.Open();<br />
<br />
lblRecords.Text = Convert.ToString(myCommand.ExecuteNonQuery());<br />
} catch (Exception ex){<br />
throw(ex);<br />
} finally{<br />
myConnection.Close();<br />
}<br />
}<br />
</script><br />
<html><br />
<head><br />
</head><br />
<body><br />
<form runat="server"><br />
Records affected: <asp:Label id="lblRecords" runat="server"></asp:Label><br />
</form><br />
</body><br />
</html><br />
File: Web.config<br />
<configuration><br />
<appSettings><br />
<add key="MySQLConnectString" value="driver={MySQL ODBC 3.51 Driver};server=localhost;database=Books;uid=yourID;pwd=letmein;" /><br />
</appSettings><br />
</configuration></source><br />
<br />
<br />
<br />
== Execuate select statement against MySQL database with OdbcCommand==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="csharp"><br />
<%@ Page Language="C#" %><br />
<%@ import Namespace="System.Data" %><br />
<%@ import Namespace="System.Data.Odbc" %><br />
<script runat="server"><br />
void Page_Load(object sender, EventArgs e) {<br />
string ConnectionString = ConfigurationSettings.AppSettings["MySQLConnectString"];<br />
string CommandText = "select PublisherID, PublisherName, PublisherCity, PublisherWebsite FROM Publisher ORDER BY PublisherID";<br />
<br />
OdbcConnection myConnection = new OdbcConnection(ConnectionString);<br />
OdbcCommand myCommand = new OdbcCommand(CommandText, myConnection);<br />
<br />
myConnection.Open();<br />
<br />
DataGrid1.DataSource = myCommand.ExecuteReader(CommandBehavior.CloseConnection);<br />
DataGrid1.DataBind();<br />
}<br />
</script><br />
<html><br />
<head><br />
</head><br />
<body style="FONT-FAMILY: arial"><br />
<form runat="server"><br />
<asp:datagrid id="DataGrid1" runat="server" EnableViewState="False"><br />
<HeaderStyle font-bold="True" forecolor="white" backcolor="#4A3C8C"></HeaderStyle><br />
<ItemStyle backcolor="#DEDFDE"></ItemStyle><br />
</asp:datagrid><br />
</form><br />
</body><br />
</html><br />
File: Web.config<br />
<configuration><br />
<appSettings><br />
<add key="MySQLConnectString" value="driver={MySQL ODBC 3.51 Driver};server=localhost;database=Books;uid=yourID;pwd=letmein;" /><br />
</appSettings><br />
</configuration></source><br />
<br />
<br />
<br />
== Execute Delete command against MySQL database with OdbcCommand (C#)==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="csharp"><br />
<%@ Page Language="C#" %><br />
<%@ import Namespace="System.Data" %><br />
<%@ import Namespace="System.Data.Odbc" %><br />
<script runat="server"><br />
void Page_Load(object sender, EventArgs e) {<br />
string ConnectionString = ConfigurationSettings.AppSettings["MySQLConnectString"];<br />
OdbcConnection myConnection = new OdbcConnection(ConnectionString);<br />
<br />
try{<br />
string CommandText = "DELETE FROM Publisher WHERE PublisherID = 6";<br />
OdbcCommand myCommand = new OdbcCommand(CommandText, myConnection);<br />
<br />
myConnection.Open();<br />
<br />
lblRecords.Text = Convert.ToString(myCommand.ExecuteNonQuery());<br />
} catch (Exception ex){<br />
throw(ex);<br />
} finally{<br />
myConnection.Close();<br />
}<br />
}<br />
</script><br />
<html><br />
<head><br />
</head><br />
<body><br />
<form runat="server"><br />
Records affected: <asp:Label id="lblRecords" runat="server"></asp:Label><br />
<!-- Insert content here --><br />
</form><br />
</body><br />
</html><br />
<br />
File: Web.config<br />
<configuration><br />
<appSettings><br />
<add key="MySQLConnectString" value="driver={MySQL ODBC 3.51 Driver};server=localhost;database=Books;uid=yourID;pwd=letmein;" /><br />
</appSettings><br />
</configuration></source><br />
<br />
<br />
<br />
== Execute update command against MySQL database with OdbcCommand==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="csharp"><br />
<%@ Page Language="C#" %><br />
<%@ import Namespace="System.Data" %><br />
<%@ import Namespace="System.Data.Odbc" %><br />
<script runat="server"><br />
void Page_Load(object sender, EventArgs e) {<br />
string ConnectionString = ConfigurationSettings.AppSettings["MySQLConnectString"];<br />
OdbcConnection myConnection = new OdbcConnection(ConnectionString);<br />
<br />
try{<br />
string CommandText = "UPDATE Publisher Set PublisherName="Old Publisher", PublisherCity = "Manchester" WHERE PublisherID = 6";<br />
OdbcCommand myCommand = new OdbcCommand(CommandText, myConnection);<br />
<br />
myConnection.Open();<br />
<br />
lblRecords.Text = Convert.ToString(myCommand.ExecuteNonQuery());<br />
} catch (Exception ex){<br />
throw(ex);<br />
} finally{<br />
myConnection.Close();<br />
}<br />
}<br />
</script><br />
<html><br />
<head><br />
</head><br />
<body><br />
<form runat="server">Records affected: <asp:Label id="lblRecords" runat="server"></asp:Label><br />
</form><br />
</body><br />
</html><br />
File: Web.config<br />
<configuration><br />
<appSettings><br />
<add key="MySQLConnectString" value="driver={MySQL ODBC 3.51 Driver};server=localhost;database=Books;uid=yourID;pwd=letmein;" /><br />
</appSettings><br />
</configuration></source><br />
<br />
<br />
<br />
== Read scalar data from MySQL database by using OdbcCommand==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="csharp"><br />
<%@ Page Language="C#" %><br />
<%@ import Namespace="System.Data" %><br />
<%@ import Namespace="System.Data.Odbc" %><br />
<script runat="server"><br />
void Page_Load(object sender, EventArgs e) {<br />
string ConnectionString = ConfigurationSettings.AppSettings["MySQLConnectString"];<br />
string CommandText = "select PublisherID, PublisherName, PublisherCity, PublisherWebsite FROM Publisher ORDER BY PublisherID";<br />
<br />
OdbcConnection myConnection = new OdbcConnection(ConnectionString);<br />
OdbcCommand myCommand = new OdbcCommand(CommandText, myConnection);<br />
<br />
myConnection.Open();<br />
<br />
string CommandTextCount = "SELECT COUNT(*) FROM Publisher";<br />
OdbcCommand myCommandCount = new OdbcCommand(CommandTextCount, myConnection);<br />
<br />
lblTotal.Text = Convert.ToString(myCommandCount.ExecuteScalar());<br />
<br />
DataGrid1.DataSource = myCommand.ExecuteReader(CommandBehavior.CloseConnection);<br />
DataGrid1.DataBind();<br />
}<br />
</script><br />
<html><br />
<head><br />
</head><br />
<body><br />
<br />
Publishers in the database: <asp:Label id="lblTotal" runat="server"></asp:Label><br />
<br />
<form runat="server"><br />
<asp:datagrid id="DataGrid1" runat="server" EnableViewState="False"><br />
<HeaderStyle font-bold="True" forecolor="white" backcolor="#4A3C8C"></HeaderStyle><br />
<ItemStyle backcolor="#DEDFDE"></ItemStyle><br />
</asp:datagrid><br />
</form><br />
</body><br />
</html><br />
File: Web.config<br />
<configuration><br />
<appSettings><br />
<add key="MySQLConnectString" value="driver={MySQL ODBC 3.51 Driver};server=localhost;database=Books;uid=yourID;pwd=letmein;" /><br />
</appSettings><br />
</configuration></source></div>
Admin