Subscribe to andrewsw's Blog        RSS Feed
- - - - -

VB.NET Get SQL Server INCREMENT Value

Icon Leave Comment
This isn't a tutorial, just a lump of code that I wanted to make available that demonstrates retrieving INCREMENT values for newly inserted SQL Server (Express) records, and displaying them on a WinForm. (There are some links in the code to articles on this subject.)

Of course, you should question whether you need to retrieve, or even...
- - - - -

Post-It Notes in localStorage

Icon Leave Comment
I started to explore this earlier today, a web page to create post-it notes, and then save, and retrieve, them from localStorage. I was going to entitle this blog "..work in progress" but I actually found that I managed to complete everything that I intended to include. (Note: I use jQuery.)

You can press the plus sign to create a new...
- - - - -

Multi-line replace in Sublime Text

Icon Leave Comment
I recently needed to find and replace blocks of code across multiple files. For example, to replace the footer of every HTML page. (Normally I would use PHP includes so that there is only a single footer, in a single file, but I wasn't allowed to do this for this site.)

It took a bit of digging to achieve this in Sublime Text. (Maybe it is...
- - - - -

Excel with Andy: Dynamic Drop-Down

Icon 1 Comments
Using Defined Names (formerly called Range Names) and Data Validation we can create a drop-down list where the list of choices changes according to the value chosen in an adjacent cell. In the screenshot the list of items in the drop-down changes according to whether Fruit or Veg is chosen in the adjacent cell in column A.

Image reduced in size...
- - - - -

Excel with Andy: More Functions

Icon Leave Comment
Most people are familar with Excel's basic statistical functions: SUM, AVERAGE, MAX, MIN, COUNT and possibly COUNTA. I will demonstrate the use of some more functions:

INDIRECT, ADDRESS, ROW, MATCH, OFFSET, COUNTA

Image reduced in size...
- - - - -

RSS Feed in WPF

Icon 1 Comments
I found this cool page to display RSS feed items in WPF:

Build an RSS reader in 5 minutes

It works great. I thought I would see how it behaves with dream.in.code's feed:

http://feeds.feedbur...ured?format=xml

Image reduced in size

Unfortunately it, for me, produces a Script Error dialog several times. My settings in IE are already set to not...
- - - - -

Dipping Into F#

Icon 2 Comments
If you don't have access to a full version of Visual Studio it is now easier to dip your toe into the F# waters, and functional programming, by downloading the free Visual Studio Community 2013 edition...
- - - - -

Grand Unified Snippet

Icon 1 Comments
When I first encountered Sublime Text, a few years ago now, I was first attracted to the look of it, then by multi-line editing, but mainly by the possibility of using it as a vehicle to extend my knowledge of Python. Python is the main language behind its plug-in architecture. On further investigation I noticed that regex...
* * * * *

Still No Answer?

Icon 1 Comments
Most forums are manned by volunteers. If only a couple of days have passed without a response this doesn't mean that your question won't be answered, or responded to. Many volunteers visit infrequently, but many will also look through the forum(s) for specific language(s) and look, specifically, at unanswered questions. (The Home page...
- - - - -

Name Your Stuff

Icon 3 Comments
Please don't name your form "form", or "form1". Please don't call your textbox "textbox1".

Do not leave your controls with their default names of "TextBox1", "TextBox2", "TextBox50000", "ListBox1". Please don't call your application "MyApplication". All of...

  • (4 Pages)
  • +
  • 1
  • 2
  • 3
  • Last »

July 2015

S M T W T F S
   123 4
567891011
12131415161718
19202122232425
262728293031 

Tags

    Recent Entries

    Recent Comments

    Search My Blog

    2 user(s) viewing

    2 Guests
    0 member(s)
    0 anonymous member(s)

    Categories