ASP.NET

23-Nov-18 2:37

Are list contents volatile ? e.g I've declared a list

Dim AdminFinalFilename As New List(Of String)

On a button press I pass a string into the list

Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click


        finalfilename = DateTime.Now.ToString("ddMMyyhhmm") + "_" + FileUpload1.FileName
       
            AdminFormFilename.Add(finalfilename)


End Sub

On pressing another button the contents of the list disappear

 Protected Sub FormSubmit_Click(sender As Object, e As EventArgs) Handles FormSubmit.Click


If AdminFinalFilename Is Nothing Then

        Else

            Dim i As Integer
            For i = 0 To AdminFinalFilename.Count - 1

                Dim y As New accessadminreq

                y.InsertAdminUpload(FormID, (AdminFinalFilename.Item(i)))

            Next i

        End If


End Sub

Richard MacCutchan23-Nov-18 2:46

Richard MacCutchan

23-Nov-18 2:46

You are adding items to AdminFormFilename, but listing from AdminFinalFilename?

caffrey_123-Nov-18 3:01

23-Nov-18 3:01

My bad, I posted the wrong paste sorry

Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click


        finalfilename = DateTime.Now.ToString("ddMMyyhhmm") + "_" + FileUpload1.FileName
       
            AdminFinalFilename.Add(finalfilename)


End Sub

Richard Deeming23-Nov-18 3:32

23-Nov-18 3:32

Values stored in fields are not persisted between requests. This is a common misunderstanding of how ASP.NET works.

The browser makes a request. ASP.NET creates a new instance of your page class, and loads any data that was included in the request via the query-string or a form POST. The page then processes the request, and generates a response. The response is sent to the browser, and the instance of your page class is thrown away.

When the browser makes its next request, it's processed by a new instance of your page class, which doesn't carry over any of the field values from the previous instance.

To make data persist between requests, it either needs to be stored in the session, or included in the query-string or form POST data for the next request. The standard approach for data that only relates to a single page is to use view state.

Understanding ASP.NET View State[^]

NB: Judging by the variable names, you've also hit another common misunderstanding about how file uploads work. The FileName property is the path - or sometimes just the name - of the file on the user's computer. It is included for information only. Your code is running on the server, and has no access to that path.

Instead, you need to save the file somewhere on the server, or read the file data from the input stream and process it.

How to: Upload Files with the FileUpload Web Server Control[^]

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

caffrey_123-Nov-18 4:05

23-Nov-18 4:05

Thanks, the file upload works this was some example code - I usually get the path with

Dim path As String = Server.MapPath("~/Uploads/")

and upload with

FileUpload1.PostedFile.SaveAs(path & _
                         finalfilename)

Saves the files fine, I'm just trying to loop through if there is more than one uploaded file and insert them into a database for retrieval later.

What's odd is I just threw together a test with this and it works like I thought it should

Dim mylist As New List(Of String)

Protected Sub Button3_Click(sender As Object, e As EventArgs) Handles Button3.Click
    mylist.Add("button3 clicked")

    Dim i As Integer
    For i = 0 To mylist.Count - 1
        Label4.Text = Label4.Text + (mylist.Item(i)) + "<br>"
    Next i

End Sub

Protected Sub Button4_Click(sender As Object, e As EventArgs) Handles Button4.Click
    mylist.Add("button4 clicked")

    Dim i As Integer
    For i = 0 To mylist.Count - 1
        Label4.Text = Label4.Text + (mylist.Item(i)) + "<br>"
    Next i

End Sub

Richard Deeming23-Nov-18 4:13

23-Nov-18 4:13

caffrey_1 wrote:
it works like I thought it should

I doubt that. Smile | :)

The label's text will be persisted between requests, because it uses view state. When you append the items from the list, you're only appending a single item each time; the previous items were already in there.

If you debug your code and look at the myList field, you'll see it's empty when you click the button.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

caffrey_123-Nov-18 4:45

RDLC Report is not showing Column Headers in all the pages

23-Nov-18 4:45

Your right, I'm having a day Smile | :)

Thanks for the pointer - I think I can get it fixed now

Problem I have I mix between coding in vb and aspx most days!

Thanks

simpledeveloper20-Nov-18 14:30

simpledeveloper

20-Nov-18 14:30

Hi,

I have two reports in my Application, Report A is without Groups in it, and Report B with Groups in it, both are set with Columns Property: Column Headers -> Repeat Header Columns on each Page,

but the Report without Groups is showing column headers on each Page, when Report B with groups is not showing the Column headers on each page. Any help please, I am using ReportViewerForMVC tool for the Report viewing, maybe if it has any impact on it.

Just in case I selected the Row Headers - Report header column on each page too still didn't help.

But any help would be greatly helpful - thanks in advance friends

Re: RDLC Report is not showing Column Headers in all the pages

Richard Deeming21-Nov-18 8:07

Killing a remote application browser session from a new browser session.

21-Nov-18 8:07

This answer on StackOverflow usually works for me:
reporting services - SSRS How to repeat the table header on each page in print preview - Stack Overflow[^]

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

CSV and WordPress

Davstr19-Nov-18 13:23

Davstr

19-Nov-18 13:23

Beginner asking a question before he makes a recommendation to his boss!!!

I have been tasked with fixing a database issue for my company and I need to ensure I am on the right track so I am asking here for confirmation.

Our current process is we use two forms for input into our database.

A registration form on Wordpress and a Facebook leads form

We take the information from there and we input it into Zoho and a Mysql database behind a Wordpress web portal.

The file format we use is CSV. My understanding of CSV is that the data fields have to match the database table. If there is a column mismatch between the file and the database, data will go into the wrong field unless it is processed in some form to move the column in the CSV file. That is my understanding. Am I correct in this?

So, if my above assumption is correct, then it would be logical that the forms used would need to be standardised in order to ensure the data format is standardised. Please let me now if I am on the right track with this. Thanks

Re: CSV and WordPress

Mycroft Holmes20-Nov-18 11:16

Mycroft Holmes

20-Nov-18 11:16

Yes you are on the correct track with this info. If you are importing directly from the CSV then the file format MUST match the database fields. You could write a parser which does the importing for you, this would give you an opportunity to trap crappy data before it hits your DB.

CSV has some gotchas, if it is not well formed, dealing with commas in the data, then you are in big trouble.

"Form" implies a standardised format otherwise it is just free form text.

Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP

Stephen Holdorf18-Nov-18 4:22

Stephen Holdorf

18-Nov-18 4:22

I have to write ASP .NET code that allows for a user to only have one application session active at a time. What the code needs to do is logout an existing user, or session, if the same user logs into the same application in a different browser. In other words the new session should kill the old or existing session. Has anyone done this before? One note is that I am using Windows authentication and not Forms.

modified 18-Nov-18 15:07pm.

Re: Killing a remote application browser session from a new browser session.

Richard Deeming19-Nov-18 3:00