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

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/

Answer 2

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#