如何使用c#和mysql编码asp.net(网站) [英] how to code asp.net (website)with c# and mysql

问题描述

如何使用c#和mysql插入，更新，删除代码asp.net(网站)...

how to code asp.net(website) with c# and mysql insert,update,delete ...

推荐答案

首先尝试使用Google:

使用C#和.NET连接到MySQL数据库 [ ^ ]

Try google first:

Asp.net C# and my sql[^]

Connecting to MySQL Database using C# and .NET[^]

使用系统；
使用System.Data;
使用System.Configuration;
使用System.Web;
使用System.Web.Security;
使用System.Web.UI;
使用System.Web.UI.WebControls;
使用System.Web.UI.WebControls.WebParts;
使用System.Web.UI.HtmlControls;
使用MySql.Data.MySqlClient;

公共局部类_Default:System.Web.UI.Page
{
受保护的void Page_Load(对象发送者，EventArgs e)
{

}
受保护的void Button1_Click(对象发送者，EventArgs e)
{


MySqlConnection myConnection =新的MySqlConnection(数据库=测试；数据源=本地主机；用户ID = sa；密码= admin");
字符串myInsertQuery =将订单插入(ID，名称)值(1，``test''))";
MySqlCommand myCommand =新的MySqlCommand(myInsertQuery);
myCommand.Connection = myConnection;
myConnection.Open();
myCommand.ExecuteNonQuery();
myCommand.Connection.Close();

}
}

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using MySql.Data.MySqlClient;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void Button1_Click(object sender, EventArgs e)
{


MySqlConnection myConnection = new MySqlConnection("Database=test;Data Source=localhost;User Id=sa;Password=admin");
string myInsertQuery = "INSERT INTO orders (id, name) Values(1,''test'')";
MySqlCommand myCommand = new MySqlCommand(myInsertQuery);
myCommand.Connection = myConnection;
myConnection.Open();
myCommand.ExecuteNonQuery();
myCommand.Connection.Close();

}
}

这篇关于如何使用c#和mysql编码asp.net(网站)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！