Prince's Technical Blog

SQL Server 2000 Survival Guid Part 1

Tue, 09 Oct 2007 03:19:43 GMT

f--* Show information about Database
--* Syntax > sp_helpdb [databasename]
--* Eg : for pubs
sp_helpdb pubs

Blog Starter Kit

Tue, 09 Oct 2007 02:58:16 GMT

Blog Starter Kit
Introduction

You are just a few steps away from starting to publish posts on your Blog site. The following sections explain how to customize and use the Blog Web Site.

Creating an Administrative User
Customizing the Blog
Administering the Blog
Further Resources

Creating an Administrative User
The first step you must take is to create an administrative user. The administrative user has permission to post articles, moderate feedback, and manage categories.

To create an administrative user

sp_makewebtask in MS SQL 2000

Tue, 02 Oct 2007 05:55:15 GMT

sp_makewebtask

Creates a task that produces an HTML document containing data returned by executed queries.

Other Sp's are

sp_runwebtask

sp_enumcodepages

sp_dropwebtask

Note All Web jobs are categorized as Web Assistant in the Job Categories dialog box in SQL Server Enterprise Manager. For more information.

Syntax

WAITFOR in MS SQL 2000

Tue, 02 Oct 2007 05:27:18 GMT

WAITFOR

Specifies a time, time interval, or event that triggers the execution of a statement block, stored procedure, or transaction.

Syntax

WAITFOR { DELAY 'time' | TIME 'time' }

Arguments

DELAY

Instructs Microsoft® SQL Server™ to wait until the specified amount of time has passed, up to a maximum of 24 hours.

'time'

How to send the output of a web control through mail

Mon, 01 Oct 2007 03:19:13 GMT

Many a time we want to send Email, which resembles the output of a web control. At these occasions it would be great to be able to send the output of a web control.

For this article I am assuming that the SMPT server is configured. We can capture the output of most of the control using their Render Control method. After that you can send the output of the control through a mail.
Here is the code for

How to add a static Item to dynamically populated list

Mon, 01 Oct 2007 03:12:55 GMT

There are quite a few features in ASP.NET 2.0. One of new healthy features in list controls (CheckBoxList, ListBox, DropdownList etc...) is the new property "AppendDataBoundItems" You can bind the list controls to some data source and also add some static data.

If the "AppendDataBoundItems" property is set to true then you will get all the date (static data and data populated by data source) in the list. This is very handy if you want to add a "Select One" item in the Dropdownlist and listbox.

The full Syntax is

Manipulating special string character in C Sharp

Mon, 01 Oct 2007 03:07:12 GMT

\n = New Line
\r = Carriage return
\r\n = Carriage return and New line
\” = Quotation mark
\\ = Backlash character
\t = Tab

[Note: Even though escaped characters involve two characters (backslash \ plus the escaped character) the compiler treats the sequence as one character. That means that \n is a single character and the same is true for \", \\, etc]

Thanks Vikram

Life Cycle of the page in ASP.NET 2.0

Mon, 01 Oct 2007 03:02:30 GMT

It talked about the entire event that takes place when a request is made. You can read the article here. This Article talk about the event that takes place in the Page.

PreInit()
In this event all the page level controls are created. The property assigned in the HTML is also assigned to the controls in this event. This event is only there for page and not present in user control (Hence not present in Master Page also). If we want to change the Theme and master page of a page, we need to override this event.
[Note: When you override this event remember to call the base pages preInit command.]

There is a big difference in the event when we have a master page for the page. If there is a Master page associated with the page then the controls on the page are not initialized. In this case the controls will be initialized only after the Init event. As I said earlier that master page does not have any

Dynamically changing themes and applying styles in asp.net 2.0

Mon, 01 Oct 2007 02:48:30 GMT

How users can change the look and feel of the site?

User can change the full theme (images, skin, and css) will change. This can be done very easily in asp.net 2.0.

All my pages are inheriting from basewebpage which inherits from System.Web.UI.Page. In basewebPage I overrode the StyleSheetTheme method like this.

public override string StyleSheetTheme
    {
        get{ return HttpContext.Current.Profile["StylesheetTheme"].ToString();}
        set{ HttpContext.Current.Profile["StylesheetTheme"] = value; }
    }

Using sorting / paging on GridView

Mon, 01 Oct 2007 02:32:50 GMT

If you set AllowPaging="true" or AllowSorting="true" on a GridView control without using a DataSourceControl DataSource (i.e. SqlDataSource, ObjectDataSource), you will run into the following errors:

When changing the page on the GridView control:

The GridView 'GridViewID' fired event PageIndexChanging which wasn't handled.

When clicking a column name to sort the column on the GridView control:

The GridView 'GridViewID' fired event Sorting which wasn't handled.

As a result of not setting the DataSourceID property of the GridView to a DataSourceControl DataSource, you have to add event handlers for sorting and paging.

<asp:

Scrollable Div position and Post back

Mon, 01 Oct 2007 01:53:23 GMT

My friend was working on a page, which had a scrollable div. The problem was that after the post back the div would loose its scroll position. Now when there is a lot of data it is very inconvenient for the user to again scroll back to the position where he was before the post back.

The solution was quite simple. We saved the value of the scroll in a hidden variable. This was done on the onscroll event of the div. On the page load event of the page we again set the scroll of the div to the value saved in the hidden variable. That’s all. Here is a simple code to show the actual working.

How to create a database with previous data from a backup file(.bak)?

Tue, 18 Sep 2007 07:40:07 GMT

Situation: U have only a backup file of a database abcdatabase with extension of .bak (abcdatabase.bak), and u want to create a database called abcdatabase with the data with are in bak files.

Things to remember :
Database Name : abcdatabase
Backupfile Name : abcdatabase.bak
SQL SERVER NAME: your system name is it is local (EG: PRINCEPY)

Password Validation

Tue, 18 Sep 2007 07:04:31 GMT

When it comes to password validation using regular expressions, things can get a bit complicated. Normally, you want people to enter a "good" password that has a mix of numbers and letters. But you may not care where the numbers and letters appear. So you're not looking for a "pattern" in the string. You just want a letter somewhere and a number somewhere.

In this first example, the password must be at least 8 characters long and start and end with a letter.

var re = /^[A-Za-z]\w{6,}[A-Za-z]$/;
if (!re.test(myString)) { alert("Please enter a valid password!"); }

How to Setup VS Studio 2005 for Import and Export to SQL Server 2005 Express as performed in SQL Server 2000

Mon, 17 Sep 2007 05:05:34 GMT

The new Microsoft IDE in VS.NET 2005 includes the ability to define custom tools to be accessible in the Main Tools Menu.

Follow these steps:

1. Click Tools Menu (in VS.NET 2005 IDE)
2. Click External Tools
3. Define name for menu item in the Title text box
4. Define full path and name of executable in the Command text box
5. Define parameters to pass in the Arguments text box

Data Transformation Services (DTS) in Microsoft SQL Server 2000

Mon, 17 Sep 2007 04:19:17 GMT

Note: DTS has been replaced by SQL Server Integration Services (SSIS) in SQL Server 2005. To learn about SSIS, read An Introduction to SQL Server 2005 Integration Services on Microsoft TechNet.

Summary: Database administrators often import, export, and transform data in support of tasks such as data consolidation, archiving, and analysis; for application development purposes; and for database or server upgrades. Data Transformation Services (DTS) in SQL Server 2000 provides a set of graphical tools and programmable objects to help administrators and developers solve data movement problems, including the extraction, transformation, and consolidation of data from disparate sources to single or multiple destinations. Sets of tasks,

Import/Export data with SQL Server 2005 Express

Mon, 17 Sep 2007 03:23:27 GMT

Do the follwing steps to Import/Export data with SQL Server 2005 Express

1. Download MSXML 6.0 from Microsoft.com and run the setup.

2. Now Download Microsoft SQL Server Management Studio Express for connecting SQL Server 2005

http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&DisplayLang=en

and run the setup. (From here you can connect with SQL Server 2005 database.)

3. Now run DTSWizard.exe from C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe

(Note: If you don't have "DTS"(Data Transformation Services) folder then check out the bottom link Or Post Named "DTS")

Migrating Data from SQL 2000 to SQL 2005

Mon, 17 Sep 2007 03:20:04 GMT

To import your SQL 2000 database into a SQL 2005 database, you can use Microsoft’s SQL Server Management Studio. After you have installed and setup the software, follow the directions below:

Installing SQL Express on your computer

Mon, 17 Sep 2007 03:17:01 GMT

There are 3 individual downloads that are required for SQL Express 2005 and have to be installed in the following sequence.

A. Microsoft .NET Framework Version 2.0 Redistributable Package Release Candidate (x86)
B. Microsoft SQL Server 2005 Express edition
C. Microsoft SQL Server Management Studio Express

Requirement: Windows 2003 Server for A, B & C
Requirement: Windows XP for A & C

Installing .NET 2.0

Adding Meta tags Dynamically in webpage using asp.net

Sat, 15 Sep 2007 03:31:10 GMT

You can easily create a HtmlMeta object and add it to the Controls collection in the HtmlHead class exposed via Page.Header. Here's a few samples:

// Render: <meta name="keywords" content="Some words listed here" />
HtmlMeta meta = new HtmlMeta();
meta.Name = "keywords" ;
meta.Content = "Some words listed here" ;
this .Header.Controls.Add(meta);

// Render: <meta name="robots" content="noindex" />
meta = new HtmlMeta();
meta.Name = "robots" ;
meta.Content = "noindex" ;
this .Header.Controls.Add(meta);

// Render: <meta name="date" content="2006-03-25"

Unable to start debugging on the web server.

Sun, 09 Sep 2007 01:48:55 GMT

When u get a error messaage like

"Unable to start debugging on the web server. The web server is not configured correctly. See help for common configuration errors. Running the web page outside of the debugger may provide further information."

if u installed diffrent verions of dot net framework like

Microsoft Visual Studio .NET 2003
Microsoft Visual Web Developer 2005 Express Edition
etc

their will be a change of getting this error since the debugger is getting confussed with all these framework.

to solve that we have to tell IIS to which framework it has to communicate.

for that u have to take a command prompt and try to reach till

"C:\WINDOWS\Microsoft.NET\Framework\"

and further try to reach the required framework folder