Important Links ......

www.indianrail.gov.in ( Railways website )

Null Check

Always check Null before use that Object or values


ex..
If IsNothing(Session("mainID")) = True Then
'Do this Job
End IF

if its database value means u must check isNull ( if the field allowed null value )

If IsDBNull(reader("mainNameMiddle")) = False Then
'Do this Job
End If

asp.net Tutorial collections

http://samples.gotdotnet.com/quickstart/aspplus/doc/default.aspx


http://asp.dotnetheaven.com/aspnet/default.aspx

asp.net controls and examples ....

some sample on asp.net controls .....

http://quickstarts.asp.net/QuickStartv20/aspnet/doc/ctrlref/data/default.aspx

Nested Repeater with Parent child relations

Nested Repeater with Parent child relations ....

if u want to bind two table with relations in a nested repeater .... u can check this links ....

http://www.dotnetspider.com/kb/Article1039.aspx

http://support.microsoft.com/kb/306154

Some basic Diff between MS Access and MS SQL Server

Do u need to know Some basic Diff between MS Access and MS SQL Server in Queries ..... pls visit below link .....

http://weblogs.sqlteam.com/jeffs/archive/2007/03/30/Quick-Access-JET-SQL-to-T-SQL-Cheatsheet.aspx

You Tube Collections ......

http://www.youtube.com/watch?v=LU8DDYz68kM

Importing Data from MS Access to SQL Server ...

If u want to import data from MS Access to SQL Server ....

please refer this link ...

http://www.microsoft.com/technet/prodtechn...access.mspx#EGC

go to SQL server Enterprise manager

1. Select a database and right click and u w'l find All Task --- > Import data
2. Select a Source Database in our case .mdb ( access database )
3. Select a Destination Database ... in our case SQL server db ...
4. Check the radio button Copy Table(s) and view(s) from the source database ..
5. Click next next and Finish .... done

you may get this Error during import ...

---------------------------
Copy Data from tblMembers to [asny].[dbo].[tblMembers] Step
---------------------------
Error at Destination for Row number 446. Errors encountered so far in this task: 1.

Insert error, column 9 ('mainDateThrough', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
Invalid character value for cast specification.

Reason for this Error is Access automatically convert all datatime to smalldatetime in SQL Server ... so if Access table have some invalid dates it may difficult to covert by SQL server ....

Solution First u create a table ( which table have this error during importing ) in SQL server make all Date Fields in DATETIME .. dont keep in smalldatetime

and then import that particular table from Access to SQL server through DTS the problem will be solved .....

Session in asp.net

if u want to know basic details about sessions please go to this link ...

http://www.codeproject.com/aspnet/ASPNETSession.asp

About SQL server DB

NVARCHAR versus VARCHAR

SQL Server provides both datatypes to store character information. For the most part the two datatypes are identical in how you would work with them within SQL Server or from an application. The difference is that nvarchar is used to store unicode data, which is used to store multilingual data in your database tables. Other languages have an extended set of character codes that need to be saved and this datatype allows for this extension. If your database will not be storing multilingual data you should use the varchar datatype instead. The reason for this is that nvarchar takes twice as much space as varchar, this is because of the need to store the extended character codes for other languages from Ask The Database Expert: Questions & Answers

What are Candidate, alternate and composite keys?

A candidate key is one that can identify each row of a table uniquely. Generally a candidate key becomes the primary key of the table. If the table has more than one candidate key, one of them will become the primary key, and the rest are called alternate keys.

A key formed by combining at least two or more columns is called composite key.

-------------------------------------------------

how to view or see our TRIGGERS in our table

It's a bit cludgy, but in Enterprise Manager, on the database you are
looking at,
Right click on a particular table and
select [generate SQL scripts].
Untick [Script All Objects]
Tick [All Tables]
Under the [Formatting Tab] untick everything.
Under the [Options] tab, tick [Script Triggers]
(.) Create one file
Then [OK]