一.说明
Mysql 的封装一直都在重复且强调,至此之后就不会再啰嗦,详情请查看(ASP.net 连接Mysql,封装登录)等笔记.
二.方法
创建MyDBSql.cs的类,添加入如下代码:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Configuration;
using MySql.Data.MySqlClient;
using System.Data;
using System.Collections;
namespace WebApplication6
{
public class MyDBSql
{
public static string DataBase = ConfigurationManager.ConnectionStrings["Conn_example"].ToString();
static MySqlConnection conn = new MySqlConnection(DataBase);
//带参数的查询
public static DataTable excutSql(string sql,Hashtable ht) {
MySqlDataAdapter mda = new MySqlDataAdapter(sql,conn);
foreach (DictionaryEntry de in ht)
{
mda.SelectCommand.Parameters.AddWithValue(de.Key.ToString(),de.Value.ToString());
}
DataTable dt = new DataTable();
mda.Fill(dt);
return dt;
}
//不带参数的查询
public static DataTable excutSql(string sql)
{
MySqlDataAdapter mda = new MySqlDataAdapter(sql,conn);
DataTable dt = new DataTable();
mda.Fill(dt);
mda.Dispose();
conn.Close();
return dt;
}
}
}
三.前端代码
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="WebApplication6.WebForm1" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<!--#Eval 获取数据源指定的内容,参数是字段名-->
<asp:Repeater ID="Repeater1" runat="server">
<ItemTemplate>
<%#Eval("id") %>
<%#Eval("name") %>
<%#Eval("password") %><br />
</ItemTemplate>
</asp:Repeater>
</div>
</form>
</body>
</html>
四.后端代码
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace WebApplication6
{
public partial class WebForm1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//将数据源与Repeater绑定,Repeater(重复)
Repeater1.DataSource = MyDBSql.excutSql("select * from user");
//直接调用数据绑定的方法
Repeater1.DataBind();
}
}
}
五.知识点
- #Eval 获取数据源指定的内容,参数是字段名
<%#Eval("id") %>
- Repeater数据绑定
//将数据源与Repeater绑定,Repeater(重复)
Repeater1.DataSource = MyDBSql.excutSql("select * from user");
//直接调用数据绑定的方法
Repeater1.DataBind();