set excel database variable to text box for getting values

Question

i have one text box after click on that open textfield box and in that textfield there are one button for open database field. and open one dialog box in that box i have create one combo box and text box for select excel value hoe to select that value and this values/variable set for direct my text box

i want to write query for retrive data and set variable to text box but how??

please help me

than you..

images of my project:

Cassie Mod · Answer

it is actually quite easy use the same query u used on the database to get the values. Now only change te datasource to excel file instead of sql server or access or whatever. maybe you need to perfection your quey [ string excelConnectString = Provider = Microsoft.Jet.OLEDB.4.0; + Data Source =  + excelFileName + ; + Extended Properties = Excel 8.0; ; OleDbConnection objConn = new OleDbConnection ( excelConnectString ); OleDbCommand objCmd = new OleDbCommand ( Select * From [Accounts$]  objConn ); OleDbDataAdapter objDatAdap = new OleDbDataAdapter (); objDatAdap . SelectCommand = objCmd ; DataSet ds = new DataSet (); objDatAdap . Fill ( ds ); fpDataSet_Sheet1 . DataSource = ds ; //fill a grid with data