void depositchk() { try { var da = new SqlDataAdapter(); var ds = new DataSet(); da = new SqlDataAdapter("SELECT Id,cheque from deposit where status = '0'", cn); ds = new DataSet(); da.Fill(ds); GVacct.DataSource = ds; GVacct.DataBind(); GVacct.RowStyle.Height = 150; Label6.Visible = false; Label7.Visible = false; Label8.Visible = false; Label9.Visible = false; Label10.Visible = false; Label11.Visible = false; LblAccountNo.Visible = false; LblClientId.Visible = false; LblDate.Visible = false; LblTime.Visible = false; LblAccountNo.Visible = false; LblStatus.Visible = false; ImageButton2.Visible = false; ImgDelete.Visible = false; ImgUpdate.Visible = false; TxtAmount.Visible = false; } catch { } }
/// <summary> /// //////////////////////////////////// /// </summary> void acountgv() { try { var da = new SqlDataAdapter(); var ds = new DataSet(); da = new SqlDataAdapter("SELECT AccountType.Type AS [Account Type], Account.Account_No AS [Account Number], Account.Bank_Transit_No AS [Transit Number], Account.Amount FROM Account INNER JOIN AccountType ON Account.Account_Type_Id = AccountType.Account_Type_Id where Client_Id = '" + fn + "'", cn); ds = new DataSet(); da.Fill(ds); GVacct.DataSource = ds; GVacct.DataBind(); GVacct.RowStyle.Height = 150; } catch { } }
void depositchk() { try { var da = new SqlDataAdapter(); var ds = new DataSet(); da = new SqlDataAdapter("Select Request_Id AS [Request Id],Client_Id AS [Client ID],Date from CreditRequest where status = '0'", cn); ds = new DataSet(); da.Fill(ds); GVacct.DataSource = ds; GVacct.DataBind(); GVacct.RowStyle.Height = 150; lblCid.Visible = false; LblMS.Visible = false; LblStat.Visible = false; LblAL.Visible = false; Label11.Visible = false; LblClientId.Visible = false; LblMonthlySalary.Visible = false; LblStatus.Visible = false; ImgDelete.Visible = false; ImgUpdate.Visible = false; LblStatus.Visible = false; LblEmail.Visible = false; LblFirstName.Visible = false; LblLastName.Visible = false; LblMonthlySalary.Visible = false; LblCN.Visible = false; LblBT.Visible = false; LblAL.Visible = false; Label13.Visible = false; Label14.Visible = false; LblCardNo.Visible = false; LblBankTransit.Visible = false; TxtAmountLimit.Visible = false; LblIssueDate.Visible = false; LblExpieryDate.Visible = false; LblFN.Visible = false; LblEM.Visible = false; LblLN.Visible = false; } catch { } }