private void SelectBedConsumtion() { try { BedConsumtionBLL consume = new BedConsumtionBLL(); List <STP_AdmitedPatientListReportResult> lst = consume.AdmitedPatientListReport(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)); if (lst != null) { lbl.Text = "Admited Patient List Report"; lblFrom.Text = txtBillDate.Text; lblTo.Text = txtToDate.Text; DataTable dt = ListConverter.ToDataTable(lst); dt.Columns.Add("colSrNo"); DataColumn dcol = new DataColumn(); if (dt.Rows.Count > 0) { int count = 1; foreach (DataRow dr in dt.Rows) { dr["colSrNo"] = count; count++; } } dgvTestParameter.DataSource = dt; dgvTestParameter.DataBind(); Session["BedConsump"] = dt; } } catch (Exception ex) { lblMessage.Text = ex.Message; } }
private void SelectBedConsumtion() { try { BedConsumtionBLL consume = new BedConsumtionBLL(); //if (ddlEmployee.SelectedIndex > 0) //{ lbl.Text = "Summarized Report"; //IPD Sale(Discharge Patient) :- decimal invCash = consume.GetCashInvoiceDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)); decimal RecCash = consume.GetRecCashDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)); txtCash.Text = string.Format("{0:0.00}", invCash + RecCash); txtCheque.Text = string.Format("{0:0.00}", consume.GetRecChequeDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text))); txtCard.Text = string.Format("{0:0.00}", consume.GetRecCardDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text))); txtRTGS.Text = string.Format("{0:0.00}", consume.GetRecRTGSDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text))); txtTotal.Text = string.Format("{0:0.00}", Convert.ToDecimal(txtCash.Text) + Convert.ToDecimal(txtCheque.Text) + Convert.ToDecimal(txtCard.Text) + Convert.ToDecimal(txtRTGS.Text)); txtDiscountIPD.Text = string.Format("{0:0.00}", consume.GetIPDDiscountInvoiceDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text))); //OPD Sale(Consulting/Treatments/Daycare) :- decimal invCash1 = consume.GetOPDCashInvoiceDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)); decimal RecCash1 = consume.GetOPDRecCashDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)); txtCash1.Text = string.Format("{0:0.00}", invCash1 + RecCash1); txtCheque1.Text = string.Format("{0:0.00}", consume.GetOPDRecChequeDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text))); txtCard1.Text = string.Format("{0:0.00}", consume.GetOPDRecCardDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text))); txtRTGS1.Text = string.Format("{0:0.00}", consume.GetOPDRecRTGSDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text))); txtTotal1.Text = string.Format("{0:0.00}", Convert.ToDecimal(txtCash1.Text) + Convert.ToDecimal(txtCheque1.Text) + Convert.ToDecimal(txtCard1.Text) + Convert.ToDecimal(txtRTGS1.Text)); txtDiscountOPD.Text = string.Format("{0:0.00}", consume.GetOPDDiscountInvoiceDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text))); //IPD Advanced Received :- txtCash2.Text = string.Format("{0:0.00}", consume.GetIPDAdvanceRecCashDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text))); txtCheque2.Text = string.Format("{0:0.00}", consume.GetIPDAdvanceRecChequeDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text))); txtCard2.Text = string.Format("{0:0.00}", consume.GetIPDAdvanceRecCardDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text))); txtRTGs2.Text = string.Format("{0:0.00}", consume.GetIPDAdvanceRecRTGSDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text))); txtTotal2.Text = string.Format("{0:0.00}", Convert.ToDecimal(txtCash2.Text) + Convert.ToDecimal(txtCheque2.Text) + Convert.ToDecimal(txtCard2.Text) + Convert.ToDecimal(txtRTGs2.Text)); //IPD OPD Registration Fees :- txtRegFeeIPD.Text = string.Format("{0:0.00}", consume.GetIPDRegFeeInvoiceDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text))); txtRegFeeOPD.Text = string.Format("{0:0.00}", consume.GetOPDRegFeeInvoiceDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text))); txtTotalReg.Text = string.Format("{0:0.00}", Convert.ToDecimal(txtRegFeeIPD.Text) + Convert.ToDecimal(txtRegFeeOPD.Text)); //IPD Refund Amount :- txtIPDCashRefund.Text = string.Format("{0:0.00}", consume.GetIPDCashRefundDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text))); txtIPDChequeRefund.Text = string.Format("{0:0.00}", consume.GetIPDChequeRefundDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text))); txtIPDCardRefund.Text = string.Format("{0:0.00}", consume.GetIPDCardRefundDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text))); txtIPDRTGSRefund.Text = string.Format("{0:0.00}", consume.GetIPDRTGSRefundDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text))); txtIPDTotalRefund.Text = string.Format("{0:0.00}", Convert.ToDecimal(txtIPDCashRefund.Text) + Convert.ToDecimal(txtIPDChequeRefund.Text) + Convert.ToDecimal(txtIPDCardRefund.Text) + Convert.ToDecimal(txtIPDRTGSRefund.Text)); //OPD Refund Amount :- txtOPDCashRefund.Text = string.Format("{0:0.00}", consume.GetOPDCashRefundDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text))); txtOPDChequeRefund.Text = string.Format("{0:0.00}", consume.GetOPDChequeRefundDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text))); txtOPDCardRefund.Text = string.Format("{0:0.00}", consume.GetOPDCardRefundDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text))); txtOPDRTGSRefund.Text = string.Format("{0:0.00}", consume.GetOPDRTGSRefundDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text))); txtOPDTotalRefund.Text = string.Format("{0:0.00}", Convert.ToDecimal(txtOPDCashRefund.Text) + Convert.ToDecimal(txtOPDChequeRefund.Text) + Convert.ToDecimal(txtOPDCardRefund.Text) + Convert.ToDecimal(txtOPDRTGSRefund.Text)); //Credit (Bill Pending)Amount :- txtCreditAmt.Text = string.Format("{0:0.00}", consume.GetCreditAmtDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text))); //Total Collection IPD OPD txtTotalCash.Text = string.Format("{0:0.00}", Convert.ToDecimal(txtCash.Text) + Convert.ToDecimal(txtCash1.Text) + Convert.ToDecimal(txtCash2.Text)); txtTotalCheque.Text = string.Format("{0:0.00}", Convert.ToDecimal(txtCheque.Text) + Convert.ToDecimal(txtCheque1.Text) + Convert.ToDecimal(txtCheque2.Text)); txtTotalCard.Text = string.Format("{0:0.00}", Convert.ToDecimal(txtCard.Text) + Convert.ToDecimal(txtCard1.Text) + Convert.ToDecimal(txtCard2.Text)); txtTotalRTGS.Text = string.Format("{0:0.00}", Convert.ToDecimal(txtRTGS.Text) + Convert.ToDecimal(txtRTGS1.Text) + Convert.ToDecimal(txtRTGs2.Text)); txtTotalAmt.Text = string.Format("{0:0.00}", Convert.ToDecimal(txtTotalCash.Text) + Convert.ToDecimal(txtTotalCheque.Text) + Convert.ToDecimal(txtTotalCard.Text) + Convert.ToDecimal(txtTotalRTGS.Text)); // Insurance Claim Approval Amount txtCashInsurance.Text = string.Format("{0:0.00}", consume.GetInsuranceCashClaimDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text))); txtChequeInsurance.Text = string.Format("{0:0.00}", consume.GetInsuranceChequeClaimDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text))); txtCardInsurance.Text = string.Format("{0:0.00}", consume.GetInsuranceCardClaimDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text))); txtRTGSInsurance.Text = string.Format("{0:0.00}", consume.GetInsuranceRTGSClaimDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text))); txtInsuranceTotal.Text = string.Format("{0:0.00}", Convert.ToDecimal(txtCashInsurance.Text) + Convert.ToDecimal(txtChequeInsurance.Text) + Convert.ToDecimal(txtCardInsurance.Text) + Convert.ToDecimal(txtRTGSInsurance.Text)); // Company Claim Approval Amount txtCashCompany.Text = string.Format("{0:0.00}", consume.GetCompanyCashClaimDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text))); txtChequeCompany.Text = string.Format("{0:0.00}", consume.GetCompanyChequeClaimDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text))); txtCardCompany.Text = string.Format("{0:0.00}", consume.GetCompanyCardClaimDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text))); txtRTGSCompany.Text = string.Format("{0:0.00}", consume.GetCompanyRTGSClaimDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text))); txtCompanyTotal.Text = string.Format("{0:0.00}", Convert.ToDecimal(txtCashCompany.Text) + Convert.ToDecimal(txtChequeCompany.Text) + Convert.ToDecimal(txtCardCompany.Text) + Convert.ToDecimal(txtRTGSCompany.Text)); //} } catch (Exception ex) { lblMessage.Text = ex.Message; } }
private void SelectBedConsumtion() { try { BedConsumtionBLL consume = new BedConsumtionBLL(); if (ddlServices.SelectedIndex == 0 && ddlEmployee.SelectedIndex == 0) { List <STP_ServiceswiseReportAllResult> lst = consume.NewAllServices(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)); if (lst != null) { lbl.Text = "New Services Datewise Report"; lblFrom.Text = txtBillDate.Text; lblTo.Text = txtToDate.Text; DataTable dt = ListConverter.ToDataTable(lst); dt.Columns.Add("colSrNo"); DataColumn dcol = new DataColumn(); if (dt.Rows.Count > 0) { int count = 1; foreach (DataRow dr in dt.Rows) { dr["colSrNo"] = count; count++; } } dgvTestParameter.DataSource = dt; dgvTestParameter.DataBind(); Session["BedConsump"] = dt; lblamount.Visible = true; txtamount.Visible = true; decimal amt = 0; foreach (GridViewRow item in dgvTestParameter.Rows) { if (item.Cells[7].Text == " ") { item.Cells[7].Text = Convert.ToString(0); amt = amt + Convert.ToDecimal(item.Cells[7].Text); } else { amt = amt + Convert.ToDecimal(item.Cells[7].Text); } } txtamount.Text = Convert.ToString(amt); //txtBillDate.Text = string.Empty; //txtToDate.Text = string.Empty; } } if (ddlEmployee.SelectedIndex == 0 && ddlServices.SelectedIndex != 0) { List <STP_ServiceswiseReportResult> lst = consume.SearchServicewiseReport(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text), Convert.ToString(ddlServices.SelectedItem.Text)); if (lst != null) { lbl.Text = "New Serviceswise Report"; lblFrom.Text = txtBillDate.Text; lblTo.Text = txtToDate.Text; DataTable dt = ListConverter.ToDataTable(lst); dt.Columns.Add("colSrNo"); DataColumn dcol = new DataColumn(); if (dt.Rows.Count > 0) { int count = 1; foreach (DataRow dr in dt.Rows) { dr["colSrNo"] = count; count++; } } dgvTestParameter.DataSource = dt; dgvTestParameter.DataBind(); Session["BedConsump"] = dt; lblamount.Visible = true; txtamount.Visible = true; decimal amt = 0; foreach (GridViewRow item in dgvTestParameter.Rows) { if (item.Cells[7].Text == " ") { item.Cells[7].Text = Convert.ToString(0); amt = amt + Convert.ToDecimal(item.Cells[7].Text); } else { amt = amt + Convert.ToDecimal(item.Cells[7].Text); } } txtamount.Text = Convert.ToString(amt); //txtBillDate.Text = string.Empty; //txtToDate.Text = string.Empty; } } if (ddlEmployee.SelectedIndex != 0 && ddlServices.SelectedIndex == 0) { List <STP_ServiceswiseReportUserResult> lst = consume.SearchServicewiseReportUser(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text), Convert.ToString(ddlEmployee.SelectedItem.Text)); if (lst != null) { lbl.Text = "New Services Userwise Report"; lblFrom.Text = txtBillDate.Text; lblTo.Text = txtToDate.Text; DataTable dt = ListConverter.ToDataTable(lst); dt.Columns.Add("colSrNo"); DataColumn dcol = new DataColumn(); if (dt.Rows.Count > 0) { int count = 1; foreach (DataRow dr in dt.Rows) { dr["colSrNo"] = count; count++; } } dgvTestParameter.DataSource = dt; dgvTestParameter.DataBind(); Session["BedConsump"] = dt; lblamount.Visible = true; txtamount.Visible = true; decimal amt = 0; foreach (GridViewRow item in dgvTestParameter.Rows) { if (item.Cells[7].Text == " ") { item.Cells[7].Text = Convert.ToString(0); amt = amt + Convert.ToDecimal(item.Cells[7].Text); } else { amt = amt + Convert.ToDecimal(item.Cells[7].Text); } } txtamount.Text = Convert.ToString(amt); //txtBillDate.Text = string.Empty; //txtToDate.Text = string.Empty; } } if (ddlEmployee.SelectedIndex != 0 && ddlServices.SelectedIndex != 0) { List <STP_ServiceswiseReportUserSerResult> lst = consume.SearchServicewiseReportUserSer(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text), Convert.ToString(ddlEmployee.SelectedItem.Text), Convert.ToString(ddlServices.SelectedItem.Text)); if (lst != null) { lbl.Text = "New Services Userwise Report"; lblFrom.Text = txtBillDate.Text; lblTo.Text = txtToDate.Text; DataTable dt = ListConverter.ToDataTable(lst); dt.Columns.Add("colSrNo"); DataColumn dcol = new DataColumn(); if (dt.Rows.Count > 0) { int count = 1; foreach (DataRow dr in dt.Rows) { dr["colSrNo"] = count; count++; } } dgvTestParameter.DataSource = dt; dgvTestParameter.DataBind(); Session["BedConsump"] = dt; lblamount.Visible = true; txtamount.Visible = true; decimal amt = 0; foreach (GridViewRow item in dgvTestParameter.Rows) { if (item.Cells[7].Text == " ") { item.Cells[7].Text = Convert.ToString(0); amt = amt + Convert.ToDecimal(item.Cells[7].Text); } else { amt = amt + Convert.ToDecimal(item.Cells[7].Text); } } txtamount.Text = Convert.ToString(amt); //txtBillDate.Text = string.Empty; //txtToDate.Text = string.Empty; } } } catch (Exception ex) { lblMessage.Text = ex.Message; } }
private void SelectBedConsumtion() { try { BedConsumtionBLL consume = new BedConsumtionBLL(); if (ddlDepartment.SelectedIndex == 0) { List <STP_DailyNursingChartResult> lst = consume.SearchDailyChart(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)); if (lst != null) { lbl.Text = "Daily Nursing Chart Report"; lblFrom.Text = txtBillDate.Text; lblTo.Text = txtToDate.Text; DataTable dt = ListConverter.ToDataTable(lst); dt.Columns.Add("colSrNo"); DataColumn dcol = new DataColumn(); if (dt.Rows.Count > 0) { int count = 1; foreach (DataRow dr in dt.Rows) { dr["colSrNo"] = count; count++; } } dgvTestParameter.DataSource = dt; dgvTestParameter.DataBind(); Session["BedConsump"] = dt; //txtBillDate.Text = string.Empty; //txtToDate.Text = string.Empty; } } else { List <STP_DailyDepartmentwiseNursingChartResult> lst = consume.SearchDepartmentwiseDailyChart(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text), Convert.ToString(ddlDepartment.SelectedItem.Text)); if (lst != null) { lbl.Text = "Daily Nursing Chart Report"; lblFrom.Text = txtBillDate.Text; lblTo.Text = txtToDate.Text; DataTable dt = ListConverter.ToDataTable(lst); dt.Columns.Add("colSrNo"); DataColumn dcol = new DataColumn(); if (dt.Rows.Count > 0) { int count = 1; foreach (DataRow dr in dt.Rows) { dr["colSrNo"] = count; count++; } } dgvTestParameter.DataSource = dt; dgvTestParameter.DataBind(); Session["BedConsump"] = dt; //txtBillDate.Text = string.Empty; //txtToDate.Text = string.Empty; } } } catch (Exception ex) { lblMessage.Text = ex.Message; } }
private void SelectBedConsumtion() { try { BedConsumtionBLL consume = new BedConsumtionBLL(); if (ddlDeptCategory.SelectedIndex != 0 && ddlDeptDoctor.SelectedIndex == 0 && ddlPatientType.SelectedIndex == 0) { List <STP_DeptCategorywisePatientDetailsResult> lst = consume.DeptCategorywisePatientDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text), Convert.ToInt32(ddlDeptCategory.SelectedValue)); if (lst != null) { lbl.Text = "Patient Details Report"; lblFrom.Text = txtBillDate.Text; lblTo.Text = txtToDate.Text; DataTable dt = ListConverter.ToDataTable(lst); dt.Columns.Add("colSrNo"); DataColumn dcol = new DataColumn(); if (dt.Rows.Count > 0) { int count = 1; foreach (DataRow dr in dt.Rows) { dr["colSrNo"] = count; count++; } } dgvTestParameter.DataSource = dt; dgvTestParameter.DataBind(); Session["BedConsump"] = dt; } } if (ddlDeptCategory.SelectedIndex != 0 && ddlDeptDoctor.SelectedIndex != 0 && ddlPatientType.SelectedIndex != 0) { List <STP_DepartmentwisePatientDetailsResult> lst = consume.SearchDepartmentwise(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text), Convert.ToInt32(ddlDeptCategory.SelectedValue), Convert.ToInt32(ddlDeptDoctor.SelectedValue), Convert.ToString(ddlPatientType.SelectedItem.Text)); if (lst != null) { lbl.Text = "Patient Details Report"; lblFrom.Text = txtBillDate.Text; lblTo.Text = txtToDate.Text; DataTable dt = ListConverter.ToDataTable(lst); dt.Columns.Add("colSrNo"); DataColumn dcol = new DataColumn(); if (dt.Rows.Count > 0) { int count = 1; foreach (DataRow dr in dt.Rows) { dr["colSrNo"] = count; count++; } } dgvTestParameter.DataSource = dt; dgvTestParameter.DataBind(); Session["BedConsump"] = dt; } } if (ddlDeptCategory.SelectedIndex != 0 && ddlDeptDoctor.SelectedIndex != 0 && ddlPatientType.SelectedIndex == 0) { List <STP_DeptCatDoctorwisePatientDetailsResult> lst = consume.DeptCatDoctorwisePatientDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text), Convert.ToInt32(ddlDeptCategory.SelectedValue), Convert.ToInt32(ddlDeptDoctor.SelectedValue)); if (lst != null) { lbl.Text = "Patient Details Report"; lblFrom.Text = txtBillDate.Text; lblTo.Text = txtToDate.Text; DataTable dt = ListConverter.ToDataTable(lst); dt.Columns.Add("colSrNo"); DataColumn dcol = new DataColumn(); if (dt.Rows.Count > 0) { int count = 1; foreach (DataRow dr in dt.Rows) { dr["colSrNo"] = count; count++; } } dgvTestParameter.DataSource = dt; dgvTestParameter.DataBind(); Session["BedConsump"] = dt; } } if (ddlPatientType.SelectedIndex != 0 && ddlDeptCategory.SelectedIndex == 0) { List <STP_PatientTypewisePatientDetailsResult> lst = consume.SearchDepartmentwise(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text), Convert.ToString(ddlPatientType.SelectedItem.Text)); if (lst != null) { lbl.Text = "Departmentwise Patient Details Report"; lblFrom.Text = txtBillDate.Text; lblTo.Text = txtToDate.Text; DataTable dt = ListConverter.ToDataTable(lst); dt.Columns.Add("colSrNo"); DataColumn dcol = new DataColumn(); if (dt.Rows.Count > 0) { int count = 1; foreach (DataRow dr in dt.Rows) { dr["colSrNo"] = count; count++; } } dgvTestParameter.DataSource = dt; dgvTestParameter.DataBind(); Session["BedConsump"] = dt; } } if (ddlWardCategory.SelectedIndex != 0 && ddlDeptCategory.SelectedIndex == 0 && ddlDeptDoctor.SelectedIndex <= 0 && ddlPatientType.SelectedIndex == 0) { List <STP_WardwisePatientDetailsResult> lst = consume.SearchWardwise(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text), Convert.ToString(ddlWardCategory.SelectedItem.Text)); if (lst != null) { lbl.Text = " Ward Category Wise Patient Details Report"; lblFrom.Text = txtBillDate.Text; lblTo.Text = txtToDate.Text; DataTable dt = ListConverter.ToDataTable(lst); dt.Columns.Add("colSrNo"); DataColumn dcol = new DataColumn(); if (dt.Rows.Count > 0) { int count = 1; foreach (DataRow dr in dt.Rows) { dr["colSrNo"] = count; count++; } } dgvTestParameter.DataSource = dt; dgvTestParameter.DataBind(); Session["BedConsump"] = dt; } } } catch (Exception ex) { lblMessage.Text = ex.Message; } }