با سلام
چگونه میشود از storeprocedure هایی که در اس کیو ال داریم در کلاس های زیر که dataaccess و BisnessLayer هستند استفاده کنم؟؟؟؟؟

کلاس dataaccesslayer

using System;using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data;

using System.Data.SqlClient;

using DA;









namespace DA

{

  public   class DataAccessLayers

    {

                  public static string p1;

                  public static string p2;

                  public static string p3;

                  public static bool p4;

                  SqlConnection con;

                  SqlDataAdapter da;

                  DataTable dt;

                  SqlCommand com;









                  public DataAccessLayers()

                  {





                      con = new SqlConnection();

                      da = new SqlDataAdapter();

                      com = new SqlCommand();

                      con.ConnectionString = @"Data Source='" + p1 + "';User Id ='" + p2 + "';Password='" + p3 + "';Database=SaveInfoStudent;Integrated Security=False";

                  }





                  public void connect()

                  {

                     

                      con.Open();

                  }





                  public void disconnect()

                  {

                      con.Close();

                  

                  }





                  public DataTable Select(string sql)

                  {





                      com.CommandText = sql;

                      DataTable dt = new DataTable();

                      da.Fill(dt);

                      return dt;





                  }





                  public void Docommand()

                  {





                      com.CommandType = CommandType.StoredProcedure;

                     

                      com.ExecuteNonQuery();

                  

                  

                  }

























    }

}


----------------------------------------------------------------------
و کلاس bisness :
---------------------------------------------------------------------
using System;using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data;

using System.Data.SqlClient;

using DA;

using BL;





 namespace BL

{

    public class Student : DataAccessLayers

    {





        public int  ID;

        public string Name;

        public string Lastname;

        public string FatherName;

        public string Tell;

        public string Address;













                public void Add()

                {





                    base.connect();



//اینجا چطور عمل کنم؟؟؟؟؟؟؟؟

                    base.Docommand();

                    

                    base.disconnect();





                }









                public void delete()

                {

                        base.connect();

         

                        base.disconnect();





                }





                public void update()

                { 

                     base.connect();



                }





                public DataTable select()

                {

                    base.connect();











                }

















    }

}