private void getDataToGv()
{
string jsonText = CrazyKTVWCF.ViewSong(0, 1000); // it will be very slow if more than 2000
DataTable dt = GlobalFunctions.JsontoDataTable(jsonText);
DataView dv = new DataView(dt);
//dv.Sort = "Song_Singer asc, Song_SongName asc, Song_Id asc";
GridView1.DataSource = dv;
GridView1.DataBind();
}
private void getDataToGv()
{
string jsonText = CrazyKTVWCF.ViewSong(0, GuiGlobal.QuerySongRows);
DataTable dt = GlobalFunctions.JsontoDataTable(jsonText);
int CurPageSize = Convert.ToInt32(((HiddenField)this.Parent.FindControl("PlayListGridViewPageSize")).Value);
if (CurPageSize < 1)
{
CurPageSize = 1;
}
// Desktop / Tablet Mode
if (((HiddenField)this.Parent.FindControl("BootstrapResponsiveMode")).Value.Contains("Desktop"))
{
GridView1.PageSize = CurPageSize;
if (dt.Rows.Count == 0)
{
DataColumn col = new DataColumn("Song_Id");
dt.Columns.Add(col);
col = new DataColumn("Song_Lang");
dt.Columns.Add(col);
col = new DataColumn("Song_SongName");
dt.Columns.Add(col);
col = new DataColumn("Song_Singer");
dt.Columns.Add(col);
}
if (dt.Rows.Count > CurPageSize)
{
if (dt.Rows.Count % CurPageSize > 0)
{
int NewRowCount = CurPageSize - (dt.Rows.Count % CurPageSize);
for (int i = 0; i < NewRowCount; i++)
{
DataRow row = dt.NewRow();
row["Song_Lang"] = " ";
dt.Rows.Add(row);
}
}
GridView1.AllowPaging = true;
GridView1.ShowFooter = false;
}
else
{
int NewRowCount = CurPageSize - dt.Rows.Count;
for (int i = 0; i < NewRowCount; i++)
{
DataRow row = dt.NewRow();
row["Song_Lang"] = " ";
dt.Rows.Add(row);
}
GridView1.ShowFooter = true;
}
}
else
{
GridView1.PageSize = 1;
GridView1.AllowPaging = false;
GridView1.ShowFooter = false;
}
DataView dv = new DataView(dt);
//dv.Sort = "Song_Singer asc, Song_SongName asc, Song_Id asc";
GridView1.DataSource = dv;
GridView1.DataBind();
if (((HiddenField)this.Parent.FindControl("BootstrapResponsiveMode")).Value.Contains("Desktop"))
{
if (dt.Rows.Count > CurPageSize)
{
DropDownList ddlSelectPage = (DropDownList)GridView1.BottomPagerRow.FindControl("SelectPage_DropDownList");
for (int i = 0; i < GridView1.PageCount; i++)
{
ddlSelectPage.Items.Add(new ListItem((i + 1).ToString(), i.ToString()));
}
ddlSelectPage.SelectedIndex = GridView1.PageIndex;
}
}
}