//Bind Grid View
#region [Bind Grid View]
private void BindGridView(string feesId)
{
try
{
EWA_Fees ObjEWA = new EWA_Fees();
BL_Fees ObjBL = new BL_Fees();
if (!feesId.Equals("Empty"))
{
ObjEWA.FeesId = feesId;
DataSet ds = ObjBL.BindGridView_BL(ObjEWA);
if (ds != null)
{
GrdFees.DataSource = ds;
GrdFees.DataBind();
}
else
{
BindEmptyDataTable();
}
}
else
{
BindEmptyDataTable();
}
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
}
//Bind Empty Data Table
#region [Bind Empty Data Table]
public void BindEmptyDataTable()
{
try
{
DataTable dtMenu = new DataTable(); //declaringa datatable
// DataColumn dcMenuID = new DataColumn("SrNo", typeof(System.String));
// dtMenu.Columns.Add(dcMenuID);// Adding column to the datatable
DataColumn dcMenuParticular = new DataColumn("Particular", typeof(System.String));
//creating a column in the same
//Name of column available in the sql server
dtMenu.Columns.Add(dcMenuParticular);// Adding column to the datatable
DataColumn dcMenuAmount = new DataColumn("Amount", typeof(System.String));
dtMenu.Columns.Add(dcMenuAmount);
DataColumn dcMenuFeesDetailsId = new DataColumn("FeesDetailsId", typeof(System.Int32));
dtMenu.Columns.Add(dcMenuFeesDetailsId);
DataRow datatRow = dtMenu.NewRow();
//Inserting a new row,datatable .newrow creates a blank row
dtMenu.Rows.Add(datatRow);//adding row to the datatable
GrdFees.DataSource = dtMenu;
GrdFees.DataBind();
GrdFees.Rows[0].Cells[0].ColumnSpan = GrdFees.Columns.Count;
GrdFees.Rows[0].Cells[GrdFees.Columns.Count - 1].Visible = false;
GrdFees.Rows[0].Cells[GrdFees.Columns.Count - 2].Visible = false;
GrdFees.Rows[0].Cells[GrdFees.Columns.Count - 3].Visible = false;
GrdFees.Rows[0].Cells[0].Text = "NO PARTICULARS FOUND";
GrdFees.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center;
lblresult.Text = "";
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
}
