Search results matching tag 'SQLProfileProvider'

MsSql Store Procedure

mohfeza — Wed, 27 Aug 2008 04:00:00 GMT

how can i insert data into temp table from 2 diferent tables, and get data from temp table.

My following code giving output just from 2nd table. how can i append 2nd table data("new_BannerList" table) into temp table after inserting

1st table data("WDI_T_PartnerRegistration" table).

ALTER PROCEDURE dbo.GetAllAdBanner
AS
BEGIN

CREATE TABLE #TempTable
(
UserName VARCHAR(100),
Banner VARCHAR(200)
)

INSERT INTO #TempTable
Select PR.UserName AS UserName, PR.Banner AS Banner from WDI_T_PartnerRegistration PR ,WDI_M_Users MU where MU.UserId=PR.UserName
and MU.UserType=3 and PR.Status=1 and PR.Banner!= ''
Select NBL.PartnerID AS UserName, NBL.Banner AS Banner from new_BannerList NBL where NBL.Banner!=''

SELECT * FROM #TempTable

drop table #TempTable

END

Thanks,

Mohfeza

Membership Management Complete Starter Kit

hunzonian — Mon, 07 Jul 2008 04:00:00 GMT

Note to Admin: Please publish this in appropriate section.

I have published a membership management starter kit on codeplex that works with the default membership, role and profile provider. I hope it helps some beginners. It is available on CodePlex at http://www.codeplex.com/AspNetWSAT under the releases tab.

Re: Difficulties with SqlProfileProvider - where to get the SettingsContext object from?

jahabdank — Tue, 10 Jun 2008 04:00:00 GMT

Thanks a lot.

So just for the sake of people who will come here later, the code in the code behind (meaning from the within the Page object) can look like that (I really wonder why sombody did not write it this way in the MSDN class description):

1                    // Providers is a static method in the ProfileManager class
2                    System.Web.Profile.SqlProfileProvider p = (System.Web.Profile.SqlProfileProvider)System.Web.Profile.ProfileManager.Providers["SqlProvider"];
3    
4                    // ProfileBase.Properties is a static collection of properties defined in the web config:
5                    //<profile defaultProvider="SqlProvider">
6                    //  <providers>
7                    //    <clear />
8                    //    <add name="SqlProvider"
9                    //      type="System.Web.Profile.SqlProfileProvider"
10                   //      connectionStringName="ASPNETDBConnectionString"
11                   //      applicationName="SampleApplication"
12                   //      description="SqlProfileProvider for SampleApplication" />
13                   //  </providers>
14                   //  <properties> --cmt:2abe902b-fbad-4ab1-905c-c40df7587bc0--
15                   //    <add name="ZipCode" />
16                   //    <add name="CityAndState" />
17                   //  </properties>
18                   //</profile>
19                   SettingsPropertyValueCollection pvalues =
20                     p.GetPropertyValues(this.Context.Profile.Context, System.Web.Profile.ProfileBase.Properties);
21   
22                   // you can get or set the values
23                   pvalues["ZipCode"].PropertyValue = "98052";
24                   pvalues["CityAndState"].PropertyValue = "Redmond, WA";
25   
26                   // in order to update, pass the current Profile Context, and the values
27                   p.SetPropertyValues(this.Context.Profile.Context, pvalues);

Difficulties with SqlProfileProvider - where to get the SettingsContext object from?

jahabdank — Mon, 09 Jun 2008 04:00:00 GMT

Hello,

I am tryng to use the built it Providers (Membership, Profile etc.). I have problems with SqlProfileProvider. I try to run exampe code from: http://msdn.microsoft.com/en-us/library/system.web.profile.sqlprofileprovider.setpropertyvalues(VS.80).aspx

1    SqlProfileProvider p = 
2      (SqlProfileProvider)Profile.Providers["SqlProvider"];
3    
4    SettingsPropertyValueCollection pvalues = 
5      p.GetPropertyValues(Profile.Context, ProfileBase.Properties);
6    
7    pvalues["ZipCode"].PropertyValue = "98052";
8    pvalues["CityAndState"].PropertyValue = "Redmond, WA";
9    
10   p.SetPropertyValues(Profile.Context, pvalues);

but it neither explains where does the SettingsContext comes from, nor what 'Profile' object is .... (what type and where to get it from. It is surely not the ProfileManager, because it does not have a Context field).

Thanks in advance,

Jozef A. Habdank

Re: Setting Membership/Profile/Role provider's connection string at runtime...?

BDawg — Tue, 04 Mar 2008 05:00:00 GMT

OK figured it out...and my multi national company is now saved...ha ha

This is a one liner gang........

you will need to create your own providers however, We simply downloaded the SampleProviderToolkitSampleProviders from microsoft to lessen the blow.

http://download.microsoft.com/download/a/b/3/ab3c284b-dc9a-473d-b7e3-33bacfcc8e98/ProviderToolkitSamples.msi

Class to modify

SQLConnectionHelper.cs

Method to modify

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------

internal static string GetConnectionString(string specifiedConnectionString, bool lookupConnectionString, bool appLevel)
{

//Your Conn String goes here!!

return Factory.ConnectionString;
}

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------

we used our own namespace to be used in the web.congif as well.

complile that bad boy and your golden..

have fun

--b

want web parts with drag & drop feature only , no personlization

pragasht — Fri, 24 Aug 2007 04:00:00 GMT

i want to use web parts feature of drag & drop , but i dont want personlization wich cause so may problem,

i give personalization = false for webparts manager.

then in server code i change the

MainWebPartManager.DisplayMode = WebPartManager.DesignDisplayMode

here there is an error says that check personalisation is enabled
for this user,

is that possible to change the display mode with personlisation enabled false

thanks in advance

SqlProfileProvider, no ProfileCommon in code-behinds but yes in the ASPX code?

junglemason — Tue, 03 Apr 2007 04:00:00 GMT

First, please allow me to vent:
I've spent all day looking into implementing a Profile Provider. No articles I've found are less than a year old. None of the examples in any of the articles worked for me. Eventually I ran across a post in this forum saying it's not going to work in a Web Application Project, with a link to an installable add-in for Visual Studio 2005 which it turns out will not install for me because my add-ins folder is mapped to a remote server and the MSI can't access it. And the site that houses that fix is going to be "phased out" by Microsoft a few months from now.
Well, anyway, that wasn't true anyway...
...it DOES work without that add-in.
Partially.
The ProfileCommon class is readily available in ASPX code, just not in a code-behind. So it seems to me that the compiled ProfileCommon is working (that's what the add-in was going to give me).

To the point:
Can anyone point me to a good explanation or a working examples of a Web Application Project that uses the default SqlProfileProvider and accesses the profile properties in code-behinds?

I have managed to get really close by breaking down and putting the code in a script block in the ASPX code instead of a code-behind. This page uses a Master Page, and I am handling the CreatedUser event of a CreateUserWizard with a customized CreateUserWizardStep. When I run in normal mode, a null pointer exception is thrown. When I run in debug mode, the code doesn't get executed! This is the most frustrating thing I've encountered in months. I could have written my own code for this from scratch by now.

Any advice would be MUCH appreciated.

How to change profile provider at runtime, then access user profile data?

jgaffney — Mon, 08 Jan 2007 05:00:00 GMT

I am trying to work around a situation in which the connection strings are different for the "test" and "production" versions of a .net site.

Is there a way to switch the profile provider connection string at runtime? That would be the simple solution.

Couldn't find a way to do this, so I created two different profile providers in the web config, one for each site.

if (HostName == "localhost")
{
myMembershipProvider = Membership.Providers["MySqlMembershipProvider_Local"];
myProfileProvider = (SqlProfileProvider)Profile.Providers["MySqlProfileProvider_Local"];
}
else
{
myMembershipProvider = Membership.Providers["MySqlMembershipProvider_Remote"];
myProfileProvider = (SqlProfileProvider)Profile.Providers["MySqlProfileProvider_Remote"];
}

Now I'm trying to understand how to use the profile provider references to actually get user profile data. Unfortunately, all I can figure out how to get is ProfileInfo collection info on the profiles, not the profile data itself.

What I want is to use something like the code that worked before:

Profile.GetProfile(thisUserName).userid;

However, Profile is based on the default profile provider chosen in web.config, and I'm unclear on how to "reset" it by selecting a new provider. Best I can do now is:

ProfileInfoCollection thisProfile = myProfileProvider.FindProfilesByUserName(System.Web.Profile.ProfileAuthenticationOption.All, thisUserName, 0, 1, out totalRecords);

which suffers from the aforementioned "collection info only" problem.

Can anyone help?