viewenquire.aspx

asp.net技术内幕的书配源码

<!-- #INCLUDE Virtual="~/site/includes/header.aspx" -->

<script language="C#" runat=server>
string  strUsername;
void Page_Load(Object sender , EventArgs e) 
{
   int intEnquiryID;
   string  strConString;
   SqlConnection conJobs;
   SqlCommand cmdSelect;
   SqlDataReader dtrEnquire;
   DateTime dtmEntryDate;

  // get { Enquiry ID
  intEnquiryID = System.Convert.ToInt32(Request.QueryString[ "id" ]);

  // get { Description From Database
  strConString = ConfigurationSettings.AppSettings[ "constring" ];
  conJobs = new SqlConnection( strConString );
  cmdSelect = new SqlCommand( "getEnquiry", conJobs );
  cmdSelect.CommandType = CommandType.StoredProcedure;
  cmdSelect.Parameters.Add( "@id", intEnquiryID );
  conJobs.Open();
    dtrEnquire = cmdSelect.ExecuteReader();
    if ( dtrEnquire.Read() ) {
      lblMessage.Text = dtrEnquire[ "e_message" ].ToString();
      strUsername = dtrEnquire[ "e_from" ].ToString();
      //dtmEntryDate = dtrEnquire[ "e_entrydate" ].ToString();
    }
  conJobs.Close();
  //lblPreamble.Text = string .Format("On {0:f}, {1} wrote", dtmEntryDate, strUsername );
  lnkUsername.Text = string .Format("{0}.aspx", strUsername );
  lnkUsername.NavigateUrl = string .Format("~/{0}.aspx", strUsername );
}
</Script>

<myControls:Header
  PageTitle="View Enquiry"
  Runat="Server" />

<asp:Label
  id="lblPreamble"
  Runat="Server" />
<p>
<asp:Panel
  CssClass="UserContent"
  Runat="Server">
<asp:Label
  ID="lblMessage"
  Runat="Server" />
</asp:Panel>
<p>
To visit the home page of this individual or company, click below:
<blockquote>
<asp:HyperLink
  ID="lnkUsername"
  Runat="Server" />
</blockquote>

<myControls:Footer
  Runat="Server" />