Code
来源:互联网 发布:淘宝买东西从来不评价 编辑:程序博客网 时间:2024/04/29 14:48
if(!Page.IsPostBack)
{
DataTable dt = new DataTable();
DataRow myDataRow;
dt.Columns.Add("Id");
dt.Columns.Add("MemberId");
dt.Columns.Add("MemberName");
dt.Columns.Add("YwName");
dt.Columns.Add("SaleId");
dt.Columns.Add("ServId");
dt.Columns.Add("TechClFlag");
dt.Columns.Add("IsJD");
string strSql="select Count(Id) from t_FormInfo "
string strCount=dal.RunSql(strSql);
for (int i = 0; i < int.Parse(strCount);i++ )
{
myDataRow = dt.NewRow();
string strTechId = dal.RunSql("select TecId from t_FormInfo");
string values = strTechId;
string[] sites = values.Split(',');
foreach (string txt in sites)
{
if (txt == this.UId.ToString())
{
SqlDataReader dr=dal.RunSqlNameDataReader("select Id,MemberId,MemberName,YwName,SaleId,ServId,TechClFlag,IsJD from t_FormInfo");
if(dr.Read())
{
strId = dr["Id"].ToString();
strMemberId = dr["MemberId"].ToString();
strMemberName = dr["MemberName"].ToString();
strYwName = dr["YwName"].ToString();
strSaleId = dr["SaleId"].ToString();
strServId = dr["ServId"].ToString();
strTechFlag = dr["TechCLFlag"].ToString();
strIsJD = dr["IsJD"].ToString();
}
dr.Close();
}
}
myDataRow["Id"] = strId;
myDataRow["MemberId"] = strMemberId;
myDataRow["MemberName"] = strMemberName;
myDataRow["YwName"] = strYwName;
myDataRow["SaleId"] = strSaleId;
myDataRow["ServId"] = strServId;
myDataRow["TechClFlag"] = strTechFlag;
myDataRow["IsJD"] = strIsJD;
//dt.Rows.i(new object[] { strId, strMemberId, strMemberName, strYwName, strSaleId, strServId, strTechFlag, strIsJD });
dt.Rows.Add(myDataRow);
}
this.GridView1.DataSource = dt;
this.GridView1.DataBind();
//sql = "select * from t_FormInfo where IsJD=0 and TecId=" + base.UId + " order by CreateTime Desc" //未结
//gridViewBind();
}
- code
- code
- code
- code
- Code
- code
- code
- Code
- Code
- CODE
- code
- code
- code
- code
- code
- code
- Code
- code
- 读取mysql 中文乱码问题
- 安装不上WINDOWS INSTALLER 3.1!!
- 企业软件发布管理
- 爆笑口误07版
- 《Eversleeping》 Xandria
- Code
- [转贴]仅通过崩溃地址找出源代码的出错行
- 连接查询
- 安装Ms SQL Server 2005 开发版时出现性能计数器要求安装错误的解决办法
- 体现数学之美的几何建筑
- JavaScript的方法和技巧
- C#获得Cpu 利用率
- 深圳给了我们什么?(--深圳之窗)
- 用C#封装海康HC系列音视频卡网络端户端SDK