Connect and Retrieve data from sql server database

Question

I am trying to connect and retrieve data from my local sql server taking the searchable data from a textbox. Can somebody give me an example of code that I can achieve these? I read that in order to do  this connection, I have  to use either the ADO.NET or LINQ of ADO.NET... To be honest I didn't understand their differences.


I would appreaciate if anyone could help me.

Thanks in advanced.

Answer 1

There's a couple of ways you can do it. You can create a panel containing all the controls you want for the advanced mode, and set it to be not visible by default. Now the button you press can alter the visibility of that panel. If you place all of the controls in a Panel called panel1, add this line to your button click event: this.panel1.Visible = !this.panel1.Visible; Add anything else to modify the text of the button if you wish. Another way to do it might be to create two different forms, but have one be the advanced, and the other the basic. There might be a good way to do that using inheritance, but having never done that myself, I can't give you too much input on it.

Answer 2

Sorry I don't understand the question??? Could you explain some more?