1.资源:
先安装vs2005与mysql5.0然后下安装两个插件:mysql connector_net连接数据库 5.1.2.msi与MySQL.VisualStudio.msi,两个插件有安装顺利,先必须安装SQL.VisualStudio.msiMySQL.VisualStudio.msi,再安装件:mysql connector_net连接数据库 5.1.2.msi
环境搭好了,再写个公共的类:
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;
/// <summary>
/// MysqlData 的摘要说明
/// </summary>
public class MysqlData
{
String SqlConnectionString = "host=localhost;userid=root;password=sa;database=yixiuge";
private MySqlConnection cn; //创建SQL连接
private MySqlDataAdapter sda; //创建SQL数据适配器
private MySqlDataReader sdr; //创建SQL数据读取器
private MySqlCommand cmd; //创建SQL命令对象
private MySqlParameter param; //创建SQL参数
private DataSet ds; //创建数据集
private DataView dv; //创建视图
public MysqlData()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
/// <summary>
/// 打开数据库连接
/// </summary>
public void Open()
{
#region
cn = new MySqlConnection(SqlConnectionString);
cn.Open();
#endregion
}
/// <summary>
/// 关闭数据库连接
/// </summary>
public void Close()
{
#region
if (cn != null)
{
cn.Close();
cn.Dispose();
}
#endregion
}
/// <summary>
/// 返回DataSet数据集
/// </summary>
/// <param name="strSql">SQL语句</param>
public DataSet GetDs(string strSql)
{
#region
Open();
sda = new MySqlDataAdapter(strSql, cn);
ds = new DataSet();
sda.Fill(ds);
Close();
return ds;
#endregion
}
/// <summary>
/// 返回DataSet数据集
/// </summary>
/// <param name="strSql">SQL语句</param>
/// <param name="strTableName">表名</param>
public DataSet GetDs(string strSql, string strTableName)
{
#region
Open();
sda = new MySqlDataAdapter(strSql, cn);
ds = new DataSet();
sda.Fill(ds, strTableName);
Close();
return ds;
#endregion
}
/// <summary>
/// 添加DataSet表
/// </summary>
/// <param name="ds">DataSet对象</param>
/// <param name="strSql">Sql语句</param>
/// <param name="strTableName">表名</param>
public void GetDs(DataSet ds, string strSql, string strTableName)
{
#region
Open();
sda = new MySqlDataAdapter(strSql, cn);
sda.Fill(ds, strTableName);
Close();
#endregion
}
/// <summary>
/// 执行Sql语句
/// </summary>
/// <param name="strSql"></param>
public void RunSql(string strSql)
{
#region
Open();
cmd = new MySqlCommand(strSql, cn);
cmd.ExecuteNonQuery();
Close();
#endregion
}
/// <summary>
/// 执行SQL语句,并返回第一行第一列结果
/// </summary>
/// <param name="strSql">SQL语句</param>
/// <returns></returns>
public string RunSqlReturn(string strSql)
{
#region
string strReturn = "";
Open();
try
{
cmd = new MySqlCommand(strSql, cn);
strReturn = cmd.ExecuteScalar().ToString();
}
catch { }
Close();
return strReturn;
#endregion
}
/// <summary>
/// 返回DataView数据视图
/// </summary>
/// <param name="strSql">Sql语句</param>
public DataView GetDv(string strSql)
{
#region
dv = GetDs(strSql).Tables[0].DefaultView;
return dv;
#endregion
}
/// <summary>
/// 获得DataTable对象
/// </summary>
/// <param name="strSql">SQL语句</param>
/// <returns></returns>
public DataTable GetTable(string strSql)
{
#region
return GetDs(strSql).Tables[0];
#endregion
}
/// <summary>
/// 获得SqlDataReader对象 使用完须关闭DataReader,关闭数据库连接
/// </summary>
/// <param name="strSql">sql语句</param>
/// <returns></returns>
public MySqlDataReader GetDataReader(string strSql)
{
#region
Open();
cmd = new MySqlCommand(strSql, cn);
sdr = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
return sdr;
#endregion
}
}
上面这个类包括了操作数据库的方法,可以直接调用,经过测试了的.
3.再在前台绑定显示出来