本文介绍了如何使用c#和mysql编码asp(网站)的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何使用c#和mysql插入,更新,删除代码asp(网站)...
how to code asp(website) with c# and mysql insert,update,delete ...
推荐答案首先尝试使用Google: Asp C#和我的SQL [ ^ ] 使用C#和.NET连接到MySQL数据库 [ ^ ] Try google first: Asp 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(网站)
发布评论