private void GetMembers()
{
using (MembershipContext db = new MembershipContext())
{
try
{
var Members = (from allMembers in db.Members select allMembers);
MemberGridView.DataSource = Members.ToList();
MemberGridView.DataBind();
}
catch
{
}
}
}
private void Bind(int pageIndex)
{
try
{
using (RockyingDataClassesDataContext db = new RockyingDataClassesDataContext(Utility.ConnectionString))
{
string query = "SELECT ID, Email, Createdate, Newsletter, UserType, MemberName, Status, Password " +
" FROM Member AS M WHERE UserType <> 1 ";
if (MemberTypeDropDown.SelectedValue != "")
{
query = string.Format("{0} AND(UserType = {1})", query, MemberTypeDropDown.SelectedValue);
}
if (StatusDropDown.SelectedValue != "")
{
query = string.Format("{0} AND(Status = {1})", query, StatusDropDown.SelectedValue);
}
if (SubscribeList.SelectedValue != "")
{
query = string.Format("{0} AND(Newsletter = {1})", query, SubscribeList.SelectedValue);
}
query = string.Format("{0} ORDER BY CreateDate desc ", query);
MemberGridView.DataSource = db.ExecuteQuery <Member>(query, new object[] { }).ToList <Member>();
MemberGridView.PageIndex = pageIndex;
MemberGridView.DataBind();
}
}
catch (Exception ex)
{
Trace.Write("Unable to fetch member records.");
Trace.Write(ex.Message);
Trace.Write(ex.StackTrace);
}
}
private void ShowData()
{
try
{
var data = new Anggota_KMB();
MemberGridView.DataSource = data.RetrievingData();
MemberGridView.Refresh();
if (MemberGridView.Columns.Count > 0)
{
MemberGridView.Columns[0].Visible = false;
MemberGridView.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
MemberGridView.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
MemberGridView.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
MemberGridView.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
MemberGridView.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
MemberGridView.Columns[6].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
MemberGridView.Columns[7].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
MemberGridView.Columns[8].Visible = false;
MemberGridView.Columns[9].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
MemberGridView.Columns[10].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
MemberGridView.Columns[11].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
MemberGridView.Columns[12].Visible = false;
MemberGridView.Columns[13].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
MemberGridView.Columns[14].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
MemberGridView.Columns[15].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
MemberGridView.Columns[16].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
MemberGridView.Columns[17].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
MemberGridView.Columns[18].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
MemberGridView.ClearSelection();
}
catch (Exception er)
{
Console.WriteLine("ERROR : Anggota_KMB.RetrivingData" + er.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
// Gets the default connection string/path to our database from the web.config file
string dbstring = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
// Creates a connection to our database
SqlConnection con = new SqlConnection(dbstring);
// query
string sqlStr = "SELECT UserName as 'Member', RoleName as 'Role' FROM aspnet_usersinroles uir, aspnet_roles r, aspnet_users u WHERE uir.userid = u.userid and uir.roleid = r.roleid";
// Open the database connection
con.Open();
// Create an executable SQL command containing our SQL statement and the database connection
SqlCommand sqlCmd = new SqlCommand(sqlStr, con);
// Fill in the parameters in our prepared SQL statement
sqlCmd.Parameters.AddWithValue("@username", User.Identity.Name);
// Adapt the data from the SQL query in order to populate the GridView
SqlDataAdapter adapter = new SqlDataAdapter(sqlCmd);
DataTable datatable = new DataTable();
adapter.Fill(datatable);
// Add a new column to the DataTable to add the buttons to allow the administrator to modify a user
datatable.Columns.Add(new DataColumn("Edit", typeof(string)));
MemberGridView.DataSource = datatable;
MemberGridView.DataBind();
con.Close();
AssignClassesToRow();
}