Question

Status:Closed Asked:Mar 06, 2009 - 08:02 PM

i want to insert bulk of records into table?thank you

I want to insert 10 records based on some condition

Comments (0) | New Comment

Add New Comment

Do you have the same question? Follow this Question

Answer this Question

Report it

Tags: .net

Answers

Anpanman

Hi,
I'm not sure why you want to bulk insert, so if you explained the circumstances a bit more, it might be easier to help.
Nevertheless T-SQL (sql server) does have a BULK INSERT function to insert records from a text file.
You can see the specifications here: http://doc.ddart.net/mssql/sql70/ba-b...
And see an example here: http://www.developerfusion.com/code/5...

If that's not what you want I would create a for loop and insert the records one by one, depending on the condition you mentioned.

Hope this helps, otherwise, please give some more information.

Comments (0) | New Comment

Add New Comment

Mar 06, 2009 - 09:07 PM

Report it

priyaravi2008

Thankyou for your response.for example in school project i want to send a fees details to all student's who are studying in I st standard.at the same time i want to store that details into database.Thankyou.

Comments (0) | New Comment

Add New Comment

Mar 09, 2009 - 10:19 PM

Report it

Anpanman

So did any of the two ideas I proposed work for you?

You didn't mention where the fees details come from. Is it a file, do you type it in manually on a webpage?

Comments (0) | New Comment

Add New Comment

Mar 09, 2009 - 11:30 PM

Report it

priyaravi2008

Thankyou Anpanmnan.its manually type on a webpage.in webpage user enter standard and fees details when user click the enter button,details are insert into student fees table who are studying in the particular standard.Thankyou.

Comments (0) | New Comment

Add New Comment

Mar 13, 2009 - 05:18 AM

Report it

Anpanman

priyaravi2008, what is it that you have difficulties in doing? If you describe what you don't understand or what is causing you problems, maybe it would be easier to help you.
I'm not going to program the whole thing for you, but I'll be happy to give advice.

Comments (0) | New Comment

Add New Comment

Mar 16, 2009 - 10:58 PM

Report it

priyaravi2008

Anpanam Thankyou for your response.thankyou.

Comments (0) | New Comment

Add New Comment

Mar 20, 2009 - 04:39 AM

Report it

admin

The question looks to be abandoned by the user who asked it. If no action is taken within 2 days, a Quomon Moderator will consider closing the question and distributing the points.

The Quomon Team

Comments (0) | New Comment

Add New Comment

Jun 04, 2009 - 06:33 PM

Report it

DevilAct

hi this is devl act
there is a option in side tool bar name "bulk Copy or Bulk"
with the help of this option you can copy bulk files.

Comments (0) | New Comment

Add New Comment

Apr 07, 2010 - 12:48 AM

Report it

shahjayesh791

if u want to insert the same data in sql without any tension then
1. create a .class file
this file contain 1 function for insert i.e. execute(str). if u want the internal code then i will send u after u like this logic. then after create a object of this file in ur code. then using this object u can call this function.now take the function call in loop.
i.e obj.execute("insert query").

using this function u can perform all type of insert, update and delete operation on database.

1 function = 3 operation.

Comments (0) | New Comment

Add New Comment

Mar 21, 2012 - 01:19 AM

Report it

Question

i want to insert bulk of records into table?thank you

Answers

OTHER QUESTIONS NEEDING ANSWERS

Popular Tags

Recently Active Members

Tools