I'm thinking through data access for an ASP.NET application. Coming from a company that uses a lot of Windows applications with Client Data sets there is a natural dendancy towards a DataSet approach for dealing with data. I'm more keen on a Business Object approach and I don't like the idea of caching a DataSet in the session then appl...
Hi, I built an online news portal before which is working fine for me but some say the home page is slow a little bit. When I think of it I see a reason why that is. The home page of the site displays Headlines Spot news (sub-headlines Spots with pictures Most read news (as titles) Most commented news (as titles) 5 news titles f...
Hi, Please clarify me with this. I am going to design a report using SSRS 2005. Is it possible to have the selection of dataset done dynamically. Lets say i am going to have two tables, first one is the summary and second one is the detail data. One of my parameter (with values 'Summary' and 'Detail')is deciding which version of the r...
I need to load a file (usually ASCII) into a DataSet. How can I do that? What data types should I use for my columns? Thanks. ...
Hi, After thinking for long, I have decided to build my data app for the Not-for-profit organization I work for (I don't program regularly there, though...) using C#, .NET 3.5 (using ADO.NET DataSets) and Scimore db. I have done base basic tinkering till now and have found this combo to be quite good and fast. Ya, "fast" is a requireme...
Hi, I using the Ultrawebgrid- Update event:: protected void UltraWebGrid1_UpdateRow(object sender, RowEventArgs e) so, I want to update the row(updated in the grid) in the datatable (inside a dataset) The datatable doesn't hav any primary key too.. How can i find any row in such datatable? for e.g. i can go for UltraGridRow oldr...
EDIT: Note. I should have mentioned I'm not interested in using the .Select, DataRowView, RowFind, etc. Thank you for those suggestions but the code as it stands, I was hoping to optimize. I wrote a function to search a datatable for terms in an array. I then return the datatable as a dataset so it can be bound to a DataGridView. Do...
I have a VB.Net data set that contains data from multiple tables. Does anyone have any good suggestions on how to query data out of the dataset. I want to run SQL-like queries on a dataset to extract data that fits a certain "where" statement. ...
This is my XML file: <?xml version="1.0" standalone="no" ?> <!-- This file represents The Details of the user and the responces: --> <Survey> <Clientdetails> <ClientName xmlns="yash" /> <ClientCompanyName xmlns="lnt" /> <ClientTelNo. xmlns="546" /> <ClientMobileNo xmlns="56" /> <ClientEMail xmlns="56" /> <...
We have a pricing dataset that changes the contained values or the number of records. The number of added or removed records is small compared to the changes in values. The dataset usually has between 50 and 500 items with 8 properties. We currently use AJAX to return a JSON structure that represents the dataset and update a webpage usi...
I'm starting on a small windows forms project that makes extensive use of editable grids. I want to use Linq to Entities, but while it's trivial to bind a grid to the Linq query it's read-only. I couldn't figure out a good way to have an editable grid that auto-updates the database. (I hacked a work-around where I copy the data into a...
How do I load the following nested XML into a DataSet? <items> <item> <id>i1</id> <name>item1</name> <subitems> <name>subitem1</name> <name>subitem2</name> </subitems> </item> <item> <id>i2</id> <name>item2</name> <subitems> <name>subitem1</name> <name>subitem2</name> </subitems> </item> ...
Hi, I've tried to find an answer to do this online but apparently it can't be done (I mean at the app level, not database). I have a need to clear out my dataset completely and reset the primary key at the same time. Any ideas? Alternatively, one hack i can use is to reinitialize the dataset but that doesn't seem possible as well since...
I'm looking for some data to create lookup tables with. Specifically, all the counties in each state in the US, and all the cities in each county. Where might I find municipal datasets like this? EDIT: I'm looking at census.gov and this appears like it may be the ticket. ...
I have class person that contain FirstName and LastName, I'd like to create an array of person which is populated from a DataTable with columns Fname and Lname. How would I do that? ...
I have a web application that connects to WCF services for its business logic. I would like to use simple Dto's for transfering data at the WCF boundary for performance and interoperability reasons. However I have to use typed datasets for data access (ORM or any other option is not available due to political reasons). Is it a good ide...
I'm using c# and i have three datatables, all three have an int column named idnum, what i need is to keep all numbers in the column idnum unique in the three tables and the next number will always be the small available. For example: table a idnum=1 idnum=3 idnum=4 table b idnum=2 idnum=7 table c idnum=8 in this case the n...
I have a dataset obtained from MySQL that goes like this: Array ( [0] => Array ( [views] => 14 [timestamp] => 06/04 [views_scaled] => 4.9295774647887 [unix_time] => 1239022177 ) [1] => Array ( [views] => 1 [timestamp] => 19/04 ...
The following PowerShell code loads a SQL result into a dataset: $sqlCommand = "SELECT A, B FROM TestTable" $connection = New-Object System.Data.OleDb.OleDbConnection $connectionString $command = New-Object System.Data.OleDb.OleDbCommand $sqlCommand,$connection $connection.Open() $adapter = New-Object System.Data.OleDb.OleDbDataAdapter ...
I have a Windows Forms application with a DataGridView in one of the forms. The DataGridView can insert and update through a Typed Data Set generated by Visual Studio. I want to show user friendly error messages when a user doesnt fill in a required field or enters the wrong data type, etc. instead of the ugly huge one that is shown by ...