Pritam's Blog

Sharing is Caring

By - Pritam Baldota

Static Classes in .Net

Static classes and class members are used to create data and functions that can be accessed without creating an instance of the class. To separate data and behavior that is independent of any object identity Static classes can be used when there is no data or behavior in the class which depends on object identity. Can be use for storing

By - Pritam Baldota

SQL Server Database Triggers

A trigger is an object contained within an SQL Server database that is used to execute a batch of SQL code whenever a specific event occurs. A trigger is “fired” whenever an INSERT, UPDATE, or DELETE SQL command is executed against a specific table. A Trigger is associated with Database Table There are three types of Database Triggers – INSERT

By - Pritam Baldota

ActionScript for Designers Part 1- Basics of ActionScript

Hi Guys, Generally Flash comes with two meanings – 1) Flash for Designer & 2) Flash for Developers (ActionScript). Designer always threaten about ActionScripting. It is not that complicated at basic level where Designer can levarage the benefits of ActionScripting to their Creative Work without having Programming knowledge. If you already know the Flash, using tools and creating animations, you may

By - Pritam Baldota

Generate Page URL Name for CMS, Blogs Application

Hi All, To give the Name to the Page can be handeled by many ways like Using GUID (Issue- Cant identify exactly while browsing through pages) Using Session (Issue-Same as above) Using Page Title provided in Text Field (We will see this) We are going to implement the scenario 3. We will first see what are our constraints for page

By - Pritam Baldota

Optimizing SQL Server Database Design Tips & Tricks

Database design is most crucial part in application development. Database can be anything SQL Server, MySQL, Oracle, etc. I will consider SQL SERVER as a part of discussion. Tunning the database depends upon various factors like whether one datatype is better depends on the context of it’s usage. Following are most common datatypes used in database. Numbers Datatype (For storing

By - Pritam Baldota

GridView in ASP.Net

GridView plays very important component in ASP.Net Application. It covers most of the basic reports for which you do not need any reporting component like Crystal Report, Report Viewer etc. Major concern with any data entry form is Add, Edit, Delete and View. Assumptions- We are using SQL Server Express editions as Database. Table Name- Employees Fields- EmpId, EmpName, Designation

By - Pritam Baldota

ASP.Net Server Variables

Below is the detailed table for showing the ServerVariables Collection information. Variable Name Description ALL_HTTP HTTP_CONNECTION:Keep-Alive HTTP_ACCEPT:*/* HTTP_ACCEPT_ENCODING:gzip, deflate HTTP_ACCEPT_LANGUAGE:sv HTTP_HOST:localhost:1229 HTTP_USER_AGENT:Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1) ALL_RAW Connection: Keep-Alive Accept: */* Accept-Encoding: gzip, deflate Accept-Language: sv Host: localhost:1229 User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322;

By - Pritam Baldota

Storing Objects into Permanant DataStore in ASP.Net

Hi All, I was facing a problem towards sharing a data between Flash and .Net. The easiest way i found is XML Seralization because Remoting is much heavy and it requires remoting implementation. Even now I can store the Calss objects permanantely. This can be used in concept of Hibernate (Some what at very basic level). I found XML Seralization