.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

ASPNetSQLProvider - Changing it from the default to a custom SQL Database

Posted By:      Posted Date: September 28, 2010    Points: 0   Category :ASP.Net



I am new to ASP.NET and need some help.


What I am trying to do is to create a login for a new site that I am developing, and I need the users etc to be contained within the SQLEXPRESS database that I am using.

Can someone please help me to work out how to point the default ASPNETSQLProvider to my SQL database and not the default APP_Data one?

I am using Visual Studio 2008 and SQLExpress 2005.

Many thanks,



View Complete Post

More Related Resource Links

Toolbox: Database and OR/M Tools, Oren Eini and Custom Visual Studio Tabs


This month we look at tools for enhancing the LINQ to SQL and Entity Framework designers, Oren Eini's .NET development blog, Visual Studio tab customization, and more.

Scott Mitchell

MSDN Magazine December 2009

Data Deployment: Streamline Your Database Setup Process with a Custom Installer


Database setup can be a tough and time-consuming process and sometimes fall victim to human error. Microsoft Installer or InstallShield can help, as can your own custom installer. In this article, the author tackles one approach to writing database installers and demonstrates the process with a working code sample.

Alek Davis

MSDN Magazine September 2004

Custom SharePoint Timer Job doesn't run after changing code and restart timer services.

Hi We are facing an issue that our custom SharePonit Timer Job doesn't run after a changing the code. First, we developed and deployed a timer job. It worked fine for a few days, then we detected a memory leak and killed the OWSTIMER.EXE. (Maybe we should uninstall the timer job and restart the timer services nicely). We fixed the problem, redeployed the fix as a feature (assemblies are re-GACed ...) to our small SharePoint farm (one web server, one services server), restarted the SharePonit Timer Services. Now we can see the time job in Timer Job Definition in Central Admin but the job never runs (Since it doesn't run, the timer job status page doesn't have any info about it). We tried the same process in a dev environment with SharePoint signle box installation. The timer job just works fine. I did some search on Internet and followed some instruction to clear the cache from "C:\ProgramData\Microsoft\SharePoint\Config\1d50d73c-9bf1-4444-85a9-910ed050d1bf" by 1. Remove all the xml2. Clear the cache.ini with "1".3. restart the timer services. It still doesn't fix the problem.Please advise what else I can do. I even rename the timer job and redeploy it. It doesn't help. I checked the even log and SharePoing log and couldn't see anything wrong. Our OS is W2K8.         public override void FeatureActivated(SPFeatureReceiverProperties properties)        { 

Changing default permissions for Owners group

When a site is created within SharePoint (and permissions are not inherited from the parent), a default Owners, Members and Visitors group is created.  The default Owners group is assigned "Full Control".  I want this to default to a custom permission level that I have created called "Full Control - Limited".  What changes do I need to make to ensure that all new Owner groups are automatically assigned this custom permission level and NOT "Full Control"? EDIT - I have a console application which sweeps through all of the sites and changes all "Full Control" to "Full Control - Limited" but I really don't want to set a Scheduled Task each night to fix the new groups. 

Custom DynamicData Default.aspx GridView

On the Default.aspx page the GridView control is populated programmatically by setting its Datasource to a list of table objects. Is there some way I could populate this GridView manually using my own set of NavigateUrls and DisplayNames?Simon

Searching for custom properties in a default search

Hi all, I have added some custom properties in to Manage User Properties in my User Profile Service Application. The issue I'm having is that I'm unable to obtain search results from these properties. For example, if in the Enterprise Search / People tab I enter "Dave" and click search, then I'll be presented with results of people who's name matches "Dave". If I enter "Information Technology" then I'll get a list of all users who's department is "Information Technology". So far we're okay! But let's go back to the custom property. Let's say it's called "Clients" and it is for storing client names against the staff profiles. If I search for "Microsoft" and a user has Microsoft in their client property then no results are found. I've created the managed properties in the Metadata Property Mappings of my search service application, done full crawls but nothing. If I search for "clients:microsoft" then I get results. So the question is how do I or is it even possible to get custom metadata properties to show up in a default search? Thanks!

Why is it that this code updates my sql database with the default EditBox text?

Any help is appreciated. using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; using MySql.Data.MySqlClient; public partial class _Default : System.Web.UI.Page { TextBox EditBox = new TextBox(); TableRow[] NewRows = { new TableRow(), new TableRow() }; TableCell[] NewCells = { new TableCell(), new TableCell() }; string ID; protected void Page_Init(object sender, EventArgs e) { } protected void Page_Load(object sender, EventArgs e) { var Connection = new MySqlConnection("Server=localhost;Database=site;Username=root;Password=root"); var Command = new MySqlCommand("select * from news", Connection); Connection.Open(); var Reader = Command.ExecuteReader(); while (Reader.Read()) { ID = Reader.GetString("ID"); string Title = Reader.GetString("Title"); string Text = Reader.GetString("Text"); foreach (TableRow Row in NewRows) { NewsTable.Rows.Add(Row); } NewCells[0].Text = Title; NewCells[1].Text = Text; NewCells[0].Font.Bold = true; NewCells[0].Font.Underline = true; NewCells[0].Font.Size = Fon

Custom Entity Framework template and access to the database type

First and foremost ... I already made a few changes in the template, the most important one changing the methods generated for stored procedures with OUTPUT parameters and no resultset so that instead of instantiating a few OutputParameter objects, passing them to the method and extracting the values (all without any type checking) you just call the method with a few "out someType?" parameters so I do not need the very basics. I am totally confused by all those GlobalItem, EdmProperty, BuiltInTypeKind, TypeUsage and all this made of objects, all alike and all different though so as soon as I need more data than what's already used by the template I run into problems :-(What I would like is to change the WritePrimitiveTypeProperty() so that it outputs [StringLength(xxx)]  for all char, varchar, nchar and nvarchar properties. But I can't find a way to get from an EdmProperty in the model to the database type in the store.Can anyone help me?In case anyone is interested here's the modified stored procedure mapping code for the template. The first code replaces the original in the .tt: //////// //////// Write EntityContainer and ObjectContext Function Import methods. //////// region.Begin(GetResourceString("Template_RegionFunctionImports")); foreach (EdmFunction edmFunction in container.FunctionIm

Database vs XML for complex changing data

Hello, I'm researching and experimenting with aspects of a new project before final design.  It will be in two parts: 1. a designer interface (like visio)2. client to display the content created within the designer interface. We have the design outline in place, the client will be in many forms, via the web using Flash or Silverlight (depending what's installed) and via windows using a WPF application. I would like to know what people think regarding storing information from the designer, all the clients will need to access the information via the internet so a database storage solution seems the first choice. But another alternative is exporting the information from the designer in something such as XML and storing that as a physical file. The designer will be an application allowing the users to create multiple pages (like PowerPoint slides), each of which they have control over placement objects (images, text, buttons etc). A database approach will require a lot of work when changes are made with update, delete and inserts every time a page (slide) is changed. The XML approach seems easier to manage because each time the page (slide) is amended the XML file can either be delete and recreated or the content inside replaced with the new designer layout. It would be great to hear what other people think. I was thinking for XML to separate each slide into a separate

Retracting feature which deployed custom master page delete default.master

Hi, I am not sure if solution to this issue is already posted? I have my feature which copy my custom.master which is copy of default.master from hive to master page gallery of web. The problem is that everything works fine with feature activate and deactivate but when I retract the solution from the server. All pages except site settings page stop working saying "file not found". I redeploy the solution, it starts working again. Looks like the retract is deleting default.master as well? I have this issue in 2010 as well. Any help will be appreciated. Thanks, Kashish

Form Based Authentication with Custom database

Hi, I have a Sharepoint 2010 web application and I want to implement FBA(Form Based Authentication) for that. I don't want to use any membership providers and role providers. I have a SQL server database where we will maintain users and roles. I want to use this database for validating user credentials and authenticating them. Is this possible in Sharepoint 2010? Please reply ASAP.

DetailsView edit problem after changing database

Hello!I had a DetailsView control for editing records in a Access 2003 database. I transfered the database to MS SQL 2008 and using the same code does not work - after clicking edit nothing happens (no error) and the record is not updated.ASP code:<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent"> <h2> Urejanje kontaktnih podatkov </h2> <p> <asp:TextBox ID="txtKontaktID" Visible="false" runat="server"></asp:TextBox> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:conKrik %>" ProviderName="<%$ ConnectionStrings:conKrik.ProviderName %>"  SelectCommand="SELECT tblKontakt.*, tblStranka.strSkrajsanNaziv FROM krik.tblKontakt INNER JOIN krik.tblStranka ON tblKontakt.StrankaID = tblStranka.StrankaID WHERE ([KontaktId] = @id)" UpdateCommand="UPDATE tblKontakt SET strIme = @strIme, strPriimek = @strPriimek, strPoslovnaEnota = @strPoslovnaEnota, strTelefon = @strTelefon, strFaks = @strFaks, strMobitel = @strMobitel, strEmail = @strEmail, rmkOpomba = @rmkO

How to submit data to a SQL Server database table from a custom page ?

Using SPD, I have created a custom page. It has a form with ASP.NET controls textbox, radio buttons, dropdown, submit button etc., Also, I created a Database connection (to the SQLServer database table) under Database Connections. But not sure how to connect this form to the database connection so that when form data is submitted, the data will be inserted into the table.

Custom Default.aspx SharePoint 2010

I would like to replace the default.aspx with a custom default.aspx.  I have been able to accomplish this with a feature. I am finding the when deployed the new default.aspx page shows up in the following directory C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\FEATURES\ProjectInsightSPMaster_ProjectInsightLayoutFeature\defaultpage I also have a default.aspx located in the following directory.  This is the one that is deployed with the site definition. C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\SiteTemplates\PISP    When I browse to a site in IE, it is in fact looking at the correct (new) default.aspx page which is located in the FEATURES directory.  How does SharePoint know to use this default.aspx page instead of the one located in the SiteTemplates directory.  This is confusing to me.  Can you explain?   Is this the correct way of deploying an updated default.aspx?   dave

claims authenticated (FBA) user cannot open a connection to our custom application database

We have designed a custom sharepoint site. This site uses a membership provider that I implemented, and the users are stored in our custom application database. These are the steps I follow to reproduce the error: 1. Browse to our site. Select Forms Authentication from the default.aspx selection. 2. Enter in a username from our DB table. This user I have configured as a site collection administrator. 3. Login to the site. The user is authenticated by our membership provider and allowed access (ValidateUser returns true) 4. Browse to a page that attempts to connect to the custom app DB. 5. I get the following error when the page attempts to open a connection to our DB: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server NOTES: The code that opens the DB connection is running with SPSecurity.RunWithElevatedPrivileges. Our application pool account has access to the database. My user can connect to the database fine as well as the user that our  application pool is running as. I have validated the connection string that is being used in the debugger, and that is correct.

Set Custom Ribbon Tab as default selected --> how?

hi, is it possible to set a custom tab as default selected?   right now, if the page loads, the listtools tab is selected; but i need the custom tab selected by default;   iv read, that it is not possible e.g. in word 2007 but what about sp 2010?

how to display matrix report with default zero when we are not having data related to it in database

Hi, I am having a matrix report in SSRS 2005 which is parameterized.When I select parameter which is having related data in the database report is working well.But When I select a parameter for which data is not present in database at that particular time.I donot see the matrix on report .So can any one suggest me how to show the matrix report with zeros in data region when user select that parameter   Thanks in advance.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend