 |
Working with Computed column in SQL Server 2000
|
| Total Hit (1541) |
There are restriction for ALTER COLUMN, documented in Books Online (see end
of this post). Depending on your particular situation, you need to DROP
INDEX, ALTER TABLE... DROP CONSTRAINT etc.
The altered column cannot be:
a) A column with a text, image, ntext, or timestamp data type.
....Read More |
Rating
 |
|
|
|
 |
Multiple file download in asp.net with vb
|
| Total Hit (1850) |
The user is shown a list of files with checkboxes for the ones they want to download. The user can choose to download 1 to many files. I have it set up to force the prompt to save/download. The program recognizes the files that the user requests, however, the download only works on the first file an
....Read More |
| Rating
|
|
 |
Downloading Files with VBScript and ASP
|
| Total Hit (1448) |
The primary use for a system like this is to allow downloading of any TEXT based file that would normally be served via a client's browser and be unable to be downloaded. This system works great when setting up downloads for files with the following extensions: *.txt, *.htm, *.html or *.asp . This s
....Read More |
| Rating
|
|
|
|
|
|
File downloading with COM and ASP
|
| Total Hit (3126) |
This article is about direct file downloading through a COM component. It uses the IResponse interface to send a file directly to the client browser.
With this approach you can protect your files from being downloaded by an unauthorized person.
|
| Rating
|
|
|
|
Download multiple files in one http request
|
| Total Hit (2757) |
HTTP protocol was designed to send one file per one request. Sometimes you will need to send more files - usually when a client selects several files for download and the files have to be delivered to the client. I created ASP sample which will do such task - the sample is located at http://www.pstr
....Read More |
| Rating
|
|
|
|
Force Download to client browser.
|
| Total Hit (5826) |
Forces users to have choice of downloading a binary file. This was becomming a problem with Word documents - as they would either open within the browser or open externally. You may need to change the FileName variable.
«Code LangId=5» <%
Dim Stream
Dim Contents
Dim FileName
....Read More |
| Rating
|
|
|
|
|
|
Problem: Click Event not firing for ImageButton
|
| Total Hit (6021) |
I had an Image Button with following properties in tag
«code LangId=4»<asp:imagebutton id="cmdSearch"
BorderWidth="1px"
BorderStyle="None"
BorderColor="Gray"
runat="server"
ImageUrl="images\general\search_a.gif"
ImageAlign="AbsMiddle"
CommandName="Search"
EnableViewState="
....Read More |
Rating
 |
|
|
|
Dynamic order by
|
| Total Hit (902) |
You can use CASE statement in order by clause to select field by which you want to order the resultset. This is very handy technique.
|
| Rating
|
|
|
|
Tricky order by without writing dynamic T-SQL
|
| Total Hit (2474) |
This example shows you how to write dynamic order by statement without writing Dynamic T-SQL which is required to re-compile the execution plan every time you run it.
|
| Rating
|
|
 |
How to disable word wrap in RichTextBox control
|
| Total Hit (2866) |
By default rich textbox control wrap a long line. Sometimes we want to disable this inbuilt feature then here is some trick.
set RightMargin property to an arbitary high value which will not wrap your long line.
Happy Programming....
|
Rating
 |
|
|
|
How to open a file with Wordpad or Notepad
|
| Total Hit (2893) |
I tried to find sourcecode which allows me to open a file with any extension with Wordpad and Notepad. And finally I came up with this solution.
Happy Programming....
|
Rating
 |
|
|
|
How to install MSDE
|
| Total Hit (4035) |
To install MSDE first extract files to a folder e.g. c:\sql2ksp3 then run folloing command on command prompt
c:\>cd sql2ksp3
You can specify installation option either in command line itself or specify in setup.ini
«b»[1] Specifying parameters in command line«/b»
For example the following
....Read More |
| Rating
|
|
|
|
How to debug Javascript in Visual Studio.net IDE
|
| Total Hit (1559) |
By default Script Debugging is disable in Internet Explorer Which can prevent you to debug Javascript in your ASP.net project
To Enable Script Debugging
1) open Internet Explorer
2) Goto Tools - > Advanced tab
3) Uncheck Disable Script debugging Check box in Advanced tab
4) Put Break point i
....Read More |
| Rating
|
|
|
|
|
|
|
|
Tutorial - Image List Control Introduction
|
| Total Hit (2125) |
The Image List control allows you to add images to your program, which you can use in the other Common Controls (Toolbar, TreeView, ListView etc). To add the ImageList control to your VB project, click Project|Components, and check the box next to Microsoft Windows Common Controls x.x where x is the
....Read More |
| Rating
|
|
|
|
|
|
|
|
ADO Tutorial
|
| Total Hit (3769) |
«big»«u»«b»ADO Tutorial«/b»«/u»«/big»
«b»ADO Introduction«/b»
This chapter explains what ADO is, and how it can be used.
«b»ADO Database Connection«/b»
This chapter explains how to connect to a database using ADO.
«b»ADO Recordset«/b»
This chapter explains how to access an ADO Recordset
....Read More |
| Rating
|
|
|
|
|
|
Programmatically Select a Node in TreeView.
|
| Total Hit (3283) |
This is very easy but tricky. By default HideSelection property of treeview is true. So it confuses many programmer. When you use Treeview.Selected=True and HideSelection is True then it wont show the selection even though node is selected. Check the following example for that
....Read More |
| Rating
|
|
|
|
|
|
Setting Custom Paper Size using Printer API
|
| Total Hit (33663) |
Here is the alternate method which shows how to use printer APIs to set custom papersize and other printer properties using API. This code will work with Win9x and WinNT both.
|
Rating
 |
|
|
|
|
|
 |
Formatting with Regular Expressions
|
| Total Hit (2844) |
If you're familiar with regular expressions, you know that they can be used for pattern matching and replacement in strings. (If you are not familiar with regular expressions, you're missing out on a powerful technology that has a myriad of applications. Read An Introduction to Regular Expressions t
....Read More |
| Rating
|
|
|
|
Common Applications of Regular Expressions
|
| Total Hit (1860) |
Regular Expressions (for those not yet acquainted with them) provide a way of matching patterns of strings that may be simple or extremely complicated and they do it in a very efficient manner. For an introduction to regular expressions in ASP be sure to read: An Introduction to Regular Expressions
....Read More |
| Rating
|
|