how to create a unvisible user control?

Question

Hello Maybe someone has a good idea how to solve this problem. In VS i coded a user control. I derived it from the class usercontrol. The user control has no graphical output. My problem now: The user control should work like a timer or a oledbconnection-usercontrol not like a button oder label becaus my user control as it has no graphical output to the user. But if i add a reference my usercontrol i see the control in the toolbox of the Visual-Studio IDE. Now if it pull the the form I see a grey box in the form. How can I arrange the the usercontrol is only visible in the footer like e.g. a timer-usercontrol, a oledbconnetion-usercontrol? For any ideas, I would be very happy. Thank you in advance Geri

Answer 1

this is the provider settings or sqlconnection settings for ms excel once we complete this every this is common like sqlcommand,dataset,dataadapter

sqlconnection con= new sqlconnectio(provider=Microsoft.Jet.OLEDB.4.0;Data Source='Your Filename';Extended Properties=Excel 8.0;)

,but select statement is sytanx is some differ like this way

ample Select sql

sqlcommand cmd  = new sqlcommand("select * from [Sheet1$] where condition",con);

if it satisfies you accept this answer by clicking thumb up symbol

 

Answer 2

Hi chiranjeevi,

This is a simple application i did of your requirements.Run the attachments.


Thanks


If it helps you plz mark the answer as Accepted answer

Answer 3

Also look at the articles in this web site about Excel.