最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
ASP.NET操作MySql数据库的教程
时间:2016-12-26 编辑:简简单单 来源:一聚教程网
一、把MySql.Data.dll放到BIN目录下。
二、这是aspx.cs的全部源码,修改参数直接运行即可!
usingMySql.Data.MySqlClient;
usingSystem;
usingSystem.Collections.Generic;
usingSystem.Data;
usingSystem.Linq;
usingSystem.Web;
usingSystem.Web.UI;
usingSystem.Web.UI.WebControls;
publicpartialclassLogin : System.Web.UI.Page
{
publicstaticclassMySqlHelper
{
publicstaticintExecuteNonQuery(stringconnectionString, CommandType commandtype,stringcommandText)
{
returnExecuteNonQuery(connectionString, commandtype, commandText,null);
}
publicstaticintExecuteNonQuery(stringconnectionString, CommandType commandtype,stringcommandText,paramsMySqlParameter[] commandParameters)
{
if(string.IsNullOrEmpty(connectionString))
{
thrownewException("connectionString exception");
}
intresult = 0;
MySqlConnection con =null;
try
{
using(con =newMySqlConnection(connectionString))
{
con.Open();
MySqlCommand command =newMySqlCommand(commandText, con);
command.CommandType = commandtype;
result = command.ExecuteNonQuery();
}
returnresult;
}
catch(Exception ex)
{
throwex;
}
finally
{
if(con.State == ConnectionState.Open)
{
con.Close();
}
}
}
}
protectedvoidPage_Load(objectsender, EventArgs e)
{
stringconnectionString ="server=localhost;uid=root;pwd=;database=zentaopro;";
LogManage_SqlDate.WriteLog("connectionString=:"+ connectionString);
stringsql ="insert user(account) values('china2')";
MySqlHelper.ExecuteNonQuery(connectionString, CommandType.Text, sql);
Console.Read();
}
}
|
相关文章
- C#复制数组的两种方式及效率比较解读 10-24
- ASP.NET Identity用法解析 10-24
- ASP.NET MVC使用Identity增删改查用户介绍 10-24
- C语言中atoi函数模拟实现介绍 10-18
- .Net反向代理组件Yarp用法介绍 10-10
- .NET使用YARP通过编码方式配置域名转发实现反向代理教程 10-10