请问 <asp:datagrid id="" runat=""><columns><asp:boundcolumn headertext="" datafield=""....>.....</columns></asp:datagrid> 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 DataTable dt=new DataTable (); DataRow dr; dt.Columns .Add (new DataColumn ("编号",typeof(long))); dt.Columns .Add (new DataColumn ("全文检索编号",typeof(long))); dt.Columns .Add (new DataColumn ("类型",typeof(string))); dt.Columns .Add (new DataColumn ("下达时间",typeof(string))); dt.Columns .Add (new DataColumn ("完成时间",typeof(string))); dt.Columns .Add (new DataColumn ("主题",typeof(string))); dt.Columns .Add (new DataColumn ("优先级",typeof(long))); dt.Columns .Add (new DataColumn ("起始时间",typeof(long))); dt.Columns .Add (new DataColumn ("结束时间",typeof(long))); dt.Columns .Add (new DataColumn ("群发阈值",typeof(long))); dt.Columns .Add (new DataColumn ("状态",typeof(string))); dt.Columns .Add (new DataColumn ("描述",typeof(string))); mycon=new OracleConnection ("Data Source =ora9i38;user id=oracle;password=oracle"); mycon.Open (); mycom=new OracleCommand (); mycom.Connection =mycon; mycom.CommandText ="select * from tasktable where tasktype=1"; reader=mycom.ExecuteReader (); while(reader.Read ()) { dr=dt.NewRow (); dr[0]=reader.GetInt64 (0); dr[1]=reader.GetInt64 (1); dr[2]="流向图"; System.DateTime date=new DateTime (reader.GetInt64 (3)); dr[3]=date.ToString (); //任务结束时间 dr[4]="00000"; // long time=reader.GetInt64 (4); // if(time.ToString ()=="") // { // dr[4]=""; // } // else // { // System.DateTime now2=new DateTime (1970,1,1,8,0,0,0); // time=time*1000*1000*10+now2.Ticks ; // System.DateTime date1=new DateTime (time); // dr[4]=date1.ToString (); // } dr[5]=reader.GetString (5); dr[6]=reader.GetInt64 (8); dr[7]=reader.GetInt64 (9); dr[8]=reader.GetInt64 (10); dr[9]=reader.GetInt64 (11); if(reader.GetInt64 (16)==1) { dr[10]="新加任务"; } else if(reader.GetInt64 (16)==2) { dr[10]="任务执行中"; } else if(reader.GetInt64 (16)==3) { dr[10]="任务结束"; } else if(reader.GetInt64 (16)==4) { dr[10]="待中断"; } else if(reader.GetInt64 (16)==5) { dr[10]="已中断"; } else { dr[10]="待删除"; } dr[11]=reader.GetString (17); dt.Rows .Add (dr); } DataGrid1.DataSource =new DataView (dt); DataGrid1.DataBind (); dt.Clear ();如何在这样的datagrid里加个checkbox模版列??帮忙 提个Vs2008下处理SQL语句的问题 关于frameset 弹出窗口 DataList实现树的折叠效果? 我点击Button先进行一些处理,然后弹出一个提示窗口,并定位到另一页,我这样为什么不行! 关于dropdownlist取值的一个问题。 立即结帐!!!关于DataGrid分页问题!!! 请教一个updatepanel的问题 大虾给小弟简单讲解下这个问题。。。 请推荐最ASP.NET开发的WEB程序进行功能测试的工具 一个用户控件的问题:控件生成一段html中包含一个文本框,在PostBack以后文本框的值就被冲掉了?请大家帮忙看下 正则表达式的问题!
DataRow dr;
dt.Columns .Add (new DataColumn ("编号",typeof(long)));
dt.Columns .Add (new DataColumn ("全文检索编号",typeof(long)));
dt.Columns .Add (new DataColumn ("类型",typeof(string)));
dt.Columns .Add (new DataColumn ("下达时间",typeof(string)));
dt.Columns .Add (new DataColumn ("完成时间",typeof(string)));
dt.Columns .Add (new DataColumn ("主题",typeof(string)));
dt.Columns .Add (new DataColumn ("优先级",typeof(long)));
dt.Columns .Add (new DataColumn ("起始时间",typeof(long)));
dt.Columns .Add (new DataColumn ("结束时间",typeof(long)));
dt.Columns .Add (new DataColumn ("群发阈值",typeof(long)));
dt.Columns .Add (new DataColumn ("状态",typeof(string)));
dt.Columns .Add (new DataColumn ("描述",typeof(string))); mycon=new OracleConnection ("Data Source =ora9i38;user id=oracle;password=oracle");
mycon.Open ();
mycom=new OracleCommand ();
mycom.Connection =mycon;
mycom.CommandText ="select * from tasktable where tasktype=1";
reader=mycom.ExecuteReader ();
while(reader.Read ())
{
dr=dt.NewRow ();
dr[0]=reader.GetInt64 (0);
dr[1]=reader.GetInt64 (1);
dr[2]="流向图";
System.DateTime date=new DateTime (reader.GetInt64 (3));
dr[3]=date.ToString ();
//任务结束时间
dr[4]="00000";
// long time=reader.GetInt64 (4);
// if(time.ToString ()=="")
// {
// dr[4]="";
// }
// else
// {
// System.DateTime now2=new DateTime (1970,1,1,8,0,0,0);
// time=time*1000*1000*10+now2.Ticks ;
// System.DateTime date1=new DateTime (time);
// dr[4]=date1.ToString ();
// } dr[5]=reader.GetString (5);
dr[6]=reader.GetInt64 (8);
dr[7]=reader.GetInt64 (9);
dr[8]=reader.GetInt64 (10);
dr[9]=reader.GetInt64 (11); if(reader.GetInt64 (16)==1)
{
dr[10]="新加任务";
}
else if(reader.GetInt64 (16)==2)
{
dr[10]="任务执行中";
}
else if(reader.GetInt64 (16)==3)
{
dr[10]="任务结束";
}
else if(reader.GetInt64 (16)==4)
{
dr[10]="待中断";
}
else if(reader.GetInt64 (16)==5)
{
dr[10]="已中断";
}
else
{
dr[10]="待删除";
} dr[11]=reader.GetString (17);
dt.Rows .Add (dr);
}
DataGrid1.DataSource =new DataView (dt);
DataGrid1.DataBind ();
dt.Clear ();
如何在这样的datagrid里加个checkbox模版列??帮忙