Select Categories Below
Advertisement
Start Your Own Q&A Site
Create your own Q&A site easily, allowing you to quickly grow a new community around any subject matter or generate new organic traffic for your existing website.
Status: Open Points: 75 Time: 23:02 - Mar 06, 2009
priyaravi2008
I want to insert 10 records based on some condition
Categories:
Add Categories
When adding more than one category, separate them with commas.
Anpanman
Date:: Mar 07, 2009
Time:: 00:07
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-bz_9... And see an example here: http://www.developerfusion.com/code/5357... 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.
Date:: Mar 10, 2009
Time:: 01:19
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.
Time:: 02:30
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?
Date:: Mar 13, 2009
Time:: 08:18
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.
Date:: Mar 17, 2009
Time:: 01:58
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.
Date:: Mar 20, 2009
Time:: 07:39
Anpanam Thankyou for your response.thankyou.
dlcasale
Date:: May 13, 2009
Time:: 18:14
System.Data.SqlClient.SqlBulkCopy if you are pushing data into sql server. It will take a datatable, data rows or a data reader. You will also have other options such as fire triggers.
admin
Date:: Jun 04, 2009
Time:: 21:33
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
DevilAct
Date:: Apr 07, 2010
Time:: 03:48
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.
Answer this Question
New User
Email:
Upon submission of this form, you will automatically be registered as a Quomon user and we will send your login information to this address
Registered User
Username:
Password:
Forgot Your Password?
Enter your email address below and we will resend your login information to you.
Login Information Sent
Questions
Hi is there a way to retrieve the loop count in XSLT
how do repair this problem: every times i opened my laptop it will suddenly n...
How i get the hp pavilion dv6-3054tx laptop bottom base assembly as a sparepa...
I don't have AOL browser but privacy scan shows hundreds of files/cookies fro...
wireless keyboard has stopped working
need validation controller for textbox in java
You have 100 characters to use
Rank
Expert
Points
1.
10279
2.
6493
3.
5596
4.
4848
5.
3487
6.
2840
7.
2770
8.
2303
9.
1820
10.
917
Register today to share your knowledge with the community and be recognized and rewarded for your contributions.
Register Here
"Psst, Quomon is a great site. Pass it on." Tell a Friend | Link To Us | Save to Delicious | Digg it
Language Options
English:
Español:
Sponsors
Questions and Answers Software