hi Im facing problem in adding values to the database sqlserver2k

hi everyone,

I have a form in in that 3columns and 8rows default.. I have to store values for 8 rows at a time in to database..

I am working with vs2003, asp.net & C# behind the code.. so pls send me a code for implementing this.. asap

vijai

what problem you are facing mention it here. There are lot of scenarious how u want to add the data. Depends on your code and architecture...

|||

Hi Vijai,

Have you created the datatable yet and what about the table's design? Since you haven't told us the details, I just suggest some reference to you.

About how to implement data access in ASP.NET : http://quickstarts.asp.net/QuickStartv20/aspnet/doc/data/default.aspx
Something about SQL Basic reference: http://www.w3schools.com/sql/sql_insert.asp
About table creating:http://www.w3schools.com/sql/sql_create.asp or just using the wizard in the tool such like Sql Server enterprise manager.

Thanks.

Hi Dan Guzman

hi dan
Some of my pals are facing a very rare kinda problem. Thay have a
Java app that connects to a SQL server instance. Currently they are
testing the app on the same comp where SQL server is installed. Few
days back when they executed the app it couldnt connect to the
database. But yesterday it found a way out. The same thing happened
but this time they restarted SQL server. None of them including me
could figure out what is the problem.
Any advises??

Cheers
DebashishWhat error message was returned when the connection failed? Do you have any
related messages in the SQL Server error log? Check out
http://support.microsoft.com/defaul...kb;en-us;827422.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"debashish" <debashish_majumdar@.rediffmail.com> wrote in message
news:bb05cfc5.0410170408.4ee5f030@.posting.google.c om...
> hi dan
> Some of my pals are facing a very rare kinda problem. Thay have a
> Java app that connects to a SQL server instance. Currently they are
> testing the app on the same comp where SQL server is installed. Few
> days back when they executed the app it couldnt connect to the
> database. But yesterday it found a way out. The same thing happened
> but this time they restarted SQL server. None of them including me
> could figure out what is the problem.
> Any advises??
> Cheers
> Debashish|||Hi

In addition to Dan's reply the following may also help:

http://support.microsoft.com/defaul...kb;en-us;313178

http://support.microsoft.com/defaul...kb;en-us;313100

It would also be useful to know which driver and version of the driver you
are using.

John

"debashish" <debashish_majumdar@.rediffmail.com> wrote in message
news:bb05cfc5.0410170408.4ee5f030@.posting.google.c om...
> hi dan
> Some of my pals are facing a very rare kinda problem. Thay have a
> Java app that connects to a SQL server instance. Currently they are
> testing the app on the same comp where SQL server is installed. Few
> days back when they executed the app it couldnt connect to the
> database. But yesterday it found a way out. The same thing happened
> but this time they restarted SQL server. None of them including me
> could figure out what is the problem.
> Any advises??
> Cheers
> Debashish