Asp.Net Resources

Interface not registered in SSIS

2010-06-08T12:58:00.000-07:00

Got the following error message when I make a new integration service projct

Failed to save package file "C:\Documents and Settings\Administrator\Local Settings\Temp\1\tmp2B.tmp" with error 0x80040155 "Interface not registered".

Just run these two commands from the command prompt:
regsvr32 msxml3.dll
regsvr32 msxml6.dll

Reportviewer 8.0 and 9.0 Issue

2010-05-27T15:51:00.001-07:00

MAIL

2010-05-26T19:59:00.000-07:00

--------------

Imports System.Net.Mail

sendmail(comments.text, body.text)
------------------

Private Sub sendmail(ByVal from As String, ByVal body As String)
Dim mailservername As String = "smtp.SASDED.com"
Dim message As MailMessage = New MailMessage(from, "", "Email from :: ASK US", body)
Dim mailclient As SmtpClient = New SmtpClient

mailclient.Host = mailservername
mailclient.Send(message)
message.Dispose()
End Sub

SUBST

2010-05-24T17:54:00.001-07:00

Subst

Associates a path with a drive letter. Used without parameters, subst displays the names of the virtual drives in effect.

Syntax
subst [drive1: [drive2:]Path]

subst drive1: /d

Top of page
Parameters
drive1: : Specifies the virtual drive to which you want to assign a path.

drive2: : Specifies the physical drive that contains the specified path (if different from the current drive).

Path : Specifies the path that you want to assign to a virtual drive.

/d : Deletes a virtual drive.

/? : Displays help at the command prompt.

Top of page
Remarks
• The following commands do not work, or should not be used, on drives used in the subst command:

• chkdsk

• diskcomp

• diskcopy

• format

• label

• recover

• The drive1 parameter must be within the range specified by the lastdrive command. If not, subst displays the following error message:

Invalid parameter - drive1:

Top of page
Examples
To create a virtual drive Z for the path B:\User\Betty\Forms, type:

subst z: b:\user\betty\forms

Now, instead of typing the full path, you can reach this directory by typing the letter of the virtual drive, followed by a colon, as follows:

z:

Report Processing

2010-04-28T14:17:00.001-07:00

Imports Microsoft.Reporting.WebForms
Dim datasourceid As New Microsoft.Reporting.WebForms.ReportDataSource
Dim strdatasource As String
Select Case op_level_selection.SelectedValue
Case 1
strdatasource = "reports/Main.rdlc"
With ReportViewer1
.Reset()
.ProcessingMode = ProcessingMode.Local
.LocalReport.ReportPath = strdatasource
.LocalReport.DataSources.Clear()
datasourceid.DataSourceId = "ods_main_data"
datasourceid.Name = "DS_MAIN"
.LocalReport.DataSources.Add(datasourceid)
.DocumentMapCollapsed = True
.LocalReport.Refresh()
.Visible = True
End With

2010-04-19T11:34:00.001-07:00

If you aren't located in the US, you may be interested in another adjustment I've made to the tagset, that of the paper size. By default it is set to "0" which is interpreted as Undefined. For us, that results in it trying to print to "letter" sized paper which is only (I believe) used in the states. To set it to A4, you need to find the line:-

CODE
put '0' nl;
and change it to

CODE
put '9' nl;

Other valid papersize values and meanings are listed here:-

CODE
Paper Size Table
Index Paper type Paper size
----------------------------------------------------
0 Undefined
1 Letter 8 1/2" x 11"
2 Letter small 8 1/2" x 11"
3 Tabloid 11" x 17"
4 Ledger 17" x 11"
5 Legal 8 1/2" x 14"
6 Statement 5 1/2" x 8 1/2"
7 Executive 7 1/4" x 10 1/2"
8 A3 297mm x 420mm
9 A4 210mm x 297mm
10 A4 small 210mm x 297mm
11 A5 148mm x 210mm
12 B4 250mm x 354mm
13 B5 182mm x 257mm
14 Folio 8 1/2" x 13"
15 Quarto 215mm x 275mm
16 10" x 14"
17 11" x 17"
18 Note 8 1/2" x 11"
19 #9 Envelope 3 7/8" x 8 7/8"
20 #10 Envelope 4 1/8" x 9 1/2"
21 #11 Envelope 4 1/2" x 10 3/8"
22 #12 Envelope 4 3/4" x 11"
23 #14 Envelope 5" x 11 1/2"
24 C Sheet 17" x 22"
25 D Sheet 22" x 34"
26 E Sheet 34" x 44"
27 DL Envelope 110mm x 220mm
28 C5 Envelope 162mm x 229mm
29 C3 Envelope 324mm x 458mm
30 C4 Envelope 229mm x 324mm
31 C6 Envelope 114mm x 162mm
32 C65 Envelope 114mm x 229mm
33 B4 Envelope 250mm x 353mm
34 B5 Envelope 176mm x 250mm
35 B6 Envelope 125mm x 176mm
36 Italy Envelope 110mm x 230mm
37 Monarch Envelope 3 7/8" x 7 1/2"
38 6 3/4 Envelope 3 5/8" x 6 1/2"
39 US Standard Fanfold 14 7/8" x 11"
40 German Std. Fanfold 8 1/2" x 12"
41 German Legal Fanfold 8 1/2" x 13"

rdlc code based DataSource

2010-04-15T18:15:00.001-07:00

rdlc code based DataSource?
Skip_Frog
Okay I have the below code.

Dim da As SqlDataAdapter
Dim ds As DataSet
da = New SqlDataAdapter("Select Distinct [OP Number] from MasterShimSel", frmMain.sConn)
ds = New DataSet("Test")
da.Fill(ds, "Test")
Dim dsname As String = "ds"
Dim rs As New Microsoft.Reporting.WinForms.ReportDataSource(dsname, ds.Tables(0))
Me.ReportViewer1.LocalReport.DataSources.Add(rs)

http://www.windows-tech.info/15/8d7972f9bf31e44d.php http://www.windows-tech.info/

2010-03-03T11:40:00.001-08:00

LEFT({ fn MONTHNAME(RIGHT(YYYYMM, 2) + '/' + '1' + '/' + LEFT(YYYYMM, 4)) } + ' ' + LEFT(YYYYMM, 4), 3) + '-' + SUBSTRING(CAST(YYYYMM AS nvarchar), 3, 2) as Month

ResponseHelper.Redirect("SiteChanges.aspx", "_blank", "menubar=0,width=700,height=768,scrollbars=1")

IMAGE INTO THE REPORTVIEWER

2009-12-03T12:36:00.000-08:00

Query: How to put Images in Reports (Microsoft ReportViewer) through code at runtime/dynamically?

You can achieve this with charm. You can easily have images on your report, even the images that are on the Web.

Assumption:

This article assumes that a user has basic idea about RDLC, Microsoft ReportViewer and DataSource. This Article does not teach the basics of how to generate Reports in Microsoft Report Viewer.

To learn about ReportViewer and how to build reports, read this free book by Mahesh Chand:
Reports using Report Viewer in Visual Studio 2005.

In ReportViewer, you have 2 options for images: External or Embedded.

1. Embedded:

If you have images in your application and you want to use them.

Stage I: Then, you first need to embed the images in to be used in Reports. To embed an image in Reports:
a) Open the RDLC File.
b) Go to the Menu Item: Report > Embedded Images. Click on: New Image.
c) Browse for the image. Edit Name for the image chosen as desired (example, here: TestImage). OK.

Stage II:
d) Use an Image control on your RDLC file.
e) Set the Image's Property-Source = Embedded.
f) Reserve a Report's DataSource Member for the image Path. For example- DataSource.ImgPath.
g) Set the value for image path from the code in DataSource.ImgPath.
For example: DataSource.ImgPath = "TestImage";
h) Do the normal stuff to bind DataSource etc.
i) Done. Enjoy your image in the Report.

2. External:

If you do not have images in your Application. That is, you want to use an external image.

a. Use an Image control on your RDLC file.
b. Set the Image's Property-Source = External.
c. Reserve a Report's DataSource Member for the image Path. For example- DataSource.ImgPath.
d. Set the value for image path from the code in DataSource.ImgPath.
For example: DataSource.ImgPath = "http://www.google.com/intl/en_ALL/images/logo.gif";
e. The following self explanatory code also needs to be written:
reportViewer1.LocalReport.EnableExternalImages = true; (reportViewer1 is the Name for the ReportViewer Control)
f. Do the normal stuff to bind DataSource etc.
g. Done. Enjoy your image in the Report.

Excel Import

2009-11-23T13:41:00.000-08:00

Separate two words from a cell in two cells

Tom Swift =RIGHT(A1,LEN(A1)-FIND(" ",A1)) =LEFT(A1,FIND(" ",A1)) By find space. Swift Tom =RIGHT(A2,LEN(A2)-FIND(" ",A2)) =LEFT(A2,FIND(" ",A2)) By find space. Peters, Willy =RIGHT(A3,LEN(A3)-FIND(",",A3)-1) =LEFT(A3,FIND(",",A3)-1) By find comma. Willy, Peters =RIGHT(A4,LEN(A4)-FIND(",",A4)-1) =LEFT(A4,FIND(",",A4)-1) By find comma.

If "name address" is in cell A1, in cell B1 type this formula : =MID(A1,1,SEARCH(" ",A1))
Then in cell C1 type this formula: =MID(A1,SEARCH(" ",A1)+1,20)

2009-08-28T19:19:00.000-07:00

YYYYMM = LTRIM(RTRIM(REPLACE(CONVERT(varchar(7), GETDATE(), 126), '-', '')))

2009-08-25T15:43:00.001-07:00

EXEC sp_spaceused
EXEC sp_spaceused 'TBL_MART_ENCOUNTER'
EXEC sp_MSforeachtable @command1="EXEC sp_spaceused '?'"
--The following example demonstrates this with the pubs database and attempts to shrink the pubs_log file to 2 MB:
DBCC SHRINKFILE(pubs_log, 2)

--NOTE: If the target size is not reached, proceed to the next step.
--Run this code if you want to truncate the transaction log and not
--keep a backup of the transaction log. Truncate_only invalidates your
--transaction log backup sequence. Take a full backup of your database
--after you perform backup log with truncate_only:
BACKUP LOG pubs WITH TRUNCATE_ONLY

--or-
--Run this code if you want to keep a backup of your transaction log and
--keep your transaction log backup sequence intact. See SQL Server Books
--Online topic "BACKUP" for more information:
BACKUP LOG pubs TO pubslogbackup

--Run this code:
DBCC SHRINKFILE(pubs_log,2)

--Depending on your recovery model, you might be able to simply run this command to manually truncate the log:
BACKUP LOG WITH TRUNCATE_ONLY

BACKUP LOG TestDB TO DISK='C:\TestDB1.bak'

--Shrink the transaction log file. To do this, run a Transact-SQL statement
--that is similar to the following Transact-SQL statement.
DBCC SHRINKFILE (, ) WITH NO_INFOMSGS

--Since the "shrink database" command within SQL 2000 Enterprise
--Manager doesn't always seem to do what you'd expect, here is the command to run in Query --Analyzer.
backup log db_name_here with truncate_onlydbcc shrinkfile(db_log_filename_here,truncateonly)

http://andieko.web.id/sql-server-2000/shrink-transaction-log-on-sql-server-2000-part-1/

2009-08-12T13:19:00.001-07:00

I found the RowDataBound Event to work the best for me without a lot of additional overhead code. Basically the code makes sure the row is a data row, looks to see if column 3 (cells(2)) is equal to "1", if it is then make the entire row yellow and color cell 3 of the row crimson.

1 Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowDataBound
2 If e.Row.RowType = DataControlRowType.DataRow Then
3 If e.Row.Cells(2).Text = "1" Then
4 e.Row.BackColor = System.Drawing.Color.Yellow
5 e.Row.Cells(2).BackColor = Drawing.Color.Crimson
6 End If
7 End If
8 End Sub

Reading the column name as datafield

2009-08-11T17:31:00.000-07:00

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE (TABLE_NAME = 'tbl_test_bbb'nook725hone481)

Reportviewer Fixes

2009-08-04T13:37:00.001-07:00

This one almost works with everything....except the postback doesn't work. This has been posted on ASP.NET newsgroups and Yahoo. Answers since last week.
This is what we are working on now,

2009-08-03T14:17:00.000-07:00

Handling Concurrency Issues in .NET
By Wayne Plourde

http://www.15seconds.com/Issue/030604.htm

Military Time Calculation

2009-07-28T17:37:00.001-07:00

Dim startTime As String = "330"
Dim stopTime As String = "1224"

startTime = startTime.PadLeft(4, "0")
stopTime = stopTime.PadLeft(4, "0")
Dim dtA As DateTime = DateTime.ParseExact(startTime, "HHmm", Nothing)
Dim dtB As DateTime = DateTime.ParseExact(stopTime, "HHmm", Nothing)
Dim ts As TimeSpan = dtB.Subtract(dtA)

Debug.Print("Time: " & ts.Hours & ":" & ts.Minutes.ToString("00"))

2009-07-20T12:44:00.000-07:00

If statement in the ACCESS:
iif (fieldname is null, 0, fieldname)

Udate any field with the leading Zero(s):
UPDATE table_name
IDENTITY_ID = RIGHT('0000' + IDENTITY_ID, 4)

2009-06-08T13:59:00.000-07:00

Date Calculation:

Dim age_to_date As DateTime = DateTime.Parse(age_to.Text)
Dim age_from_date As DateTime = DateTime.Parse(age_from.Text)

Dim age_to_ As DateTime = Convert.ToDateTime(age_to_date)
Dim year_to As String = age_to_.Year.ToString()
Dim month_to As String = age_to_.Month()
Dim day_to As String = age_to_.Day()

Dim age_from_ As DateTime = Convert.ToDateTime(age_from_date)
Dim year_from As String = age_from_.Year.ToString()
Dim month_from As String = age_from_.Month()
Dim day_from As String = age_from_.Day()

Dim age_years As Integer = Math.Abs(Convert.ToInt16(year_to) - Convert.ToInt16(year_from))
Dim age_months As Integer = Math.Abs(Convert.ToInt16(month_to) - Convert.ToInt16(month_from))
Dim age_days As Integer = Math.Abs(Convert.ToInt16(day_to) - Convert.ToInt16(day_from))

display_age.Text = age_years.ToString() & " years " & age_months.ToString() & " months " & age_days.ToString() & " days"

Date Calculation:
Dim age_to_date As DateTime = DateTime.Parse(age_to.Text)
Dim age_from_date As DateTime = DateTime.Parse(age_from.Text)
Dim age_to_ As DateTime = Convert.ToDateTime(age_to_date)
Dim year_to As String = age_to_.Year.ToString()
Dim month_to As String = age_to_.Month()
Dim day_to As String = age_to_.Day()
Dim age_from_ As DateTime = Convert.ToDateTime(age_from_date)
Dim year_from As String = age_from_.Year.ToString()
Dim month_from As String = age_from_.Month()
Dim day_from As String = age_from_.Day()
Dim age_years As Integer = Math.Abs(Convert.ToInt16(year_to) - Convert.ToInt16(year_from))
Dim age_months As Integer = Math.Abs(Convert.ToInt16(month_to) - Convert.ToInt16(month_from))
Dim age_days As Integer = Math.Abs(Convert.ToInt16(day_to) - Convert.ToInt16(day_from))
display_age.Text = age_years.ToString() & " years " & age_months.ToString() & " months " & age_days.ToString() & " days"

Date time and week number of the year:
It gets the firstdate and lastdate on the asp.net calendar control Maybe that will help.

Dim firstDOW As DayOfWeek
If (Calendar1.FirstDayOfWeek = System.Web.UI.WebControls.FirstDayOfWeek.Default) Then
firstDOW = System.Globalization.DateTimeFormatInfo.CurrentInfo.FirstDayOfWeek
Else
firstDOW = Calendar1.FirstDayOfWeek
End If
If (firstDOW = Calendar1.VisibleDate.DayOfWeek) Then
firstdate = firstdate.AddDays(-7)
Else
While (firstdate.DayOfWeek <> firstDOW)
firstdate = firstdate.AddDays(-1)
End While
End If

Dim lastdate As DateTime = firstdate.AddDays(41)

Date Time:
http://dotnetguts.blogspot.com/search/label/SQL

2009-06-05T19:59:00.001-07:00

Export/Import Data From (SQL/DataGrid) To .csv/.txt Format

Posted by: Scott Schecter on December 02, 2004 in response to Message #143895
Imports System
Imports System.Data
Imports System.Data.OleDb
Imports System.IO

Code :

Private Sub btnSubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSubmit.Click
Dim intFileNameLength As Integer
Dim strFileNamePath As String
Dim strFileNameOnly As String

If Not (UploadFile.PostedFile Is Nothing) Then
strFileNamePath = UploadFile.PostedFile.FileName

intFileNameLength = InStr(1, StrReverse(strFileNamePath), "\")

strFileNameOnly = Mid(strFileNamePath, (Len(strFileNamePath) - intFileNameLength) + 2)
Dim paths = Server.MapPath("/excelreading/")

paths = paths & "Excel/"

'If File.Exists(paths & strFileNameOnly) Then
'lblMessage.Text = "Image of Similar name already Exist,Choose other name"
'Else
If UploadFile.PostedFile.ContentLength > 40000 Then
lblMessage.Text = "The Size of file is greater than 4 MB"
ElseIf strFileNameOnly = "" Then
Exit Sub
Else
strFileNameOnly = Session("AdminID") & "-" & Session("Acountry") & "-" & Format(Date.Today, "mm-dd-yyyy").Replace("/", "-") & ".xls"
UploadFile.PostedFile.SaveAs(paths & strFileNameOnly)
lblMessage.Text = "File Upload Success."
Session("Img") = strFileNameOnly
End If
End If
'End If

Dim myDataset As New DataSet()
Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath("/excelreading/") & "excel/" & strFileNameOnly & ";" & _
"Extended Properties=Excel 8.0;"

''You must use the $ after the object you reference in the spreadsheet
Dim myData As New OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn)
myData.TableMappings.Add("Table", "ExcelTest")
myData.Fill(myDataset)

DataGrid1.DataSource = myDataset.Tables(0).DefaultView
DataGrid1.DataBind()
End Sub

Private Sub btnExportToExcel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnExportToExcel.Click
' Set the content type to Excel.
Response.ContentType = "application/vnd.ms-excel"
' Remove the charset from the Content-Type header.
Response.Charset = ""
' Turn off the view state.
Me.EnableViewState = False

Dim tw As New System.IO.StringWriter()
Dim hw As New System.Web.UI.HtmlTextWriter(tw)

' Get the HTML for the control.
DataGrid1.RenderControl(hw)
' Write the HTML back to the browser.
Response.Write(tw.ToString())
' End the response.
Response.End()
lblMessage.Text = "For any more information , feel free to contact ...!!!"
End Sub

2009-06-02T20:11:00.001-07:00

SELECT tbl_IVR_Output_Temp.phoneno, tbl_IVR_Output_Temp.loc, tbl_IVR_Output_Temp.mrn, tbl_IVR_Output_Temp.pat_name, tbl_IVR_Output_Temp.reason,
tbl_IVR_Output_Temp.state, tbl_IVR_Output_Temp.callback, tbl_IVR_Output_Temp.Langu, tbl_IVR_Output_Temp.id1, tbl_IVR_Output_Temp.id2,
tbl_IVR_Output_Temp.id3, repeatation.month AS Expr1
FROM tbl_IVR_Output_Temp CROSS JOIN
(SELECT CAST(LEFT(SUBSTRING(loc, 2, 8), 4) + RIGHT(SUBSTRING(loc, 2, 8), 4 + '-' + '01 00:00:00' ) AS smalldatetime) AS month
FROM tbl_IVR_Output_Temp AS tbl_IVR_Output_Temp_1
WHERE (phoneno LIKE '99999%')) AS repeatation
WHERE (tbl_IVR_Output_Temp.phoneno NOT LIKE '99999%')

2009-06-01T19:43:00.001-07:00

Good reference by the experts:
http://www.sourcecodeonline.com/sources/asp_net.html
Create buttons for AJAX: http://www.ajaxload.info/#preview
AJAX control toolkit: http://www.asp.net/ajax/ajaxcontroltoolkit/samples/
Nice Demos with third party tools: http://demos.telerik.com/aspnet-ajax/input/examples/radnumerictextbox/formatting/defaultcs.aspx
Ajax control with code...very Nice demo site 1: http://mattberseth2.com/demo/
Very Nice demo site 2: http://www.hanselman.com/blog/
Gridview to Excel: http://aspnetlibrary.com/articledetails.aspx?article=How-to-export-a-GridView-to-Excel
ASP.NET Quickstart Tutorial : http://quickstarts.asp.net/QuickstartV20/aspnet/
Accessing and Updating Data in ASP.NET 2.0: Inserting Data:http://aspnet.4guysfromrolla.com/articles/050207-1.aspx
Windows Scripting: http://www.aspfree.com/c/a/Windows-Scripting/Completing-Calendars-with-VBScript-Date-Functions/
Custom subtotal in a matrix: http://www.windows-tech.info/15/b71686f2d4557925.php
Matrix Reporting: http://www.gotreportviewer.com/matrices/
http://www.devasp.net/default.aspx
CSS Library: http://www.dynamicdrive.com/style/
Excel Calculation Engine: http://www.spreadsheetgear.com/support/samples/calcengine.aspx
Excel Report in asp.net 2.0: http://www.beansoftware.com/asp.net-tutorials/generating-excel-reports.aspx
Export data to SQl server 2005: http://www.ozgrid.com/forum/showthread.php?t=69825
Free Animated GIF: http://www.sevenoaksart.co.uk/
Free Download: http://www.gegereka.com/?
Dropdown listbox inside the gridview: http://www.highoncoding.com/Articles/170_DropDownList%20Inside%20The%20GridView%20Method%202.aspx
More about dropdown in gridview: http://webthingsconsidered.blogspot.com/2005/09/dropdownlist-inside-gridview-or.html
Timeline Project by MIT: http://simile.mit.edu/
Timeline control: http://demos.devexpress.com/ASPxSchedulerDemos/ViewTypes/TimelineView.aspx
More on timeline: http://weblogs.asp.net/rchartier/archive/2008/03/25/timeline-net.aspx
SQL Server Command: http://www.1keydata.com/sql/sql.html
SQL Command: http://www.lazydba.com/
SQL Server More: http://www.sqlservercentral.com/
Free VB.net code: http://www.vbdotnetheaven.com/
More VB.net code: http://www.a1vbcode.com/
Microsoft Discussion group: http://www.microsoft.com/communities/newsgroups/en-us/
Advance Matrix reporting technique: http://www.simple-talk.com/sql/sql-server-2005/advanced-matrix-reporting-techniques/
Nice tutorials: http://www.blackwasp.co.uk/Articles.aspx
Excel Formatting: http://steveorr.net/Articles/ExcelExport.aspx
Mouse Rollover and other CSS: http://www.dynamicdrive.com/dynamicindex1/mouseovertabs.htm

2009-06-01T19:42:00.003-07:00

System.DateTime in ASP.NET
back to DateTime tutorial on csharpfriends
Below are common uses of the DateTime Structure in C#

DateTime.Now; 6/1/2009 7:57:07 PM
DateTime.Now.ToString(); 6/1/2009 7:57:07 PM
DateTime.Now.ToShortTimeString() 7:57 PM
DateTime.Now.ToShortDateString() 6/1/2009
DateTime.Now.ToLongTimeString() 7:57:07 PM
DateTime.Now.ToLongDateString() Monday, June 01, 2009

--------------------------------------------------------------------------------

DateTime.Now.ToString("d") 6/1/2009
DateTime.Now.ToString("D") Monday, June 01, 2009
DateTime.Now.ToString("f") Monday, June 01, 2009 7:57 PM
DateTime.Now.ToString("F") Monday, June 01, 2009 7:57:07 PM
DateTime.Now.ToString("g") 6/1/2009 7:57 PM
DateTime.Now.ToString("G") 6/1/2009 7:57:07 PM
DateTime.Now.ToString("m") June 01
DateTime.Now.ToString("r") Mon, 01 Jun 2009 19:57:07 GMT
DateTime.Now.ToString("s") 2009-06-01T19:57:07
DateTime.Now.ToString("t") 7:57 PM
DateTime.Now.ToString("T") 7:57:07 PM
DateTime.Now.ToString("u") 2009-06-01 19:57:07Z
DateTime.Now.ToString("U") Monday, June 01, 2009 11:57:07 PM
DateTime.Now.ToString("y") June, 2009
DateTime.Now.ToString("dddd, MMMM dd yyyy") Monday, June 01 2009
DateTime.Now.ToString("ddd, MMM d "'"yy") Mon, Jun 1 '09
DateTime.Now.ToString("dddd, MMMM dd") Monday, June 01
DateTime.Now.ToString("M/yy") 6/09
DateTime.Now.ToString("dd-MM-yy") 01-06-09

2009-06-01T19:42:00.001-07:00

System.Web.AspNetHostingPermission when Accessing Network or Intranet Projects using Visual Studio 2005
I rebuilt one of my development machines recently and attempted to access a project that I had out on a network share. I continually received project messages about the project not being trusted. I remembered that I had to change something but couldn't remember what it was until I found an old note I left in Outlook. The message I would receive in Visual Studio 2005 was: ASP.NET runtime error: Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

To resolve this issue, you must change your development machine .net security configuration since you are accessing items across the network. In the event that you need this ability at runtime, you must change the trust level in your config file to full. However, since this is only in development, I can change my local PC's security by going to Start > Control Panel > Administrative Tools > Microsoft .NET Framework 2.0 Configuration. After it fully loads (sometimes takes a bit), fully expand My Computer in the navigation tree and click Runtime Security Policy. In the right hand pane, choose Adjust Zone Security. Leave the default option (Make changes to this computer) and hit next. Choose Local Intranet and change the trust level to Full Trust. Then choose next and then finish. Restart Visual Studio 2005 and you should be all set.

Format number to 0000 in SQL Server 2000 : SQL Server, 2000

2009-05-27T12:45:00.000-07:00

Format number to 0000 in SQL Server 2000 : SQL Server, 2000: "SELECT RIGHT( '0000' + cast(23 as varchar ) , 4)"