-
Advance SQL: Finding Hierarchical data using Recursive CTE
Often we have a Table that store Hierarchical data, such as any shopping cart will have product category in table that store parent table within same table. We often use such information. The typical structure of table is ID, Name , ParentID Where ParentID is ID within same table or for Top level it is […]
-
Move to Azure as Trial
Okay, so I activate my Azure trial and thought to move my blog on it. I am currently hosted with Azure VM [small instance] as trial. Hope it give better performance than my previous host, which was lately too slow to work with.
-
Reading Large Binary Files: Child Play
Yes, that was funny title, but after your experience it you will agree to me. So, here is the story. I have been working on a software that read some recording from hardware device to database, we have 45 records per second for 30 days, so it is about 30x24x60x60 record entry with 45 columns […]
-
StackOverflow.com: A Review
I lately start using StackOverFlow.com a lot to get my answers and to help others. It is really one good site, one can hook around for a while. I love reading some of their questions. Some of those questions are that I got around in future as developer myself. The fun thing about this site […]
-
Self Hosted Web Service: WebServiceHost
So today I learn about WebServiceHost. Just a normal class but it does a lot for me today. This host the web service within you Desktop/Windows Service application. i.e. you don’t need to install any Web server or other stuff, just create a Service Contract Class and use WebServiceHost to host it within your application. […]
-
WPF ComboBox: DataBinding with DataTable
Well it seems easy thing, but it took a while for me to get it working. Frankly I still don’t know why it works this way, but at least it works. With WPF I was expecting something as easy as giving DataTable object to ComboBox by it’s property and define the Data Field and Value […]
-
MDI Window: C# way
So how can we make MDI Parent and Child Window in C#. The answer I found was that there is nothing inbuilt for it. So, I have two choice, either I modify the Window class and add MDI [Multiple Document Interface] coding in them or I found a alternative interface. It took less than 5 […]