How to get data from sql server in asp.net c sharp

Add following namespace  in your cs page
using System.Data.SqlClient;


 string connstring = "Your Connection String Here";
 SqlConnection cn = new SqlConnection(connstring);
 cn.Open()
SqlCommand cmd=new SqlCommand(Youe Query Here, cn);
cmd.Execute();
cn.Close();