Geeks With Blogs
Rodney Vinyard - .NET & SQL Developer When all is said and done, more will be said than done 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> -- ===========================... ......

Posted On Wednesday, January 31, 2007 10:27 AM

no brainer public file transfer

no brainer public file transfer

http://www.senduit.com/

Posted On Sunday, January 28, 2007 9:59 PM

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 //-------------------------... ......

Posted On Saturday, January 27, 2007 6:22 AM

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/... ......

Posted On Thursday, January 25, 2007 6:38 AM

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 ......

Posted On Thursday, January 18, 2007 4:16 AM

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 ......

Posted On Thursday, January 18, 2007 4:11 AM

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\etc\

Posted On Wednesday, January 17, 2007 1:14 PM

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 ......

Posted On Wednesday, January 17, 2007 7:14 AM

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 ......

Posted On Wednesday, January 10, 2007 1:12 PM

select single column from Oracle view

to select all column from an Oracle view use asterisk:

SELECT * FROM APPIDVND0610.GET_LAST_TWO_CLOSE_BIDS

to select a single column from an Oracle view use double quotes:

SELECT "Latest_CloseBid" FROM APPIDVND0610.GET_LAST_TWO_CLOSE_BIDS

Posted On Monday, January 8, 2007 12:47 PM

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 ......

Posted On Monday, January 8, 2007 12:40 PM

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 ......

Posted On Thursday, January 4, 2007 2:13 PM

Copyright © Rodney Vinyard | Powered by: GeeksWithBlogs.net