ASP C# WebSite to load a simple CSV File

[gorovdude]

Hi All, I want to have an ASP C# WebSite that loads a simple CSV File and present it in a GridView control (at least for a start). I already have a piece of code that do almost all of the work, what i miss / unable to make it work is setting correctly the "Data Source". The CSV file that I want to load is located on different server in the network (path is "\\td47vc\public\Joe\ASP\Test"). Here is the code I wrote:

public DataSet GetCSVFile(string fileName)
{

    string pathName = "\\\\td47vc\\\\public\\\\Joe\\\\ASP\\\\Test";
    string file = System.IO.Path.GetFileName(fileName);
    OleDbConnection excelConnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + pathName + ";Extended Properties=Text;");
    OleDbCommand excelCommand = new OleDbCommand(@"SELECT \* FROM " + file, excelConnection);
    OleDbDataAdapter excelAdapter = new OleDbDataAdapter(excelCommand);
    excelConnection.Open();
    DataSet ds = new DataSet();
    excelAdapter.Fill(ds);
    excelConnection.Close();
    return ds;
}

I get the following error:

'\\td47vc\public\Joe\ASP\Test' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

Thanks, GorovDude

[Dan Mos]

Well you could try: 0)

@"\\td47vc\public\Joe\ASP\Test";

1. Using the IP of the server instead of the server name (10.xx.xx.xx instead of \\someserver01). Maybe it's on a different VLAN and it does not know it by name 2) If it still doesn't work then it's clearly a matter of credentials/rights. That one only you and/or the admin can fix. :)

I used to think.... Finally I realized it's no good.

modified on Tuesday, December 7, 2010 4:28 AM

[Luc Pattyn]

do you really want double backslashes everywhere? :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, and update CP Vanity to V2.0 if you haven't already.

[Dan Mos]

Nice. I missed it completely. Just focused on the start. Fixed. :)

I used to think.... Finally I realized it's no good.

[Luc Pattyn]

you'll have to try again I'm afraid, if you want a double backslash, either give four, or use '@'; three backslashes is no good. I prefer the '@' approach, as that takes and shows the string as intended. :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, and update CP Vanity to V2.0 if you haven't already.

[Dan Mos]

Yep that's what I did. Just before you fixed my "code" the second time :laugh: I guess I'm better of just fooling around. :)

I used to think.... Finally I realized it's no good.

[Luc Pattyn]

looking great now. :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, and update CP Vanity to V2.0 if you haven't already.

[TweakBird]

See this[^].it might be helpful.

[Alok Sharma ji]

what about setting your connection string in web inf instead of code :)

[gorovdude]

how?

[Muhammad Mazhar]

Try mapping virtual path to physical path using Server object. For example where you are doing

string pathName = "\\td47vc\\public\\Joe\\ASP\\Test";

instead do it something like

string pathName = Server.MapPath("~/Joe/Asp/Test.csv");

Where you need to make sure you are passing correct virtual path to MapPath call. You need to specify it relative to your application root.

I Web Development Free Lancer
Share your experience with others Check my Blog...