find columns and tables in a view SELECT vObj.name AS vName, vObj.id AS vID, vObj.xtype AS vType, dep.depid, dep.depnumber, tObj.name AS tName, col.colid, col.name AS cName FROM sysobjects vObj LEFT OUTER JOIN sysdepends dep ON vObj.id = dep.id LEFT OUTER JOIN sysobjects tObj ON dep.depid = tObj.id LEFT OUTER JOIN syscolumns col ON dep.depnumber = col.colid AND tObj.id = col.id WHERE vObj.xtype = 'V' And vObj.category = 0 and vObj.name = 'vw1_inv_item_det' ORDER BY vObj.name, tObj.name, col.name ......
original article: http://sqlserver2000.databa... Many people have asked if there is a way to make SQL Server behave the way FORMAT works in VB (and FormatDateTime in VBScript). What they'd like to see is the ability to tell SQL Server to format a date with long date and time, or in MM/DD/YYYY format, instead of having to memorize existing format conversion numbers and/or manipulate the strings themselves. For example, to get today's ......
C# Excel Export from ASP.NET Page ----------------- --web Page - ExcelExport.aspx ----------------- <%@ Page Language="C#" MasterPageFile="~/MasterPag... AutoEventWireup="true" CodeFile="ExcelExport.aspx.cs" Inherits="Forms_Techniques_... Title="Untitled Page" %> <asp:Content ID="Content1" ContentPlaceHolderID="Conte... Runat="Server"> <asp:GridView ID="GridView1" runat="server"> </asp:GridView> <br /> <asp:LinkButton ID="LinkButton1" runat="server" ......
[code:xml] ASP.NET 2.0: Use VB.NET and C# within the App_Code folder Original Article: http://pietschsoft.com/post... Thanks to Chris Pietschmann There is a way to partition the App_Code folder into sub-folders, one for each set of code files written in the same programming language. Awesome, I didn't have to spend a couple hours converting code from VB.NET to C#! <configuration> <system.web> <compilation> <codeSubDirectories> ......
How To: Configure MachineKey in ASP.NET 2.0
http://msdn2.microsoft.com/en-us/library/ms998288.aspx#paght000007_machinekeyexplained
1) Add a file as an "embedded resource" 2) if the file is in a "subfolder" note the "folder discussion" below 3) client call to class ResourceFileManager objResourceFileManager = new ResourceFileManager(); string x = objResourceFileManager.Read... 4) class using System; using System.IO; using System.Reflection; public class ResourceFileManager { public string ReadResourceString(string resourceFileName) { //value for our return value string resourceValue = string.Empty; ......
Problem: Microsoft Windows Installer 3.1 Error Code: 0x80070005 Solution Steps: http://support.microsoft.co... To resolve this issue, follow these steps: 1. Log on to your computer as an administrator. 2. Click Start, and then click Run. 3. In the Open box, type cmd, and then click OK. 4. At the command prompt, typemsiexec.exe /unregister, and then press ENTER. 5. Type msiexec /regserver, and then press ENTER. 6. Verify that the SYSTEM account has full control access permissions to the HKEY_CLASSES_ROOT ......
Gantt Chart - EventCalendarControl
http://www.codeproject.com/KB/webforms/EventCalendarControl.aspx