private void BindBatchData() { try { DataTable dtu = con.SelecthostProc(Com_username, "Batch_View_Select", null, null); GridView_Batchs.DataSource = dtu; GridView_Batchs.DataBind(); } catch (Exception ex) { con.ExcutehostProc(Com_username, "Log_Issues", new string[] { "msg", "details" }, ex.Message, "Err-MakeIngredient-BindBatchData"); } }
protected void GridView_Batchs_PageIndexChanging(object sender, GridViewPageEventArgs e) { try { BindBatchData(); GridView_Batchs.PageIndex = e.NewPageIndex; GridView_Batchs.DataBind(); NotifyMsg("", "none", ""); } catch (Exception ex) { con.ExcutehostProc(Com_username, "Log_Issues", new string[] { "msg", "details" }, ex.Message, "Err-MakeIngredient-GridView_Batchs_PageIndexChanging"); } }
protected void GridView_Batchs_Sorting(object sender, GridViewSortEventArgs e) { try { DataTable dtu = con.SelecthostProc(Com_username, "Batch_View_Select", null, null); if (dtu != null) { DataView dataView = new DataView(dtu); dataView.Sort = e.SortExpression + " " + ConvertSortDirectionToSql(e.SortDirection); GridView_Batchs.DataSource = dataView; GridView_Batchs.DataBind(); } } catch (Exception ex) { con.ExcutehostProc(Com_username, "Log_Issues", new string[] { "msg", "details" }, ex.Message, "Err-MakeIngredient-GridView_Batchs_Sorting"); } }