Correct VALIDATING event statement for a COMBOBOX

Question

I would like to know what can i do to construct a correct statement using the VALIDATING method for a COMBOBOX. I would like to see an example of a statement. My code below had an error and i dont know how to solve them. "this.cboTipoentrada.Validating += new System.EventHandler (this.perdefocoentrada);" System.EventHandler is wrong. Whats the correct word?

Answer 1

Yes, as per Nitin, you can use SSIS which load the MS Access data to SqlServer.

 

If you are not comfortable with SSIS then create windows service which will run daily basis and do the job. Means everyday it will create an .sql file and then execute the sql file in server.

Answer 2

May be you should look into SQL Server Integration Services (SSIS).

Answer 3

Hi,<br><br> Please go through below thread-<br> http://stackoverflow.com/questions/10577237/ms-access-to-sql-sever-in-c-net