Geeks With Blogs

News


Rodney Vinyard - .NET & SQL Developer When all is said and done, more will be said than done April 2008 Entries
find columns and tables in a view
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 ......

Posted On Tuesday, April 29, 2008 4:54 AM

SQL Server format dates and times
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 ......

Posted On Saturday, April 26, 2008 4:59 AM

C# Excel Export from ASP.NET Page
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" ......

Posted On Sunday, April 20, 2008 1:13 PM

ASP.NET 2.0: Use VB.NET and C# within the App_Code folder
[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> ......

Posted On Thursday, April 17, 2008 1:39 PM

How To: Configure MachineKey in ASP.NET 2.0

How To: Configure MachineKey in ASP.NET 2.0

http://msdn2.microsoft.com/en-us/library/ms998288.aspx#paght000007_machinekeyexplained

Posted On Wednesday, April 16, 2008 1:16 PM

Get text from embedded resource files
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; ......

Posted On Saturday, April 12, 2008 11:22 AM

Problem: Microsoft Windows Installer 3.1 Error Code: 0x80070005
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 ......

Posted On Tuesday, April 8, 2008 5:34 AM

Gantt Chart - EventCalendarControl

Gantt Chart - EventCalendarControl

http://www.codeproject.com/KB/webforms/EventCalendarControl.aspx

Posted On Thursday, April 3, 2008 11:42 PM

Copyright © Rodney Vinyard | Powered by: GeeksWithBlogs.net