Configuration :: Preparing External SQL Database Fo .NET Web Application?
Sep 30, 2010
It's been so long since I've done this that I don't remember how.
Basically, I am creating a Web Application from scratch. I have dragged the LoginBox to the page and went to "Administer Website". Unfortunatel I see no where where I can choose to have the application talk to an externally-hosted database as opposed to defaulting to the "App_Data" folder. I am hosting an SQL instance named "SQLEPXRESS" on my development machine and have configured a database and user. I wish for the site to use this database and user and have set the connectionstring as follows in the web.config:
Yet even after adding that I see it showing no where in the "Administer Website" section. Please walk me through getting my application to talk to this database and configuring the necessary tables. I remember there needing to be some sort of exe I needed to run to do this, but my Google and forum searching is failing me.
I have an ASP.NET web app and am attempting to reference an external config (using enterprise application blocks configuration) for some of the configuration but it is not entirely working. I previously had all of the configuration info in the web.config (and it was working), but we are wanting to share some of this configuration information between multiple apps. When I put configurationSource tag in the web.config, and read the configuration through the WebConfigurationManager object, it loads some of the external config info (Logging) but not the connectionStrings and not the custom section I created. So it's reading it (logging is working), but some dots aren't being connected and my connection strings aren't coming through.
Again, it worked when it was all in the web.config. I am running .NET 3.5. Any idea what needs to change to be able to reference an external configuration source and have it all come through?
I've got a really good idea for a service I'd like to create for the web, but since I'm new to ASP.NET I'd like to get everything up and running before I go and buy hosting etc.
What I'm curious about is the database side of things.
I don't quite understand how I can create a datebase on my computer for the sake of testing and practicing (Presumably through mssql server) and then just transfer it to a hosting account when I'm ready.
I guess the main part I don't understand is how can I connect to a database on my computer via my application and then change the connection so that it points to the web version when I'm ready.
I know that when you create the database and include it in your project it's not technically inside your project (Right?), but it just seems that the application is very rigid once you've specified the connection.
I have all my tables and queries in online DB ie., i have created all my tables and queries in online using third party site [URL] Now i want to make connect my application (which is in my system) with that database
I never host any web application on the development server.I learn the tutorial how to copy the file using file zilla FTP client.But question is raised, how can I link my sql server machine to Http development server.And how can I configure my database on the development server.What at all DNS setting is require?
Finally All I need is , upload a web application and SQL server database on development server.
for this i can create a libaray and do it ..many different libarray for many people with interface inclued in all ..this is want i need to do ...but the problem for me s i dont know wat library he s going to give me .. client will give me only the dll and i hv find the class name and its corresponding custom sectipon and call the interface method and get the output ..Reflection s the way but i dont know how to do it ...
Over the years I have had a few of the websites I have developed submitted for penetration testing by clients. Most of the time the issues that are highlighted when the results return relate to the default behaviour of ASP .Net such as possible cross site scripting attacks etc.Are there any good articles on which vulnerabilities exist by default in an ASP .Net application and secondly are there any good checklists to follow which will help prepare a site in advance?
have been working on a leave module and it created this problem. I am trying to identify the end date from a given start date after deducting the public holidays including Fridays & Saturdays. It works like this,Suppose, the starting date is '22-Jun-2010' and the No of days employee wishes to take for leave is 25 days. I wanted to calculate the end date excluding the public holidays (Fridays and Saturdays).For ExampleLeave Requested - Start Date = '22/06/2010'No of days requested = 25 DaysPublic Holiday (National Day) = '26/07/2010'Public Holiday (On the occasion) = '27/07/2010'Output: Leave Start Date: '22/06/2010' Leave End Date: 28/06/2010'(End Date must be calculated without including the Fridays and Saturdaysor any given Public Holiday[National Day &On the occasion] - )
I have a simple webApplication. Now I have a second webapplication with few web aspx pages. When I build each project I get aspx files with 1 dll per project.
Now the structure of the first webApplication is like this
Is it possible to load the dll of the second application dynamically and put its dll into the bin directory. The result will be something like this:
The problem is that when I try to open application2default.aspx the compiler is throwing an error that it cannot find the class for that particular page because the assembly inwebapplication2.dll is not loaded. I tried to load the assembly from the web config like this <add assembly="myassemly, Version=188.8.131.52, PublicKeyToken=null, Culture=neutral"/> and also from the code like this Assembly.LoadFrom( @"D:Projectsinmyassemly.dll" ); OR Assembly.Load( "myassemly, Version=184.108.40.206, PublicKeyToken=null, Culture=neutral" ); but I still have no success. Can u tell me what is the logic here with the assembly load?
Using Visual Studio 2010 Web Developer Express (vb.net code) with SqlDataSource to SQL Server 2008.
I am developing an email form to my users to send email to vendors with an attachment. The aspx page is quite simple -- 2 dropdownlists, a fileupload control, and a send email button. They select their store (which populates the "From" address of the email). They select the Vendor (which populates the "To" address of the email). Then they browse for the file attachment and click "send email"
I just can't get outside emails to send. I do not get any error messages in the web page. If I change the email1 and email2 in SQL Server Vendor table to an email address (mine) within the domain I get the emails. However when I change to a test hotmail, yahoo, or gmail accounts the emails never get there. I have absolutely no confidence that my programming is correct so before I go to the IT Manager again I really need to verify I am not missing something on my end. We did make a change on the exchange server to allow anonymous email from my webserver and still didn't work.
Here is my webconfig file:
Here is my code-behind:
Here is my aspx page:
I have been playing around with the programming for 2 days making 1 change at a time then testing to see if external email is sending. I'm going quite crazy at this point ...
I've put in breakpoints and debugged. Below is the output from the latest test. I have concerns about the clientDomain being "SQLSVR" which is my webserver name, our domain is "chuckanddons.com". As well as the line "Domain" that is blank " " under NetworkCredential. Also the line TargetName "SMTPSVC/exchangesvr"
I'm trying to figure out how to save my XML file in the outside location.
I have a Main web app that uses an XML file as a datasource for one of it's pages. This XML file is generated manually by accessing a utuility page in the same app. I created a utility app that resides outside of the Main app ( it's on my C:/Inetpub/wwwroot) but it should save an XML file in the directory of the Main applicatoin. My utility works fine if I need to save to C:/Inetpub/wwwroot/XMLFiles) but I when I try to access the file at the Main application something like that:
It gives me an error: System.Web.HttpException: Cannot use a leading .. to exit above the top directory. If I just type full URL it says that URI cannot be resolved.. How can I access that Tests.xml file to update it?
As indicated in the Subject, I have a web application (say APP) that should feature an e-Mail Notification Service (ENS). Activation of the Service is controlled by a Button in a dedicated page where some parameters are also included to set running Period (FromTime - ToTime), Interval, Recipients, etc.
When said button is clicked, it should maintain those parameters into database then launch ENS. Since ENS is expected to run for good according to set parameters, it logically should run as an external application/service, independent from APP.
When ENS starts, it needs to consult database to fetch parameters, then schedules its Timer to periodically check database for some transactions that when found, should trigger ENS to dispatch e-Mails to concerned Recipient(s).
1. Launch ENS as an external application on button click from APP.Achieved by using System.Diagnostics.Process class. However, I encountered a problem in verifying if the process is already running before starting it. The root of the problem lies in ProcessName property. Since ALL web applications must be launched via IE, hence, have iexplore as their ProcessName, which is also applicable to all processes started through IE, it is very likely to have multiple processes utilising IE. How to check which is which? I couldn't figure out that.
Eventually, I ended up with a workaround: when the Process is started from APP, capture its ID and save it to database, then use this ID with GetProcessById() method for later verification. When the Process is terminated, reset stored ID in database.
2. What sort of application should ENS be: Windows Application or Web Application?
In either way however, ENS will always run invisible in the background being a Process. If this is the case, how about creating it as a Windows Service instead?
I did a lot of reading but still confused. However, the choice is limited now to either Web Application or Windows Service. Which one is more convenient to the task in hand?
3. What Timer to use?
I tried System.Timers.Timer in a test web application but it didn't fire! Then I used ASP AJAX Timer and it worked pretty well (I still need though to try running it from APP to judge its functionality). I came across some recommendations to use System.Threading.Timer but haven't tested that yet. Would it worth the trial?
4. ENS as a Windows Service.
If I create ENS as a Windows Service, would I be able to communicate with database? How would this influence the Timer to use?
I've noticed as my website gets bigger and bigger, the time my laptop takes to display my page is much longer then say a new projects with minimal references. I think there are two variables at play that affect ASP.NET warm-up time:
The quantity of external references The time it takes for a worker process to new() up each instance per worker process Additional time for the WCF objects as the ServiceHost may be in an external DLL First, are those the correct variables to take into account when considering ASP.NET startup time? Next, it appears that web.config may dispatch other objects for use with certain filetypes (*.svc, *.aspx, Windows Identity Foundation (WIF), etc. ). This too may cause delays in ASP.NET.
Last, my project is created as a "web project" not a "web site". Not sure if this has an impact. Is my theory full of holes, or is there something I can do to make development on a old laptop any better?
Being new to integrating sharepoint documents into web applications I am struggling with the following task, so anyI have a page in my web application that needs to display a document from sharepoint.I use the appropiate sharepoint web service to get a list of all the documents in the sharepoint list, I then pick out the one I would like to retrieve and get the path to the document so i would end up with something like:
Company%20Hire/Hire%20Site%20Price%20Lists/0.pdf Within our network I can do following: iframePdf.Attributes[ "src"] = ConfigurationManager.AppSettings["SharepointUrl"] + _filePath;
This would display the document in iframe... problem I have is coming from outside the network the sharepoint site can't be accessed (due to firewalls etc). We do have a vpn back to our network on the external server our web application sits on. If i was to use the document url in a browser on the server I am prompted for credentials and then get to view the document.Is there a way for the web application to use the vpn, use credentials i give (e.g through impersonation) to access the document and display it to exernal clients?
Is it possible to embed an external application inside the browser (IE, Chrome, Safari, Firefox) so it will look like a native web application but actually having access to the USB ports of the client machine? I have heard that I need to make an ActiveX control. I would like to use the .Net framework, but if that is not possible, maybe using Java or C++ will be fine.
I have to make an application that will allow to the users to connect an external device to an USB port, this device will take a backup of the information contained in a SIM card and send it to the user's account online agenda. So the user can restore it later using the same application. This should be a web application or at least look like one.
If the first is not possible. Is there any way to launch an external application from all the browsers, and then pass information to the browser window to allow it to refresh after the backup has been made?
I have an ASP.NET application running on multiple IIS6 web servers, with a SQL Server 2005 database back-end.
I need to:
monitor the database for the completion of an external job event, and then have exactly one web application instance submit some information to a web service For (1) it seems like a SqlDependency would be the best approach (or just plain old polling). Each web application instance would register such a dependency when it starts up. (I don't want to configure a 'master' instance because the failure of that instance would mean the task doesn't proceed, even if other instances are available. Thus my design is to ensure that if there is an instance available to do the work, then the work ought to proceed.)
For (2) I have been thinking of having some sort of flag in the database that the web application instances try to update once they receive the SqlDependency notification in (1), along the following line (greatly simplified):
UPDATE StatusTable SET TaskStatus = 1 WHERE TaskStatus = 0
that only one application instance would have been able to update the TaskStatus, and thus only one instance would have a @@ROWCOUNT > 0. This would then be the instance 'elected' to submit the information to the web service.