How To save multiple data into database in sqlserver....

Question

1.00/5 (1 vote)

See more:

How to save a list data into sqlserver database.....

I want to save multiple row at one time from Aspx page to sqlserver.

Posted 11-Nov-13 0:53am

Parmendra choudhary

Add a Solution

Comments

Thanks7872 11-Nov-13 7:01am

Where is the code you have implemented till now?

Parmendra choudhary 11-Nov-13 7:07am

I just want to save Patient's treatment information so multiple medicine save at one time.

Thanks7872 11-Nov-13 7:25am

Ok but where is the code and what problem did you face with that code?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 1 · 2013-11-11T01:04:00

Solution 1

Go through the Article to know Multiple Ways to do Multiple Inserts[^].

The easiest way is to create one XML string and send that to the Stored Procedure and inside the Procedure, read the values and insert to table.

See one example- Inserting multiple rows in single command using asp.net[^].

Posted 11-Nov-13 1:04am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

Parmendra choudhary 11-Nov-13 7:15am

I just want to save data with listview

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 11-Nov-13 7:17am

Okay, so loop through the record and make one XML and send that to Database. You can't directly insert.

thatraja 11-Nov-13 7:27am

5! for the 1st link

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 11-Nov-13 8:00am

Thanks a lot... :)

Mishra Laxmikant · Answer 2 · 2013-11-11T01:18:00

You should pass your records as table as "sqldbType.structured". and in database procedure handle the table.

in database create a type:

SQL

CREATE TYPE LogData AS TABLE(
 [Date] [varchar](20) NULL,
 [Scbytes] [bigint] NULL,
 [CsHost] [varchar](256) NULL
)

then use that type in procedure

SQL

[prc_insertlog]
       @intClientID INT ,
      @tlbLogData  LogData READONLY

In aspx page just create a datatable with the fields as in Type. and pass in the procedure.

In sql server, you should create cursor. OPen cursor and fetch the rows one by one. and loop until @@FETCH_STATUS = 0.

Hope your problem will be sorted out :)