Need help for writing a code in C# in order to Read from Excel sheet

[Syed Adonis]

Hi,

I have an excel sheet which have multiple tabs in it. Excel sheet contains SQL queries. I need to write a code in C# so that it opens the excel sheet, search for a select Statement and execute the query in sql developer.
I was able to open SQL developer using the following command
System.Digonestics.process.start ("sqldeveloper.exe").

[Arjay]

Not sure what sqldeveloper is. Is it a 3rd party app? Or are you referring to the developer edition of MS Sql? At any rate, you can open an excel file and read the cell data to extract the sql easy enough. If using MS sql dev edition, just use SqlConnection and SqlCommand to execute the sql statement. If SqlDeveloper.exe is a 3rd party app, then how you do it will depend on their interface.