You may generate html document from the same database, and run javascript for printing this page, this page may blink for a while and also write close window command in javascript. May this help. Happy Programming.

Store your connection string in the application settings and set all connection objects to the application setting To store an app setting: Right click your project > properties > settings > add your connection string Alexei Rodriguez

Thank you all for replying. It was a great help to try diffrent methods. John,

Hy, I just wanted VB.Net program or formula that do the same job as the Excel one. That's all. I couldn't read well the Excel formula & I need to use i in VB.Net. J ,

Hy , At uni it is wireless connection and at home the connection is wired !! I mentioned that befor in the first messaged i posted ! Thx for the help Andy . J ,

John Kh wrote: Check if the file exist and the copy it to another directory on a button click You could do something like that... that would be the easiest. Only thing is, you will need to make sure that the backup copy works. So restore the database back to original location and check that it actually has been copied over correctly.

It depends on the programming language you're using (we have C++, C#, VBand even Java forums). You may also as the SQL/ADO/ADO.NET forum if you feel the problem springing from the database. :) If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile. This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke

hi, first up all check the size of u r fields and then insert the data in that range.dont insert any record out off that limit. Try insert syntax as: insert into "insert into CA values('"+textbox1.text+"',...............................) ; bye bye purushottam

Possibly post in a more relavent thread, describing exactly WHAT errors it gives (C# Thread, VB.NET Thread, etc) - Or (MAYBE) here, if you upload the code (Try http://tinyupload.com[^]) :) - Reelix