(Lviv community of .NET developers)

Recent posts

OracleDecimal and ODP.NET IConvertable exception

October 3, 2008 07:49 by alexk

Oracle ODP.NET

I'm working now on a new project that in internals use ODP.NET - ORACLE Data Provider for .NET and latest Oracle 11g.

First of all I want to mention that ODP.NET is a great disappointment for me. In writing of very simple a stupid code ODP give me so many issues that I start to think that ORACLE completely loose own mind and release very unstable library for developers. I loose 2 days for fighting with found issues and I hope my article will help others a lot.

Simple Scenario that does not work in ODP.NET

Let's start from the simple scenario: Create typed DataSet with several tables, infill dataset by the data and update database by that data. Primary keys of the rows must be updated by Adapter automatically on Update method call.

... >>>

Currently rated 5.0 by 2 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

IP geo-location - make it easy!

September 12, 2008 03:49 by alexk

Introduction

Today I want to open one more interesting part of making internet business - statistics collection. I hope you already knows popular service Google Analytics that helps many companies to track internet activity on web site (main issue that those analytics is not runtime, you have to wait 1 day for getting ready to use statistics). But do you want to know how to make own statistics tracking engine on IIS? I hope you do.

In this article I will describe how to collect statistics from IIS and how to do most common thing - resolve clients IP into geo-locations.

Theory

Let's make a quick look on web site hosting. What we can see? Let's count:

  1. IIS hosting server
  2. Web site (for example ASP.NET)
  3. Database (for example MS SQL Server)

Those 3 components are the most common for every web site based on Microsoft technologies.

Statistics tracking can be done only on first two components: IIS and ASP.NET... (but this is not exactly true, if take a look into depth then we can identify that in reality we have only one component IIS and it's filters model - ISAPI filters.)

Tracking of statistics on IIS layer is well described by Microsoft in own knowledge database.

... >>>

Currently rated 5.0 by 2 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Полезные ссылки - Part 7

July 22, 2008 05:34 by alexk
C# avionic instrument controls By Chootair
http://www.codeproject.com/KB/miscctrl/Avionic_Instruments.aspx



Статья интересна "расжованной" тематикой поворота картинок, ну и конечно самими контролами.
... >>>

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Полезные ссылки - Part 6

May 7, 2008 14:49 by alexk

How to learn WPF fast?

This is a good question and I have easy answer on it. Read this articles and in several hours you will know sufficient to start writting simple applications on WPF...
  1. WPF: A Beginner's Guide - Part 1 of n
  2. WPF: A Beginner's Guide - Part 2 of n
  3. WPF: A Beginner's Guide - Part 3 of n
  4. WPF: A Beginner's Guide - Part 4 of n
  5. WPF: A Beginner's Guide - Part 5 of n
  6. WPF: A Beginner's Guide - Part 6 of n
Easy learning and Enjoy. Great thanks Sacha Barber the author of these great articles.
... >>>

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Categories: .NET | General | Links | WinFx | WPF
Actions: Permalink | Comments (0) | RSSRSS comment feed

TCP ports forwarding, tunneling, proxies

April 27, 2008 08:32 by alexk
Hi Everyone,

Today I want to share a small piece of code that demonstrate TCP Sockets usage in .NET.

This is not very advanced example of sockets programming, but at the same time it show a lot of technics that you can use in programming, like:
- debugging of the windows services
- async sockets
- async operations and there synchronization
- events used for service controlling
- registry access
- advanced tracing/logs
- and etc.

Introduction

The idea was to write a simple TCP proxy class that will help us to forward ports (or better to say create a tunnel) from one source to destination.

In my case I want to use this functinality to open direct access to my computer in network shown below (ADSL modem connected by lan to the Vista computer; Vista publich AdHoc connection to the other computer Windows Xp. I setup service on Vista PC that helps me to open port directly for the Windows XP computer!!!):


In more simple way it's looks like this (configuration for testing):

... >>>

Currently rated 5.0 by 2 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Delete Old files from Command Line

January 29, 2008 11:23 by alexk

Very often administrator in any company have to solve simple problem: delete from server old files. How we can do this?

  1. Write command line script that will do this for us and run it periodically by windows scheduler service
  2. write custom application that will do the same
  3. find freeware or shareware with required functionality

In our case I want to introduce COMMAND LINE version of problem solving

... >>>

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Cache results with duration

January 18, 2008 15:15 by alexk
This time I want to show how to implement simple cache with duration interval. For it implementation were used generics and anonymous delegate C# features. Class is very simple but power that it give us is unmeasurable.
In real life this class is designed for DB oriented applications. It allowiing to cache long time taken operations results of which has long time of life. Enjoy.

... >>>

Currently rated 4.0 by 1 people

  • Currently 4/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

OpenBox satellite tuner firmware uploader

January 10, 2008 10:24 by alexk
I'm a happy owner of the satellite tuner x820CI produced by our Ukraine company: http://www.openbox.ua



One from the best features of this tuner is that it support firmware updates. And of course great team of developer on OPENBOX company side that systematically support firmware, update and fix bugs in it.

One issue that still is not done well is software that uploading firmware to this tuner... It's old and crappy written.

So I take my PC, notebook, usb2com (RS232) converter, null-modem cable and of course my favorite programming language C#...
... >>>

Currently rated 5.0 by 3 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Auto Update Application Block

January 8, 2008 10:33 by alexk

I start my day from reading articles on CodeProject.com and found very interesting one: http://www.codeproject.com/KB/install/DDayUpdate_Part1.aspx

It's based on ClickOne technology and provide easy way to update own applications. Do you want to know how to implement something like ClickOnce Auto Update by own hands? I'm sure you want...

... >>>

Currently rated 4.2 by 6 people

  • Currently 4.166667/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Полезные ссылки - Part 5

December 18, 2007 11:48 by alexk

C# Pivot Table By felipesabino

Так называемый поворот таблички на 90 градусов с групировкой...
http://www.codeproject.com/KB/recipes/CsharpPivotTable.aspx
... >>>

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Categories: Performance | .NET | QA | General | WinForms | Links | ASP.NET
Actions: Permalink | Comments (0) | RSSRSS comment feed