一.说明
Mysql 的封装一直都在重复且强调,至此之后就不会再啰嗦,详情请查看( 连接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="/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();