The OP has really cheered up my day. Finally post that literally doesn't have a question, or even an attempt at one. Not even an "itz urgentz plz help" plea. Almost zen-like in depth-through-simplicity.
I have no idea how you can integrate it with your forms. You cannot use Process.Start to integrate any form with you custom form. Try to find any Library control like OCX control so that they can be integrated with your forms. But try this one [^]. I hope this will help you.
hi can you help me about my problem regarding this C# program. I try to update but this error always show. what is the meaning of Syntax error in UPDATE statement: ? thank you so much. your reply will highly appreciated.
As Richard says, without your actual code and the UPDATE command istelf, we can't tell you exactly what the problem is.
An SQL update statement is similar to this:
UPDATE <table_name> SET <field>=<new value>,<field... WHERE <field>=<value>
So an example would be:
UPDATE myTable SET UserName='kruczynski123'WHERE UserID=9738136
So, check you have each section of it, or very similar, and check you have quotes where you need them. If you are using C# (and I assume you are) then try using Parametrized queries - they may help you (and you should use them anyway to prevent an SQL Injection attack accidentally of deliberately destroying your database). This may help:
using (SqlConnection con = new SqlConnection(strConnect))
using (SqlCommand com = new SqlCommand("UPDATE myTable SET myColumn1=@C1, myColumn2=@C2 WHERE Id=@ID", con))
The universe is composed of electrons, neutrons, protons and......morons. (ThePhantomUpvoter)