|
Hi,
i have a requirement to read a data from a file and load it in to the database. Before loading in to database directly. I am reading data to data table and processing the row by row and then loading in to the database.
If a file contains..5 million records, can datatable handle that one?
is there any limit for datatable?
G. Satish
|
|
|
|
|
Why don't you try it and see ? It sure sounds like a dumb move tho, what are you hoping to do with these 5 million records in memory that you can't do in the DB ?
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Actaullly, i didn;t find the direct method to load the csv file data to database. I find the method to load throught the datatable. But i know, it occupies more memory and the appliction will crash.
Is there any way to read the records from csv file and load it into sqlserver database?
G. Satish
|
|
|
|
|
Definately not all at once, do it in batches, reading from a stream.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
DTS/SSIS depending on your version of sqlserver, or bcp which works with all versions.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Satish - Developer wrote: Actaullly, i didn;t find the direct method to load the csv file data to database
There is SqlBulkCopy[^] class which is very useful to insert data into SQL server database. You can use OLEDB to read from the CSV and get a reader from it.
|
|
|
|
|
No Inherent restrictions on That .....but ur page becomes really heavy with so big DataTable
Use "Custom data providing" for manipulating large Datasets ...
see this link http://support.teamdev.com/thread/796[^]
|
|
|
|
|
i am using jquery in asp.net page .
jquery is working fine in page but when i fire a server side event on image button click after clicking on any jquery event
page produce error like
The state information is invalid for this page and might be corrupted.
please help me
thanks in advance
no knowledge in .net
|
|
|
|
|
|
Hi guys,
vs2005 having inbuilt iis?,
With out iis installation it will work?,
I know with out iis .net framework wont work,
But i have doubt on it vs 2005 having inbuit iis or not?
Plz clarify my doubt?
Thanks & Regards,
Member 3879881,
please don't forget to vote on the post
|
|
|
|
|
It has a web server built in, but it's not IIS. It's fine for testing tho.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Thank u Graus
Thanks & Regards,
Member 3879881,
please don't forget to vote on the post
|
|
|
|
|
Member 3879881 wrote: vs2005 having inbuilt iis?,
NO. It is called as ASP.NET development server. It has very few features when compared with IIS.
Member 3879881 wrote: I know with out iis .net framework wont work,
It will
|
|
|
|
|
Member 3879881 wrote: vs2005 having inbuilt iis?,
No
Member 3879881 wrote: With out iis installation it will work?,
Yes, becuase it has it on Application Server to Run From IDE
But if you want to deploy it in sever from where every one will going to access, you need IIS.
Member 3879881 wrote: I know with out iis .net framework wont work,
Wrong !!
IIS only required if you want to deploy the application on web server.
.NET Framework can work with out IIS.
but if you want deploy an asp.net application on IIS then you need to install Proper Framweork.
Member 3879881 wrote: But i have doubt on it vs 2005 having inbuit iis or not?
No. VS 2005 has it own ASP.NET Runtime App Server.
Member 3879881 wrote: Plz clarify my doubt?
Hope now your doubt is cleared !!!
cheers,
Abhijit
|
|
|
|
|
hi,
i am working a project which needs to convert the xls,doc,ppt,rtf to pdf format.i search but couldnt find a library or dll that does all these format. can anyone plz help me out.
regards
Navin
|
|
|
|
|
I only found one, and it's about $8k, from memory. Aspose, I think are the people who sell it. You need to buy their whole toolkit to convert word docs. It does XLS, it doesn't do PPT.
A print driver is the quick and dirty way to do it.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Hi,
You can use MS Word 2007. then save as to file .pdf 
|
|
|
|
|
thank you for the reply
but sorry , i dont think you understand.let me clarify, i want to convert the xls,doc,ppt,rtf to pdf format in a asp.net website project .so i when a user upload a file,which may be xls,doc,ppt and rtf it should be converted in to pdf and should be stored in the server.hope u can help me.
|
|
|
|
|
He's right, you can control Office 2007 to create PDFs, you could do this on your server.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
oh, ok Thanks for the help, can u kindly post a sample code for converting ppt to pdf using office 2007
|
|
|
|
|
when i open 2.0 site in 3.5 and try to run it. it gives me error...related to web.config file error is as follow..
"It is an error to use a section registered as allowDefinition=MachineToApplication beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS"
right now i have nothing to do with iis i have want to just run locally
any solution for this...????
umerumerumer
|
|
|
|
|
That section is in an app config below the root. Remove it.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Hello guys, I'm working with ASP.NET 1.1 and the validations are not working on the client-side with firefox, it's working fine on the client-side with IE and on server-side for both, can anyone help me with this?
Web Developer
|
|
|
|
|
It's possible they are not supported for FF. Why are you using 1.1 ?
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
