Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- dataGridView1.DataSource = bindingSource1;
- Describing JKSBSCHEMA.AUTOPAYMENT_VIEW....
- NAME Null? Type
- ------------------------------- --------- -----
- ISPAY NUMBER
- BANKACCOUNTID NOT NULL CHAR(5)
- ACCOUNTID NOT NULL CHAR(15)
- ACCOUNTNAME VARCHAR2(75)
- PAYINSTRUCTIONLINE1 VARCHAR2(100)
- PAYINSTRUCTIONLINE2 VARCHAR2(100)
- ADDITIONAL_PAY_INSTRUCTION VARCHAR2(151)
- CLIENTBANKID CHAR(8)
- CLIENTBANKACCOUNTNO VARCHAR2(18)
- SWIFTCODE VARCHAR2(20)
- XSACTDATE NOT NULL DATE
- PMODEID NOT NULL CHAR(1)
- NORMALPAYABLE NUMBER(12,2)
- SOPAYABLE NUMBER(12,2)
- FINALPAYABLE NOT NULL NUMBER(12,2)
- REFNO NUMBER(*,0)
- CONTRACT_VALUE NUMBER
- SETTLEMENTCTRLID CHAR(2)
- SOQTY NUMBER(12,0)
- IS_PLEDGE_GROUP NUMBER
- EQUITYID CHAR(9)
- COURT_CASE_STATUS NUMBER(1,0)
- private void loadPaymentData()
- {
- dataGridView1.AutoGenerateColumns = false;
- if (dataGridView1.CurrentSelectedRow != null)
- {
- lastRowPosition = dataGridView1.CurrentSelectedRow.Index;
- }
- try
- {
- Init(null);
- Thread.CurrentThread.CurrentCulture = CultureInfo.GetCultureInfo("en-US");
- oDsBank = ExecuteDataSet("SELECT * FROM JKSBSCHEMA.BANKACCOUNT WHERE BANKACCOUNTNO IS NOT NULL", CommandType.Text, null);
- bindingSource3.DataSource = oDsBank;
- bindingSource3.DataMember = oDsBank.Tables[0].TableName;
- oDsPmode = ExecuteDataSet("SELECT * FROM JKSBSCHEMA.PMODE", CommandType.Text, null);
- bindingSource2.DataSource = oDsPmode;
- bindingSource2.DataMember = oDsPmode.Tables[0].TableName;
- oDs = ExecuteDataSet("SELECT * FROM JKSBSCHEMA.AUTOPAYMENT_VIEW", CommandType.Text, null);
- try
- {
- dSettleDate = Convert.ToDateTime(oDs.Tables[0].Rows[0]["XSACTDATE"].ToString());
- label3.Text = string.Format("Data for Settlement Date {0}", dSettleDate.ToString("dd-MMM-yyyy"));
- this.Text = string.Format("Data for Settlement Date {0}; {1} Records Loaded", dSettleDate.ToString("dd-MMM-yyyy"), oDs.Tables[0].Rows.Count.ToString());
- }
- catch (Exception)
- {
- label3.Text = "Error Occured while loading data";
- }
- bindingSource1.DataSource = oDs;
- bindingSource1.DataMember = oDs.Tables[0].TableName;
- PMODEID.DataSource = oDsPmode.Tables[0];
- PMODEID.ValueMember = "PMODEID";
- PMODEID.DisplayMember = "PMODEDESC";
- BANKACCOUNTID.DataSource = oDsBank.Tables[0];
- BANKACCOUNTID.ValueMember = "BANKACCOUNTID";
- BANKACCOUNTID.DisplayMember = "BANKACCOUNTNAME";
- dataGridView1.DataSource = bindingSource1; //Error here
- updateStat();
- label1.Text = string.Format("No. of Records to be processed {0}", oDs.Tables[0].Rows.Count.ToString("N0"));
- dataGridView1.Sort(dataGridView1.Columns["ACCOUNTID"], ListSortDirection.Ascending);
- if ((lastRowPosition > 0) && (dataGridView1.Rows.Count > lastRowPosition))
- {
- try
- {
- dataGridView1.CurrentCell = dataGridView1.Rows[lastRowPosition].Cells[0];
- }
- catch (Exception)
- {
- dataGridView1.CurrentCell = dataGridView1.Rows[0].Cells[0];
- }
- }
- }
- catch (Exception er)
- {
- throw er;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement