Get all data in a table using store procedure

  public void GetApplicationId()
    {
        SqlConnection con = new SqlConnection(inductionConnectionString);
        SqlCommand cmd = new SqlCommand("select max(ApplicationForm_ID) as ApplicationForm_ID from forms.ApplicationForm", con);
        cmd.Connection = con;
        da = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);
        string id = dt.Rows[0]["ApplicationForm_ID"].ToString();

        SqlCommand cmd1 = new SqlCommand("select * from forms.ApplicationForm where ApplicationForm_ID='" + id + "'", con);

        cmd1.Connection = con;
        da = new SqlDataAdapter(cmd1);
        DataTable dt1 = new DataTable();
        da.Fill(dt1);
        ViewState["Application_ID"] = dt1.Rows[0]["ApplicationRegNo"].ToString();
    }