private void BindGrid(string type) { //at = SpringUtil.at(); /* 帳號未審核 */ String sql = "SELECT IsApproved, UserId,UserName,Email,CreateDate,'' as Type,'' as Name,'' as Corp,'' as Tel "; sql += " from vw_aspnet_MembershipUsers "; if (type.Equals("A")) { sql += " where IsApproved=false "; } else if (type.Equals("B")) { sql += " where UserName not in ('isrmng','root') "; } if (!qryText.Text.Trim().Equals("")) { sql += " and Comment like '%" + qryText.Text.Trim() + "%'"; } //DataSet ds = new DataSet(); //at.DataSetFill(ds, CommandType.Text, sql); OleDbCommand cmd = new OleDbCommand(sql); DataSet ds = SQLUtil.QueryDS(cmd); foreach (DataRow dRow in ds.Tables[0].Rows) { p = Profile.GetProfile(dRow["UserName"].ToString()); dRow["Type"] = p.UserProfile.Type; dRow["Name"] = p.UserProfile.Name; dRow["Corp"] = p.UserProfile.Corp; dRow["Tel"] = p.UserProfile.Tel; } ApproveGrid.DataSource = ds; ApproveGrid.DataBind(); cnt.Text = Convert.ToString(ds.Tables[0].Rows.Count); }
private void ApprovingScreen_Load(object sender, EventArgs e) { List <int> dersIds = new List <int>(); for (int i = 0; i < ogrenci.AlinanDersler.Length; i += 2) { string dummy = ogrenci.AlinanDersler.Substring(i, 2); dersIds.Add(Convert.ToInt32(dummy)); } ApproveGrid.DataSource = DersDAO.ApprovingList(dersIds); if (ApproveGrid.DataSource == null) { this.Close(); } for (int i = 4; i < ApproveGrid.ColumnCount; i++) { ApproveGrid.Columns[i].ReadOnly = true; } ApproveGrid.AutoResizeColumns(); }