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:

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:


View 2 Replies

DataSource Controls :: How To Connect To Multiple Databases

Jun 8, 2010

i want to know how to connect to multiple databases in sql from our code??

View 4 Replies

DataSource Controls :: How To Make One DataContext For Multiple Databases

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:


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

Forms Data Controls :: Finding Best Way To Handle This Scenario - Select Gridview Row And Show Related Info Below?

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

Forms Data Controls :: Displaying All Users In A Grid Along With Profile And Membership Info?

Mar 24, 2010

I am developing a website in that user 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

SQL Server :: Retrieving Info From 2 Databases With One Statement?

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

Security :: DataBind() To DetailsView Membership User Info?

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

DataSource Controls :: Obtaining Collation Info From Objects?

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

C# - Create Method To Handle Multiple Types Of Controls

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";

View 1 Replies

Forms Data Controls :: Handle Multiple DataKeyNames?

Mar 17, 2010

I have these line of 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

Databases :: Data Access Layer For Multiple Databases?

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 3.5 based on database connection

View 1 Replies

Authorization - How To Handle Membership Levels With Roles

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

Databases :: ORA-24338: Statement Handle Not Executed But Its Getting On All Over Internet?

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 "" 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 "" & most imp thing i;m using site number of years

View 1 Replies

DataSource Controls :: How To Handle Null Value Between Sql And C#

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.


View 4 Replies

DataSource Controls :: How To Handle Null DateTime

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

Data Controls :: Handle CheckBox Check Uncheck Event In Multiple Nested Child GridView

Jan 24, 2016

I have followed this article: [URL] ....

I have added textbox and checkbox in nested(child) gridview....

View 1 Replies

DataSource Controls :: How To Handle The String Having More Than 1000 Characters

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

DataSource Controls :: Handle Quotes In A Stored Procedure?

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

DataSource Controls :: When Use LINQ To Handle The Paging Of Gridview?

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)


View 3 Replies

Databases :: How To Use Oracle Membership Provider For .Net

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

DataSource Controls :: How To Write Handle Exceptions In Stored Procedure

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

DataSource Controls :: Create And Handle Wide Tables Programmatically?

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

Databases :: Use GUID As Userid When Using MySql For Membership?

Apr 23, 2010

I have followed this tutorial which provides me with Membership, Role, Profile etc.


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

VS 2008 Upload Multiple Files - Store All Info In Database?

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

Copyrights 2005-15, All rights reserved