Question about buttons and Autopostback

[just_the_basix]

Hello,
Can anyone tell me what I am missing???
I declare a variable at the module level. I use this variable over and over throughout the page in various functions, etc. I want to write the value of this variable to a database. Well, evidently by default a button is set to autopostback=true. I can't seem to change that. So when I click on my "save report" button, it reposts the page and writes the variable to the database. The problem is since it reposted the page, the variable is empty. What am I doing wrong?

Thanx in advance

[Smokie]

Show me the code you have where you insert the data into the database... are you using Parameters? ...you should have something like this:

cmdUpdate.Parameters.Add(New OleDbParameter("@NewsTitle", NewsTitle.Text))

NewsTitle.Text should be the value of your variable.

[just_the_basix]

here is my code in a nutshell:

qrystring = "execute my stored procedure"
MyCommand = New SqlCommand(QryString, "my connection")
open connection
MyCommand.ExecuteNonQuery
close connection

Again, it connects and writes to the DB, the variables are just empty.

Thanks in advance.

[Smokie]

so where are you passing the variables into the stored proceedure?