View Complete Post
Can anyone give me suggestions on how to implement the following requirement?
1. A online wizard (step-by step operation) processes user requests across several ASP.NET pages. The session data is stored in memory until the user submits the request. Once the request is submitted, a XML file is created and the data are passed to XML.
# Case Study: The parent page has a "select" button. Click "select" will pop up a child page. The users can select 1000+ items from a datagrid in the child page. Once the user clicks "confirm", the selected items in the child page will be populated to the selected item gridveiw in the parent page. The user can keep selecting more in the child page and the selected items will be appended to the gridview in the parent page.
- What's the best way to extract strings from a text file and convert to a dataset in memory and then present it in a datagrid in UI?
- What's the best way to persist and manipulate a large dataset across pages? Session? or ViewState? Can it be accomplished by LINQ?
The app doesn't interact with a DB. Once the request is submitted, it will convert the in memory data to a XML file. What technology can be used to accomplished this?&nb
I have one problem is that when i send large dataset containing byte array.. then webservice not respond well..
it shows error like underlying connection was closed...
I mark that when dataset size goes some large then only problem occurs otherwise it works well..
Please give me solution of how to send large dataset over web service...
I'm hoping to understand the behavior of SSRS a bit better in the following scenario (SSRS 2008). A single matrix (tablix) exists on the report. No other objects are on the report. That matrix is populated with 1.1 million rows of data
totaling about 200MB. Why does SSRS download the entire dataset prior to rendering the report's first page or am I missing something here?
When previewing the report, the local .data file bloats to 200MB indicating all dataset rows are being returned. The matrix does not contain any sorting, all cell "can grow" and "can shrink" properties are set to false, no expressions
are used anywhere, and even the table's column data types from which the data is being pulled are appropriate. In other words, I believe I've reduced storage and CPU needs while eliminating elements that add overhead when rendering a report.
The specific scenario here is a researcher previewing the first few pages of data then choosing to download the entire dataset. MS documentation I've read refers to "soft page breaks" when rendering as HTML and left me with the impression
that perhaps SSRS needs to know the entire height of the dataset before it'll slice the report into pages. It's odd to me though that it needs to download 1.1 millions rows of data befor
Reporting Services 2008 R2
I have a rather large report that returns around 40,000 records. (I've tried telling the business that this is not a useable report and no one is listening.)
When I execute the report through a webservice and stream it to an excel file the response time is fine. Trying to load the report using the report viewer control it just hangs.
When I run the report through SSRS own Report Manager, I get the following error
This is on my own local dev machine at the minute and I've only just gotten the correct dataset it will be run against.
The stored proc runs in a couple of seconds.
Does anybody have any suggestions in what I can do?
Any help would be appreciated.
Basically, I have combined 3 call logs from verizon (comma-delimited), t-mobile (comma-delimited), and a internal system (SQL Server) into one table. Built a dataview to a table that right now with test data has 300,000 rows and will have lots and
lots more and all fields are varchar() in database even date and time. Since I have 300,000 rows, I paged the data at 1000 as this would take a long time for everything to load.
So building the dataview was a challenge to get working but figured that out. Now I am trying to build searching functions so that someone can search and filter the results on date, time, and really any of the fields. I attempted a form webpart
and setup parameter for search and it kinda works when I have a few test rows. One thing I noticed was if the data was on another page it did not include those in my filter and I think if I paged over eventually I would find it.
So my ultimate question is how would I add filtering/searching into this dataview. Could I dynamically adjust the query for the dataview like on said date range based on dates in form web part? Is there a better method for anything I am trying todo?
I have searched on net and even i worked on 2 huge shipping projects.
Everywhere i found that while binding data to control use dataset but when we save, they recommend use command (use generic collection and create command object with store procedure) why not we use dataset as in .NET 2.0 it is improved lot and data adapter has new feature batchupdatesize.
why we need to create property page which maps to all column in a database.
E.g. if i have employee table with empid and empname in database then i use to create emp.cs with properties of empid and empname and use same properties for saving. If i use these properties for validation in business rule then no problem. But why we use them in saving for creating command object.
I follow the tutorial and create DAL with Dataset. I created a Table Adapter with many column, but when i Call a simple Get for 2 column only. The system display 2 column and the rest column with empty data.
My question is that will this affect the performance? because i only need 2 column.
example: Table with 40 column define in Dataset in DAL. I have GetMember from Dataset with 40 column, some request only 1 column (with 39 empty), some request 22 column (with 18 empty column). Will this affact the performance?
Should i create a seperate DatasetAllColumn, Dataset1Column, Dataset22Column ?? so system only return exact column i need. and hofully the performance is optimized to it best.
i have a stored procedure which returns three tables to a dataset ..... now i need to merge all three tables to a single table from d same dataset
like dataset1 has table1 table2 and table3 .... i want all the three tabels to be merged into dataset1 itself .... instead of three diffrent tables so that i can show all three table data in a single datagrid as a compact data and combination of 3 tables from d single dataset.....
can some1 help me please.....
I know how to export a grid view to excel.
But here i have a Dataset which consists of data like below and also it need to display in a required format like below.
pno psubno pstate pdetailid pdetails
12 1 CA 1 cbsdjcbdjc
12 1 CA 2 cndcnjdcjcj
12 2 VA 4 xcndwkfcgygry
13 1 AL 1 ncdcnjdcndj
My excel sheet should like this.
12/1 CA &nb
i'm new in reporting so thanks to be patient with me,
here is my problem, i have created a report then a report viewer,, i passed some parameters to the report it goes well.
i'm working with local data stored in List<object>, i tried to fill my dataset (data) with those local data stored in the list, i filed
looking for yor help
I am using rdlc reports in my appln. Am trying to generate a huge pdf file which almost consists of 1500 - 2000 pages.I have used ReportViewer and am adding datasource (Generic collection) to report. But am getting system out of Memory exception as it is a huge file.Can any one suggest me how to generate large pdf files in asp.net c#
Udi Dahan explains how his team identified and overcame unforeseen problems while developing a large-scale software + services trading application.
MSDN Magazine April 2009