ds=service1.SelRetds2("gzwj_view","",sortfield.ToString());
DataColumn sequence=new DataColumn();
sequence.DataType=System.Type.GetType("System.Int32");
sequence.AllowDBNull=false;
sequence.Caption="sortnum";
sequence.ColumnName="count";
ds.Tables[0].Columns.Add(sequence);
for(int i=0;i<ds.Tables[0].Rows.Count;i++)
{
ds.Tables[0].Rows[i]["count"]=i+1;
}
DataColumn sequence3=new DataColumn();
sequence3.AllowDBNull=false;
sequence3.Caption="time";
sequence3.ColumnName="sj1";
ds.Tables[0].Columns.Add(sequence3);
for(int i=0;i<ds.Tables[0].Rows.Count;i++)
{
int cd=ds.Tables[0].Rows[i]["SJ"].ToString().Length;
ds.Tables[0].Rows[i]["sj1"]=ds.Tables[0].Rows[i]["sj"].ToString().Remove(cd-8,8);
string[] s;
s=ds.Tables[0].Rows[i]["sj1"].ToString().Split('-');
ds.Tables[0].Rows[i]["sj1"]=s[0].ToString()+"年"+s[1].ToString()+"月"+s[2].ToString()+"日";
}
DataView source=new DataView();
source=ds.Tables[0].DefaultView;
DataGrid1.DataSource=source;
DataGrid1.DataKeyField="BH";
DataGrid1.CurrentPageIndex=page_no;
DataGrid1.DataBind();
DataColumn sequence=new DataColumn();
sequence.DataType=System.Type.GetType("System.Int32");
sequence.AllowDBNull=false;
sequence.Caption="sortnum";
sequence.ColumnName="count";
ds.Tables[0].Columns.Add(sequence);
for(int i=0;i<ds.Tables[0].Rows.Count;i++)
{
ds.Tables[0].Rows[i]["count"]=i+1;
}
DataColumn sequence3=new DataColumn();
sequence3.AllowDBNull=false;
sequence3.Caption="time";
sequence3.ColumnName="sj1";
ds.Tables[0].Columns.Add(sequence3);
for(int i=0;i<ds.Tables[0].Rows.Count;i++)
{
int cd=ds.Tables[0].Rows[i]["SJ"].ToString().Length;
ds.Tables[0].Rows[i]["sj1"]=ds.Tables[0].Rows[i]["sj"].ToString().Remove(cd-8,8);
string[] s;
s=ds.Tables[0].Rows[i]["sj1"].ToString().Split('-');
ds.Tables[0].Rows[i]["sj1"]=s[0].ToString()+"年"+s[1].ToString()+"月"+s[2].ToString()+"日";
}
DataView source=new DataView();
source=ds.Tables[0].DefaultView;
DataGrid1.DataSource=source;
DataGrid1.DataKeyField="BH";
DataGrid1.CurrentPageIndex=page_no;
DataGrid1.DataBind();
private DataSet CreateDataSet()
{
DBCon db = new DBCon();
DataSet ds = db.GetTopRecord(int.Parse(tbNum.Text),"录入"); DataTable dt = ds.Tables[0];
dt.Columns.Add("RowID",Type.GetType("System.Int32"));
dt.AcceptChanges(); return ds;
}public void BindGrid()
{
DataSet ds = CreateDataSet();
DataView dv = ds.Tables[0].DefaultView; int i = 1;
foreach(DataRowView drwv in dv)
{
drwv["RowID"] = i;
i += 1;
} dgList.DataSource = dv;
dgList.DataBind();
}