DataSource Controls :: How To Create Multiple Records In A Dataset From Multiple Databases
Mar 7, 2011
I am trying to design my logic to do this but I want to create a dataSet which will have records from several databases, The records all have the same layout.
I am reagin the connection string paths from a table in a database.
I am asking for your help in trying figure out my logic.
Should I use the connectionString builder in conjunction with a loop to Connect, read a record into a dataset Until therer are no more records to be read from my databse table with the database name/paths tables ?
Here is my beginning code which deals with one database:
Well I Am Working On A Client Project Who Was Earlier Using A Software Developed On Foxpro database And Now I Am Developing Advanced Reporting Based On Same Data Of Existing Database
I Am Prohibited To Create New Database, I Have To Use Existing Database Now Problem is That There Is A Report Which Require data from multiple database
database are related Like This
Database (a) 1 Column is Common in Common In Database (b)
database(b) 1 column is common in database (c)
like that
what i am doing is that, I First Filled A Dataset With Required Value Then I loped This Dataset Row For Value On Which I Have To Get Data From Another Database Again I Stored new data in another dataset and After Looping, I Merged It With Previous One.
I have a dataset with 3 tables that are inner joined. Thsi dataset is connected to an object datasource which is connected to a gridview. So at runtime it displays data from the database. The problem is when I click on a save button to add information to the database it throughs me an error saying Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. But if i have two tables in my dataset it works 100%. But the problem i need that 3 tables in order to pull the required information. And if i populate the gridview using code to select the information from the database and insert information it also works 100%.
I have an inventory page with a gridview that shows 1 item per record, each item starts with a checkbox in the gridview. Currently users can select multiple records and hit the order button and everything has worked well. Now I have multiple pages in my gridview, and if a user selects a few records from the first page, and then goes to the second page, all the records (checked checkboxes) disappear from the first page.
I have 2 databases one called DB1, and the other DB2. Both of them has exactly the same design (tables, procedures and etc..)
Now, I am using SQLMETAL to create the DataContext. problem is that there are two lines that direct to a certain database and so I cannot use the same code for both databases.
here is the code:
[Code]....
Now, What I am lookin for is a programmatically way to change this two lines (DataBaseAttribute and the connrection string) .
The easiest solution for me of course is to create the class twice, with the same code and just change manually what I need which is not what I am looking for.
There is a full discussion with microsoft stuff right here: [URL]
I have a dataset that comprises of multiple tables (about 20) linked together with constraints to reflect the relational database. My question(s):
1) Will having multiple tables affect performance? I'm asking this as there are often times I would not need to get data for all the tables, but only for specific tables.
2) If it does affect performance, would breaking up the tables into their own datasets be the best solution. It seems to me that by doing that, you would lose the ability to apply constraints among tables and tables that might exist in multiple datasets will be subjected to replication.
I would like to have everything in one dataset as I get a view of the related tables and their relationships and also because the Fill method allow me to fill tables, maintaining the hierarchy of the data, but performance is still a key factor.
I have Gridview on my webapplication and it is getting filled with multiple rows . When clicked on Save I want to Insert all rows without calling multiple database hits.
Is there any way I can insert all rows by single db hit?
I'm creating a site that will offer several different services (blogs, videos, images..), all under the same site.
Each service will use a separate database and all services must use the same membeship info. Users will only need one login to access all these services.
For the membership database i will use the default aspnetdb database.
There are two ways i can think of:
1) Use a join-query between two databases, each time i want to show some service records per user.
2) Create a custom membership-info table in each service's database, and keep it in sync with the master membership table in aspnetdb database.
I was in need of exporting multiple tables in a DataSet to an Excel file with multiple sheets. I found a very good article in [URL].[URL] was able to successfully export each of my datatables in the dataset to excel worksheets. This solution worked for small number of rows. But when the data got larger I am consistently getting the system.outofmemoryexception. THis is because the code is using up the memory when creating excel.
Would it be better to have a sp return multiple result sets and use NextResult() or have subsequent call to dr.execute.... () and hadle one result at a time?
To me using nextResult() on a multiresult datareader would be cleaner and easier - but it does not seem to be very "atomized". I guess I am wondering can the cost of executing multiple commands be neglected? Seems like executing multiple commands and receiving a single result set would also be easier to read/test/understand.
I have read up on uploading multiple images and storing them to a file but so far i am only able to store one image into both file and into database. The problem i have is that i don't know how to create the table to store more than one image?
I have a situation where i have a dataset with many, many rows but few columns (5). Lets say in one row i have A,B then somewhere else in the dataset i could have another row that has B,A. What i want to do is if A,B exists then remove the row where B,A exists.
I am using dataset which contains some records I want to query with dataset to get every time next 20 records. I don't want to do it throught loop is there any way that I can get next 20 records everytime.
I have a form which inserts data in DB on Submit button click but the problem is when client click the button multiple times its sends multiple create requests means multiple button click events for the same time of same data, which must not be.
I tried to disable the button when client click the Submit button first time but after this it does not call server click event handler or not fire the server click event once it got disabled.
Does dataset store all its datatables' records into server memory if I just call one datatable from it?Lets make an example, a dataset with three datatables - tbCompany, tbCompanyStaffs, tbSalesOrderwhere tbCompany is the parent of tbCompanyStaffs. tbSalesOrder is an independant table.Does dataset load all tbCompanyStaffs records into the server memory as well when a class retrive data from tbCompany?
i want to develop a data access layer ,it can support multiple database like oracle ,Mssqlserver and Mysql using enterprise library and C#.net 3.5 based on database connection
I have a Vendor table and a Vendor Contracts table.I have a ddl outside of formview that selects VendorID and VendorName from the Vendor table.
FormView gets the VendorID from the ddl attached to the Vendor table and populates formview with records from the Vendor Contract table with the same Vendor ID. The primary key of the Vendor Contract table is VendorContractID.
This works fine as long as there is only one vendor contract. If there are multiple contracts, the ddl shows the vendor twice and aborts when selecting.
If there is only one vendor contract, the vendor is listed once in the ddl and selecting it causes the record to display in formview and is updatable.This is related to an earlier post today solved by PeteNet.
Is it ok to do multiple records update with the following requirements and be safe that the operation will not get timed out? A user requiring me to do the following using a web form:
I. Display a list of accounts in a GridView for multiple records insertion with no client side validation. Each account will accept new reading and posted date values.
II. Once the user presses the submit button, the following steps will be performed for each record at server side:
1. Check if new input data is for new or old period. A checkbox is to be selected in the form. 2. Check if new data has existing related records. Else this is first time insertion; get consumption result and save to db. 3. If records found, get previous reading and date. 4. Check if new reading and date is greater than previous reading/date else should inform the user. 5. Get new consumption = new reading - previous reading and some other operation. 6. A join select statement will be used to get the lowest and highest values (consumption) for current account. 7. Compare the new consumption result with previous consumption to give a status indication for new reading as either high, low or normal to be saved into the db. (# 6 values will be used here) 8. If everything goes ok, save new data into 3 different tables. 9. Display the GridView with new data.
The SQL server and the hosted page are in two different servers.
i have a gridview inside an edittemplate formview control in a master/detail scenario
so in the formview i have some comboboxs/datepicker/..etc corresponding to the master table
and a gridview corresponding to the detail table
in this gridview i enabled multi editing of rows like in this article[URL]
the problem is that even i change the values on the gridview , if i click the update button of the formview the "details table" changes isn't submited to the database
