DataSource Controls :: Display Results From Two Separate Tables In Two Separate Databases?
Jan 14, 2010
I have access to two seperate databases (mySQL) located on two servers. I need to get the data, link the tables on a key field and display the results in a datagrid. My challenge is that if the search criteria changes for the display it affects rows returned from on table and should thus automatically affect the linked table and resulting data returned.
what the best approach would be to achieving this? So far I have set up a dataset with a dataadapter and table for each connection and then linked the tables in the dataset. The problem that I'm having is getting the linked resultsets to work.
On my form I have the datagrid with two Objectdatasources one for each dataadapter and i believe that's where I'm going wrong...
I am trying to create a search filter much like the one used on eBay that dynamically comes up with appropriate search categories based on the search results left. For example: [URL]
As you can see the search filters on the left are based upon the details displayed on the product results.
I need to try and implement something similar for an ASP.NET site, whereby I need to filter articles based on fields such as sales, companies, employee numbers etc. My database is quite normalised so I am able to separate all the data into their own tables.
have ui layerand i have two table for examlple1)Dept2)empin databasein ui layer i have seperate panels for insertion of dept fields, and emp fieldsi have two conditions apply sepreatly , here for insertion of two fields 1)if dept fields insertion faild i dont want to insert employee fields to insert in emp table2)if dept fileds insertion is sucsessfull and employee fields insertion fail i dont want to insert employee fields in employee table and i want to delete previously inserted dept row from dept tablehere no relation between two tables and here can i use transations
I'm trying to achieve something very similar to a forum. Two basic tables in a database, [Thread] and [Comment] (one to many relationship).
I need to create a form using MVC that creates the initial Thread, and also the very first comment row in the [Comment] table, which references that topic.
Would I need to create a custom object for the View Model? Is there any examples anybody knows of that demonstrate what i'm trying to achieve as I can't seem to find information..
I'm working on a new asp.net 4.0 resume web site. I'm starting off with SQL Server Express 2005 and using the standard security and login features given with ASPNETDB.mdf. My site will be hosted on GoDaddy.com.
Quesiton. Should the tables that will contain the information that users will be putting in like resumes, contact information and such go into ASPNETDB.mdf or should it go into a separate database.
We have a spreadsheet that has a Zip column. These zip has a plus 4 digit in this format 99999-9999. When I looked at the format of this cell, it was a Special format with Zip+4 type. I just need to get the 5 digit zip code but the problem I am running into is the leading 0s. I tried =LEFT(A2, 5) but this trims the leading 0s. I also tried highligiting the column, then DATA -> Text to Columns -> Delimeter with hyphen but that didn't work. Is there any other way to do this or am I missing something on my first two attempts. Please let me know if you need more clarifications.
We have a ASP.NET 3.5 application where we want each user to have their own database. Everyone uses the same web application, but the database their data is kept separate from all others. So every customer has his own database. All database structures are identical, so the only thing the application has to do is connect to the right one when the user logs in.
I envision that we look up a connectionstring to their data at the time they log in and set it globally for that session. With Linq, the connection is handled automatically though, in the background, based on the setting in the web.config file. Unlike SQL Server where you set it each time you use it, with Linq it is hidden in the .NET generated class files. So how do we make this vary by user, while using the same application for everyone?
I am working on a multi-lingual application Assume the following:
Database has 50 tables and application has to support 5 languages
Which is the best way to design the database:
1. Include a langugae column for each table. Repeat the values for each language. Say i have a country table which has 100 countries in it. Then my design will contain 500 rows (100 for each langugae)
2. Create a separate table which will contain the translations for all the 50 tables in with a foreign key to the parent table.
i have a need to display the each row in a separate page,
example: if a Grid view contains the 10 rows,each row should be displayed in one page(only that row only),when ever second row comes, first row should be removed from grid and second row should be displayed as a whole in that, like wise..when ever 3rd row comes 2nd should be erased and 3rd will come into Grid view.
i am using following code but not getting result as i want,
I am using a DataGridView and have a master table which contains values which different tables related to the master data, i.e. StatusID =1 in master table = TrailerStatus (1, 2, 3, 4 and their descriptions) are in a related table. I am able to retrieve the values from Table B 1 = Empty, 2 = Rejected, 3 = Onsite, etc. However, I don't know how to relate the master table StatusID = 1 to default my dropdown list from the relational table 1, 2, 3, 4.
I have been fighting with this for quite some time and just have not found a solid example of how to do this. I actually have two dropdownlists which will need to be correctly wired in order for my application to work.
This will also be an editable dataGridView but I will tackle that challenge once I get this first hair plucked from my butt.
There is some code-behind which doesn't work at all pertaining to a ;; gvSCACDetail_RowDataBound ;;
but I dont' think I can even get the code to compoile when this is not commented out.
I've a dropdown list for departments (engineering, bio, chemistry,physics etc.) when somebody choose the departments from the dropdown list, it displays the opening closing time(hours) in a detailsview controls.
I have separate homepage for these departments ( these are the static html pages and no way to send querystring value) and I want to link the hours for each department from the departmental homepage.
When I choose the department from the DDL, everytime it's the same URL.
How can I solve the problem So that I can point the respective hours from the respective departments ?
This code returns MdaID and StateID, I want to assign them in this manner:
MdaIDLabel.Text = MdaID and StateIDLabel.Text = StateID, but I am not sure how to separate the two values and then to assign them as I have indicated above. Since my function has a "void" return -
MdaIDLabel.Text = GetMdaState({0}, 64114);
StateIDLabel.Text = GetMdaState({1}, 64114); - will not satisfy the requirement.
I am working with VS 2008 VWD, .NET 3.5 SP1, C#, SQL Server 2008 Express
I am retrieveing data from an API and after getting the data to my code behind by instantiating the proxy, I am not able to display the data line sperate lines . ( I am using Response.write(feeeddata);) to display the data onto my webpage from code behind in page load.
here is the eg: I have data 1234567890asdfghjklpoiuytrewq and I want to display like this on the webpage
1234567890 asdfghjkl poiuytrewq ( like seperate lines)
I am using foreach to retrieve the values of the properties from feed( jus letting you people know so that if ther eis anything i can include in my foreach to do the trick)
I have an ASP.NET Web Site I am creating in Visual Web Developer 2008 Express using Visual Basic as the language. It is actually a rewrite-with-mods of an existing ASP script and I'm trying to chew what I've bitten off. I created my page with a text box (txtOutput) on it and since the end product is very complex, and it's generally good practice to separate like functions, I have created 4 separate classes in the App_Code section.
My main page is Sync.aspx and has a code file Sync.aspx.vb with it.
One of my code files is SyncDatabases.vb and in it I have created
Public Class SyncDB
In that class I have created some routines such as
Public Function ReadMSDB(ByVal SQLString as string) as Boolean
In this routine I want to put information in my text box txtOutput on the main form (the default - Form1).
My problem is that if I try:
Form1.txtOutput.Text = "Hello world"
or just
txtOutput.Text = "Hello world"
it says Name 'Form1' (or 'txtOutput') is not declared. I am sure I am missing something simple but have no clue what it is. I assume it's the fact that the write command is in a file (class?) outside the file (class?) containing the page itself but I don't know how to address it properly.
I'm wondering how I can go about accessing page controls from a separate class I've made. I've tried a few things I found using google, but no luck :(
What I'm trying to do is keep a function that is used often, in a global class.
The function then accesses a page literal and calls ScriptManager.RegisterStartupScript. I was hoping this is possible, so then this function wouldn't have to be copied to all of the pages.
