The name 'ID' does not exist in the current context

Hi,

Thank you for your answer.

The ID comes from the following SELECT on a MS SQL SERVER as shown.
It works just right, but I can't access its value outside this part of the code:

<script runat="server">

protected override void OnLoad(EventArgs e) {


int ID = -1;

SqlConnection myConn = new SqlConnection("Data Source=192.168.1.50"; Initial Catalog=mydb; User=123; Password=123");


try
{
myConn.Open();
SqlCommand myCommand = new SqlCommand("SELECT MAX(PostID) from dbo.Posts", myConn);
ID = (int)myCommand.ExecuteScalar();
}
finally
{
if (myConn != null)
 {
   myConn.Close();
  }
}


}

</script>


Warm Regards,
Mário Gamito