Managing SQL Server Connected To Existing DotNetNuke Website?
Oct 14, 2010
Before my time at the company they paid for a very expensive website written in asp.net and dotnetnuke. Absolutely terrible but there's very little that can be done about that now. They won't give us access to the SQL Server for some bizarre reason but they've given us FTP access.
Is there some way I can install a database manager (like phpMyAdmin) using FTP? I think I've found the username and password but I'm not familiar with asp so it's quite a confusing system.
As part of a redesign for one of my clients I'd like to move them to DotNetNuke to gain the CMS and blogging features. Their existing site has some custom ecommerce functionality that an off-the-shelf package just can't handle, so I'm inclined to leave it and just re-skin to match the new site.
The challenge is making this all fit together.
I could create two physical web sites in IIS, for example:
www.website.com <-- DNN install
and
shop.website.com <-- Existing ecommerce
This would keep things isolated, but I see a problem with the SSL certificate. It's tied to www.website.com, so now I'd either need two -- one for www. and one for shop. -- or I need a wildcard certificate. Either adds ongoing expenses for the client.
I could try to encapsulate the existing site into a DNN module, but that seems like a lot of work. I could also try doing something tricky with iframes, but again I think this would just further complicate things.
i added one treeview control in aspx page .All parent and child nodes are working perfect in this aspx page.
Now this same code i pasted in an ascx page and that ascx page i called through DNN website.That time parent node display is coming properly,but when i click on the parent node child nodes are not showing up?
My lecturer insists that a web site should NOT have a static SQL connection as its not good practice (didn't explain why) but then I thought that if one makes instances of an SQL connection everytime I want to save, delete or edit then surely thats a bottleneck as I would need to everytime establish a connection and then do the save process. From what I have read online, the process of establishing a connection to the server is the longest (about 5 to 10ms)...
How would one manage their SQL connection. At the moment I do something like:
Now i am developing web application, i wanted to be like a CMS but not with all the bells and whistles of a fully blown CMS system. To explain the idea, it is a classifieds ads site were users can log on and add their own ads or browse other users' ads. What i want to be able to do is to have full control on the application without having to write any line of code. I mean, after the application is launched, i want to be able to add / delete ad categories, change dynamic content on the site (like banners, polls and so on).
I managed to create a control panel for myself where i can edit and manage the ad categories (after all it's a data repeater bound to a database and rendering to an ul list containing the categories). My question now is: i am using Master / child pages design, I have some content that's on the Master page and other on the child pages (by content i mean those plugins that are frequently found on websites like polls, news tickers, stocks...etc). Using the Master / Chile paradigm: how can i control the visibilty of those controls through my control panel?
add labels for those controls and control their content from the backend database together with a boolen indicating their visibility. But the problem is that: how can i determine which page is serving this content currently. Like for example, a news ticker on the addad.aspx child page but not on viewads.aspx child page.
when a website is entered in a browser it should take to a login page (in localhost) and if the login succeed then the site should be loaded else an error page should be displayed. the login page will be connected to local database. how to do this?
I want to fetch a web page from a ASP.NET site that is only accessible from within a session. I'm using Apache HttpClient. I first open the main page of the site, then I search for the link to the "goal" page, and then I fire up a GET request for the "goal" page. The problem is that when I get the response for the second GET request, I always get the same (first) page. If I open the site with Firefox or Google Chrome I get the "goal" page.
From the first response from the server I get the following headers:
I inspected the traffic with WireShark and all headers look OK. I send the correct cookie back to the server on the second GET request.
I'm using Apache HttpClient. I have only one instance of DefaultHttpClient and I reuse that for the second request. I have BROWSER_COMPATIBILITY Cookie Policy.
I have one main project for the cms we are using for our website. I have also created usercontrols to include in the site, but I think I would like to keep these in a separate project and just reference them in the main project. Is this a best practice and how would I do this?
Ive created a web site using VS2008 ASP.net and connected to a Firebird Database.
I have a page that has a GridView(added at design time) and have connected to a table at runtime.
[Code]....
All good as the table contents are displayed at 10 rows per page. Ive set the Property AllowSorting to True. Has anyone got examples on how to code the sorting? Ive had a look round the net but all the examples Ive tried dont work.
When developing large application using ASP.NET (MVC or classic, doesn't matter), especially in large team, it is easy to produce a lot of messy, non-traceable CSS definitions. After some time we can end up not knowing why particular definition exists and what is its real effect considering style inheritance and cross-browser differences. Needless to say, changing anything in that mess is a risk and there are hundreds of ways how small change could affect the system.
I know some solutions to organize CSS stylesheets better, like predefined CSS "frameworks" or DotLessCss engine, but I still find it quite hard to cope with CSS as there is no such relationship between HTML markup and CSS styles like i.e. between interface and concrete class in C# code. I know this is by design to make presentation separate from the structure, but I believe it might be useful to have such a correspondence at development level.
Ideally, I need something that can enforce the team not to make messy CSS or be able to clean that mess up automatically. Do you know any resources that may help me, or any guidance how to manage my CSS definitions easily? Let me ask for something a bit different:Despite of my several years of web experience, I believe I would feel much more confident if some of my CSS could be moved into C# code, the same way as some of HTML generation is done by MVC HTML Helpers. It saves me writing a lot of unnecessary markup, still allowing to do so if needed. And it is more unit testable, easier to refactor using tools like ReSharper etc. I don't need mergers and compressors of my CSS, I would like to be able to manage my CSS at declaration level. Maybe there are some tools like that I'm not aware of, or maybe that idea is just wrong and wouldn't be useful?
Dim myDataset As New DataSet() Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & Request.ServerVariables("APPL_PHYSICAL_PATH") & "dynamicuploadedLists" & strFileName & ";" & _ "Extended Properties=""text;HDR=Yes;FMT=Delimited(,)"";"
''You must use the $ after the object you reference in the spreadsheet
Dim myData As New OleDbDataAdapter("SELECT * FROM [" & table & "$]", strConn) 'myData.TableMappings.Add("Table", "ExcelTest") myData.Fill(myDataset)
And I am getting the error , while the path is correct.
'E:missitenamedynamicuploadedListsSheet1.csv' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
I restored a database from another server, and everything looks good except the users.
I'm managing all this from SQL Server 2008 Management Studio as SA.
The users are present in the [u]databaseName > security > users[/u] section, and they exist in [u]databaseServer > Security > Logins[/u]. However I can't change anything in the [u]databaseName > security > users[/u] section, because when I try and make a change, and then I hit OK to apply, it says "[i]login name must be specified[b][/b][/i]". But the login name field is grayed out and I can't modify it(even though I'm logged into the machine as Administrator and SQL as SA).
Also, in the user mapping section, when I try to map one of the users to a database, it says '[i]create failed user already exists[b][/b][/i]'...but I don't want to create the user, I just want to map that user to the appropriate databases...
I have an existing ASP.NET web application that is for public use and any anonymous user can access it. I would like to implement mechanism for users to sign up. The first thought that crossed my mind is to use the ASP.NET membership API.
I have a (internet) web site with the below web.config (everything works fine). How would I alter this to include an applicationName attribute. I wish to eventually have multiple web sites using the same ASPNETDB database.
I have an exiting ASP.NET website that already has user accounts in it. I would now like to simplify logon and considering the use of Janrain. Is this a recommended product? Any alternatives you have used? What do I do with my existing users (I assume I need to extend my membership db to select between them and Janrain tokens)?
So my application is on a production and running smoothly with no bugs at all. yay! My question: Is there's more efficient way of updating an existing ASP.NET application? Here's what i'm currently doing ( dont laugh that's why im asking xD):
1. I compile the project, 2. after compilation i transfer the compiled files via ftp. then i delete the existing files on my folder and put the newer one.
What are the options available to call another web applications hosted in the same server. Eg: i have a application App1 and App2 hosted on the same server.i just wanted to call App2 from App1 how would i do it.
The most important point is that I can not change the url on the address bar to call the page of the 2nd web application.
Whatever I have achieved so far is I have added a link to my 1st application which redirects to the 2nd application, but it is changing the url on the address bar, I want to redirect to the 2nd application from within the 1st application.
I have one of the .Net site running and want to implement web-parts on that site. well I am not using (aspnet_Users, or aspnet_Membership) defaults tables from aspnetDB but I have my own login controls and create new user contols ect on the site. so in short I have the users uniq ID when logged in from our corporate database nothing similar to aspnetDB.
Hecen want to know can I impelemt webparts in the existing site by just importing the tables from aspnetdb like (aspnet_PersonalizationAllUsers, aspnet_PersonalizationPerUser) to my database and what else I will require apart from these tables?
1. which list of store procedures I should coopy?
2. Any modification to my web.config?
3. Are their any functions/classes which I might have to copy to my App_Code folder to work these webparts with my exisitng site and userdetails
I have a running ASP.NET web site. There is following problem with one of the forms:
One part of submitted data is added to database after "submit" is clicked. (to "table1") Another part is lost (not added to "table2", and no files uploaded) I have no source code of that project. So, because I cant edit existing page, I came to a decision to add new .aspx page to a running application with same functions as existing one. How can I do that? Or maybe you can recommend some other solution.
