How to use STORED PROC

//retrieve Data .
using (
                  SqlConnection con =
                      new SqlConnection(ConfigurationManager.ConnectionStrings["testConnectionString"].ConnectionString))
        {


            using (SqlCommand cmd = new SqlCommand("usp_test", con))
            {
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("tst", txt.Text);
                DataTable dt = new DataTable();
                SqlDataAdapter adpt = new SqlDataAdapter(cmd);
                adpt.Fill(dt);
                GridView1.DataSource = dt;
                GridView1.DataBind();
            }
        }

SqlCommand cmd=new SqlCommand("spGetData", con);
//con is your connection object.
SqlDataAdapter sda=new SqlDataAdapte(cmd) ;
DataTable dt=new DataTable();
sda.Fill(dt);
con.Close();
DataGrid1.DataSource=dt;
DataGrid1.DataBind();

          SqlCommand cmd = new SqlCommand("yourstoredprocedure",yourconnection);
          cmd.CommandType = CommandType.StoredProcedure;
          cmd.Parameters.AddWithValue("@rid", Session["cust_id"].ToString());
// you can add more parameters
            SqlDataAdapter adp = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
           dt.Locale = System.Globalization.CultureInfo.InvariantCulture;
            adp.Fill(dt);
            GridView1.DataSource = dt;
            GridView1.DataBind();

protected void Page_Load(object sender, EventArgs e)
{
 
string strSQLconnection = "Data Source=dbServer;Initial Catalog=testDB;Integrated Security=True";
SqlConnection sqlConnection = new SqlConnection(strSQLconnection);
SqlCommand sqlCommand = new SqlCommand("select * from table1", sqlConnection);
sqlConnection.Open();
 
SqlDataReader reader = sqlCommand.ExecuteReader();
       
GridView1.DataSource = reader;
GridView1.DataBind();
}