My Fishing Stream

Converting Time in DATETIME to Zero

2010-05-13T09:55:00.000-06:00

The biggest question I get in regards to date functions is a quick way to convert the time portion of datetime to zero (or 00:00:00), regardless of where you get the date. There are several options out there, but the easiest to implement and remember for me is using, what I call a flip-flop. First you date the date and convert into an float. This turns your date into a Julian date which does

How to Get the First or Last Day of a Given Month

2010-03-04T10:13:00.000-07:00

This seems to be a frequently asked question that people give multiple answers to. Even I struggled with something so simple. Why?? I think we all too often try to think out of the box when often times the box holds the answer. GETTING THE FIRST DAY OF THE MONTH Subtract the day on the month +1 from the date. Simple huh? DATEADD(d,-DAY(getdate())+1,getdate()) GETTING THE LAST DAY OF

How to Check if File Exists (VB)

2010-02-01T12:46:00.001-07:00

How to check to see if a file exists before allowing an upload to your server. In your Upload code-behind add the following lines to your btn_click sub: ... If System.IO.File.Exists(path & Upload1.Filename) THEN code on what to do if it exists End If ... Here is an example of my code with some error handling and reporting lines. You will need to change the generic objects to your id

ASP.Net Login Errors

2010-01-28T15:46:00.003-07:00

"CREATE DATABASE permission denied in database 'master'."This was the bane of my existence for several days. I scoured the web to see what other people were doing to resolve the issue and I just got the same stuff, the stuff I was doing. BACKGROUND: I am using SQL SERVER 2005 to host my data and aspnetdb from the ASP.net framework. I already have the ASPNETDB installed. This DB install

Nested Cursors

2009-12-03T16:33:00.000-07:00

I was working on a problem at work to find items within a given property, within a given aspect, within a... (you get the point) But what to do in the case that @@fetch_status <> 0 would it break all levels of the nesting? It can if you do it wrong. There are several examples on the web, but here is the best way to conquer this relatively simple query. First you need to create your

How to set a default item to an datasource generated list in ASP.net

2009-11-21T18:53:00.000-07:00

While creating a site I created a DetailsView to insert and update some item. While I created a view that allowed inserting and updating, changed a field item to a template view and added a dropdown to pull a list of options from another table within the database. This was all well and good but I ran into a situation where there were some dropdowns that I would not utilize while adding or

To display a drop-down list while editing or inserting

2009-11-10T10:41:00.004-07:00

*** This can be used for editing or inserting. For inserting change the ItemTemplate section from EditItemTemplate to InsertItemTemplate. *** From the Data node of the Toolbox, drag a SqlDataSource control onto the page. Configure the datasource Right-click the GridView control and select Show Smart Tag. In the GridView Tasks menu, select Edit Columns. In the Fields dialog box, select City

New Fly Tying Website

2009-10-24T16:35:00.003-06:00

I am working on a fly-fishing website that will feature fly patterns and instructions. Members will be able to access instructions (up to X/month). Guests will be able to see a list of flies and pattern/materials of 5/month.