Web Forms :: Mark Up A Database Driven Table From Custom Business Objects?
Apr 14, 2010
UI markup to create the table shown below, which I have mocked up quickly to visualise what I need to do. The data is in the form of custom objects; a SelectedSession object which has a List (Of Students) sorted by AcademicYear, TeachingSet, then name.
So the question is how do I create that table from my custom object?
<table class="style1">
<tr class="academicYear">
<td colspan="3">
[Code]....
View 4 Replies
Similar Messages:
Feb 24, 2010
I'm working on a project in which we have a database, data layer (entity framework), business layer and web/UI layer.I want to use ASP.NET Dynamic Data for the web layer, but don't want it to access the data layer or database, as I want it to be purely running off business logic, and not directly accessing the data.However, it appears that Dynamic Data only allows Linq-to-SQL or entity framework data sources to be used.Has anyone used it with business-layer objects instead?
View 1 Replies
Sep 2, 2010
As I began writing web applications with asp.net I started with small projects that used a Linq-To-SQL mapper for database access to a MSSQL Server. After gaining some expierence I switched into a classic 3 tier with Graphic Layer, Business Layer, Data Layer. The only function of the Data Layer was to provide methods insert/update/delete without any logic and logic the form of selection methods.
Over the time I realized that it would be better not to provide the database classes up to the GUI (took some time unfortunately). I switched into using Business classes in the BL that are used for all operations performed by the BL and display by the GUI in the form of getting List from the BL. A great advantage is that I can provide additional properties that are not represented by the database itself. However, I did that mapping inside the BL myself with methods that mapped the corresponding BL class to the database class.
I guess thats where O/R mapper come in handy? Until now I haven't realized their purpose, but I think I just found it. I've recently tried out using the new Entity Framework with .net framework 4, but I'm only using it like the Linq-To-SQL DataContext.
Is there a way to achieve the mapping automatically? If yes, is that something the new Entity Framework provides or do I need to look for a O/R Mapper like NHibernate?
View 4 Replies
Mar 20, 2010
designing Business Objects. What a business object class can contain ?
I have looked many sample codes and articles. Some only use properties in them. Some use private members, properties and constructoers. As more I am reading becoming more confuse.
Some sample codes that I checked were making functions in BO classes as well. what a BO class should contain and what is its purpose. Should there be functions in them as well ? If yes how they can be differentiated from Business Logic class functions.
View 5 Replies
Feb 23, 2010
I am new to OOP. Kindly guide me why making business objects is good ? how and what benefit they bring in development. As I am new to OOP if please you decidable with example in simple way will be great help to me.
View 3 Replies
Feb 2, 2010
We are using below class(TypeInterceptor) in one of our project to create the instance of business objects.
To Create any business object, we are using the below code
++++++++++
BLayer.TestBO objTestBO;
this.objTestBO = TypeInterceptor.CreateObject<BLayer.TestBO>();
+++++++++++
I think using this kind of creational pattern makes the application not scalable as the same instance will be shared among all the concurrent users.Is it correct?
Is there any better way to abstract the creation and maintaining instance of business objects
Class code:namespace Microsoft.IT.RelationshipManagement.Internal.CISF.Infrastructure
{
using System;
using System.Linq;
using System.Text;[code].....
View 5 Replies
May 12, 2010
Unit Testing for Business Object
View 2 Replies
Mar 25, 2011
I'm currently writing an N-Tier architected ASP.NET system with a relatively normalised SQL database backend, but I'm struggling to get my head around how lookup values should be represented in my business objects (I don't get the priviledge of using EF or ORMs). My table (as an example) could be structured like this:
CoreDataTable:
ID | Name | Favourite_Colour
---|-------|-----------------
01 | Peter | 01
02 | John | 03
03 | Mary | 05
ColoursLookup:
ID | Colour | is_active
---|--------|----------
01 | Red | 1
02 | Green | 1
03 | Blue | 1
04 | Pink | 1
05 | Black | 1
Now initially, I had created my business object to look like this:
[code]....
I'm 100% convinced that I'm (a) overthinking this, and (b) making it more complicated than it needs to be. So, is there a preferred way of doing this? Or is there an option that I've overlooked?
View 2 Replies
Feb 5, 2010
I have two business objects mapped via LINQ to tables. One of the objects contains an instance of the other object and share a key as an identifier.I want to retrieve Class A and within class A all of Class B's values as well. What I am doing is this:
[Code]....
[Code]....
This seems a little clunky, as in slow. Is there a better way to get the Class B (User) information without making a query every time?
View 4 Replies
Jun 22, 2010
If I do thisPublic PageDetail As CoreBO.GetStartUpDetails = PageCoreBLL.InitialSetup(DomainName)
[Code]....
Where GetStartUpDetails is a structure in the Business Objects Layer In my page subs is their a performance differance between writing
sub xx
Dim test as pagedetails.structure1
response.write (test)
end sub
or just response.write (pagedetails.structure1)
View 1 Replies
Mar 26, 2010
I created a class library: PRTreatmentReviews. I created a reference for the class library on the website. I checked the property pages and the reference to the class is there. I put objectdatasource on a page and tried to pick up the PRTreatmentReviews class but it's not there? The Class
[Code]....
View 13 Replies
Apr 12, 2010
I amcreateinga dynamic web application and I wand the ablity to to control the bcakround color and backround images to controled by a database entery. does anyone know how to do this I am at a loss and I have been searching on the web all day to do this
View 5 Replies
Aug 12, 2010
Did anybody do Database Driven - Horizontal and Vertical Nav without using XML?is it possible to bind menu control with query or view and pass query string to find particular horizontal nav and vertical nav?Please post working solution, i was trying for days to find a working solution. All the samples i tried is not working or it is too complex.i love to write and manage simple code.
View 1 Replies
Oct 21, 2015
I don't want to use any asp.control to bind data so.
Is it possible to create dynamically customized table for database record.
View 1 Replies
Mar 2, 2011
I have a form where users enter their preferred contact method. It has:
- a radio button where a user selects whether they'd like to be contact by phone or email or either
- a textbox for the user's email address
- a textbox for the user's phone number
I have validation via a custom attribute that verifies that if the user selected phone they entered a phone number, if they selected email they entered an email, etc... but it's at a class level on my ViewModel. As such the validation doesn't mark the expected field as invalid.
Is there a way that my IsValid override (or some other method) can mark the child property's value as invalid so I get highlighting?
View 1 Replies
Mar 23, 2010
What I'm trying to do is rather basic, but I might have my facts mixed up. I have a details page that has a custom class as it's Model. The custom class uses 2 custom objects with yet another custom object a property of one of the 2. The details page outputs a fair amount of information, but allows the user to post a comment. When the user clicks the post button, the page gets posted to a Details action that looks something like this:
[AcceptVerbs(HttpVerbs.Post)]
public ActionResult Details(VideoDetailModel vidAndComment) { ....}
[Code]....
The only fields on the form that is posted are CommentText and VideoId. Here is what the VideoDetailModel looks like.
public class VideoDetailModel
{
public VideoDetailModel()
{
[Code]....
I suppose if I added more form fields for the properties I need, they would get posted, but I only need 1 form entry field for the CommentText. If I could get the same Model objects value that were sent to the page to post with the page, it looks like the solution is rather simple. I think using the RenderPartial in the middle of a form is problematic somehow to how the form gets written in html. I can't really put my finger on why things went bonkers, but if I do my RenderPartials before my form and then begin my form with the text entry field and the hidden VideoId, the default ModelBinder works just fine. I was beginning the form, writing the hidden VideoId, rendering several partial views, create my CommentText field, and then closed the form out. The CommentText field would get bound just fine. The hidden VideoId would not. Maybe I missed a rule somewhere about using RenderPartial.
For completeness, the partial view I was rendering took a Comment object and just wrote out it's CommentText data. Several of these objects would exist for a single Video object. All of this data was in a custom type and passed into the View (the main view) as it's Model. This partial view did not have a form and did not have any data entry fields.
View 2 Replies
Feb 5, 2011
Using Visual WebDeveloper 2010 Express and ASP.NET 4.0 don't know whether its relevant but the whole thing is in a ContentPlaceHolder and inside an UpdatePanel. To avoid using the old table tr td model, I have created a simple form like this
<div class="admin-form">
<asp:Label ID="UserNameLabel" runat="server"
CssClass="form-label"
Text="User Name" />
<asp:TextBox ID="UserNameText" runat="server"
Width="200px"/>
<br />
<asp:Label ID="PasswordLabel" runat="server"
CssClass="form-label"
Text="Password" />
<asp:TextBox ID="PasswordText" runat="server"
TextMode="Password"
Width="200px"/>
<br />
<asp:Label ID="ConfirmPasswordLabel" runat="server"
CssClass="form-label"
Text="Confirm Password" />
<asp:TextBox ID="ConfirmPasswordText" runat="server"
TextMode="Password"
Width="200px"/>
<br />
<asp:Label ID="EmailLabel" runat="server"
CssClass="form-label"
Text="Email" />
<asp:TextBox ID="EmailText" runat="server"
Width="200px"/>
<br />
<br />
<br />
<span class="form-label"></span>
<asp:Button ID="CreateUserButton" runat="server"
CssClass="button blue"
Text="Create New User"/>
</div>
And the CSS
.form-label
{
width: 300px !important;
}
This renders incorrectly as I would like to have all textboxes vertically lined after taking 300px. What is wrong? I cannot use HTML Controls like label as I have resx for globalization
View 1 Replies
May 18, 2010
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.
View 14 Replies
Mar 3, 2011
On my local machine I have created a database driven website. All is working well on my local machine.
Now I want to upload it to my Arvixe Hosting. How do I do that from Visual Studio 2010 Keeping in mind I have a Database too ?
Do I need to manually create a Database on the Server ? Do I then create all the tables Manually ? Do I then populate the tables manually ? Or is it a 1 button click ?
View 10 Replies
Mar 26, 2016
In this article [URL] ....
I am receiving "Object reference not set to an instance of an object" error. It pops up in line :
Menu1.Items.Add(menuItem) in method called "PopulateMenu"
View 1 Replies
Sep 14, 2010
I have one table named 'dbo.ac_Products' Within this table there is a column named 'ProductId' There is also another table named 'dbo.ac_CatalogNodes' Within this table there is a column named 'CatalogNodeId' and a column named 'CatalogNodeType'
I need to delete all the rows from 'dbo.ac_Products' and 'dbo.ac_CatalogNodes' where 'ProductId' = 'CatalogNodeId' and 'CatalogNodeType' = 1
View 4 Replies
Jan 17, 2010
I didn't really know where and how to put this so here we go:
I'm trying to design a map with co-ordinates that's driven from data in a database. I want it to look something like this:
Also, the selected X/Y co-ordinate must be centered for the user to see. How could I produce something like this?
View 5 Replies
Dec 25, 2010
I create a database driven menu, in specific condition i want to open link in new tab... i use following code but not working....
Menu1.Target = "_blank"; (target is not working in menu control)Any other solution for this....
View 3 Replies
Mar 23, 2011
Im using Visual Web Developer 2010 Express and have put together a custom form using ASP controls and labels.
I now need to update an access database with the data that is captured on the form. I have added an AccessDataSource but do not know how to link the fileds to the fileds within the database so that when I click submit it updates the table.
View 8 Replies
Feb 12, 2010
My code is not updating the sql database. I am definately passing the correct information in to this function, and it runs without errors. If I exec the procedure with the passed in data, it works great. Can someone tell me what is missing?
public DataTable UpdateEmailList(int listId, string connectionString, DataTable EmailList)
{
//DataTable dt = new DataTable();
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlDataAdapter da = new SqlDataAdapter(null, conn);
SqlCommand cmd = null;
//add
cmd = new SqlCommand("dbo.fp_ServiceAwards_AddEmailToList", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@emailList_id", SqlDbType.Int)).Value = listId;
cmd.Parameters.Add(new SqlParameter("@email_address", SqlDbType.NVarChar, 255, "email_address"));
cmd.Connection = conn;
da.InsertCommand = cmd;
//delete
cmd = new SqlCommand("dbo.fp_ServiceAwards_DeleteEmailFromList", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@emailList_id", SqlDbType.Int)).Value = listId;
cmd.Parameters.Add(new SqlParameter("@email_address", SqlDbType.NVarChar, 255, "email_address"));
cmd.Connection = conn;
da.DeleteCommand = cmd;
try
{
da.Update(EmailList);
}
catch (Exception ex)
{
string msg = ex.Message;
}
conn.Close();
conn.Dispose();
return EmailList;
}
View 3 Replies
