having a hard time with things falling out of scope please help

[sparks]

I am building a web ap and have a webform1 an agreement.cs and a files.cs going to an access database
I am not having problems reading or writing to the database but I have hit a snag on how to keep my
variables from falling out of scope to write back to the webform.

in webform1 I am calling a fcn in files.cs to read the values for a certain agreement number and writing
those values to the variables in agreement.cs...this works.
but when I return to the calling fcn in the webform I can no longer write these variables to the text boxes for
display because it has fallen out of scope.
any help would be greatly appreciated.

thanks again
sparks
================
WEBFORM
--
private void contractread_Click(object sender, System.EventArgs e)
{
db.readAgreement(AgreementList.SelectedValue.ToStr ing());
PanelContractInfo.Visible=true;
ContractNumber.Text=agreement.getContractNumber();
ExpDate.Text=agreement.getExpDate();
Status.Text=agreement.getStatus();
Allowed.Text=agreement.getAllowed();
}

================
files.cs
--
public Agreement readAgreement(string ContractNumber)
{
string sCommand = "Select * From tblAgreement Where ContractNumber = " + ContractNumber;
OleDbCommand cmd = new OleDbCommand(sCommand, Connection);
cmd.CommandType = CommandType.Text;
Connection.Open();
OleDbDataReader reader = cmd.ExecuteReader();
if(reader.Read())
{
return new Agreement(
reader.GetValue(0).ToString(),
reader.GetValue(1).ToString(),
reader.GetValue(2).ToString(),
reader.GetValue(3).ToString()
);
}
================
Agreement.cs
public class Agreement
{
private string ContractNumber;
private string ExpDate;
private string Status;
private string Allowed;
}

[Massimo]

"sparks" <jo***@lost.net> ha scritto nel messaggio
news:3s********************************@4ax.com...

================
WEBFORM
--
private void contractread_Click(object sender, System.EventArgs e)
{
db.readAgreement(AgreementList.SelectedValue.ToStr ing());
PanelContractInfo.Visible=true;
ContractNumber.Text=agreement.getContractNumber();
ExpDate.Text=agreement.getExpDate();
Status.Text=agreement.getStatus();
Allowed.Text=agreement.getAllowed();
}

Where are you declaring the "agreement" variable?
And where are you putting the return value from ReadAgreement()?
Shouldn't it be something like "Agreement agreement =
db.readAgreement(...);"?

Massimo

[sparks]

Thank You VERY MUCH...
I would Like to say DOH but I don't even deserve that.

thanks again

sparks

On Sun, 5 Dec 2004 17:39:38 +0100, "Massimo" <ba****@mclink.it> wrote:

"sparks" <jo***@lost.net> ha scritto nel messaggio
news:3s********************************@4ax.com.. .

================
WEBFORM
--
private void contractread_Click(object sender, System.EventArgs e)
{
db.readAgreement(AgreementList.SelectedValue.ToStr ing());
PanelContractInfo.Visible=true;
ContractNumber.Text=agreement.getContractNumber();
ExpDate.Text=agreement.getExpDate();
Status.Text=agreement.getStatus();
Allowed.Text=agreement.getAllowed();
}

Where are you declaring the "agreement" variable?
And where are you putting the return value from ReadAgreement()?
Shouldn't it be something like "Agreement agreement =
db.readAgreement(...);"?

Massimo

[Massimo]

"sparks" <jo***@lost.net> ha scritto nel messaggio
news:s5********************************@4ax.com...

Thank You VERY MUCH...
I would Like to say DOH but I don't even deserve that.

Don't worry, it happens lots of times to anyone :-)

Massimo