Advertisement
Guest User

Untitled

a guest
Sep 1st, 2014
164
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.22 KB | None | 0 0
  1. dataGridView1.DataSource = bindingSource1;
  2.  
  3. Describing JKSBSCHEMA.AUTOPAYMENT_VIEW....
  4.  
  5. NAME Null? Type
  6. ------------------------------- --------- -----
  7. ISPAY NUMBER
  8. BANKACCOUNTID NOT NULL CHAR(5)
  9. ACCOUNTID NOT NULL CHAR(15)
  10. ACCOUNTNAME VARCHAR2(75)
  11. PAYINSTRUCTIONLINE1 VARCHAR2(100)
  12. PAYINSTRUCTIONLINE2 VARCHAR2(100)
  13. ADDITIONAL_PAY_INSTRUCTION VARCHAR2(151)
  14. CLIENTBANKID CHAR(8)
  15. CLIENTBANKACCOUNTNO VARCHAR2(18)
  16. SWIFTCODE VARCHAR2(20)
  17. XSACTDATE NOT NULL DATE
  18. PMODEID NOT NULL CHAR(1)
  19. NORMALPAYABLE NUMBER(12,2)
  20. SOPAYABLE NUMBER(12,2)
  21. FINALPAYABLE NOT NULL NUMBER(12,2)
  22. REFNO NUMBER(*,0)
  23. CONTRACT_VALUE NUMBER
  24. SETTLEMENTCTRLID CHAR(2)
  25. SOQTY NUMBER(12,0)
  26. IS_PLEDGE_GROUP NUMBER
  27. EQUITYID CHAR(9)
  28. COURT_CASE_STATUS NUMBER(1,0)
  29.  
  30. private void loadPaymentData()
  31. {
  32. dataGridView1.AutoGenerateColumns = false;
  33.  
  34. if (dataGridView1.CurrentSelectedRow != null)
  35. {
  36. lastRowPosition = dataGridView1.CurrentSelectedRow.Index;
  37. }
  38.  
  39. try
  40. {
  41. Init(null);
  42.  
  43.  
  44. Thread.CurrentThread.CurrentCulture = CultureInfo.GetCultureInfo("en-US");
  45.  
  46. oDsBank = ExecuteDataSet("SELECT * FROM JKSBSCHEMA.BANKACCOUNT WHERE BANKACCOUNTNO IS NOT NULL", CommandType.Text, null);
  47. bindingSource3.DataSource = oDsBank;
  48. bindingSource3.DataMember = oDsBank.Tables[0].TableName;
  49.  
  50. oDsPmode = ExecuteDataSet("SELECT * FROM JKSBSCHEMA.PMODE", CommandType.Text, null);
  51. bindingSource2.DataSource = oDsPmode;
  52. bindingSource2.DataMember = oDsPmode.Tables[0].TableName;
  53.  
  54. oDs = ExecuteDataSet("SELECT * FROM JKSBSCHEMA.AUTOPAYMENT_VIEW", CommandType.Text, null);
  55.  
  56. try
  57. {
  58. dSettleDate = Convert.ToDateTime(oDs.Tables[0].Rows[0]["XSACTDATE"].ToString());
  59. label3.Text = string.Format("Data for Settlement Date {0}", dSettleDate.ToString("dd-MMM-yyyy"));
  60. this.Text = string.Format("Data for Settlement Date {0}; {1} Records Loaded", dSettleDate.ToString("dd-MMM-yyyy"), oDs.Tables[0].Rows.Count.ToString());
  61. }
  62. catch (Exception)
  63. {
  64. label3.Text = "Error Occured while loading data";
  65. }
  66.  
  67. bindingSource1.DataSource = oDs;
  68. bindingSource1.DataMember = oDs.Tables[0].TableName;
  69.  
  70. PMODEID.DataSource = oDsPmode.Tables[0];
  71. PMODEID.ValueMember = "PMODEID";
  72. PMODEID.DisplayMember = "PMODEDESC";
  73.  
  74. BANKACCOUNTID.DataSource = oDsBank.Tables[0];
  75. BANKACCOUNTID.ValueMember = "BANKACCOUNTID";
  76. BANKACCOUNTID.DisplayMember = "BANKACCOUNTNAME";
  77.  
  78. dataGridView1.DataSource = bindingSource1; //Error here
  79.  
  80. updateStat();
  81.  
  82. label1.Text = string.Format("No. of Records to be processed {0}", oDs.Tables[0].Rows.Count.ToString("N0"));
  83.  
  84. dataGridView1.Sort(dataGridView1.Columns["ACCOUNTID"], ListSortDirection.Ascending);
  85.  
  86. if ((lastRowPosition > 0) && (dataGridView1.Rows.Count > lastRowPosition))
  87. {
  88. try
  89. {
  90. dataGridView1.CurrentCell = dataGridView1.Rows[lastRowPosition].Cells[0];
  91. }
  92. catch (Exception)
  93. {
  94. dataGridView1.CurrentCell = dataGridView1.Rows[0].Cells[0];
  95. }
  96. }
  97. }
  98. catch (Exception er)
  99. {
  100. throw er;
  101. }
  102. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement