62,072
社区成员
发帖
与我相关
我的任务
分享
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using MySql.Data.MySqlClient;
/// <summary>
/// testdb 的摘要说明
/// </summary>
public class testdb
{
string _constr;
MySqlConnection _con;
MySqlCommand _cmd;
string msg;
int _rows=0;
public testdb()
{
_constr = "Data Source=localhost;Database=testdb;pwd=123456;uid=root;";
}
public void con()
{
_con = new MySqlConnection(_constr);
_con.Open();
_cmd = new MySqlCommand("select count(1) from tg_product;",_con);
_rows=_cmd.ExecuteNonQuery();
_con.Close();
}
}
<add key="MyDB" value="server =localhost;port=3306;database=db1;user id=root;password =sa;"/>
public static string connectionString = ConfigurationManager.AppSettings["MyDB"];
/// <summary>
/// 执行查询语句,返回DataSet
/// </summary>
/// <param name="SQLString">查询语句</param>
/// <returns>DataSet</returns>
public static DataSet Query(string SQLString)
{
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
DataSet ds = new DataSet();
try
{
connection.Open();
MySqlDataAdapter command = new MySqlDataAdapter(SQLString, connection);
command.Fill(ds, "ds");
}
catch (MySql.Data.MySqlClient.MySqlException ex)
{
throw new Exception(ex.Message);
}
return ds;
}
}
//---------------------
string sql="select ID,Title form news limit 10";
var modelList = db.HelperMySQL.Query(sql);
GridView1.DataSource = modelList;
GridView1.DataBind();
public void con()
{
testdb();
_con = new MySqlConnection(_constr);
_con.Open();
_cmd = new MySqlCommand("select count(1) from tg_product;",_con);
_rows=_cmd.ExecuteNonQuery();
_con.Close();
}