DataSource Controls :: Saving Big Amount Of Data?
Jun 25, 2010
I have an application that is developed using VB.Net that is saving data in SQL Server 2008. in this application i have to save a big amount of data in one button click. When i say big i mean around 21000 record in one table. this is taking a lot of time since I'm calling the "Insert" procedure around 21000 time from my application. What i want to do is to find a way to put my data in a kind of container then let VS or SQL 2008 manage the saving. I'm thinking of putting the data in a dataset.
Is this the best solution, or is there any other way to reduce the saving time of the 21000 records?
View 2 Replies
Similar Messages:
Feb 15, 2010
I have contact mails large than 700.000 Mails and i want to insert them in sqlserver using c# in a few minutes not hours i know that pre impossible but , i know there`s way to do it
View 4 Replies
Sep 15, 2010
I have a problem. I have a textbox where i enter the amount and in another textbox the amount in words comes automatically. The function appended below works fine when the amount entered is without a decimal. But if the amount entered has a decimal, then the function gives an error. Can anyone check the same and tel me a solution.Wat i want is suppose the amount entered in 2345.68 the amount in words should come, Rupees two thousand three hundred forty fve and sixty eight paisa only. if the decimal is not entered then the function gives proper result.
[Code]....
View 2 Replies
Jan 30, 2010
We have a web application that allows users to upload sales information in Excel format and store the information in our SQL server. The way it works is that the uploaded Excel file will be stored in a folder on the web server, the application will then open it up and read it row by row, and call a stored procedure to store each row's data. Now it is so slow that if the Excel file contains more than 75 rows of data, the application will just time out.
We have already increased the timeout limit by changing the executionTimeout to 300 seconds in the web.config file. Instead of increasing this further to wait for this slow process, I'm wondering if there are ways to speed it up. Is there a better way than calling the stored procedure row by row?
View 3 Replies
Feb 21, 2010
how can I create a query in order to select some records every time user wanna to display them into a gridview. I don't want to select all entire records from my data source. What I exactly want is to simulate pagination by query.
View 1 Replies
Apr 8, 2010
How would I determine the amount of time in weeks between two dates and compare that value to another value in Linq, for example:
Where the amount of time in weeks between (startdate and enddate) = value x
View 1 Replies
Jul 9, 2010
I am trying to calculate the total amount of shopping cart by multiplying the quantity with the product price and then sum up the sub results.I am doing this but it does not make the multiplication.
[Code]....
decimal? TotalAmount = (from shopCart in dc.KP_ShoppingCarts
View 1 Replies
Mar 25, 2010
I have a work request web page that now has a need for my users to add screenshots to.
View 2 Replies
Mar 23, 2010
had a look around and a couple come close to the problem I have, but there more evolved than me, so it seems quite basic.I basically, want to store the current DateTime of when a button is hit. In order to achieve this I have a field in the table of SQL DB called 'TimeStamp' (Although strictly speaking its not, thats just what I've called it) using Datetime Datatype. I think I'm skipping some stages in order to accomplish it, although I'm not sure what it is I'm missing/doing wrong :SHere is my code:
[Code]....
I just have DID have "obj.TimeStamp = DateTime.Now;" but states I need to convert it (unsure how to do) Adding "ToLongTimeString" after .Now asks if I invoked the method. I've also tried a few other ways (saveNow.Now etc... ) but to no avail.
View 13 Replies
Apr 28, 2010
I have a problem with saving hebrew into sqlserver.I've done it before in another computer but did not have problem.Now the hebrew is saved as '???'.About the field collation, it is latin1_general_cp1_ci_as in another DB I have in another computeranf also in the current field in the current DB.I guess it not the collation.Ialso tried to change the text field to varchar, but it still saves '???'.
View 9 Replies
Mar 26, 2010
I have to create PDF Files reading data from SQL Server where the data is in Binary format as Image data type.
View 2 Replies
Jul 2, 2010
I am generating some text on my application just like as below;
KgQa5MgxIXH6czaTSue/zcjQ6p5d4BCK2uNgscHq3+h/gbbrfEPvWGySnZGy88ntm28DPFp3KhDFQhXHNkZecQI0HyBq7BDJTop6n0VgTWc2AQEnZWPvEgHc4vMTDIfnoY+/04414vOUdatD8G+CZexcJQr0Tz4jLkDEsI58xcc=
I wanna save this text in my sql db as binary.I wanna retrive it any time I want and read text and view it. How can I do that in c#. Aslo what should my table row type? binary(1000) is ok?
View 6 Replies
Jan 5, 2010
I am facing a problem with retrieving an image and showing it on asp.net grid. I migrated MS Access database to sql server. Image are visible in Crystal report when fetched from the same database (migrated sql server database). But same images are not visible in ASP.Net grid view or simple asp.net image control. Following is my code
SqlConnection oConn =
new
SqlConnection(ConfigurationManager.ConnectionStrings["csr"].ToString());
oConn.Open();
SqlCommand oraCmd = oConn.CreateCommand();
oraCmd.CommandText = "select top 1 photo from [test] where photo is not null";
SqlDataReader dr =
null;
dr = oraCmd .ExecuteReader ();
if(dr.Read ())
if (dr["photo"] !=
null)
{
Response.ContentType = "image/gif";
Response.BinaryWrite((byte[])dr["photo"]);
}
This function is getting called from another page . "hlopen" is hyper link in the grid. hlopen.NavigateUrl = "GetPhoto.aspx?id=1";
View 1 Replies
Jun 7, 2010
I have a table with a varbinary(MAX) column. I want to use the FileUpload control to save the file directly there by a stored procedure. How do you do it without using SaveAs to create a temporary file first?
View 9 Replies
Sep 24, 2010
how do I go about inserting into a database special characters such as the uppercase O, umlaut Ö Please understand that I have been able to insert the special character from inside MMS by putting an N in front of the value but when I run the SQL file from inside an ASP.net 4.0 page it comes up as a diamond with a question mark in it
View 12 Replies
Jan 19, 2010
Here is what I am basically trying to accomplish I want to upload images to the server separated into categories and save the file path into the database. I have found plenty of documentation on saving to a file and the file path to a database. But, I haven't found anything that will allow me to seperate the images into categoies.
I have made three tables in the database
[code]....
What I am trying to do is create a gallery for our clients to browse and download different vesions of posters and ad cards.
View 15 Replies
Mar 5, 2010
we have a classic ASP Webpage for displaying reporting data.
The process is following:
user inputs reporting criteria reporting criteria are passed to a method in a VB6 DLL containing the reporting business logic (generating a dynmic sql statement) VB6 DLL method returns xml data xml data are displayed with xsd transformation 150.000 datarows are displayed in some seconds (less than 10 seconds maybe) Now we want to extend this reporting function and decided to use asp.net (2.0) So I have written a little prototyp application with a SqlDataSource Object and a GridView Control.
A table with less data (about 100 or so) are displayed quickly.
But a view with about 150.000 datarows needs about 2 minutes and ended with a OutOfMemoryException!
The request of the customer is definitvely to display the data on one page like in the old classic asp application!
View 1 Replies
Mar 7, 2014
how to display large amount of data in griedview with serach funcationality.(the data should be 20 L)with example in asp.net.
View 1 Replies
Jun 9, 2010
i have an datatable called orders. One of the columns is "OrderAmount" In the aspx, page I have a datalist and am using the {0:c} in the item template but it is not showing the £ symbol or the amount in correct number format.
In my datatable I am not sure if I need to use Int or Float.
the amount I want to enter is £21,316.56. I have tried entering 2131651 but it does not display correctly in data list.
View 1 Replies
Dec 17, 2010
I am working with GridView, When huge amount of Data is inserted in the GridView its columns became very thin all tall, however I want to Display the Gridview with Fix size and if the Data is hugeit only display the starting few words of Data.in other words I want to use gridView same like the GMAIL account where Data Display like this. .
View 2 Replies
May 7, 2015
I want to bind large amount of data in gridview using jquery but without paging.
I am taking reference from this post
[URL]
But when there is large amount of data, it's not working
View 1 Replies
Nov 18, 2013
i want to display amount in installment using grid view, the amount and no. of installment will be user define in text box.
View 1 Replies
Jan 20, 2010
I creating a page where our clients can view advertising images and then able to download the images in different file formats. So I need the images and the different download types all saved into the same row in the database so that when I go to display them on the page when they select a picture the right download links will be there. So here where my problem comes in, I don't know how to code it so that I can insert mulitiple file paths into the database at once. The images are saved in a table called images. The downloads are saved in a table called Image Downloads.
Here is the code for the page I have it coded to submit the images to the database but not sure how to add the rest. I have got three different sql datasources for each table not sure if that's the way to go.
[Code]....
View 1 Replies
Jan 11, 2011
to format Amount in 00,00,000.00 in Bound Field of gridview?
View 8 Replies
Jan 22, 2010
it was possible to create X number of radio button groups depending on a parameter.
Say if I Selected Fruit as the parameter these groups would need to be created;
APPLE
- Green
- Red
- Pink
GRAPEFRUIT
- Yellow
- Pink
GRAPE
- Green
- Purple
And if I were to pick vegetable;
TOMATO
- Regular
- Cherry
POTATO
- Brown
- White
So when I pick "Fruit" 3 Radio Groups appear(APPLE, GRAPEFRUIT, GRAPE), and when I pick vegetable 2 Radio groups(TOMATO, POTATO). Obviously this sample data is dumbed down, and my Radio options are going to be retrieved from the DB. Can this be achieved?
View 3 Replies
