Configuration :: Using C# 4 And Has A SQL 2008 Backend And Then An CMS Custom Building?
Oct 19, 2010
experienced pros on the best way of doing something.First let me give you the broad view of everything.I have a main site (http://www.ffinfo.com/) which is built completely in ASP.Net using C# 4 and has a SQL 2008 backend and then I have an CMS I am custom building to administer the site.At some point I hope to have more people playing the Final Fantasy games and helping me collect data to add to the site so I am using the CMS to both add/modify data in the SQL DB and genereate new pages on the main site as needed.I want to compile the main site so it runs faster as my server has limited resorces and after a reboot or upload of new pages it takes a little bit for the first visit to run.Now here is the problem.
When I use the CMS to make a new page I currently copy over a .asp and .aspx file from a template into the appropreate folder and am good but if I want to compile that page along with any other new pages made I have to scower my FTP for them, download to the local machine,build and publish.This will very quickly become a lot of work,not to mention I can not really take advantage of OOP.
So my question is this, how do I go about doing this better? Have I taken the wrong approce from the start and need to find another road or is the road I am ok I just need to improve my transportation?
We are building an extranet loan status check website using ASP.NET MVC with a WCF backend. Its a pretty standard design with the MVC site using a WCF service reference to get customer objects. The ervice uses an Oracle backend + http binding, and won't be hosted on the same server as the MVC site (so we can't use tcp binding to reduce latency).
The problem we encountered is that every call to the service is resulting in a 7-8s response time which is unacceptable for an extranet site and much higher than the 2s magic mark. The service method(s) call 12 stored procedures to create the customer object. The database is, unfortunately, denormalized (we can't change it as its also used by other inhouse production systems) so most of the calls are basic select statements which populate the customer object and its associated objects. The service proxy is properly opened and closed/disposed in the MVC actions so there are no instances of any service connection leaks. A new client proxy is created for every request (i.e., we are not using the singleton pattern for the service). how we can speed this up ?
I am working on building a custom form builder module for our customers ... and wondering if you know any good .NET code base references for this module.
Requirements:
Customer should be able to add a form field(radio button, text box, dropdown menu) and customize the values real time.
I am having problems with a user control. I want my solution to have a separate project for holding my user controls.The main project can get a reference to this user control project and can import this user control dll into my main project.
i have a webapplication project which uses some functionailty from class library project, i am Using VS2010 TCP 4.
so the class library is a reference in this webapplication project,
unfortunatelly, when i build the webapplication, the class decleration has been lost!!!, and the message appear "The type or namespace name 'ClassName' could not be found (are you missing a using directive or an assembly reference?)" !!! i must delete the class reference from the webapplication and re-refrence it again !!!
but still when every time i build the project the reference decleration removed !!! does that error in VS or what ?
My intention is to give the user a flexible user control on a master page that does the following:
When navigating, a child page will pass the URL (with querystring) and PageTitle to the user control. The user control will take those two parameters and insert them as a "breadcrumb" object at first index of a List<breadcrumb> collection
This part works fine through the use of a Repeater with a LinkButton contained in an ItemTemplate. The user sees each of the pages he has been visiting in descending order, the provided benefit is a quick way to re-open records they have recently modified or created.
The part I'm having trouble handling is what happens when the user clicks the LinkButton, which is that the child page adds a new reference to the URL at the beginning of the List<> collection and I cannot seem to control the behavior of removing the LinkButton before it gets re-created. What I've tried doing is:
While that should work, my CreateBreadCrumb(string url, string title) function gets called by the child page before the UserControl detects the Repeater1_ItemCommand event, so in effect it appears that the wrong ItemIndex is being used for removal.
I'm creating a website and I'm testing resgistering and Log-in.
I followed a simple tutorial to create a Log-in in Visual Studio C# template which generated a SQL Server database.Locally the Log-in and registration page works perfectly. The problem is that when I upload my site to the hosting site the navigation works but the Log-in and Registration forms send an error when clicked "Register" or "Log-in". I contacted the site and they upload my database the way it should be because I was doing it wrong. I can see all my files including the data base.
They commented me that I had to do a connection string to the data base so the login and registration forms can work. I don't understand how to do that, I know the connection string has to be declared in the Web Config File, the thing is that I don't know how to write that code and link it to my data base in the hosting site, in fact I have sample code but I don't know just what do I need to put in it.
Recent we are deploy(Setup and Deploy) our Product which is develop in ASp.Net(C#) using SqlServer Here We Face one Problem i.e.
When we install the porduct there is no issue if we manually run the sqlScript file in sql server(manully we create the DataBase and All DataBase Object i.e. Table,StoreProcedure,Function,Views....& We are enter the Sample Data) But We know that is not the Right Approch.
Any one Can tell me the procedure "How to Building DataBase & All DataBase Object with Sample Data when we click the Install and set up file"
In Setup and Deploy wized it ask for any Dependence file for the application i have attach the Dependence file(.sql) but i am not getting any OutPut .
Is there any Command prompt Utility(SqlServer/VS Commandprompt) ?
I can't use Asp.net Configuration in visul studio 2008.when I click on Security tab , displayed below error:unable to connect to sqlserver database.please help me to solve this problem.also my server explorer can't connect to my sqlserver.
In the separate userSetting.config file I have some template user details. When a new user is crated the template details are stored in the userSetting.config file. I am trying to write to this filebut not having much luck.
[Code]....
[Code]....
The issue is that the new entryis not saved at all. There are no errors generated. Initially I was getting an error: A configuration file cannot be created for the requested Configuration object.
While the economy has been in the shitter, I've written possibly the most coolest site EVER for unemployed developers looking to buzzword-ify their resumes. (Don't hate the player, hate the game.)
The only problem is, it needs a scheduled task to run once a day to do some data mining. I spent many, many hours a few months ago researching solutions, but nothing seemed sure-fire.
If I have shared hosting and cannot remote in (e.g. mstsc and create a Schedule Task), how can I create a task that will run once a day on the backend of an ASP.NET website?
After all the research I did, I don't think it's possible. Per my last analysis, someone has to visit the site at least once a day to instantiate an instance of HttpApplication.
Does anyone have any solution to making sure an operation runs automatically, no matter whether anyone visits the site, and without anything but FTP access to the website?
Like I said, I've done A LOT of looking into this in the past, and it didn't seem possible. IF YOU HAVE EXPERIENCE implementing a solution, contribute your advice! But not postulating or conjecturing needed--it's far more nuanced and difficult than you're surely imagining.
I think I already know the answer to this but I think you know more than me so best to ask :)I've got a basic .Net 3.5 site using C#, with no database backend.I've had a request for a function to be added to some forms for people to be able to save the forms and come back later to finish them off.Is this possible?I would think not without a database backend to save it too,
How to do something like this without actually downloading the spreadsheet to the local machine? Any tools or what not out in the world for doing something like this? Does sharepoint allow for .xlsx editing in a page?
Anything short of writing all the inputs and mapping them with backend code?
at our office we take daily backup of ASP.net application ms access backend for the next few days we need to evaluate the changes made to records in the database tables at the end of each day i want to compare 2 access databases first database is the backup of yesterday and second database is the backup of today i thought of the following algorithm, how to proceed to compare the datatables / gridviews
i need to display th rows / cells containing the differences / updates / deleted data
I'm constructing a new cms with the option to create reviews and articles (blog items). Now if the user wants to write a review he/ she will want to add a lot of images in the text. Now my question to you is , what would be the best option to include those images (with keeping in mind that a CDN can be used later). I was thinking of the following methods:
Break an article in multiple blocks, each block can then include a picture and text. Just add the picture in the text via WYSIWYG editor (easiest option but not so versatile) Upload images separately and include them via tags in article text. Like Title{img_1}Content
I want to start creating sites with simple backends! I don't know much about databases though and I don't want to jump straight into creating sites with databases anyway. So I want to find out what the best way of creating a simple backend without using a database is.
I have an asp.net webpage which is a prices page detailing the prices of services at a hair salon. The prices change every 6 months so I want to give the client a simple backend so he can update the prices himself. The backend will just be a table of inputs populated with the current prices which can be changed and then click 'save changes' to update the site.
Now what is the best way of implementing this?
A) In the prices page, hard code an html table, within each cell code a <span> tag with an id for the price that will go within the span tag like id="menscut" and within the span tag hard code the price of the service. Then wirte a C# class called 'edit' that is used when the 'save changes' button is clicked on the backend page. When 'save changes' is clicked the 'edit' class parses the prices.aspx page and finds <span id="menscut">£20</span> and then changes it to <span id="menscut">£22</span> (or what ever new price has been entered in the backend) and then saves the new edited prices.aspx page over the old one on the server.
or
B) Don't hard code prices into the prices.aspx but instead store the prices in a seperate .txt or .xml file. Every time the prices.aspx page loads it runs a class called 'populate' which extracts the prices from the .txt file or .xml file and inserts them into the table in the prices.aspx page. And now the edit class instead of editing the prices.aspx page it edits the .txt or .xml file.
So which of those ways is better, or if they are fairly even pegged what are the pros and cons of each?
Or are there any other options I haven't thought of?
A friend suggested instead of having a backend class which verifies the user permission in every public function (results are cached and non static) i should have a more 'streamlined' site. When i dropped the backend i also drop the database code and merged them in the appropriate user permission (base user, logged_in_user, moderator).
The site code looks better now that merging them has decreased LOC (tons of LOC in fact) and i write Method() instead of backend.Method() which increases readability. However now that i have no backend how am i suppose to unit test my code? and what about things like user file upload with different extensions? (txt vs jpg vs FLAC)
I'm trying to make a client-server app using SOAP. The communication btw the client and gateway will be done using SOAP messging. I was wondering if it's possible for the gateway to communicate with my backend servers using SOAP as well(blue lines)? will I need to create a second interface/port for the gateway and servers so they can communicate. or is there an easier way to do it bust still using SOAP
I've created a custom gridview control with a custom datacontrolfield as well, which enabled me to have textboxes in the headercells of the gridview so I can filter each column value.
Now I've added textboxes to the footer row as well so I can allow users to insert data directly from the grid.
As you can see, I added an Insert and Cancel button in the footer row. Then I have my custom column. Now in the rowdatabound event of the grid, i'm trying to hook up the linkbutton click event to a handler:
Code: Protected Sub nsGrvContainer_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles nsGrvContainer.RowDataBound Select Case e.Row.RowType Case DataControlRowType.Footer Dim lbInsert As LinkButton = CType(e.Row.FindControl("lbInsertCN"), LinkButton) AddHandler lbInsert.Click, AddressOf odsContainerNumber_Inserting End Select
I find the control fine, but the click event never fires.
My ASP.NET MVC web app has a weird issue. In VS debugging mode it works as expected, but when I publish it to dedicated web server (windows 2003, IIS6) a sql query returns previous data even though underlying data was already updated through the same connection. It looks like as if a query returns cached data. What might be the problem?
