using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
namespace Demo3
{
public partial class 查询 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string constr = "Data Source=.;Initial Catalog=Schools;Persist Security Info=True;User ID=sa;Password=910809";
using (SqlConnection con = new SqlConnection(constr))
{
con.Open();
using (SqlCommand cmd = con.CreateCommand ())
{
string sql = "select * from Student";
cmd.CommandText = sql;
using (SqlDataReader reader=cmd.ExecuteReader ())
{
if(reader .HasRows)
{
while (reader .Read ())
{
TableRow trRow = new TableRow();//-------读取的是行
//获取第一条记录的第一列中的值
TableCell trCell = new TableCell();//-----读取的是列
trCell.BorderStyle = BorderStyle.Solid;
trCell.BorderWidth = 1;
trCell.Text = reader.GetValue(0).ToString();
trRow.Cells.Add(trCell );//_------把列添加到行中
//获取第一条记录的第二列中的值
trCell = new TableCell();
trCell.BorderStyle = BorderStyle.Solid;
trCell.BorderWidth = 1;
trCell.Text =reader.GetValue(1).ToString();
trRow.Cells.Add(trCell);
//获取第一条记录的第三列中的值
trCell = new TableCell();
trCell.BorderStyle = BorderStyle.Solid;
trCell.BorderWidth = 1;
trCell.Text = reader.GetValue(2).ToString();
trRow.Cells.Add(trCell);
//获取第一条记录的第四列中的值
trCell = new TableCell();
trCell.BorderStyle = BorderStyle.Solid;
trCell.BorderWidth = 1;
trCell.Text = reader.GetValue(3).ToString();
trRow.Cells.Add(trCell);
//获取第一条记录的第五列中的值
trCell = new TableCell();
trCell.BorderStyle = BorderStyle.Solid;
trCell.BorderWidth = 1;
trCell.Text = reader.GetValue(4).ToString();
trRow.Cells.Add(trCell);
Table1.Rows.Add(trRow );//----------把行添加到table中去
}
}
}
}
}
}
}
}