PLEASE help me about asp.net

Please help- me
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class get : System.Web.UI.Page
{

protected void Page_Load(object sender, EventArgs e)
{

if (Session.Count == 0)
Response.Redirect("Default.aspx");
else
{
if
(!IsPostBack)
{
string strconn = "server=.;database=Northwind; user id=sa;pwd=";

PostID= Request["PostID"] ;

}

string strconn = "server=.;database=Northwind; user id=sa;pwd=";

SqlConnection myConnection = new SqlConnection();
myConnection.ConnectionString = strconn;
BindData();
}
}

private void BindData()
{

string selCmd1 = "select * from Ex09_GuestBook where PostID="+PostID;

SqlDataAdapter da1=new SqlDataAdapter(selCmd1,myConnection);

string selCmd2 = "select * from Ex09_GuestBook where ParentID= " + PostID;
SqlDataAdapter da2=new SqlDataAdapter(selCmd2,myConnection);
DataSet ds=new DataSet();
da1.Fill(ds,"host");
da2.Fill(ds,"guest");
Label1.Text=ds.Tables["host"].Rows[0][4].ToString();
int reCount=ds.Tables["guest"].Rows.Count;
Label2.Text=reCount.ToString();
Label3.Text=ds.Tables["host"].Rows[0][2].ToString();
Label4.Text=ds.Tables["host"].Rows[0][5].ToString();
HyperLink1.Text=ds.Tables["host"].Rows[0][3].ToString();
HyperLink1.NavigateUrl="userInfo.aspx?UserName="+HyperLink1.Text;
DataList1.DataSource=ds;
DataList1.DataMember="guest";
DataList1.DataBind();
this.DataBind();
myConnection.Close();
}

protected void Button3_Click(object sender, EventArgs e)
{
string strconn = "server=.;database=Northwind; user id=sa;pwd=";
string Name = Session["username"].ToString();
string insCmd = "insert Ex09_GuestBook values(" + PostID + ",getdate(),'" + Name + "','','" + TextBox1.Text + "')";
SqlConnection myConnection = new SqlConnection();
myConnection.ConnectionString = strconn;



SqlCommand myCmd = new SqlCommand(insCmd, myConnection);
myCmd.Connection.Open();
myCmd.ExecuteNonQuery();
myCmd.Connection.Close();
myConnection.Close();
BindData();
TextBox1.Text = "";

}
protected void Button4_Click(object sender, EventArgs e)
{
TextBox1.Text = "";
}

}
I do not know why it alawys occur this

error

CS0103: there is no"PostID"

行 35:
行 36:
行 37: PostID= Request["PostID"] ;
行 38:
行 39:

You a reading the value fromRequest["PostID"] which is null where you have set the value and also check for null

like

if( Request["PostID"] != null )
PostID= Request["PostID"] ;

Please Assist! Installation Issue - Updated Info

I have updated this - I really need help! If you read this before, see the
bottom for additional info.
--
Due to configuration changes, I had to uninstall RS (which was running just
fine).
Now I cannot reinstall it.
I have a test server that is a domain controller.
It is running Windows Server 2003 Enterprise.
Running SQL Server 2000 Enterprise with SP3a and hotfix 859.
I have not been able to put it back on - its really strange - I get the
dialog box that says it successfully installed the SQL Server Reporting
Services Setup Support Files. When I click the Next button nothing happens.
If I reboot the machine and log back in as Administrator, I get the Error
Report dialog:
SQL Server Setup encountered an error and needed to close.
Of course, I choose "Send" to send the error report. In the event viewer, it
has this:
Faulting application SETUP.EXE, version 2000.80.743.0, faulting module
sqlspars.dll, version 2000.80.743.0, fault address 0x00059cf8.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
--
Now it occurred to me that it appears to be dying when it is supposed to go
to the "System Check" dialog.
I have tried to generate a setup log using /l*v setup.log to no avail - as
no log is ever generated.
Can anyone shed any light on this? I would be happy to allow a remote
desktop connection - just send me an email to
Chris.Conner@.REMOVETHISgisinfosystems.comRun the command line setup with the silent option.
I remember this from a previous post..
Jeff
"Christopher Conner" <someone@.someplace.com> wrote in message
news:#8V9WzrsEHA.3532@.TK2MSFTNGP15.phx.gbl...
> I have updated this - I really need help! If you read this before, see the
> bottom for additional info.
> --
> Due to configuration changes, I had to uninstall RS (which was running
just
> fine).
> Now I cannot reinstall it.
> I have a test server that is a domain controller.
> It is running Windows Server 2003 Enterprise.
> Running SQL Server 2000 Enterprise with SP3a and hotfix 859.
> I have not been able to put it back on - its really strange - I get the
> dialog box that says it successfully installed the SQL Server Reporting
> Services Setup Support Files. When I click the Next button nothing
happens.
> If I reboot the machine and log back in as Administrator, I get the Error
> Report dialog:
> SQL Server Setup encountered an error and needed to close.
> Of course, I choose "Send" to send the error report. In the event viewer,
it
> has this:
> Faulting application SETUP.EXE, version 2000.80.743.0, faulting module
> sqlspars.dll, version 2000.80.743.0, fault address 0x00059cf8.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> --
> Now it occurred to me that it appears to be dying when it is supposed to
go
> to the "System Check" dialog.
> I have tried to generate a setup log using /l*v setup.log to no avail - as
> no log is ever generated.
> Can anyone shed any light on this? I would be happy to allow a remote
> desktop connection - just send me an email to
> Chris.Conner@.REMOVETHISgisinfosystems.com
>|||How is it that the silent switch is going to allow me to install RS on the
machine?
I have tried /qn, /qb, /qr with no avail.
=-Chris
"Jeff Dillon" <jeff@.removeemergencyreporting.com> wrote in message
news:#BiLrOwsEHA.3200@.TK2MSFTNGP14.phx.gbl...
> Run the command line setup with the silent option.
> I remember this from a previous post..
> Jeff
> "Christopher Conner" <someone@.someplace.com> wrote in message
> news:#8V9WzrsEHA.3532@.TK2MSFTNGP15.phx.gbl...
> > I have updated this - I really need help! If you read this before, see
the
> > bottom for additional info.
> > --
> >
> > Due to configuration changes, I had to uninstall RS (which was running
> just
> > fine).
> > Now I cannot reinstall it.
> >
> > I have a test server that is a domain controller.
> > It is running Windows Server 2003 Enterprise.
> > Running SQL Server 2000 Enterprise with SP3a and hotfix 859.
> >
> > I have not been able to put it back on - its really strange - I get the
> > dialog box that says it successfully installed the SQL Server Reporting
> > Services Setup Support Files. When I click the Next button nothing
> happens.
> >
> > If I reboot the machine and log back in as Administrator, I get the
Error
> > Report dialog:
> >
> > SQL Server Setup encountered an error and needed to close.
> >
> > Of course, I choose "Send" to send the error report. In the event
viewer,
> it
> > has this:
> >
> > Faulting application SETUP.EXE, version 2000.80.743.0, faulting module
> > sqlspars.dll, version 2000.80.743.0, fault address 0x00059cf8.
> >
> > For more information, see Help and Support Center at
> > http://go.microsoft.com/fwlink/events.asp.
> >
> > --
> > Now it occurred to me that it appears to be dying when it is supposed to
> go
> > to the "System Check" dialog.
> >
> > I have tried to generate a setup log using /l*v setup.log to no avail -
as
> > no log is ever generated.
> >
> > Can anyone shed any light on this? I would be happy to allow a remote
> > desktop connection - just send me an email to
> > Chris.Conner@.REMOVETHISgisinfosystems.com
> >
> >
>|||I believe the silent install circumvents a known bug or something. Search
this group for more info..sorry that's all I have
Jeff
"Christopher Conner" <someone@.someplace.com> wrote in message
news:#2lEolStEHA.312@.TK2MSFTNGP10.phx.gbl...
> How is it that the silent switch is going to allow me to install RS on the
> machine?
> I have tried /qn, /qb, /qr with no avail.
> =-Chris
> "Jeff Dillon" <jeff@.removeemergencyreporting.com> wrote in message
> news:#BiLrOwsEHA.3200@.TK2MSFTNGP14.phx.gbl...
> > Run the command line setup with the silent option.
> >
> > I remember this from a previous post..
> >
> > Jeff
> > "Christopher Conner" <someone@.someplace.com> wrote in message
> > news:#8V9WzrsEHA.3532@.TK2MSFTNGP15.phx.gbl...
> > > I have updated this - I really need help! If you read this before, see
> the
> > > bottom for additional info.
> > > --
> > >
> > > Due to configuration changes, I had to uninstall RS (which was running
> > just
> > > fine).
> > > Now I cannot reinstall it.
> > >
> > > I have a test server that is a domain controller.
> > > It is running Windows Server 2003 Enterprise.
> > > Running SQL Server 2000 Enterprise with SP3a and hotfix 859.
> > >
> > > I have not been able to put it back on - its really strange - I get
the
> > > dialog box that says it successfully installed the SQL Server
Reporting
> > > Services Setup Support Files. When I click the Next button nothing
> > happens.
> > >
> > > If I reboot the machine and log back in as Administrator, I get the
> Error
> > > Report dialog:
> > >
> > > SQL Server Setup encountered an error and needed to close.
> > >
> > > Of course, I choose "Send" to send the error report. In the event
> viewer,
> > it
> > > has this:
> > >
> > > Faulting application SETUP.EXE, version 2000.80.743.0, faulting module
> > > sqlspars.dll, version 2000.80.743.0, fault address 0x00059cf8.
> > >
> > > For more information, see Help and Support Center at
> > > http://go.microsoft.com/fwlink/events.asp.
> > >
> > > --
> > > Now it occurred to me that it appears to be dying when it is supposed
to
> > go
> > > to the "System Check" dialog.
> > >
> > > I have tried to generate a setup log using /l*v setup.log to no
avail -
> as
> > > no log is ever generated.
> > >
> > > Can anyone shed any light on this? I would be happy to allow a remote
> > > desktop connection - just send me an email to
> > > Chris.Conner@.REMOVETHISgisinfosystems.com
> > >
> > >
> >
> >
>|||Hi,
I've tried the silent install and other recommendations (e.g., copying
the CD to a local directory), and I still can't get past the
installation of the support files. Does anyone have any other
suggestions that I might try?
Thanks,
-Melissasql

Please advise cluster configuration

We have datawarehouse servwer with Active/Active cluster.
One node has 8GB Ram and another node has 12GB.
Right now I have configured for both the nodes the Max.Sql Server Memory to
be 8GB.
Both the nodes are running with windows 2003 SP1and SQL Server 2000 SP4 with
the 8 CPU.
Please advise the best configuration for this.
Thanks.
Best practice is that you keep the Hardware configuration of all your
cluster nodes the same.
Assuming that you already have the /PAE switch in your boot.ini file, I
would recommend that you add 4GB ram to the node with only 8GB ram.
"DKRReddy" <dkrreddy@.hotmail.com> wrote in message
news:%23UPSxwbNHHA.4152@.TK2MSFTNGP06.phx.gbl...
> We have datawarehouse servwer with Active/Active cluster.
> One node has 8GB Ram and another node has 12GB.
> Right now I have configured for both the nodes the Max.Sql Server Memory
to
> be 8GB.
> Both the nodes are running with windows 2003 SP1and SQL Server 2000 SP4
with
> the 8 CPU.
> Please advise the best configuration for this.
> Thanks.
>
|||Here, here to Edwin's recommendations.
Moreover, you did not say if this installation was x86 or IA-64.
If the former, you will need to set AWE enabled for the BPool to be able to
address more than 4 GB and you will want to limit each node to only 1/2 (or
slightly less) than available memory.
If the latter, and you are not running with Lock Pages in Memory, then you
could specify the full memory amount on each node, but you might want to
also specify a minimum memory amount as well. The Itanium build is more
aggressive about acquiring the minimum memory setting and will cause the
other instance to give up excess memory more readily.
The reason is that in a multi-instanced configuration, there will be times
when you will need or have to have multiple instances running on a single
node, and you will need available resources for each.
Sincerely,
Anthony Thomas

"Edwin vMierlo" <EdwinvMierlo@.discussions.microsoft.com> wrote in message
news:eyyfUfiNHHA.4720@.TK2MSFTNGP03.phx.gbl...
> Best practice is that you keep the Hardware configuration of all your
> cluster nodes the same.
> Assuming that you already have the /PAE switch in your boot.ini file, I
> would recommend that you add 4GB ram to the node with only 8GB ram.
>
> "DKRReddy" <dkrreddy@.hotmail.com> wrote in message
> news:%23UPSxwbNHHA.4152@.TK2MSFTNGP06.phx.gbl...
> to
> with
>
sql