private void LoadData()
{
gridHelper.ClearDataTable();
string query = "select Forums.*, Symbol, Communities.Name as CommunityName from Forums left join Statuses on Statuses.Id=Status left join Communities on Communities.Id=CommunityId";
using (GmConnection conn = Global.CreateConnection())
{
conn.Fill(gridHelper.DataTable, query);
}
gridHelper.DataTable.DefaultView.Sort = "CommunityId, Id";
}
private void LoadData()
{
gridHelper.ClearDataTable();
string query = "select Galleries.*, Symbol from Galleries left join Statuses on Statuses.Id=Status";
using (GmConnection conn = Global.CreateConnection())
{
conn.Fill(gridHelper.DataTable, query);
}
gridHelper.DataTable.DefaultView.Sort = "Name";
}
private void LoadData()
{
gridHelper.ClearDataTable();
string query = "select * from LinkExchange";
using (GmConnection conn = Global.CreateConnection())
{
conn.Fill(gridHelper.DataTable, query);
}
gridHelper.DataTable.DefaultView.Sort = "Id";
}
private void UpdateGrid()
{
gridHelper.ClearDataTable();
int communityId = RequestUtils.GetCommunityId(this);
string query = "select Polls.*, Symbol from Polls left join Statuses on Statuses.Id=Status";
using (GmConnection conn = Global.CreateConnection())
{
conn.Fill(gridHelper.DataTable, query);
}
gridHelper.DataTable.DefaultView.Sort = "Id";
}
private void UpdateGrid()
{
gridHelper.ClearDataTable();
LogType lt = (LogType)int.Parse(ddlLogType.SelectedValue);
string query = string.Format("select * from [Log] where LogTypeId={0}", (int)lt);
using (GmConnection conn = Global.CreateConnection())
{
conn.Fill(gridHelper.DataTable, query);
}
gridHelper.DataTable.DefaultView.Sort = "Time desc";
}
private void LoadData()
{
int forumId = RequestUtils.GetForumId(this);
hlAdd.NavigateUrl += "?fr=" + forumId;
gridHelper.ClearDataTable();
string query = "select ForumTopics.*, Symbol from ForumTopics left join Statuses on Statuses.Id=Status where ForumId=" + forumId;
using (GmConnection conn = Global.CreateConnection())
{
conn.Fill(gridHelper.DataTable, query);
}
gridHelper.DataTable.DefaultView.Sort = "Id desc";
}
private void LoadData()
{
gridHelper.ClearDataTable();
int gl = RequestUtils.GetGalleryId(this);
hlAdd.NavigateUrl += "?gl=" + gl;
string query = "select GalleryImages.*, Symbol from GalleryImages left join Statuses on Statuses.Id=Status";
query += " where GalleryId=" + gl.ToString();
using (GmConnection conn = Global.CreateConnection())
{
conn.Fill(gridHelper.DataTable, query);
}
gridHelper.DataTable.DefaultView.Sort = "Name";
}