January 2007 Entries

@userDate match up with @FrequencyCode & @FrequencyValue

set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER FUNCTION [Rodney Vinyard].[function_TodayIsR... -- ===========================... -- Author: <Rodney Vinyard> -- Create date: <1/31/07> -- Description: -- Does @userDate match up with @FrequencyCode & @FrequencyValue? -- -- <for input (1) @userDate (cannot use getDate() here in Function -- (2) @FrequencyCode -- (3) @FrequencyValue, returns 1 - true or 0 - false> -- ===========================...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Posted On Wednesday, January 31, 2007 10:27 AM | Feedback (2)

no brainer public file transfer

no brainer public file transfer http://www.senduit.com/
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Posted On Sunday, January 28, 2007 9:59 PM | Feedback (1)

wrap dataset storage in view state, in a property

public DataSet MyDataset{ get { //-------------------------... // get dataset from viewstate //-------------------------... DataSet localDataset = null; object o = ViewState["viewStateDataset"]; if (o == null) { //-------------------------... // ViewState is null, dataset get from Db //-------------------------...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Posted On Saturday, January 27, 2007 6:22 AM | Feedback (2)

AJAX 101

You might want to go to this link: http://ajax.asp.net/default... Install ASP.NET AJAX 1.0 on your machine Run the video (highlighted below) and follow along in Visual Studio 2005 Build a i. Data grid view ii. insert/update Data Details View iii. for a SQL Server table - with no server side code AJAX enable the whole thing Nikhil Kothari's Weblog ASP.NET AJAX: http://www.nikhilk.net/Entr... This link has a download for a nice set of cheat sheets: http://aspnetresources.com/...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Posted On Thursday, January 25, 2007 6:38 AM | Feedback (2)

How to merge/join/append/concatenate PDF files with WebSuperGoo ABCpdf

How to merge/join/append/concatenate PDF files with WebSuperGoo ABCpdf Approach 1: Public Sub DoPDFAppend() If SummaryFileName = "" Then Exit Sub On Error GoTo ReportErrorHandler '--------------------------... ' PDF $ Append OneFile_Bookmark_ByAccount_... '--------------------------... Dim ii As Integer Dim totalFileCount As Integer totalFileCount = UBound(PDFFileArray) + 1 For ii = 0 To UBound(PDFFileArray) Dim thisFileNumber As Integer thisFileNumber...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Posted On Thursday, January 18, 2007 4:16 AM | Feedback (92)

How to merge/join/append/concatenate files in VB6 with FileSystemObject

How to merge/join/append/concatenate files in VB6 with FileSystemObject Private Sub Command1_Click() Dim folder As String Dim dest_file As String Dim file_ext As String Dim lPid As Long Dim shellStr As String Dim rvShellStr As String rvShellStr = "" folder = "C:\myFolder\mySubFolder\" dest_file = "MergeFileName" file_ext = "*.txt" Dim srcFolder As String srcFolder = folder + file_ext Dim destFile As String destFile = folder + dest_file + ".txt" '--------------------------... 'kill target...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Posted On Thursday, January 18, 2007 4:11 AM | Feedback (9)

How to map your own, made-up server name to an IP address

How to map your own, made-up server name to an IP address edit a file called "hosts" (no file extension), in folder: C:\WINDOWS\system32\drivers
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Posted On Wednesday, January 17, 2007 1:14 PM | Feedback (8)

Active Directory .NET System.DirectoryServices - Dump Schema Information

Active Directory .NET System.DirectoryServices - Dump Schema Information original article http://www.codeproject.com/... Try '--------------------------... 'build me.ActiveDirectoryPropertyList 'the list should contain key-value pairs that match with the properties '(e.g. DisplayName) of this class ' Key: displayname, Value: Vinyard, Rodney (Consultant) '--------------------------... Dim result As SearchResult...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Posted On Wednesday, January 17, 2007 7:14 AM | Feedback (5)

Oracle - format a date, Date Add, query by date

Oracle - format a date, Date Add Here is a query to format a date select distinct job_date, to_char(job_date, 'Dy DD-Mon-YYYY HH24:MI:SS') AS "job_date_text" from duhTable order by job_date desc "JOB_DATE" "job_date_text" "05-JAN-07" "Fri 05-Jan-2007 19:00:44" "05-JAN-07" "Fri 05-Jan-2007 08:00:37" "03-JAN-07" "Wed 03-Jan-2007 10:46:35" "29-DEC-06" "Fri 29-Dec-2006 08:00:38" Here is a query to get data “older than 5 days”: select * from duhTable latest Left Outer Join (Select loanxid, job_date, closebid...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Posted On Wednesday, January 10, 2007 1:12 PM | Feedback (3)

select single column from Oracle view

to select all column from an Oracle view use asterisk: SELECT * FROM APPIDVND0610.GET_LAST_TWO_C... to select a single column from an Oracle view use double quotes: SELECT "Latest_CloseBid" FROM APPIDVND0610.GET_LAST_TWO_C
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Posted On Monday, January 08, 2007 12:47 PM | Feedback (7)

Export a DataSet to Microsoft Excel without the use of COM objects

Export a DataSet to Microsoft Excel without the use of COM objects original article: http://www.codeproject.com/... private void exportToExcel(DataSet source, string inFileName) { try { //-------------------------... //replace GetExecutingAssembly().GetN... with inFileName //-------------------------... string fileName = System.Reflection.Assembly.... string...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Posted On Monday, January 08, 2007 12:40 PM | Feedback (14)

Making Rows in an Editable DataGrid Un-Editable

Making Rows in an Editable DataGrid Un-Editable original article by : Scott Mitchell http://datawebcontrols.com/... Private Sub dgSchedules_ItemDataBound(B... sender As Object, ByVal e As System.Web.UI.WebControls.D... Handles dgSchedules.ItemDataBound If e.Item.ItemType = ListItemType.Item Or e.Item.ItemType = ListItemType.AlternatingItem Then 'Columns {templateColumn = 0, Date, Amount, BU_Name, BU_Id = 4} Dim bu As String = e.Item.Cells(4).Text...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Posted On Thursday, January 04, 2007 2:13 PM | Feedback (2)

 
Powered by:

Copyright © Rodney Vinyard