private void Page_Load(object sender, System.EventArgs e)
{
if(!Page.IsPostBack)
{
string strCn="Data Source=sprogram;uid=develop;pwd=xx;Initial Catalog=new_ks";
string strSQL=" SELECT person_name1,person_name2,person_name3 "
+" FROM dbo.tabA ";
SqlDataAdapter sadTest=new SqlDataAdapter(strSQL,strCn);
DataSet dsTest=new DataSet();
sadTest.Fill(dsTest);
DataTable tblNew=new DataTable();;
DataRow trNew;
tblNew.Columns.Add("Title");
tblNew.Columns.Add("Name");
for(int intI=0;intI<=2;intI++)
{
trNew=tblNew.NewRow();
trNew[0]="name"+(intI+1);
trNew[1]=dsTest.Tables[0].Rows[0][intI];
tblNew.Rows.Add(trNew);
}
DataGrid1.DataSource=tblNew;
DataGrid1.DataBind();
}
}
{
if(!Page.IsPostBack)
{
string strCn="Data Source=sprogram;uid=develop;pwd=xx;Initial Catalog=new_ks";
string strSQL=" SELECT person_name1,person_name2,person_name3 "
+" FROM dbo.tabA ";
SqlDataAdapter sadTest=new SqlDataAdapter(strSQL,strCn);
DataSet dsTest=new DataSet();
sadTest.Fill(dsTest);
DataTable tblNew=new DataTable();;
DataRow trNew;
tblNew.Columns.Add("Title");
tblNew.Columns.Add("Name");
for(int intI=0;intI<=2;intI++)
{
trNew=tblNew.NewRow();
trNew[0]="name"+(intI+1);
trNew[1]=dsTest.Tables[0].Rows[0][intI];
tblNew.Rows.Add(trNew);
}
DataGrid1.DataSource=tblNew;
DataGrid1.DataBind();
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货