public static void a_Procedure1()
    {
   SqlConnection cn = new SqlConnection("context connection=true");
        SqlCommand cmd1 = new SqlCommand("Select Item, sName As FirstName From sprdoc", cn);
        SqlCommand cmd2 = new SqlCommand("Select Item, sName As FirstName From sprfin", cn);
        cmd1.CommandType = CommandType.Text;
            cn.Open();
            SqlDataReader rdr = cmd1.ExecuteReader();
            SqlDataReader rdr1 = cmd2.ExecuteReader();
 
            rdr.Close();
            rdr1.Close();

    }