 |
Custom Assembly in Reporting Services
|
| Total Hit (1075) |
SQL Server 2000 Reporting Services is a server-based reporting solution that can deliver interactive Web–based reports. This article describes a problem that occurs when you access a custom assembly in your Reporting Services report that does not have sufficient permissions on the resources in your
....Read More |
Rating
 |
|
|
|
Querying the SQL Server System Catalog FAQ
|
| Total Hit (1120) |
Data Types
How do I find the data types of the columns of a specified table?
How do I find the LOB data types of a specified table?
How do I find the columns that depend on a specified data type?
How do I find the computed columns that depend on a specified CLR user-defined type or alias d
....Read More |
| Rating
|
|
 |
Top Questions about the DataGrid Web Server Control
|
| Total Hit (1324) |
Windows Forms versus Web Forms DataGrid Controls
Controlling Column Width, Height, and Alignment
Customizing Column Layout in Display and Edit Mode
Formatting Dates, Currency, and Other Data
Showing and Hiding Columns Dynamically
Adding Columns Dynamically
Adding New Records to a Data Source U
....Read More |
| Rating
|
|
 |
Reusable function to open form by name
|
| Total Hit (2395) |
«code LangId=2»Private Sub showForm(ByVal frmName As String)
Dim frm As Form
frm = AppDomain.CurrentDomain.CreateInstanceAndUnwrap( _
Me.GetType.Assembly.GetName.Name, _
System.String.Concat(Me.GetType.Assembly.GetName.Name, ".", frmName) _
)
frm.Show()
End
....Read More |
| Rating
|
|
|
|
|
|
|
|
SQL Server Reprting Services (SSRS) Report Design Tips and Tricks
|
| Total Hit (3859) |
This white paper covers best practices on report design and helps you avoid common mistakes when choosing a report layout and output format. Take advantage of existing product features to achieve the results you want. The paper includes report and code examples that implement functionality that is f
....Read More |
| Rating
|
|
|
|
The implementation of Flags using bitwise operators
|
| Total Hit (1010) |
Bitwise operators give you the ability to store multiple settings in a single primitive data type (e.g. an integer). This is useful when a single item has potentially more than one setting of the same type. For example, a message box could have an Ok button, a Cancel button, a Retry button or any co
....Read More |
| Rating
|
|
|
|
Understanding BCP/BULK COPY Format Files
|
| Total Hit (1144) |
In Microsoft SQL Server 2000 and earlier, bulk exporting and importing works with a single type of format file. This is supported in Microsoft SQL Server 2005. SQL Server 2005 also supports XML format files as an alternative. To distinguish format files of the original type, they are called non-XML
....Read More |
| Rating
|
|
|
|
How to create Format File using BCP command
|
| Total Hit (22037) |
When you bulk import into a SQL Server table or bulk export data from a table, you can use a format file to store format information for each field in a data file relative to that table. A format file provides a flexible system for writing data files that requires little or no editing to comply with
....Read More |
Rating
 |
|
|
|
Writing Provider-Independent Data Access Code with ADO.NET 2.0
|
| Total Hit (958) |
When you need to write an application that allows users to select the database provider, the application code itself needs to be completely provider-independent. ADO.NET 2.0 helps you create and deliver database applications even when you don't know what database your clients are using.
....Read More |
| Rating
|
|
|
|
Display Multiple reports using single ReportViewer control
|
| Total Hit (1110) |
It is easy to get the ReportViewer Control to report off of a DataSet that is set during design time. But what if you want to use code to cause one ReportViewer control to display many totally different reports using your own O/R mapper collection instead? It is not easy to see how to do this, but i
....Read More |
| Rating
|
|
|
|
Scanning the network for SQL Server for a range of IP addresses
|
| Total Hit (936) |
In a large IT department, it can be difficult to locate where new SQL Server installations were made and how many of those SQL Servers were patched, etc. This article explains how to scan the entire network for a range of IP addresses to find which boxes have SQL Server instances installed. The OSQL
....Read More |
| Rating
|
|
|
|
|
|
|
|
|
|
How to find and sort files based on creation time
|
| Total Hit (6602) |
The following code will sort file list based on CreationTime
«code LangId=2»Option Explicit On
Option Strict On
Imports System.Collections
Imports System.IO
Module Module1
Private Class CreateTimeComparer
Implements IComparer
Public Function Compare(ByVal x
....Read More |
| Rating
|
|
 |
How to auto refresh page
|
| Total Hit (7481) |
Here is the script to refresh page automatically at certain interval
«code LangId=4»
<html>
<HEAD>
<script type="text/javascript">
<!-- Begin
/*
Because this is a true refresh, you might want to put a
notice on the page that it refreshes every "X" minutes */
function reFresh()
....Read More |
Rating
 |
|
|
|
IIS Resource Kit
|
| Total Hit (2277) |
<b>Internet Information Services (IIS) 6.0 Resource Kit Tools</b>
The IIS 6.0 Resource Kit Tools can help you administer, secure, and manage IIS
<a href='http://www.microsoft.com/downloads/details.aspx?familyid=56fc92ee-a71a-4c73-b628-ade629c89499&displaylang=en'>http://www.microsoft.com/downl
....Read More |
| Rating
|
|
|
|
SSIS Script Task Variable Write Example (Using LockOneForWrite)
|
| Total Hit (1690) |
I had some difficulty finding a succinct code example for how to change the value of a variable in a SQL Server 2005 SSIS Script task, so I thought I would add one here now that I think I've figured it out. (Is anyone besides me disappointed by the lack of examples in the Books Online and Help?)
....Read More |
| Rating
|
|
|
|
Bulk Edit GridView (ASP.net 2.0)
|
| Total Hit (978) |
GridView is a tremendously useful control in ASP.NET 2.0. Despite being much improved from the DataGrid of the ASP.NET 1.x era, GridView still lacks some features which always seem to be requested. This is a multipart post on how to customize GridView to add some of this missing functionality. I'
....Read More |
| Rating
|
|
|
|
|
|
|
|
|
|
How to find start/end date of Previous Quarter
|
| Total Hit (3345) |
«code LangId=6»declare @PrevQtrDate datetime
declare @PrevQtrStartDate datetime,@PrevQtrEndDate datetime
declare @ReportDate datetime
set @ReportDate=getdate()
set @PrevQtrDate=dateadd(q,-1,@ReportDate)
Print @PrevQtrDate
set @PrevQtrStartDate=cast(month(@PrevQtrDate) as varchar(10)) + '
....Read More |
| Rating
|
|
|
|
Displaying RTF formatted text in SQL 2005 Reporting services
|
| Total Hit (43971) |
I haven't tried this but it may be helpful to someone who is trying to display RTF formatted text on their report. Crystal Report Support RTF/HTML format but RS 2005 doesnt support. May be MS will add in the next release.
Just follow these steps:
Compile the code below it into a class
Firs
....Read More |
Rating
 |
|
|
|
|
|
|
|
|
|