Connect server in vs2005

[s j shah]

How to connect server2005 and insert,delete,update record in database.plz help me

 

[Jon]

How to connect server2005 and insert,delete,update record in database.plz help me

Hello mate,

There's 12 pages of stuff here: http://aspnet.4guysfromrolla.com/articles/011106-1.aspx.

HTH,

Jon

 

[Juan T. Llibre]

For a simple tutorial on data handling in ASP.NET, using SQL Server 2005 Express, see :

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

Also, this 3-part tutorial will teach you all you need to know:

http://technet.microsoft.com/en-us/library/ms345152.aspx
http://technet.microsoft.com/en-us/library/ms345150.aspx
http://technet.microsoft.com/en-us/library/ms345153.aspx

Download the sample code and study it.

If you haven't downloaded SQL Management Studio Express yet, d/l and install it :
It makes managing SQL Server Express 2005 a whole lot easier.

There's a version of SQL Server Express 2005 which includes
SQL Server Management Studio Express (SSMSE).

It's called "SQL Server 2005 Express Edition with Advanced Services".

You can download it, and also the stand-alone version of SSMSE, at :
http://msdn2.microsoft.com/en-us/express/bb410792.aspx

One last suggestion...

Download ASPXFormsGen, a free tool which generates data acess web forms
using as its basis a pointer to any data table...and study the code it produces:

http://www.junnark.com/DownloadAspxFormsGen.aspx

The tutorial on how to use ASPXFormsGen is here :
http://www.junnark.com/AspxFormsGenExp.aspx




Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
======================================