C# ASP.NET Class - problém s funkčností třídy

using System.Web;

Kdepak, stále to samé

Classes you add will not have any connection to the HttpContext, i.e they will not have access to things like Request, Response, Session and Server.
If the method is called when a request is in progress, you will be able to access Server using

HttpContext.Current.Server

A better approach though is that you add the target folder as a method argument and create the path from that. That way, the class will be usable in non-web contexts as well.
public void CreateFile(string[] PR,string targetfolder)

1

nahradil jsem to tímto:

String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + (HttpContext.Current.Server.MapPath ("data.xls")) + ";Extended Properties=\"Excel 8.0;HDR=No\"";
            OleDbConnection objConn = new OleDbConnection(sConnectionString);

...a stále nefunguje, tohle hází chybu cannot be used like a method...

A musíš tu cestu zjišťovat přes Server.MapPath?

pokud nechám jen data.xls ta to sice projde, ale ten soubor to nenajde i když je přímo u projektu

A proč jsi to dal celé do závorky?

i bez závorky to nejde, chová se to i bez ní stejně...

Jakou chybu to přesně hlásí?

Tak ted to nechápu, ale něco jsem omylem smáznul a začlo to makat... Zde je funkční kód:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.OleDb;
using System.Data;
using System.Web;

namespace Objekt
{
    public class test
    {
        public static string getText()
        {
            /* String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("data.xls") + ";Extended Properties=\"Excel 8.0;HDR=No\"";
            OleDbConnection objConn = new OleDbConnection(sConnectionString); */
            String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + (HttpContext.Current.Server.MapPath ("data.xls")) + ";Extended Properties=\"Excel 8.0;HDR=No\"";
            OleDbConnection objConn = new OleDbConnection(sConnectionString);

            objConn.Open();

            OleDbCommand objCmdSelect = new OleDbCommand("SELECT * FROM [List1$B2:B2]", objConn);
            object nazev = objCmdSelect.ExecuteScalar();
            return nazev.ToString();

            objConn.Close();
        }
    }
           
}