Application Design - Update Data?
Mar 9, 2010
I've got a web application with 3 layers: front, business and data. I'm using linqToSql for retrieving my data from the db. On the front end, I'd like to show the data that's being pulled from the database. In online examples all code is shown in the same layer. I'm wondering if it's good design to put a reference to the linqtosql classes in my front end so I can bind the results to my gridview, or whether I should use a different way. Since the user should be able to update the data, the easiest thing would be to use the gridview, connect it to the linq2sql datasource and bind it that way, but that would totally defeat my 3-layer structure.
View 1 Replies
Similar Messages:
Nov 10, 2010
I need to develop an application, which will get records (orders) from one application and process them. The updates to this records (order updates) will be sent back to the source application for end customer reference. I'm planning to achieve this data synchronization at the database level using triggers and stored procedures to insert database between the 2 databases.
But, the issue is I have to deploy this application in 3 different customer sites and I have to change the database names (cannot use the same database name) in each deployment manually. Because of this deployment issue, I was thinking of handling this within the asp.net application where I can store the db name in the database and then build the query within the application, but I dont want to do it as building queries like that doesnt look very professional.
View 2 Replies
Feb 23, 2010
can't connect to sql 2005 express sp1 and vs is also sp1. 2) Which my guess is because of the database connection not being able... design view is not able to pull in the application for design, it's as if there is no theme and css just white background and black print.
View 1 Replies
Nov 4, 2010
I'm about to begin designing the architecture of a personal project that has the following characteristics:
Essentially a "game" containing several concurrent users based on a sport. Matches in this sport are simulated on a regular basis and their results stored in a database. Users can view the details of a simulated match "live" when it is occurring as well as see results after they have occurred. I developed a similar web application with a much smaller scope as the previous iteration of this project. In that case, however, I chose to go with SQLite as my DB provider since I also had a redistributable desktop application that could be used to manually simulate matches (and in fact that ran as a standalone simulator outside of the web application). My constraints have now shifted to be only a web application, so I don't have to worry about this additional level of complexity.
My main problem with my previous implementation was handling concurrent requests. I made the mistake of using one database (which was represented by a single file on disk) to power both the simulation aspect (which ran in a separate process on the server) and the web application. Hence, when users were accessing the website concurrently with a live simulation happening, there were all sorts of database access issues since it was getting locked by one process. I fixed this by implementing a cross-process mutex on database operations but this drastically slowed down the performance of the website. The tools I will be using are:
ASP.NET for the web application. SQL Server 2008 R2 for the database. probably with an NHibernate layer for object relational mapping. My question is, how do I design this so I will achieve optimal efficiency as well as concurrent access? Obviously shifting to an actual DB server from a file will have it's positives, but do I need to have two redundant servers--one for the simulation process and one for the web server process?
View 1 Replies
Jul 28, 2010
the best practice for a designing a simple CRUD application with some screens updating various tables (like admin pages to maintain static data for an application). the simplest way would be to drag a data grid/gridview, bind it to a dataset and use a data adapter for CRUD operations. but if this application needs to be scalable, lets say to add any extra UI/business logic in future, then is there any design pattern that can with this? should I be using an object data source control and bind it to business objects instead? or are there any better ways of doing it? should I build a complete layered application or will that be overengineering for this requirement?
View 3 Replies
Oct 4, 2010
I am working with a financial application and am looking for the best solution for designing my application.
We have 100's of stored procedures where most/all of our business logic sits. We have WCF web services projects built using Web Service Software Factory (http://servicefactory.codeplex.com/). We have stored procedures built for nearly everything (tables, dropdowns, etc..) and each of these stored procs have their own webservice exposed to be called by the web application. Each web service is a very simple method that calls the stored procedure with the exact paramaters of the web service. I am not too sure if this is the best design and would like to ask for suggestions and alternatives to the design. Does anyone else have a similar environment ? How is it implemented on your end ?
View 2 Replies
Nov 4, 2010
While designing (and then implementing) a layered application:
Is it correct to use the same ORM objects accross all layers? (which would go against encapsulation).
Or the presentation, business and data layer should each have their own objects? (which would lead to lots of code repetition).
e.g. (just to illustrate the question): if one uses Linq to SQL in the Data Layer and Visual Studio's O/R designer to generate the ORM objects, are those objects supposed to be used in the Business and Presentation Layers as well.
i.e.: Are the objects associated with the entities that the application handles a crosscutting issue?
View 1 Replies
Jan 18, 2011
I am very new to application design, how and from where should i start to design application
View 3 Replies
Dec 3, 2010
I use AJAX tab panel for my web site (ver.1.0.2) with VS2005. Previously I use large page and now i it change to tab panel. The problem is when I change the source view to design view it automatically update the content of tab panel and show the 'error creating control' and sometimes it not. So I'm having difficulty on designing that page because always I have to keep the backup of the page.
View 1 Replies
Mar 13, 2011
i would like to ask about the design pattern of insert/update/delete record in the datagrid.
my page have 3 datagrids, each datagrid display different data.
but when clicking the save/update/delete button, how can i write a good progrmming pattern to perform this action.
any example code for my reference?
View 1 Replies
Jan 14, 2010
I've created a UserControl with the following public property:
[Browsable(true)]
public string Text
{
get { return pnlLookupTable.GroupingText; }
set { pnlLookupTable.GroupingText = value; }
}
pnlLookupTable is, as you may have guessed, a Panel control. I can change the value of the Text property in the Properties window and it's reflected in the markup like it should be. However, the design view of the UserControl inside a page does not show updated GroupingText for the Panel. How can I get this to happen?
EDIT:
By request, here is the entire class to which that property belongs. You can see there's nothing special going on:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Linq;
[Code]....
And here's the relevant part of the .ascx file:
<%@ Control Language="C#" AutoEventWireup="true" CodeFile="LookupTable.ascx.cs" Inherits="LookupTable" %>
<asp:Panel ID="pnlLookupTable" runat="server" GroupingText="Lookup Table">
<%-- Irrelevant content here. --%>
</asp:Panel>
I have changed some identifiers and other trivial things to protect the proprietary nature of the code.
I should also reiterate that I'm looking at a Web form in design mode that has my control added, and I'm changing the Text property. I want to see the change to the Panel's GroupingText visually in the designer.
View 2 Replies
Feb 8, 2011
I've been asked to re-write an existing VS 2003 applicatoin in VS 2010. The application contains multiple sections that allows certains users the ability to edit based on security roles. Each user is able to view the sections. There is ton of code to enable/disable section permissions for each user. Is there a better option available in VS 2010? I'm not too familiar with MVC and not sure if it would work in this scenario - each section should be available when the users login.
View 9 Replies
May 17, 2010
I'm trying to build a small, web application. But I want to use desing patterns in it. So I have a question: which desing patterns do you use and why in asp.net applications?
View 11 Replies
Mar 10, 2010
designing a view for Mobile browsers in ASP.NET MVC framework. I am new to this mobile web application development. I learned already how to provide a diffrent view when the request comes from a mobile browser. but now i need to learn, how to design the view with a good look and feel. I have demo this weekend with my client so i would appriciate if some one respond imidiately.
View 2 Replies
Sep 22, 2010
I'm trying to decide which of the two factory patterns I should use in my Asp.Net applications:
1 : All DAL providers derive from same abstract base class DepartmentsProvider, which defines public interface of the class ( all the necessary CRUD methods for which derived classes (providers ) provide a concrete implementation ). BLL layer instantiates correct provider by calling DepartmentsProvider.Instance:
public abstract class DepartmentsProvider
{
static private DepartmentsProvider _instance = null;
/// <summary>[code]....
In first case we implement new provider by deriving from DepartmentsProvider class, while in second case new provider is implemented by deriving from DBProviderFactory. What are pros and cons of each implementation?
View 1 Replies
Sep 6, 2010
I am starting to design my own CMS , and i want it to be modular to add more functionality later by me or by any other developer I put my eyes on joomla CMS (very popular ,robust and extensible) I want to make a CMS with asp.net to be just skeleton and all functions are done through components
Functions like :-
User management
Content Management ,editing and display etc.
My main idea is to let the skeleton to know from the query URL the required component and pass all other parameters to it and the component do the rest (parse parameters display results etc.)
the problem is how to achieve this how to call the component and and how to let it render its UI and pass it to the skeleton to put it in the appropriate place in the main site template
View 4 Replies
Dec 2, 2010
i am working on a asp.net webforms app, and i have to create 'dynamic order lines'That is : you select a product and a quantity, and the amount is calculated.
To visualize: this is on one 'line', so forst product dropdown, next to it the quantity textbox and next to that the amount label.
Then you click 'add another product', and another 'line' is added with a product dropdown, quantity textbox and amount label.
So you can click add and add and add....
Now i was thinking how to implement that, and i came up with two choises:
'add html client side' and 'add user control server side'
The first looks more fancy of course, but i also have to create some server side code to generate the lines again, when the user says 'go' but after validation i have to warn the user for example the amount was over credit or the quantity was to high. Then i get the 'client side' added html, and i have to reproduce that in my code behind, am i right?
On the other hand (add user control server side), i have to create a new user control on 'and another product' postback, which might look easier in the beginning because it's all strong typed, and the client side (jquery / javascript) isn't?
And one more thing: there is a possibility (they are not sure yet) that this functionality is wrapped within a 'section', with an address box and call it an order.And then: the user can add that 'section' also multiple times, so he can create multiple orders in one page, so i have to create multiple sections for an order, and within that order have the possibility to add another product.It looks like it will be hard to do this client side, especially with generating id's?
View 2 Replies
Jul 18, 2011
I'm in the process of re-writing an existing survey application that is currently using nested repeater controls to display questions and answers. The application was not designed with future enhancements in mind and its a pain any time a new question has to be added to the application. The repeaters currently contain questions, answers, and controls(texbox, radiobuttonlist,etc.)
Is the repeater the correct control to use for this type of application? What is the best way to design this type of application and table structure? Are there any new controls or features in VS2010? How to design this application the correct way and make it more flexible?
View 6 Replies
Feb 1, 2011
How would I go about creating a desktop application that would be capable of generating an ASP.NET master page, perhaps using drag and drop for the different allowed elements (image, text, video). I would take the co-ordinates and generate a master page that can be used later.
View 2 Replies
Sep 3, 2010
I've a project where i need to allow users to design their own pages for their application. So i want to create a designer/editor using ASP.NET/C# or silverlight or using anyother MS technologies. The designer should have the following featuresDrag and drop controlsMove the controls in the designer toposition it
Preview mode/Source ModeProperty Window for Controls with specific propertiesI've not any designer as a hosted application. I basically want to create something similar to visual studio designer as a web app.
View 1 Replies
Oct 5, 2010
my application is in Intranet, but in my application mail is trigger to the user, and in that mail (outlook) user getting one link of that application so that he can update "YES"
My problem is that when the user is not in office and he is using Blackberry, at that time intranet link will not work.........
so, any solution that anybody can update through internet.
View 1 Replies
Aug 26, 2010
i have visual studio 2008 and ms office 2007..when i try to develop a web application in vs 2008, i didnt able to open the design view of the web page.. i can only able to see the source view..came to know by googling as, there is some compatibility issues between vs 2008 and ms office 2007 in web authoring components.
View 1 Replies
Feb 14, 2011
My web application goes onto several client servers and I wrote a simple VB6 app that when run downloads relevant files and copies them into the directory.If I wanted the web application to perform this update can I assume this is impossible, i.e. FTP the files and copy them accordingly?Also I am now pre-compiling my site each time using the aspnet_compiler and this seems to update every page, do I need to copy each page every time or simply the ones I've changed.
View 1 Replies
Sep 22, 2010
I want to create a WCF Service to transfer data to our clients application(WPF). The Data I am trying to send is as follows.
ID Code Description unit Rate
1 104200000 LIVE GOAT NOS 25
2 104200000 LIVE GOAT2 NOS 25
3 104200030 LIVE GOAT3 KGS 10
4 104202030 Water LTR 5
and so on till ~ 11000 records.
What I have done so far is. Created a service which return a list of data.
public List<Classes.TariffData> GetTariffData() { var currentTariffData = new List<Classes.TariffData>(); using (var myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString)) { const string query = "select a.ID,a.Code,a.Description,a.unit,a.rate,a.rate3 from tariff.dbo.tariffdata a, tariff.dbo.code_history b where a.id = b.id and b.endofvalidity is null"; using (var myCommand = new SqlCommand(query, myConnection)) { using (var ad = new SqlDataAdapter(myCommand)) { var dt = new DataTable("tariff"); ad.Fill(dt); currentTariffData.AddRange(from DataRow row in dt.Rows select new Classes.TariffData { Id = int.Parse(row["Id"].ToString()), Code = row["Code"].ToString(), Description = row["Description"].ToString(), Unit = row["unit"].ToString(), Rate = row["rate"].ToString(), Rate3 = row["rate3"].ToString() }); return currentTariffData; } } } }
Class is as follows
public class TariffData { public int Id { get; set; } public string Code { get; set; } public string Description { get; set; } public string Unit { get; set; } public string Rate { get; set; } public string Rate3 { get; set; } }
If i Limit the number of data by using const string query = "select top 300 a.ID,a.Code,a.Description. The Service works fine. But if I remove the top 300 part I get an error. What is your advice if I want a service to allow our client applications to update their data by using WCF. (11000 records.) I am using visual Studio 2010. C# .Net 4.0
View 3 Replies
May 3, 2010
I need to auto update application like in wordpress, Application must check if new updates are available, download this updates and install.But I don't know how to install application. Because if some files in bin directory are updated application is restarted.Is it possible to create ASP.NET web application which will be auto updatable?now we have a new technologies, could u please suggest me any kind of soultion for the above problem. here i am enclosing my email idsunnyb4uu@hotmail.com
View 2 Replies
