Tips on Database Design

1.Develop A Prototype
Significant time can be saved by creating the structure in a simple desktop database (such as Microsoft Access) before finalising the design in one of the enterprise databases. The developer will be able to recognise simple faults and makes changes more rapidly than would be possible at a later date.

2.Split database structure into multiple tables
Unlike paper-based structures, databases do not require the storage of all fields in a single table. For large databases it is useful to split essential information into multiple tables. Before creating a database, ensure that the data has been normalised to avoid duplication.

3.Use understandable field names
The developer should avoid field names that are not instantly recognisable. Acronyms or internal references will confuse users and future developers who are not completely familiar with the database.

4.Avoid illegal file names
It is considered good practice to avoid exotic characters in file or field names. Exotic characters would include ampersands, percentages, asterisks, brackets and quotation marks. You should also avoid spaces in field and table names.

5.Ensure Consistency
Remain consistent with data entry. If including title (Mr, Miss, etc.) include it for all records. Similarly, if you have established that house number and address belong in different fields, always split them.


6.Avoid blank fields
Blank fields can cause problems when interpreting the data at a later date. Does it mean that you have no information, or you have forgotten to enter the information? If information is unavailable it is better to provide a standard response (e.g. unknown).

7.Use standard descriptors for date and time
Date and time can be easily confused when exporting database fields in a text file. A date that reads ‘12/04/2003’ can have two meanings, referring to April 12th or December 4th, 2003. To avoid ambiguity always enter and store dates with a four-digit century and times of day using the 24 hour clock. The ISO format (yyyy-mm-dd) is useful for absolute clarity, particularly when mixing databases at a later date.

8.Use currency fields if appropriate
Currency data types are designed for modern decimal currencies and can cause problems when handling old style currency systems, such as Britain’s currency system prior to 1971 that divided currency into pounds, shillings and pence.

9.Avoid proprietary extensions
Care should be taken when using proprietary extensions, as their use will tie your database to a particular software package. Examples of proprietary extensions include the user interface and application-specific commands.

10.Avoid the use of field dividers
Commas, quotation marks and semi-colons are all used as methods of separating fields when databases are exported to a plain text file and subsequently re-imported into another database. When entering data into a database you should choose an alternative character that represents these characters.


Collected From:Website

little bit on Windows Forms

In .Net, the most important namespace is System.Windows.Forms. this namespace can be grouped into the following broad categories:

Core infrastructure: represent the core operations of a Windows Forms program and activeX control.

Controls:Button, MenuStrip, ProgressBar,
DataGridView, etc. are related to control. its is used to create rich user interface.

Components:are not visible at runtime, but can be configured visually at design time, i.e timer, backgroundworker.

Common dialog boxes:provides a number of canned dialog boxes for common operations

To set the default input button of a form we need to use AcceptButton. Suppose, to set the button btnPaul as teh default buttorn for the form(Enter invokes this button directly), we need to write the following code

this.AcceptButton = btnPaul;

Come here to meet with my Ubuntu

To send sms through http port

We can send sms through a dedicatd http port to mobile no. To implement that, we need a very small code in c#.net. And we can use that code on the basis of the requirement of the server.
----------------------
String httpAddress = "http://192.164.4.224:8237/cpSubscriptionService/Default.aspx?key=ppl_450w98";
String mobileNo = txtMobile.Text;
String sentMessage = txtMessage.Text;
String out_Msg_Id = txtOutMsg_id.Text;
String sendRequest = httpAddress+ "&mobileNo="+mobileNo+"&body="+sentMessage+"&msg_type=4&send_port=003225&in_Msg_Id=1&out_Msg_Id="+out_Msg_Id;

HttpWebRequest loHttp = (HttpWebRequest)WebRequest.Create(sendRequest);

//loHttp.Timeout = 10000;
loHttp.Method = "GET";

HttpWebResponse loWebResponse = (HttpWebResponse)loHttp.GetResponse();

Encoding enc = Encoding.GetEncoding(1252); // Windows default Code Page
StreamReader loResponseStream = new StreamReader(loWebResponse.GetResponseStream(), enc);

string lcHtml = loResponseStream.ReadToEnd();
txtResponse.Text = lcHtml;

loWebResponse.Close();
loResponseStream.Close();
---------------------------------

For that purpose, we have just used the http port for the example purpose. Here three text box has been used just to take the no., text and the feedback field. Here in the program these fields have been used.

unable to connect to asp.net development server

Recently, I have started to make deal with ASP.net to learn that. And I firstly installed the Visual Studio 2008 and wrote the code. But when I start to debugging, I was helpless, as I am not a man with a lot of concentration. And most of the cases at past, I stopped programming when a error arouse me. But at this time I have started to face the problem, as its my target.
But this session isn't different from the before. When I start to debug my first program, I find the message "unable to connect to asp.net development server". As its my challenge, I use the internet and solve he problem. You can solve it following the steps

first download the file from following link
http://www.esnips.com/doc/9ef73cba-6d6a-4e76-a42d-83b58024300e/WebDev.WebServer
extract the file ..
u will get an exe named WebDev.WebServer.exe
simply right click and copy it..
now..
goto your drive containing windows...
by deault this is c drive..
so open
the following path...
C:\Program Files\Common Files\microsoft shared\DevServer\9.0
you will find already a file named WebDev.WebServer.exe..
so what you have to do is simply replace this file...
by right click and paste...
and click yes on the message that you want to replace the file..
yes its done ...

N.B: