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.

Abhimanyu K Vatsa · Answer

Look at the Sam's Post to learn basics of ADO etc. Read this post it will full-fil your ask. here you will find a working example too. http://www.c-sharpcorner.com/UploadFile/abhikumarvatsa/1605/

Sam Hobbs · Answer

Look at the following. I know that the Forms section is quite large but you will see the abundance of useful material. ADO.NET in C# Windows Forms in C#