ASP.NET

Re: ERROR:The test form is only available for requests from the local machine

11-Jul-07 3:44

There you go:

http://support.microsoft.com/kb/819267[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Sebastian T Xavier11-Jul-07 3:55

Sebastian T Xavier

11-Jul-07 3:55

Thank you, I have tried the first method listed here, and that doesn't help me. i receive the same message..
sebastian

Export a table to a csv

Senseicads11-Jul-07 3:10

11-Jul-07 3:10

Can someone tell me if this is possible please. I have created a web based reporting application for my boss and he wants the option to export the tables that get shown to a .csv file. Seems reasonable except I am pretty sure that as it's web based I can only write back to the server...is this true? If not what do I do to save the .csv on his local machine? I was thinking that maybe I can save it on the server then try and open it on via the browser so the standard download attatchment window comes up? is there a set/standard or best practice way of doing this?

Thanks in advance for any help.

Ian

Vasudevan Deepak Kumar11-Jul-07 3:24

http://www.codeproject.com/Purgatory/Exporting_Dataset_ASPNet.asp[^]

11-Jul-07 3:24

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Senseicads11-Jul-07 4:02

11-Jul-07 4:02

So having a quick glance thru that article and the code for it, that just writes a csv string to the browser. I can do that already, I can parse the table to a csv stream no probs. Big Grin | :-D

My question and what I am more interested in knowing about is how I can export a .csv file from the datatable to a file through a button click on the browser...do i have to save the csv on the server? or can i save it straight to a user specified location on the local machine? I was thinking that if it wasn't possible to save to the user's local machine do I save it to the server with a unique name then try and open the file from the server? Is that the best way of doing things? or is there a reccomended best practive for this? Thanks for taking the time to help.

Cheers

Ian

ed^nrgc11-Jul-07 5:29

ed^nrgc

11-Jul-07 5:29

Check into placing the results in a stream.

Senseicads11-Jul-07 5:36

11-Jul-07 5:36

yeah I can do all that I can put the csv file using streamwriter...i just need to know where to put the file that streamwriter creates and how do i access it!

At the moment I am attempting to place the file on the server and then redirect the browser to the file name. This isn't working for me yet however, and I am not sure that this is even the best way to do it. I was asking which is the best way.

Here is my code, so you can see where I am currently coming from, it don't work like but it should give you an idea as to where i am coming from. But don't forget I am enquiring about best practices here, not how to fix this specific bit of code.

  Protected Sub btExport_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btExport.Click<br />
<br />
        Dim datTable As DataTable = gvReport.DataSource<br />
<br />
        ' Create a directory for the file to be stored on the server<br />
        ' Check whether a directory exists in the first place. If not create it.<br />
        If Not Directory.Exists(Server.MapPath("CSV")) Then<br />
            Directory.CreateDirectory(Server.MapPath("CSV"))<br />
        End If<br />
<br />
        ' Create a unique identifier.<br />
        Dim strFileName As String<br />
        strFileName = Server.MapPath("CSV") & "\" & GetTempName()<br />
<br />
        Dim objStreamWriter As StreamWriter<br />
        objStreamWriter = File.AppendText(strFileName)<br />
        ' Code to write the csv file to the writer.<br />
        objStreamWriter.Close()<br />
End Sub

Cheers

Ian

martin_hughes11-Jul-07 8:59

martin_hughes

11-Jul-07 8:59

Here's the way I've seen it done before (no idea if it's best practice - but what the hey! Smile | :)

)

When the user clicks the button, have the database export to a temporary .csv somewhere on the server (that the user will be able to access). Then do a response.redirect as the return of the page postback giving the url of the newly created temporary file. Hey presto, the user should be presented with a file download dialog.

There's bound to be a few gotchas, the one that springs readily to my mind is that you must make sure to purge that temp directory on a frequent basis, or you'll enter a world of pain!

Senseicads12-Jul-07 1:11

how can v write html tags in asp.net +c# code??

12-Jul-07 1:11

Thanks thats the way I have implemented it now. I perform the purge whenever the application start method runs. The Server is shutdown at the end of each working day so it should purge once a day. Its a right bit of a bugger tho. Esp as I haven't been able to figure out as to when the application object is created if the path of the calling webform isn't in the root then it has the potential to create CSV directories allover the shop :-S I am using MapPath to get the Path name and it just picks up the current location. nightmare! Frown | :(

lol I am sure is will come up with something tho Big Grin | :-D

Cheers

For everyone's help esp Martin! Big Grin | :-D

Ian

regin11-Jul-07 2:57

regin

11-Jul-07 2:57

how can v write html tags in asp.net +c# code??

Re: how can v write html tags in asp.net +c# code??

gauthee11-Jul-07 3:07

gauthee

11-Jul-07 3:07

you can write all your html code in a stringbuilder if you want to!

Gautham

Re: how can v write html tags in asp.net +c# code?? [modified]

N a v a n e e t h11-Jul-07 3:07

N a v a n e e t h

11-Jul-07 3:07

Do you mean something like this ? Response.Write("<h1>This is HTML heading tag</h1>")

-- modified at 9:19 Wednesday 11th July, 2007

My Website | Ask smart questions

Re: how can v write html tags in asp.net +c# code??

regin11-Jul-07 3:16

regin

11-Jul-07 3:16

can i write the html tags in defaultpage.aspx.css???

Re: how can v write html tags in asp.net +c# code??

N a v a n e e t h11-Jul-07 3:21

N a v a n e e t h

11-Jul-07 3:21

regimol wrote:
can i write the html tags in defaultpage.aspx.css???

Yes. You can append all your HTML tags in a string and write it to the response. Or put one literal control and assign this string to there

My Website | Ask smart questions

Re: how can v write html tags in asp.net +c# code??

Vasudevan Deepak Kumar11-Jul-07 3:25

11-Jul-07 3:25

regimol wrote:
defaultpage.aspx.css

.CSS indicates Cascading Style Sheet.
.CS indicates CSharp

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Pop Up Window

gauthee11-Jul-07 2:53

gauthee

11-Jul-07 2:53

Hi,

We have our application in two different servers!
Now in our application we have a page with a provison of a link, on clicking this link a new pop window opens! [this normally takes time]

Now, the problem is in one of the server even it is taking time finally you could see the contents of the pop up window.

In the other server the pop window appears with nothing loaded waits for about 10 - 15 seconds and then automatically closes.

What could be the problem, is it related some server configuration?

Gautham

Re: Pop Up Window

Vasudevan Deepak Kumar11-Jul-07 3:46

11-Jul-07 3:46

gauthee wrote:
and then automatically closes.

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Re: Pop Up Window

gauthee11-Jul-07 4:00

gauthee

11-Jul-07 4:00

Was i unclear?

Gautham

CSV Field Issue

Brendan Vogt11-Jul-07 2:31

Brendan Vogt

11-Jul-07 2:31

Hi,

I am uploading from a CSV file. The price comes through as R 100.00. On my local machine it sees it as a decimal 100.00. When I upload the file to the server, it sees it as a string, namely R 100.00. How do I convert this R 100.00 value (which is a string) to a decimal?

And why do the 2 machines see the same field as different types? Where do I go and check for this?

Regards
ma se

Christian Graus11-Jul-07 2:34

Christian Graus

11-Jul-07 2:34

In fact, if it's a CSV file, it IS a bunch of strings, the only possible reason I can think for one machine to refuse to parse it as a number, when your code tries to do that, is regional settings ( some regions would call 100,00 a decimal number )

You need to strip the R if you want to convert to a number.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Brendan Vogt11-Jul-07 2:38

Brendan Vogt

11-Jul-07 2:38

Yeah I also thought the same thing. How do I write a regular expression to remove only the numeric part, irrespective of what else is with the decimal. It can also display as R 100,00 or R100,00 or R 100.00 or R100.0. I am not familiar with regular expressions.

Christian Graus11-Jul-07 2:40

Christian Graus

11-Jul-07 2:40

I recommend you google 'expresso' and download it, it's an awesome tool for writing regular expressions. Off the top of my head ([\d\.,]*) will capture the numeric portion of those strings. Or you could just do replace("R", "") to remove the R, if you know that's all you need to remove.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )