Book for architect

97 Things Every Software Architect Should Know

Loading large files as attachment in sql server

CREATE TABLE [dbo].[TEMP_ATTACH](
[DOCID] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FILE_NAME] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ATTACHMENT] [varbinary](max) NULL,
[FULL_NAME] [varchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

declare @path varchar(100)
declare @filename Nvarchar(500)
SET @path = 'C:\Attachments\'
declare att_cursor cursor fast_forward for
select [full_name] from temp_attach

open att_cursor
fetch next from att_cursor into
@filename

while @@fetch_status = 0
begin

EXEC ('UPDATE TEMP_ATTACH
SET ATTACHMENT = BulkColumn
FROM OPENROWSET (BULK ''' + @path + @filename + ''', SINGLE_BLOB) MyFile
WHERE [full_name] = ''' + @filename + '''')

fetch next from att_cursor into
@filename
end
CLOSE att_cursor
DEALLOCATE att_cursor

remove all the options in the dropdown select box.

Use this JavaScript to remove all the options in the dropdown select box.

document.getElementById('Dropdown').length = 0;

update a table from other table sql server

update Employee set email = lgfl.xx_email
from DB2.dbo.directEmployee lgfl join Employee on Employee.emp_name = lgfl.emp_name
where Employee.emp_id = dept.emp_id

GridView with BoundField which was setup to format date field with DataFormatString but string formatting is not working

html encoding is applied by default for the data before it is formatted. Therefore set HtmlEncode="false" to the BoundField so that formatting has expected effect.


http://aspadvice.com/blogs/joteke/archive/2005/09/25/12871.aspx


http://www.netnewsgroups.net/group/microsoft.public.dotnet.framework.aspnet/topic24899.aspx