Dot net blog

BasicInstincts

2005-09-17T06:36:00.000-07:00

http://msdn.microsoft.com/msdnmag/issues/04/06/BasicInstincts/

parsing a comma delimited string by stored procedure

2005-08-25T21:11:00.000-07:00

This is a Code by which u can send a string delimited by comma(or any delimiter u may choose)containing multiple values to a stored proc to be inserted into the DB. It saves considerable DB roundtrips.N.B. There is a caveat : Use it only if u are sure that the string would not exceed 8000 chars (The max length for a varchar).=====================================================================
ALTER PROC sprocCreateIndustryImageAssoc( @ImageList varchar(5000), @IndustryID int)ASBEGIN
Begin Tran
SET NOCOUNT ON IF @ImageList = '' BEGIN Delete From tblAFDImageIndustryAssoc where IndustryID=@IndustryID commit tran RETURN END
DECLARE @ImageID int, @Pos int
SET @ImageList = LTRIM(RTRIM(@ImageList))+ ',' SET @Pos = CHARINDEX(',', @ImageList, 1)
IF REPLACE(@ImageList, ',', '') <> '' BEGIN Delete From tblAFDImageIndustryAssoc where IndustryID=@IndustryID WHILE @Pos > 0 BEGIN SET @ImageID = LTRIM(RTRIM(LEFT(@ImageList, @Pos - 1))) IF @ImageID <> '' BEGIN INSERT INTO tblAFDImageIndustryAssoc (ImageID,IndustryID) VALUES (CAST(@ImageID AS int),@IndustryID) --conversion of ImageID to Int if @@Error > 0 begin rollback tran return -1 end END SET @ImageList = RIGHT(@ImageList, LEN(@ImageList) - @Pos) SET @Pos = CHARINDEX(',', @ImageList, 1)
END END
--SELECT ImageID,IndustryID FROM tblAFDImageIndustryAssoc
Commit Tran return 0END

remote-scripting-ajax

2005-08-05T07:25:00.000-07:00

http://www.sitepoint.com/print/remote-scripting-ajax

Want to know how Gmail works - and whether it will work?

2005-08-05T07:19:00.000-07:00

http://www.techworld.com/applications/news/index.cfm?NewsID=1356

Google's storage strategy

2005-08-05T07:15:00.000-07:00

http://www.techworld.com/storage/features/index.cfm?featureid=467

Generate insert scripts from existing data

2005-07-12T04:43:00.000-07:00

SET NOCOUNT ON
GO

PRINT 'Using Master database'
USE master
GO

PRINT 'Checking for the existence of this procedure'
IF (SELECT OBJECT_ID('sp_generate_inserts','P')) IS NOT NULL --means, the procedure already exists
BEGIN
PRINT 'Procedure already exists. So, dropping it'
DROP PROC sp_generate_inserts
END
GO

--Turn system object marking on
EXEC master.dbo.sp_MS_upd_sysobj_category 1
GO

CREATE PROC sp_generate_inserts
(
@table_name varchar(776), -- The table/view for which the INSERT statements will be generated using the existing data
@target_table varchar(776) = NULL, -- Use this parameter to specify a different table name into which the data will be inserted
@include_column_list bit = 1, -- Use this parameter to include/ommit column list in the generated INSERT statement
@from varchar(800) = NULL, -- Use this parameter to filter the rows based on a filter condition (using WHERE)
@include_timestamp bit = 0, -- Specify 1 for this parameter, if you want to include the TIMESTAMP/ROWVERSION column's data in the INSERT statement
@debug_mode bit = 0, -- If @debug_mode is set to 1, the SQL statements constructed by this procedure will be printed for later examination
@owner varchar(64) = NULL, -- Use this parameter if you are not the owner of the table
@ommit_images bit = 0, -- Use this parameter to generate INSERT statements by omitting the 'image' columns
@ommit_identity bit = 0, -- Use this parameter to ommit the identity columns
@top int = NULL, -- Use this parameter to generate INSERT statements only for the TOP n rows
@cols_to_include varchar(8000) = NULL, -- List of columns to be included in the INSERT statement
@cols_to_exclude varchar(8000) = NULL, -- List of columns to be excluded from the INSERT statement
@disable_constraints bit = 0, -- When 1, disables foreign key constraints and enables them after the INSERT statements
@ommit_computed_cols bit = 0 -- When 1, computed columns will not be included in the INSERT statement

)
AS
BEGIN

/***********************************************************************************************************
Procedure: sp_generate_inserts (Build 22)
(Copyright © 2002 Narayana Vyas Kondreddi. All rights reserved.)

Purpose: To generate INSERT statements from existing data.
These INSERTS can be executed to regenerate the data at some other location.
This procedure is also useful to create a database setup, where in you can
script your data along with your table definitions.

Written by: Narayana Vyas Kondreddi
http://vyaskn.tripod.com

Acknowledgements:
Divya Kalra -- For beta testing
Mark Charsley -- For reporting a problem with scripting uniqueidentifier columns with NULL values
Artur Zeygman -- For helping me simplify a bit of code for handling non-dbo owned tables
Joris Laperre -- For reporting a regression bug in handling text/ntext columns

Tested on: SQL Server 7.0 and SQL Server 2000

Date created: January 17th 2001 21:52 GMT

Date modified: May 1st 2002 19:50 GMT

Email: vyaskn@hotmail.com

NOTE: This procedure may not work with tables with too many columns.
Results can be unpredictable with huge text columns or SQL Server 2000's sql_variant data types
Whenever possible, Use @include_column_list parameter to ommit column list in the INSERT statement, for better results
IMPORTANT: This procedure is not tested with internation data (Extended characters or Unicode). If needed
you might want to convert the datatypes of character variables in this procedure to their respective unicode counterparts
like nchar and nvarchar

Example 1: To generate INSERT statements for table 'titles':

EXEC sp_generate_inserts 'titles'

Example 2: To ommit the column list in the INSERT statement: (Column list is included by default)
IMPORTANT: If you have too many columns, you are advised to ommit column list, as shown below,
to avoid erroneous results

EXEC sp_generate_inserts 'titles', @include_column_list = 0

Example 3: To generate INSERT statements for 'titlesCopy' table from 'titles' table:

EXEC sp_generate_inserts 'titles', 'titlesCopy'

Example 4: To generate INSERT statements for 'titles' table for only those titles
which contain the word 'Computer' in them:
NOTE: Do not complicate the FROM or WHERE clause here. It's assumed that you are good with T-SQL if you are using this parameter

EXEC sp_generate_inserts 'titles', @from = "from titles where title like '%Computer%'"

Example 5: To specify that you want to include TIMESTAMP column's data as well in the INSERT statement:
(By default TIMESTAMP column's data is not scripted)

EXEC sp_generate_inserts 'titles', @include_timestamp = 1

Example 6: To print the debug information:

EXEC sp_generate_inserts 'titles', @debug_mode = 1

Example 7: If you are not the owner of the table, use @owner parameter to specify the owner name
To use this option, you must have SELECT permissions on that table

EXEC sp_generate_inserts Nickstable, @owner = 'Nick'

Example 8: To generate INSERT statements for the rest of the columns excluding images
When using this otion, DO NOT set @include_column_list parameter to 0.

EXEC sp_generate_inserts imgtable, @ommit_images = 1

Example 9: To generate INSERT statements excluding (ommiting) IDENTITY columns:
(By default IDENTITY columns are included in the INSERT statement)

EXEC sp_generate_inserts mytable, @ommit_identity = 1

Example 10: To generate INSERT statements for the TOP 10 rows in the table:

EXEC sp_generate_inserts mytable, @top = 10

Example 11: To generate INSERT statements with only those columns you want:

EXEC sp_generate_inserts titles, @cols_to_include = "'title','title_id','au_id'"

Example 12: To generate INSERT statements by omitting certain columns:

EXEC sp_generate_inserts titles, @cols_to_exclude = "'title','title_id','au_id'"

Example 13: To avoid checking the foreign key constraints while loading data with INSERT statements:

EXEC sp_generate_inserts titles, @disable_constraints = 1

Example 14: To exclude computed columns from the INSERT statement:
EXEC sp_generate_inserts MyTable, @ommit_computed_cols = 1
***********************************************************************************************************/

SET NOCOUNT ON

--Making sure user only uses either @cols_to_include or @cols_to_exclude
IF ((@cols_to_include IS NOT NULL) AND (@cols_to_exclude IS NOT NULL))
BEGIN
RAISERROR('Use either @cols_to_include or @cols_to_exclude. Do not use both the parameters at once',16,1)
RETURN -1 --Failure. Reason: Both @cols_to_include and @cols_to_exclude parameters are specified
END

--Making sure the @cols_to_include and @cols_to_exclude parameters are receiving values in proper format
IF ((@cols_to_include IS NOT NULL) AND (PATINDEX('''%''',@cols_to_include) = 0))
BEGIN
RAISERROR('Invalid use of @cols_to_include property',16,1)
PRINT 'Specify column names surrounded by single quotes and separated by commas'
PRINT 'Eg: EXEC sp_generate_inserts titles, @cols_to_include = "''title_id'',''title''"'
RETURN -1 --Failure. Reason: Invalid use of @cols_to_include property
END

IF ((@cols_to_exclude IS NOT NULL) AND (PATINDEX('''%''',@cols_to_exclude) = 0))
BEGIN
RAISERROR('Invalid use of @cols_to_exclude property',16,1)
PRINT 'Specify column names surrounded by single quotes and separated by commas'
PRINT 'Eg: EXEC sp_generate_inserts titles, @cols_to_exclude = "''title_id'',''title''"'
RETURN -1 --Failure. Reason: Invalid use of @cols_to_exclude property
END

--Checking to see if the database name is specified along wih the table name
--Your database context should be local to the table for which you want to generate INSERT statements
--specifying the database name is not allowed
IF (PARSENAME(@table_name,3)) IS NOT NULL
BEGIN
RAISERROR('Do not specify the database name. Be in the required database and just specify the table name.',16,1)
RETURN -1 --Failure. Reason: Database name is specified along with the table name, which is not allowed
END

--Checking for the existence of 'user table' or 'view'
--This procedure is not written to work on system tables
--To script the data in system tables, just create a view on the system tables and script the view instead

IF @owner IS NULL
BEGIN
IF ((OBJECT_ID(@table_name,'U') IS NULL) AND (OBJECT_ID(@table_name,'V') IS NULL))
BEGIN
RAISERROR('User table or view not found.',16,1)
PRINT 'You may see this error, if you are not the owner of this table or view. In that case use @owner parameter to specify the owner name.'
PRINT 'Make sure you have SELECT permission on that table or view.'
RETURN -1 --Failure. Reason: There is no user table or view with this name
END
END
ELSE
BEGIN
IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = @table_name AND (TABLE_TYPE = 'BASE TABLE' OR TABLE_TYPE = 'VIEW') AND TABLE_SCHEMA = @owner)
BEGIN
RAISERROR('User table or view not found.',16,1)
PRINT 'You may see this error, if you are not the owner of this table. In that case use @owner parameter to specify the owner name.'
PRINT 'Make sure you have SELECT permission on that table or view.'
RETURN -1 --Failure. Reason: There is no user table or view with this name
END
END

--Variable declarations
DECLARE @Column_ID int,
@Column_List varchar(8000),
@Column_Name varchar(128),
@Start_Insert varchar(786),
@Data_Type varchar(128),
@Actual_Values varchar(8000), --This is the string that will be finally executed to generate INSERT statements
@IDN varchar(128) --Will contain the IDENTITY column's name in the table

--Variable Initialization
SET @IDN = ''
SET @Column_ID = 0
SET @Column_Name = ''
SET @Column_List = ''
SET @Actual_Values = ''

IF @owner IS NULL
BEGIN
SET @Start_Insert = 'INSERT INTO ' + '[' + RTRIM(COALESCE(@target_table,@table_name)) + ']'
END
ELSE
BEGIN
SET @Start_Insert = 'INSERT ' + '[' + LTRIM(RTRIM(@owner)) + '].' + '[' + RTRIM(COALESCE(@target_table,@table_name)) + ']'
END

--To get the first column's ID

SELECT @Column_ID = MIN(ORDINAL_POSITION)
FROM INFORMATION_SCHEMA.COLUMNS (NOLOCK)
WHERE TABLE_NAME = @table_name AND
(@owner IS NULL OR TABLE_SCHEMA = @owner)

--Loop through all the columns of the table, to get the column names and their data types
WHILE @Column_ID IS NOT NULL
BEGIN
SELECT @Column_Name = QUOTENAME(COLUMN_NAME),
@Data_Type = DATA_TYPE
FROM INFORMATION_SCHEMA.COLUMNS (NOLOCK)
WHERE ORDINAL_POSITION = @Column_ID AND
TABLE_NAME = @table_name AND
(@owner IS NULL OR TABLE_SCHEMA = @owner)

IF @cols_to_include IS NOT NULL --Selecting only user specified columns
BEGIN
IF CHARINDEX( '''' + SUBSTRING(@Column_Name,2,LEN(@Column_Name)-2) + '''',@cols_to_include) = 0
BEGIN
GOTO SKIP_LOOP
END
END

IF @cols_to_exclude IS NOT NULL --Selecting only user specified columns
BEGIN
IF CHARINDEX( '''' + SUBSTRING(@Column_Name,2,LEN(@Column_Name)-2) + '''',@cols_to_exclude) <> 0
BEGIN
GOTO SKIP_LOOP
END
END

--Making sure to output SET IDENTITY_INSERT ON/OFF in case the table has an IDENTITY column
IF (SELECT COLUMNPROPERTY( OBJECT_ID(QUOTENAME(COALESCE(@owner,USER_NAME())) + '.' + @table_name),SUBSTRING(@Column_Name,2,LEN(@Column_Name) - 2),'IsIdentity')) = 1
BEGIN
IF @ommit_identity = 0 --Determing whether to include or exclude the IDENTITY column
SET @IDN = @Column_Name
ELSE
GOTO SKIP_LOOP
END

--Making sure whether to output computed columns or not
IF @ommit_computed_cols = 1
BEGIN
IF (SELECT COLUMNPROPERTY( OBJECT_ID(QUOTENAME(COALESCE(@owner,USER_NAME())) + '.' + @table_name),SUBSTRING(@Column_Name,2,LEN(@Column_Name) - 2),'IsComputed')) = 1
BEGIN
GOTO SKIP_LOOP
END
END

--Tables with columns of IMAGE data type are not supported for obvious reasons
IF(@Data_Type in ('image'))
BEGIN
IF (@ommit_images = 0)
BEGIN
RAISERROR('Tables with image columns are not supported.',16,1)
PRINT 'Use @ommit_images = 1 parameter to generate INSERTs for the rest of the columns.'
PRINT 'DO NOT ommit Column List in the INSERT statements. If you ommit column list using @include_column_list=0, the generated INSERTs will fail.'
RETURN -1 --Failure. Reason: There is a column with image data type
END
ELSE
BEGIN
GOTO SKIP_LOOP
END
END

--Determining the data type of the column and depending on the data type, the VALUES part of
--the INSERT statement is generated. Care is taken to handle columns with NULL values. Also
--making sure, not to lose any data from flot, real, money, smallmomey, datetime columns
SET @Actual_Values = @Actual_Values +
CASE
WHEN @Data_Type IN ('char','varchar','nchar','nvarchar')
THEN
'COALESCE('''''''' + REPLACE(RTRIM(' + @Column_Name + '),'''''''','''''''''''')+'''''''',''NULL'')'
WHEN @Data_Type IN ('datetime','smalldatetime')
THEN
'COALESCE('''''''' + RTRIM(CONVERT(char,' + @Column_Name + ',109))+'''''''',''NULL'')'
WHEN @Data_Type IN ('uniqueidentifier')
THEN
'COALESCE('''''''' + REPLACE(CONVERT(char(255),RTRIM(' + @Column_Name + ')),'''''''','''''''''''')+'''''''',''NULL'')'
WHEN @Data_Type IN ('text','ntext')
THEN
'COALESCE('''''''' + REPLACE(CONVERT(char(8000),' + @Column_Name + '),'''''''','''''''''''')+'''''''',''NULL'')'
WHEN @Data_Type IN ('binary','varbinary')
THEN
'COALESCE(RTRIM(CONVERT(char,' + 'CONVERT(int,' + @Column_Name + '))),''NULL'')'
WHEN @Data_Type IN ('timestamp','rowversion')
THEN
CASE
WHEN @include_timestamp = 0
THEN
'''DEFAULT'''
ELSE
'COALESCE(RTRIM(CONVERT(char,' + 'CONVERT(int,' + @Column_Name + '))),''NULL'')'
END
WHEN @Data_Type IN ('float','real','money','smallmoney')
THEN
'COALESCE(LTRIM(RTRIM(' + 'CONVERT(char, ' + @Column_Name + ',2)' + ')),''NULL'')'
ELSE
'COALESCE(LTRIM(RTRIM(' + 'CONVERT(char, ' + @Column_Name + ')' + ')),''NULL'')'
END + '+' + ''',''' + ' + '

--Generating the column list for the INSERT statement
SET @Column_List = @Column_List + @Column_Name + ','

SKIP_LOOP: --The label used in GOTO

SELECT @Column_ID = MIN(ORDINAL_POSITION)
FROM INFORMATION_SCHEMA.COLUMNS (NOLOCK)
WHERE TABLE_NAME = @table_name AND
ORDINAL_POSITION > @Column_ID AND
(@owner IS NULL OR TABLE_SCHEMA = @owner)

--Loop ends here!
END

--To get rid of the extra characters that got concatenated during the last run through the loop
SET @Column_List = LEFT(@Column_List,len(@Column_List) - 1)
SET @Actual_Values = LEFT(@Actual_Values,len(@Actual_Values) - 6)

IF LTRIM(@Column_List) = ''
BEGIN
RAISERROR('No columns to select. There should at least be one column to generate the output',16,1)
RETURN -1 --Failure. Reason: Looks like all the columns are ommitted using the @cols_to_exclude parameter
END

--Forming the final string that will be executed, to output the INSERT statements
IF (@include_column_list <> 0)
BEGIN
SET @Actual_Values =
'SELECT ' +
CASE WHEN @top IS NULL OR @top < 0 THEN '' ELSE ' TOP ' + LTRIM(STR(@top)) + ' ' END +
'''' + RTRIM(@Start_Insert) +
' ''+' + '''(' + RTRIM(@Column_List) + '''+' + ''')''' +
' +''VALUES(''+ ' + @Actual_Values + '+'')''' + ' ' +
COALESCE(@from,' FROM ' + CASE WHEN @owner IS NULL THEN '' ELSE '[' + LTRIM(RTRIM(@owner)) + '].' END + '[' + rtrim(@table_name) + ']' + '(NOLOCK)')
END
ELSE IF (@include_column_list = 0)
BEGIN
SET @Actual_Values =
'SELECT ' +
CASE WHEN @top IS NULL OR @top < 0 THEN '' ELSE ' TOP ' + LTRIM(STR(@top)) + ' ' END +
'''' + RTRIM(@Start_Insert) +
' '' +''VALUES(''+ ' + @Actual_Values + '+'')''' + ' ' +
COALESCE(@from,' FROM ' + CASE WHEN @owner IS NULL THEN '' ELSE '[' + LTRIM(RTRIM(@owner)) + '].' END + '[' + rtrim(@table_name) + ']' + '(NOLOCK)')
END

--Determining whether to ouput any debug information
IF @debug_mode =1
BEGIN
PRINT '/*****START OF DEBUG INFORMATION*****'
PRINT 'Beginning of the INSERT statement:'
PRINT @Start_Insert
PRINT ''
PRINT 'The column list:'
PRINT @Column_List
PRINT ''
PRINT 'The SELECT statement executed to generate the INSERTs'
PRINT @Actual_Values
PRINT ''
PRINT '*****END OF DEBUG INFORMATION*****/'
PRINT ''
END

PRINT '--INSERTs generated by ''sp_generate_inserts'' stored procedure written by Vyas'
PRINT '--Build number: 22'
PRINT '--Problems/Suggestions? Contact Vyas @ vyaskn@hotmail.com'
PRINT '--http://vyaskn.tripod.com'
PRINT ''
PRINT 'SET NOCOUNT ON'
PRINT ''

--Determining whether to print IDENTITY_INSERT or not
IF (@IDN <> '')
BEGIN
PRINT 'SET IDENTITY_INSERT ' + QUOTENAME(COALESCE(@owner,USER_NAME())) + '.' + QUOTENAME(@table_name) + ' ON'
PRINT 'GO'
PRINT ''
END

IF @disable_constraints = 1 AND (OBJECT_ID(QUOTENAME(COALESCE(@owner,USER_NAME())) + '.' + @table_name, 'U') IS NOT NULL)
BEGIN
IF @owner IS NULL
BEGIN
SELECT 'ALTER TABLE ' + QUOTENAME(COALESCE(@target_table, @table_name)) + ' NOCHECK CONSTRAINT ALL' AS '--Code to disable constraints temporarily'
END
ELSE
BEGIN
SELECT 'ALTER TABLE ' + QUOTENAME(@owner) + '.' + QUOTENAME(COALESCE(@target_table, @table_name)) + ' NOCHECK CONSTRAINT ALL' AS '--Code to disable constraints temporarily'
END

PRINT 'GO'
END

PRINT ''
PRINT 'PRINT ''Inserting values into ' + '[' + RTRIM(COALESCE(@target_table,@table_name)) + ']' + ''''

--All the hard work pays off here!!! You'll get your INSERT statements, when the next line executes!
EXEC (@Actual_Values)

PRINT 'PRINT ''Done'''
PRINT ''

IF @disable_constraints = 1 AND (OBJECT_ID(QUOTENAME(COALESCE(@owner,USER_NAME())) + '.' + @table_name, 'U') IS NOT NULL)
BEGIN
IF @owner IS NULL
BEGIN
SELECT 'ALTER TABLE ' + QUOTENAME(COALESCE(@target_table, @table_name)) + ' CHECK CONSTRAINT ALL' AS '--Code to enable the previously disabled constraints'
END
ELSE
BEGIN
SELECT 'ALTER TABLE ' + QUOTENAME(@owner) + '.' + QUOTENAME(COALESCE(@target_table, @table_name)) + ' CHECK CONSTRAINT ALL' AS '--Code to enable the previously disabled constraints'
END

PRINT 'GO'
END

PRINT ''
IF (@IDN <> '')
BEGIN
PRINT 'SET IDENTITY_INSERT ' + QUOTENAME(COALESCE(@owner,USER_NAME())) + '.' + QUOTENAME(@table_name) + ' OFF'
PRINT 'GO'
END

PRINT 'SET NOCOUNT OFF'

SET NOCOUNT OFF
RETURN 0 --Success. We are done!
END

GO

PRINT 'Created the procedure'
GO

--Turn system object marking off
EXEC master.dbo.sp_MS_upd_sysobj_category 2
GO

PRINT 'Granting EXECUTE permission on sp_generate_inserts to all users'
GRANT EXEC ON sp_generate_inserts TO public

SET NOCOUNT OFF
GO

PRINT 'Done'

.NET Reflector site

2005-06-20T06:56:00.001-07:00

http://serial.n6k.com/reflecta/doc_net-1.1/System.php

Ensuring all applications run on latest CLR

2005-05-02T05:22:00.000-07:00

If you want to ensure that all applications run on the latest CLR installed on your system, you just need to change some registry settings or set a flag in VS.NET 2005 (Beta 1). There is a switch in VS.NET 2005 (Beta 1) which does this.Doing it with registry:To turn on the switchHKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework\OnlyUseLatestCLR=dword:00000001To turn off the swtichHKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework\OnlyUseLatestCLR=dword:00000000

good .NET links

2005-04-25T01:47:00.000-07:00

http://www.cite-sciences.fr/english/ala_cite/expo/explora/image/mona.html http://live.indiatimes.com/ppt/120804/index.html http://msdn.microsoft.com/theshow/Episode020/TranscriptText.asp http://www.lebonze.com/stuff/move.htm

.NET=========1. What ASP_NET Programmers Should Know About Application Domains
http://www.odetocode.com/Articles/305.aspx
2. WSE webcast
http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032256128&Culture=en-US http://searchvb.techtarget.com/webcast/0,295011,sid8_gci970124,00.html
3. Good Video
http://www.theserverside.net/articles/showarticle.tss?id=TheCodeRoom
4. Calling a Web service frm JS
http://www.dotnetbips.com/displayarticle.aspx?id=278

4. Prevent multiple login
http://www.eggheadcafe.com/articles/20030418.asp
5. .NET questions
http://www.andymcm.com/dotnetfaq.htm
Indexershttp://www.softsteel.co.uk/tutorials/cSharp/lesson15.html
Delegates and Eventshttp://www.softsteel.co.uk/tutorials/cSharp/lesson16.html
Db programming using ADO.NET- Good articleshttp://www.c-sharpcorner.com/Database.asp
Database Vendor Independent Code with Improved Connection Poolinghttp://www.c-sharpcorner.com//Code/2002/Oct/DbIndepCode.asp
Design an Effective Data-Access Architecture http://www.ftponline.com/wss/2002_07/magazine/features/dfox/page4.aspx
http://www.c-sharpcorner.com/Code/2002/July/GenericDataAccessCompActivator.asp
Strange things with IsPostBackhttp://www.asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=798824
http://channel9.msdn.com/India/
ViewState---------http://msdn.microsoft.com/netframework/downloads/samples/default.aspx?pull=/library/
en-us/dnaspnet/html/asp11222001.asp
Custom Collection generator----------------------------http://www.codecube.net/demos/dotnet/collectionwizard.aspx
Darius - Colorblind song--------------------------http://www.mtvasia.com/Video/Feature/20030924000034/
AJEX-----------
http://adaptivepath.com/publications/essays/archives/000385.php
XMLHttpRequest---------------http://www.xml.com/pub/a/2005/02/09/xml-http-request.html
Ajax: a New Approach to Web pplications --------------------------Very very interesting, talks about "Asynchronous JavaScript + XML", the technique
that drives Google Maps, Gmail, Google Suggest etc. [I especially like the linked
analysis articles, must read if JavaScript is part of your toolset]
http://adaptivepath.com/publications/essays/archives/000385.php http://www.theserverside.net/news/thread.tss?thread_id=32688&News03_22_05-click
Using strongly typed collections with the ASP.NET DataGrid control===================http://www.123aspx.com/redir.aspx?res=32651
Communication using ports in C#=================================http://www.htservices.com/Tools/VBandC/SerialCommunications.htm
Improved Caching in ASP.NET 2.0===============================http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvs05/html/caching
nt2.asp
http://www.msmvps.com/KevinMcNeish/
Building a better wait page--------------------------http://www.123aspx.com/redir.aspx?res=32860
Desktop programming in .NET---------------------------http://windowsforms.net/
Important C# samples--------------------http://msdn.microsoft.com/vcsharp/downloads/samples/23samples/default.aspx
Interesting anti-microsoft sites-------------------------------http://www.kmfms.com/

Disabling the back button

2005-03-30T02:12:00.000-08:00

use document.location.replace("");

Good .NET links

2005-01-13T09:16:00.000-08:00

.NET
=========
1. What ASP_NET Programmers Should Know About Application Domains

http://www.odetocode.com/Articles/305.aspx

2. WSE webcast

http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032256128&Culture=en-US
http://searchvb.techtarget.com/webcast/0,295011,sid8_gci970124,00.html

3. Good Video

http://www.theserverside.net/articles/showarticle.tss?id=TheCodeRoom

4. Calling a Web service frm JS

http://www.dotnetbips.com/displayarticle.aspx?id=278

4. Prevent multiple login

http://www.eggheadcafe.com/articles/20030418.asp

5. .NET questions

http://www.andymcm.com/dotnetfaq.htm

Indexers
http://www.softsteel.co.uk/tutorials/cSharp/lesson15.html

Delegates and Events
http://www.softsteel.co.uk/tutorials/cSharp/lesson16.html

Db programming using ADO.NET- Good articles
http://www.c-sharpcorner.com/Database.asp

Database Vendor Independent Code with Improved Connection Pooling
http://www.c-sharpcorner.com//Code/2002/Oct/DbIndepCode.asp

Design an Effective Data-Access Architecture
http://www.ftponline.com/wss/2002_07/magazine/features/dfox/page4.aspx

http://www.c-sharpcorner.com/Code/2002/July/GenericDataAccessCompActivator.asp

Strange things with IsPostBack
http://www.asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=798824

Interview questions

2005-01-09T07:22:00.000-08:00

.NET/C# Questions :
-------------------
http://forums.aspfree.com/showthread.php?t=23415
http://www.techinterviews.com/index.php?p=159
http://www.franklins.net/dotnetrocks/
http://blogs.crsw.com/mark/articles/252.aspx
http://www.dotnetspider.com/technology/KBPages/1068.aspx
http://forums.aspfree.com/archive/t-33756
Book
----
Programming Interviews Exposed: Secrets to Landing Your Next Job

Microsoft Interview questions
-----------------------------
http://www.sellsbrothers.com/fun/msiview/default.aspx?content=question.htm
Remoting Questions------------------
http://blogs.crsw.com/mark/articles/253.aspx

MCAD Transcript URL

2004-12-21T00:50:00.000-08:00

http://www.microsoft.com/learning/mcp/transcripts

Transcript ID : 683733
Access Code : ashishgupta

Good .NET links

2004-12-20T05:20:00.000-08:00

MSN Spaces link

2004-12-07T02:32:00.000-08:00

http://spaces.msn.com/members/netarena/

Interview Questions for C#

2004-10-26T03:42:00.000-07:00

C# Interview Questions

General Questions

1. Does C# support multiple-inheritance?
No, use interfaces instead.

2. When you inherit a protected class-level variable, who is it available to?
Classes in the same namespace.

3. Are private class-level variables inherited?
Yes, but they are not accessible. Although they are not visible or accessible via the class interface, they are inherited.

4. Describe the accessibility modifier “protected internal”.
It is available to derived classes and classes within the same Assembly (and naturally from the base class it’s declared in).

1. To do: Confirm the “within the same assembly” portion.

5. C# provides a default class constructor for me. I decide to write a constructor that takes a string as a parameter, but want to keep the constructor that has no parameter. How many constructors should I write?
Two. Once you write at least one constructor, C# cancels the freebie constructor, and now you have to write one yourself, even if there’s no implementation in it.

6. What’s the top .NET class that everything is derived from?
System.Object.

7. What does the term immutable mean?

1. answer the question.

8. What’s the difference between System.String and System.StringBuilder classes?
System.String is immutable. System.StringBuilder was designed with the purpose of having a mutable string where a variety of operations can be performed.

9. What’s the advantage of using System.Text.StringBuilder over System.String?
StringBuilder is more efficient in cases where there is a large amount of string manipulation. Strings are immutable, so each time it’s being operated on, a new instance is created.

10. Can you store multiple data types in System.Array?
No.

11. What’s the difference between the System.Array.CopyTo() and System.Array.Clone()?
The first one performs a deep copy of the array, the second one is shallow.

1. To do: improve the answer.

12. How can you sort the elements of the array in descending order?
By calling Sort() and then Reverse() methods.

13. What’s the .NET class that allows the retrieval of a data element using a unique key?
HashTable.

14. What class is underneath the SortedList class?
A sorted HashTable.

15. Will the finally block get executed if an exception has not occurred?
Yes.

16. What’s the C# equivalent of C++ catch (…), which was a catch-all statement for any possible exception?
A catch block that catches the exception of type System.Exception. You can also omit the parameter data type in this case and just write catch {}.

1. To do: Bad question. Re-word.

17. Can multiple catch blocks be executed?
No. Once the proper catch code fires off, the control is transferred to the finally block (if there are any), and then whatever follows the finally block.

18. Explain the three services model commonly know as a three-tier application.
Presentation (UI), business (logic and underlying code) and data (from storage or other sources).

19. What is the role of the DataReader class in ADO.NET connections?
It returns a read-only dataset from the data source when the command is executed.

1. To do: Improve the answer.

Class Questions

20. How do you inherit from a class in C#?
Place a colon and then the name of the base class.

21. Can you prevent your class from being inherited by another class?
Yes. The keyword “sealed” will prevent the class from being inherited.

22. Can you allow a class to be inherited, but prevent the method from being over-ridden?
Yes. Just leave the class public and make the method sealed.

23. What’s an abstract class?
A class that cannot be instantiated. An abstract class is a class that must be inherited and have the methods overridden. An abstract class is essentially a blueprint for a class without any implementation.

24. When do you absolutely have to declare a class as abstract?

1. When at least one of the methods in the class is abstract.

2. When the class itself is inherited from an abstract class, but not all base abstract methods have been overridden.

25. What’s an interface class?
It’s an abstract class with public abstract methods all of which must be implemented in the inherited classes.

26. Why can’t you specify the accessibility modifier for methods inside the interface?
They all must be public. Therefore, to prevent you from getting the false impression that you have any freedom of choice, you are not allowed to specify any accessibility, it’s public by default.

1. To do: Clean up this answer.

27. Can you inherit multiple interfaces?
Yes, why not.

1. To do: Need a better answer.

28. And if they have conflicting method names?
It’s up to you to implement the method inside your own class, so implementation is left entirely up to you. This might cause a problem on a higher-level scale if similarly named methods from different interfaces expect different data, but as far as compiler cares you’re okay.

29. What’s the difference between an interface and abstract class?
In an interface class, all methods must be abstract. In an abstract class some methods can be concrete. In an interface class, no accessibility modifiers are allowed, which is ok in an abstract class.

30. What is the difference between a Struct and a Class?
Structs are value-type variables and are thus saved on the stack -> additional overhead but faster retrieval. Another difference is that structs CANNOT inherit. (questions courtesy of Eyal)

Method and Property Questions

31. What’s the implicit name of the parameter that gets passed into the set method/property of a class?
value. The data type of the value parameter is defined by whatever data type the property is declared as.

32. What does the keyword “virtual” declare for a method or property?
The method or property can be overridden.

33. How is method overriding different from method overloading?
When overriding a method, you change the behavior of the method for the derived class. Overloading a method simply involves having another method with the same name within the class.

34. Can you declare an override method to be static if the original method is non-static?
No. The signature of the virtual method must remain the same, only the keyword virtual is changed to keyword override.

1. To do: Re-word the answer for better clarity.

35. Can you override private virtual methods?
No. Private methods are not accessible outside the class.

1. Original answer: No, moreover, you cannot access private methods in inherited classes, have to be protected in the base class to allow any sort of access.

2. To do: Can a private method even be declared a virtual?

36. What are the different ways a method can be overloaded?
Different parameter data types, different number of parameters, different order of parameters.

37. If a base class has a number of overloaded constructors, and an inherited class has a number of overloaded constructors; can you enforce a call from an inherited constructor to a specific base constructor?
Yes, just place a colon, and then keyword base (parameter list to invoke the appropriate constructor) in the overloaded constructor definition inside the inherited class.

1. To do: question is to complex. It can be stated better.

38. Why is it a bad idea to throw your own exceptions?
Well, if at that point you know that an error has occurred, then why not write the proper code to handle that error instead of passing a new Exception object to the catch block?
Throwing your own exceptions signifies some design flaws in the project.

39. What’s a delegate?
A delegate object encapsulates a reference to a method.

40. What’s a multicast delegate?
It’s a delegate that points to and eventually fires off several methods.

1. To do: Need a better answer.

Assembly Questions

41. How is the DLL Hell problem solved in .NET?
Assembly versioning allows the application to specify not only the library it needs to run (which was available under Win32), but also the version of the assembly.

42. What are the ways to deploy an assembly?
An MSI installer, a CAB archive, and XCOPY command.

43. What is a satellite assembly?
When you write a multilingual or multi-cultural application in .NET, and want to distribute the core application separately from the localized modules, the localized assemblies that modify the core application are called satellite assemblies.

44. What namespaces are necessary to create a localized application?
System.Globalization and System.Resources.

XML Documentation Questions

45. What’s the difference between // comments, /* */ comments and /// comments?
Single-line comments, multi-line comments, and XML documentation comments.

46. How do you generate documentation from the C# file commented properly with a command-line compiler?
Compile it with the /doc switch.

47.What is the difference between and XML documentation tag?
Single line code example and multiple-line code example.

1. To do: Bad question

48. Is XML case-sensitive?
Yes.

Debugging and Testing Questions

49. What debugging tools come with the .NET SDK?

1. CorDBG – command-line debugger. To use CorDbg, you must compile the original C# file using the /debug switch.

2. DbgCLR – graphic debugger. Visual Studio .NET uses the DbgCLR.

50. What does the “This” window show in the debugger?
It points to the object that’s pointed to by this reference. Object’s instance data is shown.

1. To do: Need a better answer.

51. What does assert() method do?
In debug compilation, assert takes in a Boolean condition as a parameter, and shows the error dialog if the condition is false. The program proceeds without any interruption if the condition is true.

52. What’s the difference between the Debug class and Trace class?
Documentation looks the same. Use Debug class for debug builds, use Trace class for both debug and release builds.

53. Why are there five tracing levels in System.Diagnostics.TraceSwitcher?
The tracing dumps can be quite verbose. For applications that are constantly running you run the risk of overloading the machine and the hard drive. Five levels range from None to Verbose, allowing you to fine-tune the tracing activities.

54. Where is the output of TextWriterTraceListener redirected?
To the Console or a text file depending on the parameter passed to the constructor.

55. How do you debug an ASP.NET Web application?
Attach the aspnet_wp.exe process to the DbgClr debugger.

56. What are three test cases you should go through in unit testing?

1. Positive test cases (correct data, correct output).

2. Negative test cases (broken or missing data, proper handling).

3. Exception test cases (exceptions are thrown and caught properly).

57. Can you change the value of a variable while debugging a C# application?
Yes. If you are debugging via Visual Studio.NET, just go to Immediate window.

ADO.NET and Database Questions

58. What are advantages and disadvantages of Microsoft-provided data provider classes in ADO.NET?
SQLServer.NET data provider is high-speed and robust, but requires SQL Server license purchased from Microsoft. OLE-DB.NET is universal for accessing other sources, like Oracle, DB2, Microsoft Access and Informix. OLE-DB.NET is a .NET layer on top of the OLE layer, so it’s not as fastest and efficient as SqlServer.NET.

59. What is the wildcard character in SQL?
Let’s say you want to query database with LIKE for all employees whose name starts with La. The wildcard character is %, the proper query with LIKE would involve ‘La%’.

60. Explain ACID rule of thumb for transactions.
A transaction must be:

1. Atomic - it is one unit of work and does not dependent on previous and following transactions.

2. Consistent - data is either committed or roll back, no “in-between” case where something has been updated and something hasn’t.

3. Isolated - no transaction sees the intermediate results of the current transaction).

4. Durable - the values persist if the data had been committed even if the system crashes right after.

61. What connections does Microsoft SQL Server support?
Windows Authentication (via Active Directory) and SQL Server authentication (via Microsoft SQL Server username and password).

62. Which one is trusted and which one is untrusted?
Windows Authentication is trusted because the username and password are checked with the Active Directory, the SQL Server authentication is untrusted, since SQL Server is the only verifier participating in the transaction.

1. To do: ask the question better.

63. Why would you use untrusted verificaion?
Web Services might use it, as well as non-Windows applications.

1. To do: answer better.

64. What does the Initial Catalog parameter define in the connection string?
The database name to connect to.

65. What is the data provider name to connect to an Access database?
Microsoft.Access.

66. What does the Dispose method do with the connection object?
Deletes it from the memory.

1. To do: answer better. The current answer is not entirely correct.

67. What is a pre-requisite for connection pooling?
Multiple processes must agree that they will share the same connection, where every parameter is the same, including the security settings. The connection string must be identical.

maintain scroll position

2004-10-26T03:36:00.000-07:00

///

/// Registers a _javascript method that will bring the focus of the page
/// to a specific control when the page loads.
///

/// The ID of the control to focus on.
/// The page the control belongs to.
public static void RegisterControlFocusScript(string controlID, Page
target)
{
string script = "\r\n\r\n " function focus() {\r\n" +
" var target;\r\n" +
" target = document.getElementById('" +
controlID + "');\r\n" +
" if (target != null) {\r\n" +
" target.focus();\r\n" +
" }\r\n" +
" }\r\n" +
" window.onfiltered=focus;\r\n" +
"\r\n";

target.RegisterClientScriptBlock("focus", script);
}

Editor tips and tricks in VS.NET

2004-10-10T23:45:00.000-07:00

dotnetJiNi.com - Blogs @ Jignesh Desai: "Matching Braces
If you program in c# where you find yourself lost in brace wonderland. All you need to do is to press CTRL + } to match the brace that your cursor is next to. This obviously makes life easier with nested ifs/fors/whiles/etc

Wrap/Unwrap
If you are in the habit of writing long lines to preserve your code readability, you can toggle word wrap using CTRL + R twice. That way your code is neat and tidy, but can be viewed without moving way out to the end of the line and back (which is a horrible pain) when you need to see what's going on.

Full Screen
press ALT + SHIFT + ENTER That will toggle your view to full screen. Pretty nice.

Pane toggling
It's always good to be able to ALT + TAB between different applications on your box. If you use CTRL + F6 you can do the same thing with panes in VS.NET. "

Yahoo! Mail - ashish_cal5@yahoo.com

2004-09-23T07:25:00.000-07:00

Yahoo! Mail - ashish_cal5@yahoo.com

Public keys and public key tokens

2004-09-23T06:00:00.000-07:00

spent some time this morning doing some "dotting the i's work" on my metadata engine. One of the things that I've been holding out implementing for a while because it wasn't particularly important in my test cases was adding some code that would generate efficient assembly references to strongly-named assemblies.

Strongly-named assemblies contain the signer's public key embedded in the assembly. You can see this by opening up the assembly using ILDASM and viewing its manifest. Inside the manifest, there must be a .publickey section if that assembly has a strong name. If you look at one of these sections, you'll see that it is rather large. For example, System.Web.dll's public key is 160 bytes in length.

When one assembly references a strongly-named assembly, it must embed a reference to the strongly-named assembly's public key to ensure that an attacker cannot substitute another assembly for the one that it was expecting to find. The simplest solution would be to simply embed the strongly-named assembly's public key in the referencing assembly. As you can see, however, this is not a very efficient solution due to the large size of the public keys.

Microsoft solves the "public key bloat" problem by using a hash of the strongly-named assembly's public key. These hashes are referred to as public key tokens, and are the low 8 bytes of the SHA1 hash of the strongly-named assembly's public key. SHA1 hashes are 160 bit (20 byte) hashes, and the top 12 bytes of the hash are simply discarded in this algorithm.

Calculating the SHA1 hash of an assembly's public key turns out to be really straightforward using the CryptoAPI hashing functions. Here's a simple piece of code that will generate an SHA1 hash:

bool CalculatePublicKeyToken( const unsigned char *publicKey, ULONG publicKeyLen )
{
if( 0 == publicKeyLen )
return true;

bool result = false;
HCRYPTPROV hProv = 0;
HCRYPTHASH hHash = 0;
unsigned char buffer[ 20 ];
DWORD bufferLen = 20;

if( CryptAcquireContext( &hProv, 0, 0, PROV_RSA_FULL, 0 ) )
{
if( CryptCreateHash( hProv, CALG_SHA1, 0, 0, &hHash ) )
{
if( CryptHashData( hHash, publicKey, publicKeyLen, 0 ) )
{
if( CryptGetHashParam( hHash, HP_HASHVAL, buffer, &bufferLen, 0 ) )
{
DumpPublicKeyToken( buffer, bufferLen );
result = true;
}
}
}
}

if( hHash ) CryptDestroyHash( hHash );
if( hProv ) CryptReleaseContext( hProv, 0 );

return result;
}

It is also possible to use the StrongNameTokenFromAssembly API defined in the StrongName.h header file in the Framework SDK. However, this API assumes that the assembly isn't loaded already, which certainly isn't the case in my code.

Difference between ODBC and OLEDB

2004-09-22T04:30:00.000-07:00

First of all both are API for database access.
The differences between these two data access protocols are technical, but in the most general terms, OLE DB is newer, more advanced, and compatible with a wider selection of database technologies. In addition, OLE DB is more general, in that it includes the ODBC functionality.

Technically speaking, ODBC (Open Database Connectivity) is designed to provide access primarily to SQL data in a multi-platform environment. OLE DB (Object Linking and Embedding Database) is designed to provide access to all types of data in an OLE Component Object Model (COM) environment. OLE DB includes the SQL functionality defined in ODBC but also defines interfaces suitable for gaining access to data other than SQL data.

you can vist this page for details http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnodbc/html/msdn_ole4odbc.asp.

Conversion : datareader into array

2004-09-08T03:52:00.000-07:00

private Object[] PopulateReportRecordFromSqlReader(IDataReader reader)
{
//Add One More for ID
int length = reader.FieldCount + 1;

Object[] data = new Object[length];

for(int i =0 ; i < length ; i++)
{
if(i==0)
{
data[0] = i;
}
else
{
data[i] = reader[i-1];
}
}
return data;
}

Efficient string manipulation

2004-09-08T00:47:00.000-07:00

Avoid Returning null Instead of Array, String, or Collection

In almost all situations except when performance can be an issue (e.g.
heavily looped or performance tuned code), null should not be returned
from a method that returns an array, string, collections, ArrayList,
BitArray, HashTable, Queue, SortedList, or Stack. It should not be
necessary for a user of a method to handle a null that is returned
from a method. Instead only empty or zero-length data types such as 0
item arrays, empty strings (String.Empty), and 0 item collections
should be returned.

Avoid Checking String Equality Using == and = Operators

Using == operator in C# and = operator in Visual Basic to compare
strings is slower than using the System.String.Equals method. In
addition, if you need to do case sensitive or insensitive comparisons
the System.String.Compare method is the preferred way to do so. The
String.Compare method can compare two strings based on their
alphabetical sort order as well, something that is important in
developing applications for the international market.

Testing for Empty Strings

The most efficient method to determine if a string is empty is via
it's Length property.

[C#]
if(var1.Length < 1)

[Visual Basic]
If (var1.Length < 1) Then

Avoid Hard Coded String Literals

Use String.Empty rather than "" for empty strings. Other strings
should be placed in a constants class.
[C#]
string var1 = ""; // Avoid
string var2 = String.Empty; // Recommended

[Visual Basic]
Dim var1 As String = "" ' Avoid
Dim var2 As String = String.Empty ' Recommended

Server.Transfer Vs. Response.Redirect

2004-09-07T08:30:00.000-07:00

1.Server.Transfer. Where possible, use the Server.Transfer method
instead of the Response.Redirect method. Response.Redirect sends a response header to the client that causes the client to send a new request to the redirected server by using the new URL. Server.Transfer avoids this level of indirection by simply making a server-side call.

2. You cannot always just replace Response.Redirect calls with
Server.Transfer calls because Server.Transfer uses a new handler during the handler phase of request processing. If you need authentication and authorization checks during redirection, use Response.Redirect instead of Server.Transfer because the two mechanisms are not equivalent. When you use Response.Redirect, ensure you use the overloaded method that accepts a Boolean second parameter, and pass a value of false to ensure an internal
exception is not raised.

3. Also note that you can only use Server.Transfer to transfer control to pages in the same application. To transfer to pages in other applications,you must use Response.Redirect.

ViewState: All You Wanted to Know

2004-08-30T01:14:00.000-07:00

ASPAlliance.com : The #1 ASP.NET Community : ViewState: All You Wanted to Know

To get a list of all the procedures created or updated recently, simply run this query in SQL Server

2004-08-27T06:02:00.000-07:00

SELECT
ROUTINE_NAME, CREATED, LAST_ALTERED
FROM
INFORMATION_SCHEMA.ROUTINES
WHERE
ROUTINE_TYPE = 'PROCEDURE'
ORDER BY LAST_ALTERED DESC"

One can not create folders of name like NUL, AUX, CON, COM1-4, LPT1-3, and PRN

2004-08-27T05:43:00.000-07:00

U cant Create these folders 'coz

NUL, AUX, CON, COM1-4, LPT1-3, and PRN
are reserved words used for Devices

These are specified in IO.SYS. Here is a list:

CLOCK$ - System clock
CON - Console; combination of keyboard and screen to handle input and
output
AUX or COM1 - First serial communicationport
COMn - Second, Third, ... communicationport
LPT1 or PRN - First parallel port
NUL - Dummy port, or the 'null device' which we all know under Linux as
/dev/null.
CONFIG$ - Unknown

con, aux and prn stand for 'console', 'auxiliary' and 'printer' and stand
for output devices."

Protecting Files with ASP.NET

2004-08-26T06:36:00.000-07:00

ASP.NET.4GuysFromRolla.com: Protecting Files with ASP.NET

Determining the names and ordinal values for exported functions

2004-08-16T07:11:00.000-07:00

CodeNotes� - Article Display

Check whether a dll calls a fucntion

2004-08-16T06:48:00.000-07:00

It is difficult to determine whether executable content can be trusted. One test is to use the DumpBin tool to determine if the executable code makes calls to certain APIs. DumpBin is included with many Win32 API developer tools.

To use DumpBin to check for calls made
1.
At the command prompt, to determine whether MyISAPI.dll calls RevertToSelf(), type

dumpbin /imports MyISAPI.DLL | find "RevertToSelf"

If no result appear, MyISAPI.dll does not call RevertToSelf() directly. It might call the API through LoadLibrary(), in which case you should search for this.

My Google Licence key

2004-08-16T00:40:00.000-07:00

0VCqh3pQFHK8GIA0l8WVCpf+F2vrMyKV

Google talks

2004-08-16T00:09:00.000-07:00

Google talk a
Google Hack by
Douwe Osinga

How to embed .Net User control in an Html Page

2004-07-28T04:00:00.000-07:00

it is possible to embed a .net user control in an HTML page.
You have to use html Object tag, to do so.... as shown below.
classid="http://127.0.0.1/SampleControl.dll#Test.SampleControl">

Retrive records without column name

2004-07-28T03:59:00.000-07:00

Create a Stored Procedure or Function using following script, and pass
tablename and NoOfColumns as Input Parameters. You problem is solved

Declare @TableName nvarchar(1000)
Declare @NoOfColumns Int
Set @NoOfColumns = 3
Set @TableName = 'Stores'

Declare @ID INT
Declare @SqlString nvarchar(3000), @SqlString1 nvarchar(3000)
Set @SQLString = 'Select '
Select @ID = id From SYSOBJECTS WHERE xtype = 'U' and Name = @TableName
Declare @SQlParameters nvarchar(1000)
Set @SqlParameters = N'@SQLString nvarchar(3000)
OUTPUT, @ID Int'
Set @SqlString1 = 'Select Top ' + Cast(@NoOfColumns as varchar(5)) + '
@SQLString = @SQLString + '' '' + name + '','' From SYSCOLUMNS WHERE id =
@ID order by colid'
PRINT @SQLString1
Exec sp_executesql @SqlString1, @SqlParameters, @SqlString OUTPUT, @ID
SeT @SQLString = Left(@SqlString, Len(@SqlString) - 1) + ' From ' +
@tablename
Exec sp_executesql @SqlString

ListDictionary Class

2004-07-23T04:48:00.000-07:00

ListDictionary Class:

It is smaller and faster than a Hashtable if the number of elements is 10 or less.

ListDictionary Class: "ListDictionary Class"

Google Search: c# design patterns intro

2004-07-21T07:22:00.000-07:00

Google Search: c# design patterns intro