Answers
Mar 06, 2009 - 08:07 PM
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.
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.
Mar 09, 2009 - 10:19 PM
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.
Mar 09, 2009 - 11:30 PM
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?
You didn't mention where the fees details come from. Is it a file, do you type it in manually on a webpage?
Mar 13, 2009 - 05:18 AM
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.
Mar 16, 2009 - 10:58 PM
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.
I'm not going to program the whole thing for you, but I'll be happy to give advice.
Mar 20, 2009 - 04:39 AM
Anpanam Thankyou for your response.thankyou.
Jun 04, 2009 - 06:33 PM
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
The Quomon Team
Mar 21, 2012 - 01:19 AM
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.
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.
Add New Comment