SQL Server is a Microsoft product. So is Visual Studio that is used to create C# applications.
In the .cs file, add a using System.Data.SqlClient; statement to have full access to SqlConnection, DataSet, SqlException, SqlDataAdapter, and other SQL Server interface classes.
If you have SPECIFIC questions, PM me.