I have written the code as below. here problem is that dt remain null. how to solve thst please tell me. public partial class Form1 : Form { private DataTable DTable; private DataRow drow; public Form1() { InitializeComponent(); } private OleDbConnection getConnection() { OleDbConnection con=new OleDbConnection (@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Administrator\My Documents\Visual Studio 2008\Projects\winApp for Student\winApp for Student\App_Data\SchooMgnSystem.mdb;Persist Security Info=True"); return con; } private void button1_Click(object sender, EventArgs e) { InsertData(); } private void InsertData() { if (DTable==null) { DTable = new DataTable(); DTable.Columns.Add("StudID", typeof(string)); DTable.Columns.Add("StudName", typeof (string)); DTable.Columns.Add("Address", typeof(string)); drow = DTable.NewRow(); drow[0] = txtStudID.Text; drow[1] = txtSTudName.Text; drow[2] = txtAddress.Text; DTable.Rows.Add(drow); grdStudent.DataSource = DTable; } else { drow = DTable.NewRow(); drow[0] = txtStudID.Text; drow[1] = txtSTudName.Text; drow[2] = txtAddress.Text; DTable.Rows.Add(drow); grdStudent.DataSource = DTable; } } private void button2_Click(object sender, EventArgs e) { string cmdstr; OleDbCommand cmd; OleDbConnection con = getConnection(); foreach (DataRow Drow in DTable.Rows) { cmdstr = "Insert into Student values('" + drow[0].ToString() + "','" + drow[1].ToString() + "','"+drow [2].ToString()+"')"; cmd = new OleDbCommand(cmdstr,con); try { con.Open(); cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { con.Close(); } } }

2642

after going to service throw to administrator tools service promp are not opening

2274

[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table

2720

hai i got one error i,e http status 404 error what is ds why ds is comming

2582

Hi guys, I have four tables those are emp,dept,eliminate and uneliminate. i wrote small cursor..when i run, it display one error (ORA-01403 nodata found)... The query is: Declare cursor c1 is select e.ename emp_name from emp e,dept d where e.deptno=d.deptno group by deptno; r1 c1%rowtype; test_emp varchar2(200); begin for r1 in c1 loop begin select eliminate_emp into test_emp from eliminate t,uneliminate ut where t.number=ut.number and t.deptno=e.deptno and rownum<1; end; dbms_output.put_line(r1.emp_name); end loop; end; Thanks...

2594

NZE-28868: Peer certificate chain check failed.

2798

hi. i m Anil patel when reconcile 57f4 chalan(subcontraction with out excise)i m facing error like short by material 220 kg. even i have migo all material.

2531

I entered the data in SQL toad version 9.0.1 in English and Arabic language but when i do the query i get the data in Arabic language with (??? question mark) ,please your support.

1647

Account GOLD-100200 not allowed to be defined as reconciliation account Message no. AC309 Diagnosis Account 100200 is defined as a reconciliation account for fixed assets for chart of accounts GOLD and account determination 11000. This is not correct in the circumstances (Accumulated depreciation account for ordinary depr). Keep in mind that the Customizing definition of the given depreciation area also influences the consistency check of the G/L accounts. This is particularly true for the posting settings in the depreciation area, if the accounts are value adjustment (depreciation) accounts. Procedure Change the account definition, or assign a different account. ERROR MESSAGE “Account INT-160600 not allowed to be defined as reconciliation account” . Message No.: AC309 ANALYSIS The above error message occured when saving the configuration changes in “Acquisition from affiliated company” through config transaction AO90. Here’s the configuration path that prompted the error: Path: IMG → Financial Accounting → Asset Accounting → Integration with the General Ledger → Assign G/L Accounts. Transaction Code: AO90 G/L account 160600 is entered in the highlighted “Acquisition from affiliated company” field. Upon saving the configuration change, the above error messageprompted. Do note that g/l account 160600 has been defined as reconciliation account type for asset. Here’s how it is set- up. SYSTEM DIAGNOSIS Account 160600 is defined as a reconciliation account for fixed assets for chart of accounts BPPH and account determination 1000. This is not correct in the circumstances (Clearing acct: Acquisition from affiliated company). Keep in mind that the Customizing defination of the given depreciation area also influences the consistency check of the G/L accounts. This is particularly true for the posting settings in the depreciation area, if the accounts are value adjustment (depreciation) accounts. SOLUTION & PROCEDURE If the g/l account entered is correct change the settings of g/l account 160600. Do not set it as reconciliation account, just leave the reconciliation account type blank. Otherwise, create a new g/l account that will be used as intercompany transfer clearing account. The new g/l account should not be set as reconciliation account. You must be logged in to post a comment. • F Asset accounting account determination natandycanada asked Sep 3, 2009 | Replies (5) Hello I am building the asset accounting account determination. When i enter the GL account for Account determination i get the message: reconciliation account is not allowed!!! (. SAP message AC309 )has anyone come across this message? I checked the depreciation area definition and all should be good. I am on ECC6. Thank you Join this group Popular White Paper On This Topic • 2011 ERP (Enterprise Resources Planning) Comparison Guide 5 Replies 1 Anuj Purwar replied Sep 4, 2009 Hi, Assign a P&L account for depreciation posting. Thanks. _____ 1 natandycanada replied Sep 4, 2009 I do have a P&L account Andy Maoulaoui 0 Ron Roberts replied Sep 4, 2009 Help us ouot with a little more detail. What G/L account are you trying top assign? Depreciation expense? Asset account? Accumulated depreciation account? Gain/loss on disposal P&L account? Other? 1 natandycanada replied Sep 5, 2009 I am assigning an accumulated depreciation account. this account is naturally a reconciliation account. all other accounts can be entered without any error. When i enter the accum depreciation account in depr area 01 (post to legder 0L) the system give the message that reconciliation account is not allowed. when i enter the accum dep account in dep area 02 ( posting to non leading ledger) i dont get the error. Andy Maoulaoui White Papers and Webcasts Popular • The Evolution of ERP and What it Means for Business Related • Gain IT asset visibility, control and automation • SMB Accounting SaaS Comparison Guide • Shifting the B2B Marketing Paradigm from Contacts to People: ... More White Papers 0 Gearoid Pierse replied Dec 4, 2009 Hi everyone - I am getting the same problem when putting in an accumumated depreciation account in the customizing for depreciation area 01, I get *** (message AC309 "Account 1100250 is defined as a reconciliation account for fixed assets for chart of accounts OPER and account determination AD400. This is not correct in the circumstances (Accumulated depreciation account for ordinary depr).Keep in mind that the Customizing definition of the given depreciation area also influences the consistency check of the G/L accounts. This is particularly true for the posting settings in the depreciation area, if the accounts are value adjustment (depreciation) accounts. *** However, I can assign my accumulated depreciation account 1100250 (which has the recon account "A" (assets) setting no problem for depreciation area 20. If I take away the recon account setting in the G/L account I get a different error message

11086

IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

3152

i want a list of top 10 nationalized banks in inda....can some expects help me???

2287

what are the test cases for ticket vending machine?

4272

I'm having trouble with coming up with the correct code. Thank You!! The assignment was to write a program using string functions that accepts a price of an item and displays its coded value. The base of the keys: X C O M P U T E R S 0 1 2 3 4 5 6 7 8 9 Sample I/O Dialogue: Enter Price: 489.50 Coded Value: PRS.UX

2155

IMP-00070: Lob definitions in dump file are inconsistent with database.

1742

dear sir I want singal maintainer(iii& ii) solved question paper in every year in every board in rrb. If you collect these and sent these my mail-id i shall very grateful to you. thanking you your's faithfully soma saha

2407