April 2009 - Posts

2
Comments

Keeping ASP.NET sessions alive by bunbun

I had an application where users would routinely start working, then stop to do something else and then keep the web page open for hours on end. This would inevitably lead to some ASP.NET Session has expired messages. To combat this, there is a simple...
Filed under:
0
Comments

Separate gridview column alignment with CSS Friendly Control Adapter by bunbun

When using the CSS Friendly Control Adapters, you get an easy to modify the look and feel of all your controls through one style sheet. With the gridview style, you can set the text alignment for your columns: .PrettyGridView .AspNet-GridView table tbody...
Filed under:
3
Comments

Using a linked server in a stored proc job by bunbun

Working on a new stored proc, I encountered an error when trying to run a job that called the stored proc. The error message was: Executed as user: NT AUTHORITY\SYSTEM. The OLE DB provider "SQLNCLI" for linked server "costpoint_rw" reported an error....
Filed under: ,
0
Comments

Convert SQLDataSource to DataTable by bunbun

Sometimes I find the need to convert a SQLDataSource to a DataTable. Here's how to do it: Dim dv As DataView = New DataView() Dim dt As New DataTable dv = Me .sqldsData.Select(DataSourceSelectArguments.Empty) dt = dv.ToTable()
Filed under:
1
Comments

Padding in SQL (Replicate Command) by bunbun

In .NET there are nice functions for padding like PadLeft and PadRight. Found out SQL has its own: the replicate command. You pass a string (the value you want to pad) and then an integer value for how many occurences you want. Combine that command with...
Filed under:
More Posts