How many tables can we upload in dataset.
What is the maximum size of dataset. advantages and disadvantages of ado.net
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 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
ADO. NET 2. 0 sports some exciting enhancements to the core classes found in ADO. NET 1. x and introduces a variety of new classes, all of which promise to improve performance, flexibility, and efficiency.
MSDN Magazine November 2005
MSDN Magazine June 2004
Edited by Nancy Michell
MSDN Magazine October 2003
ADO.NET provides many techniques for improving the performance of data-intensive applications and for making them easier to build. The DataSet, the hallmark of the ADO.NET object model, serves as a miniature, disconnected facsimile of a data source. While using the DataSet improves performance by reducing expensive trips to the database server, it also introduces the possibility of multiple users attempting to change the same data simultaneously, thereby generating data concurrency exceptions. This article examines the common causes behind data concurrency exceptions and presents techniques for overcoming them.
MSDN Magazine April 2003
MSDN Magazine July 2002
MSDN Magazine May 2002