private void PopulateMemberRequest()
{
taMember.Fill(ds1.Member);
DataTable dt = new DataTable();
CommandField selectCommandField = new CommandField();
selectCommandField.ShowSelectButton = true;
selectCommandField.SelectText = "Confirm Delete";
gvMemberRequest.Columns.Add(selectCommandField);
dt.Columns.Add(new DataColumn("Member ID", typeof(string)));
dt.Columns.Add(new DataColumn("Name", typeof(string)));
dt.Columns.Add(new DataColumn("Phone", typeof(string)));
dt.Columns.Add(new DataColumn("Email", typeof(string)));
DataRow drTemp;
foreach (DataRow dr in ds1.Member.Rows)
{
if (!Convert.ToBoolean(dr["Status"].ToString()))
{
drTemp = dt.NewRow();
drTemp[0] = dr["MemberID"].ToString();
drTemp[1] = dr["Name"].ToString();
drTemp[2] = dr["PhoneNumber"].ToString();
drTemp[3] = dr["Email"].ToString();
dt.Rows.Add(drTemp);
}
}
gvMemberRequest.DataSource = dt;
gvMemberRequest.DataBind();
}
private void PopulateMember()
{
taMember.Fill(ds1.Member);
foreach (DataRow dr in ds1.Member.Rows)
{
ddlMember.Items.Add(new ListItem(dr["Name"].ToString(), dr["MemberID"].ToString()));
}
//ddlMember.Items.Add()
}