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.