Metodo para DataTable c sharp

[abassi]

Resuelto:

Código:

public class accessdb
{
    public accessdb()
    {
          
    }
    public DataTable conectar(string sqlq)
    {
        OleDbConnection cnn;
        OleDbDataAdapter cmd;
        DataTable dt;
      
        string s;
        s = sqlq;
        cnn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source="
                + HttpContext.Current.Server.MapPath(@"App_Data\expensas.mdb") + ";");
        cmd = new OleDbDataAdapter(s, cnn);
        dt = new DataTable();
        cmd.Fill(dt);
        
        return dt;

    }

}

y

Código:

public partial class usolaclase : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        int n = 0;
        int i = 0;
        decimal total = 0;

        accessdb conecto;
        conecto = new accessdb();
        DataTable dt;
        dt = conecto.conectar("SELECT monto FROM facturas;");

        n = dt.Rows.Count;
        
        for (i = 0; i < n; i++)
        {
            string sTitulo;

            sTitulo = dt.Rows[i]["monto"].ToString();


            total = total + Convert.ToDecimal(sTitulo);
            Label1.Text = total.ToString();
        }
    }
}