sqlconnection 与 repeater等数据控件的绑定

最新推荐文章于 2022-03-24 14:01:02 发布

流云诸葛

最新推荐文章于 2022-03-24 14:01:02 发布

阅读量674

点赞数

文章标签： null string security object 数据库 server

本文链接：https://blog.csdn.net/zxf1by1/article/details/7054984

版权

 public partial class Default2 : System.Web.UI.Page
    {
        private static SqlConnection conn = null;
        private static SqlDataReader reader = null;
        private static SqlCommand comm = null;

        protected void Page_Load(object sender, EventArgs e)
        {
            OpenSqlConnection();
            ConnMsg.Text = "数据库连接成功";
            MyTableRepeater.DataSource = reader;//repeater控件
            MyTableRepeater.DataBind();
            reader.Close();
            reader = comm.ExecuteReader();
            MyTableGridView.DataSource = reader;//gridview控件
            MyTableGridView.DataBind();
            reader.Close();
        }

        private static void OpenSqlConnection()
        {
            string connectionString = GetConnectionString();
            conn = new SqlConnection(connectionString);
            conn.Open();
            comm = conn.CreateCommand();
            comm.CommandType = CommandType.Text;
            comm.CommandText = "select * from mytable";
            reader = comm.ExecuteReader();
            
        }

        static private string GetConnectionString()
        {
            return @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Test.mdf;Integrated Security=True;User Instance=True";
        }
    }

repeater展示的时候是：

<asp:Repeater ID="MyTableRepeater" runat="server">
            <HeaderTemplate>
                <table>
                   <tr><th>ID</th><th>StuNo</th><th>StuName</th><th>StuAge</th></tr>
            </HeaderTemplate>
            <ItemTemplate>
                <tr>
                    <td><%#DataBinder.Eval(Container.DataItem,"ID")%></td>
                    <td><%#DataBinder.Eval(Container.DataItem, "StuNo")%></td>
                    <td><%#DataBinder.Eval(Container.DataItem, "StuName")%></td>
                    <td><%#DataBinder.Eval(Container.DataItem, "StuAge")%></td>
                </tr>
            </ItemTemplate>
            <FooterTemplate></table></FooterTemplate>
        </asp:Repeater>