Kshitij’s Blog

.NET/ CSLA.NET / ASP.NET / VB.NET / C# / SQL Server / MySql ..

  • Dec
    8

    Hi,

    Few days back i needed a code snippet to write a text in starting of all files in a directory. Searched net but could not find any working code. Then i decide to write my own code and come up with following code. I hope

    Read the rest of this entry »
    No Comments
  • Jun
    16

    So what basically is reflection:

    Using a class library methods at runtime without adding its reference in your project is done through Reflection. In this article I will show you how to use reflection using a simple example.

    Let’s first create a Class Library.

    ScreenHunter_01 Jun. 13 12.06

    Read the rest of this entry »
    4 Comments
  • Jun
    9

    So what exactly Stored Procedures are :

    • Basically in a database management system (DBMS), a stored procedure is a set of Structured Query Language (SQL) statements with an assigned name that’s stored in the database in compiled form so that it can be shared by a number of programs. The use of stored procedures can be helpful in controlling access to data (end-users may enter or change data but do not write procedures), preserving data integrity (information is entered in a consistent manner), and improving productivity (statements in a stored procedure only need to be written one time). Stored procedures have been part of Oracle, MS SQL Server, DB-2, postgreSQL and others for years but MySQL introduce Store procedures recently in version 5.xxx. MySQL stored procedures are very similar to the DB2 implementation, as both are based on the SQL:2003 standard.
    Read the rest of this entry »
    9 Comments
  • Jun
    5

    Recently i faced lots of problem with my hosting company as almost daily my site was down due to some problems in their servers. They usually send me a link to trace my site. Basically that site provide service to ping back any URL from their servers which are located in different countries. So it [...]

    Read the rest of this entry »
    5 Comments
  • May
    28
    Hi,
    I was searching an article about creating controls at runtime based on a master table. But I couldn’t find one. So I decided to write my own code and here is the result. I hope this post will help other guys who are looking to do same thing.So let’s first create a master table which will store details about fields need to appear on our page.
    Let’s call this table tblFieldMaster.
    tblFieldMaster
    Now Insert some data in it.
    screenhunter_02-may-30-1017
    Now add a new webForm to your website project ( i assume you know how to create a website project with visual studio 2005 or 2008). Let’s Name it createControl.aspx.
    Add following code to newly added webform between tag.
    Read the rest of this entry »
    4 Comments