12/29/2005

Create Jet database on the fly

Filed under: General — russell @ 1:32 am

I need to create a Jet Database on the fly so I can then run DTS to dump SQL Server data into it. Heres the code to do it after the jump
(more...)


More ASP.Net tricks

Filed under: General — russell @ 1:05 am

The developer.com article had some really nice stuff thanks to Karl Moore. I have clipped parts of the article and these can be found after the jump. For the full articles you can goto:
http://www.developer.com/net/asp/article.php/1594521
(more...)


Changing the title of aspx page in ASP.Net

Filed under: General — russell @ 12:44 am

I have looked for this snippet for quite a while and have used labels and such to mimick this. Developer.com posted a good article on .net tricks. This was one of them:

Three Steps to Changing Your Page Title in Code!
If I asked you to change the title of your Web form, you'd be forgiven for looking for a "title" or "text" property somewhere. The problem is, that mysterious property doesn't exist: Microsoft forgot to put it in. If you want to change your page title programmatically, you have to do it yourself. Here's how.

Firstly, switch to the HTML view on your Web form. Near the top of your page, you'll see the title tag, looking something like

Code:
<title>WebForm1</title>

Replace this with

Code:
<title runat="server" id="PageTitle"></title> 

Here, you're creating a title tag that runs on the server and has an ID, meaning you can manipulate it in code.

Next, switch back to design mode; then, open up the code window behind your form. At the top of your page, under the Inherits line, add the following line of code. This declares the server title tag you've just added:

Code:
Protected PageTitle _
          As System.Web.UI.HtmlControls.HtmlGenericControl

Our third and final step involves changing the page text. Behind the Load event of your page, or in response to some similar event, set the InnerText property of the PageTitle tag to your new page title. Here's my sample code:

Code:
PageTitle.InnerText = "Welcome! - Last Updated 20/05/2003"

And that's it—one line of code and your page title has changed.