2010VS动态生成sql数据库里面的数据

web.config

<configuration>
    <system.web>
        <compilation debug="true" targetFramework="4.0" />
    </system.web>
  <connectionStrings>
    <add name="constr" connectionString="Data Source=计算机名字;Initial Catalog=数据库名字;Persist Security Info=True;User ID=账号;Password=密码"/>
  </connectionStrings>
</configuration>

前台

<div>
   
        <asp:Button ID="Button1" runat="server" Xonclick="Button1_Click" Text="查询" />
        <br />
        <asp:Table ID="Table1" runat="server">
        </asp:Table>
   
    </div>

后台

protected void Button1_Click(object sender, EventArgs e)
        {
            string connstr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
            using (SqlConnection conn = new SqlConnection(connstr)) {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand()) {
                    cmd.CommandText = "select * from T_student";
                    using (SqlDataReader reader = cmd.ExecuteReader()) {
                        while (reader.Read()) {
                            TableRow tr = new TableRow();
                            TableCell tc = new TableCell();
                            tc.Text = reader.GetValue(0).ToString();
                            tr.Cells.Add(tc);
                            tc = new TableCell();
                            tc.Text = reader.GetValue(1).ToString();
                            tr.Cells.Add(tc);
                            tc = new TableCell();
                            tc.Text = reader.GetValue(2).ToString();
                            tr.Cells.Add(tc);
                            tc = new TableCell();
                            tc.Text = reader.GetValue(3).ToString();
                            tr.Cells.Add(tc);
                            tc = new TableCell();
                            tc.Text = reader.GetValue(4).ToString();
                            tr.Cells.Add(tc);
                            Table1.Rows.Add(tr);
                        }
                   
                    }
                }
            }
        }