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?
View 2 Replies
Similar Messages:
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...
View 1 Replies
Sep 8, 2010
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.
Here are some of the details:
<td style="width: 700px; height: 20px">
<asp:GridView ID="gvSCACDetail" runat="server" AutoGenerateColumns="False" AutoGenerateEditButton="True" DataKeyNames="trailerid,locationid,scacid,statusid,capacityid" AutoGenerateDeleteButton="True" DataSourceID="SCACDetailView" Visible="False" Width="698px">
<PagerStyle CssClass="centerh" HorizontalAlign="Center" />
[Code]....
View 2 Replies
Dec 27, 2012
I have one table in sql server called student_info
In this table keys kills column contain value like below
'c,c++c#'
'c++,c,c#'
'c,c++,c#,asp.net'
etc...
I want to search the student information based on keyskills like naukri
1.Any keyskills from textbox1
2.All keyskills from textbox2
3.Except keyskills from textbox3
When I enter c,c++ or c++,c in textbox1 then it will dispaly all the student whose have c,c++ keyskill
How to achieve this.
View 1 Replies
Jun 29, 2010
I'm trying to combine a date and time from separate variables in my asp.net insert sql. pointers? I'm getting the following error
Conversion failed when converting date and/or time from character string.
[Code]....
View 2 Replies
May 6, 2010
Stored procedure:
[Code]....
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
View 3 Replies
Mar 2, 2010
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)..
View 3 Replies
May 30, 2010
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
View 1 Replies
Mar 3, 2010
I wanna join all the field as a new col.
but how can i ignore the empty field because i always join the field and separate by space like the following.
select (field_1+' '+field_2+' '+field_3) as new_col from TABLEA
but if the field is empty, then there is the double space
how can i ensure all the space is one space only.
View 2 Replies
Nov 4, 2010
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...
View 3 Replies
Jun 22, 2010
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?
View 1 Replies
Jun 8, 2010
I'm sure this is very trivial but I'm trying to create anchor tags based on data in a database. Here is a my code.
[Code]....
View 6 Replies
Feb 20, 2010
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.
View 1 Replies
Jun 3, 2010
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.
View 2 Replies
Feb 9, 2010
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
<userdata>
<user>
<name>michel</name>
<nickname>micho</nickname>
</user>
</userdata>
View 3 Replies
Apr 25, 2010
Whenever I run the following code to insert a record into database:
protected void Button1_Click(object sender, EventArgs e)
View 5 Replies
Feb 24, 2010
i am trying to read data of from a sql database
the code that im using is as follows:
[Code]....
as you can see, im using table adapters - though when i run the page, it throughs me the following error, which i'm finding hard to understand
for my last project, i had to use the exact code, but at the time, i was using an access DB and now i'm uning sql D|B
the only difference from last time is that instead of using :
using System.Data.OleDb;
Now im using: using System.Data.SqlClient; //sql server
View 4 Replies
Apr 11, 2010
I have this code and not sure what is wrong.
csconnection = New OleDbConnection (Stringconnection)
cscommand = new OleDbCommand("INSERT INTO Login ([Username], [Password], [Name], [DOB], [Gender], [Nationality]) VALUES (@Username, @Password, @Name, @Dob, @Gender, @Nationality);") [code]...
it just says errorat bottom of page and is there a way to tell the webpage to show me the error.
View 3 Replies
Apr 30, 2010
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.
View 1 Replies
Mar 10, 2010
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,
View 1 Replies
Jan 3, 2010
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?
View 2 Replies
Mar 18, 2010
Is linq just for retrieving data or can you send data to the database using it?
View 3 Replies
Jun 21, 2010
iam using asp.net2.0 with c#, with backend sql server2000
in my client system i have to create dynamically procedure and return the result
but when iam using in my local system the code is working fine but at client system it it not working
[Code]....
View 5 Replies
Jan 18, 2010
I have SQL Server Database Primary Data File.
I want to recover the data from that file in to my data base which has the empty tables.
I have Microsoft SQL Server Query File which contain the table structure.
View 1 Replies
Mar 27, 2010
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]....
View 7 Replies