Code

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();}