DataSource Controls :: How To Handle Membership Info Among Multiple Databases
May 13, 2010
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.
The custom membership table will be like this:
Id - int, primary, identity
UserId - uniqueidentifier (of aspnetdb database)
What is the best way to do this in the long run, when i will have six or seven or more services ?
View 2 Replies
Similar Messages:
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:
[Code]....
View 2 Replies
Jun 8, 2010
i want to know how to connect to multiple databases in sql from our asp.net code??
View 4 Replies
Apr 17, 2010
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]
View 4 Replies
Dec 12, 2010
almost typical master-detail scenario except the 'detail' data I want to display below the gridview will be coming from both the table that is bound to the gridview (master) and a related table.
simplified example: tableMain with field1, field2, field3 bound to master gridview. I need to select a row from the master gridview and have a form display below with field4 and field5 from tableMain, as well as all fields of tableDetail where field1 of tableMain equals field1 of tableDetail.
Is this what a 'formview' control is for? or do I just arrange my own controls to accommodate the data? Would a formview work considering my source will be partially from both the main table and the detail table? This is one of the scenarios were I know I could come up with something using none of the databound controls (except the master gridview), but I want to use the controls provided when it makes sense to do so, and utilize their benefits etc...
View 6 Replies
Mar 24, 2010
I am developing a website in asp.net that user asp.net membership, users and profile tables.I am trying to display all the users that are registered in a grid along with their first name, last name, email and other profile information . unfortunately all this information is scattered in various tables in the database ( aspnet_users, profiles, membershipsetc)... Can you please tell me how to configfure the datasource & columns of my datagrid (control) to achieve what I am trying to do .. ?????
View 3 Replies
Nov 29, 2010
at present our site has a search function which then populates a grid with results from our catalogue database... I'm trying to implement product availability into the grid, but the stock information is stored in a completely different database in a different location. Both the main search results and the stock levels have to be referenced in the same datasource to get them both in the same grid; does anyone have any thoughts on how to do this? I'm not hugely experienced with SQL, but could I create a view containing aspects of both db's or are these limited to a single db?
View 3 Replies
Jun 7, 2010
Is there an easy way to select a specific user that is already logged in and bind all the users info to a detailsview for edit and saving back to the tables?The tabels were generated in AWAT of VS 2010
View 1 Replies
Jan 21, 2010
For some reason, some of the fields in our database use a different collation than the default. There doesn't seem to be a pattern as to which fields use the different collations, so I'd like to run a query to find which fields use this collation and change them to the default. Does anyone know how to do this?
View 2 Replies
Mar 30, 2010
I am trying to create a method that accepts multiple types of controls - in this case Labels and Panels. The conversion does not work because IConvertible doesn't convert these Types.
public void LocationsLink<C>(C control)
{
if (control != null)
{
WebControl ctl = (WebControl)Convert.ChangeType(control, typeof(WebControl));
Literal txt = new Literal();
HyperLink lnk = new HyperLink();
txt.Text = "If you prefer a map to the nearest facility please ";
lnk.Text = "click here";
lnk.NavigateUrl = "/content/Locations.aspx";
ctl.Controls.Add(txt);
ctl.Controls.Add(lnk);
}
}
View 1 Replies
Mar 17, 2010
I have these line of code:
[Code]....
When i debug i get an error that says: 'System.Data.DataRowView' does not contain a property with the name 'job_id'and sometimes 'System.Data.DataRowView' does not contain a property with the name 'pub_id'I need to get the appropriate value for the selected row. GridView only output Jobs results or Publishers results, the problem is when the user clicks select button beside the record, i get the error i mentioned above.
View 3 Replies
Jul 6, 2010
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
View 1 Replies
Mar 21, 2011
I am building a subscription based web site, which currently has three subscription levels, i.e. Horses, Soccer, and Horses and Soccer. I was thinking of implementing standard role based authorization, where a Horses subscriber would get roles including those to use the Horses section, etc.
Should I use a standard role provider, and when a member subscribes to the site, assign roles for his subscription to him, or use a hierarchical role provider, that when asked for the roles for a member, only then uses the member's subscription level to 'calculate' a set of roles for the member.
View 2 Replies
Dec 15, 2010
actuly my site is working fine but suddenly site is giving "ORA-24338: statement handle not executed" this error i'm try to resolve this error but i could not get proper solution
my prblm is tht when i access my site on my PC using "www.xyz.in" at tht time i access my site with report properly but whn i access my site on out of company or any cyber cafe or other internet pc thn i could nt access my site properly tht site is give me error.......
ORA-24338: statement handle not executed
i'm use oracle10g & database connection in "system.data.oracleclient" & most imp thing i;m using site number of years
View 1 Replies
Feb 3, 2010
I need to retrive a value from a column of a table per stored proc. This is usually an integer, but also can be null. I get this value and store it in a session variable.
Later, I need to pass this same session variable to another stored proc.
Session["myVariable"] = ds.tables[0].rows[0][1]; // this can be null or an integer
somewhere else in the project, I need to pass it to another stored proc exactly as received.
[code]....
View 4 Replies
Feb 26, 2010
I get a recordset returned from DB and try to load it. However sometimes field "LastRun" may be empty (NULL). when i have this it compiles fine but errors out when value is null m_LastRun = Convert.ToDateTime(r["LastRun"]); when I take out Convert.ToDateTime it doesn't even compile.
View 3 Replies
Jan 24, 2016
I have followed this article: [URL] ....
I have added textbox and checkbox in nested(child) gridview....
View 1 Replies
Jun 6, 2010
i am making a dynamic query, it contains more than 1000 characters.
when i am trying to execute it then loss the query , it is skipping some charachters.
why it happens and how can i handle it ?
varchar variable's length is 5000 .
View 4 Replies
Mar 31, 2010
i am trying to write a stored procedure which constructs an email containing a table. typically, when creating a string of HMTL code, i might have something like:
@strEmail = @strEmail + chkNum + '<br>'
but how do you handle it if the html needs single quotes?
for example:
@strEmail = @ strEmail + chkNum + '<td bgcolor='#000'>'
View 1 Replies
Jun 28, 2010
Both the Method 1 and Method 2 can handle the paging of GridView, could you tell me how about the performance of the Method 1?and how much will Method 1 slower than Method 2
#region ForPaging
public static List<HD_ToDoList> Get_ToDoListByUserNameForPage(string username, int StartIndex, int PageSize)
{
[code]...
View 3 Replies
Apr 13, 2010
to Find website or write to me How to use Oracle Membership provider for ASP.Net and what changes should i do to Web.config and machine.config?
View 1 Replies
Feb 17, 2010
In sqlserver2005 how to handle exceptions in stored procedures and
1)redirect to other page
2)write in to log file
View 1 Replies
Apr 15, 2010
I have a set of keywords (about 1000 keywords), and I want to build a wide table, up to 1000 columns:
+each column corresponding to a keyword
+each row will represent an article document, which each cell will be the frequency of the keyword in the document
How to do that in a programmatically way? (e.g., using Linq and C#)
View 4 Replies
Apr 23, 2010
I have followed this tutorial which provides me with Membership, Role, Profile etc.
[URL]
Everything is working fine, but I noticed that the userid is in standard INT, not GUID. Is it possible to get around this? I want the userid as GUID.
View 4 Replies
Nov 2, 2010
I have an entity called a file which is the main part of my project. The file has invoices and timesheets captured against it. So I have a file tab with info about the file, like FileNumber, Vessedl, Voyage etc. Now I need to be able to upload documents for the file. So I will add an uploads tab. But the uploaded documents need to be saved for the specified file the user uploads it for. then when a user opens a file I need to show the documents for that file in a list of some sort. the best way to do this. What's the best way to upload multiple files? should I store all the info in my database?
View 36 Replies
