DataSource Controls :: The Database Their Data Is Kept Separate From All Others?
Jan 21, 2010
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 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 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.
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'm trying to figure out if it's possible to transfer records from SQL central database (who has a public IP address) into SQL local database (who doesn't have a public IP)?
or if it's not possible can I use a centralized website instead to pass some data into the local website? (but i'm not sure if it will have some security concerns)..
i would like to ask about how to sync data from client sybase database import to our sql server database regularly(set time to sync everyday) by create a file in our sql server database
Currently, we have our ASP.NET applications running on windows server 2003. All of our data resides on an IBM ISeries / AS400. The 400 people are going to be creating massive new tables with millions of records. Because of this, I've been asked to look into the idea of putting new ASP.NET pages on the IBM ISeries server. This server uses APACHE. I have read that to do this, I will need to use the Mod_Mono Apache module. I would like to come up with a list of benefits and drawbacks to this new idea. Initially, it seems like this is a bad idea for a few reasons:
Security: if a users gets unauthorized access to our local server(s), they will only have access to either DB or web server, not both. Maintainability: Microsoft ASP.NET is easier to implement on a Microsoft Windows Server. Problem Solving: I will have to first determine if an issue is due to the ISeries server, or the Apache server, or the ASP.NET application. This could be countered by saying that I would already have to determine if the issue is due to Windows server, or ASP.NET application. However I have better experience with troubleshooting on a windows box that I am familiar with.
Problem Creating: I could escentially create a problem that not only takes down the web server, but the database as well, and other RPG programs running on the ISeries. Resources: The database server will not have to server my application, it will only have to retrieve the data for it.
Drivers: The windows server already contains many drivers and .DLL's that are used... will these even exist on the ISeries? How easy (if even possible) would it be to get them on the ISeries if they dont exist..? A few positive thoughts: The application will reside on the same server as the data, thus, it may be quicker at retrieving data from these millions of records in a table. This was the main point as to why I should look into this possibility. Single point of failure. We no longer have to worry about two servers going down and causing this application to be unavailable...
I use VB.net and use sql database. My database' name is database.mdf. I create one button and one textbox controls. When put some words in the textbox and click button, the words will recorded in to database.mdf. How can I do it? If I put a paragraph of sentence maybe 1000 words, is it also ok?
Time in database e.g in about 5minutes ago, in about 30minutes ago, in about 1hr 20 minutes ago, which types of shema is used to create this data in database. i mean i want to create a time that will always show in this format.
new to this forum, and visual studio web development. Here is what I want to do: -From a webpage on my website, I would like to upload multiple photos to an sql database, but instead of having a container or field name for each photo, i would like to have multiple photos on one field, on each record.Then, I would like to display it back one record at a time, but with the capability of displaying all the pics from the one field holding the pics. Similar to the function in MS Access, where I can upload mutiple photos in one field and then display them back by just scrolling through them on the same record.
I was just wondering that when we insert some datainto database we can use the following method.
create a sql datasourse , set the conection string, set the insert comand type, set insert parameters, and Set the SQL Statement like sqldatasource.insertStatement="insert into tablename(field1, field2) values(@parameter1, @parameter2)";
and then call the datasourse insert() function, this method is usually used for single line insertion at the end of the DB.
Now I am a starter in asp.net c#,
I want to know that if There is a way that I have lots of data like some XML file that have the same table structure as the SQL database table and I want to write that data to the database, HOw to do it Properly,
I can Still achieve the required results by iterating through XML datarows and for each row conecting to db and inserting and then disconecting dfrom the db,
But I want to know that if there is a way to do it in one go meaning I have to conect to database only one time,
Note: I already have some data in my SQL table, there are three fields(ID Name and Nickname) the ID(primary key) is INT type and auto incremented, the name and nickname are strigns. the xml file has the structure
I'd like two websites to have read/write access to the same user profile database (named "aspnetdb" by default). Presumably this is possible by configuring the websites appropriately in the web.config.
I have a lot of members data to enter into the ASPNETDB database. How can I read this data from an Access data file and input into the SQL database. All data is for user Names and Password,
I am using an SQL Express server hosted on a different machine and it is listed in my server explorer just fine. It is listed as my connection string in my web.config just fine as well and lastly it seems to sync just fine with my asp.net membership tables. My question is does it need to be listed in my app data folder of my site? Currently I have the ASPNETDB.mdf connection listed, which is apparently just a local sql express connection. The database I am using in my webconfig and other files is not listed so do I need to add it there?
Second question is about DAL, Data Access Layers. I have mostly been using presentation level SQL commands with my data presentation controls. Manually entering separate select, insert and update statements. I just went through a tutorial that stated the best way to interact with your database in asp.net is with DAL using table adapters. It mentioned that it gives you the ability to use strongly-typed references to each row. My question is can I use the same method multiple times on a single page. For instance a method inside an adapter named GetProductsByID(@ID) ? What if I want this bound to three different gridviews on a single page? Anyone have any other general things to point out about using DAL over presentation level commands?
i'm new to programming and i'm doing a project of ana e-store, i have a data gridview that brings data from a data base and it have to more templeate files one a textbox and the other one is a label. and i have a button outside the grivdview. what i need that when i press on this button it will take the values from the grid view and insert them into a new sql table.
[Code]....
and here is the VB code that i'm trying to use with no luck : [Code]....
