Web Forms :: Retrieve Rows From Store Procedure In BAL And Iterate In Presentation Layer?

Feb 23, 2010

Actually what i am doing in my Data Access Layer dragging store procedure to TestDbml to display records and creating data context instance in BAL to retrieve records and my method in BAL is like this

public IEnumerable display()
{
using (TestDataContext db = new TestDataContext())
{
var display = obj.USP_Actor_View_Speciality(p_UserName, 1);
return display as IEnumerable;
}

Now the problem is that how can i iterate or fetch over the records and display accordingly in my Presentation Layer so that i could return all the field parameteres Like ield1=val.field1,field2=val.field2.

View 3 Replies


Similar Messages:

Architecture :: How To Pass The Values From Presentation Layer To Business Logic Layer

Oct 26, 2010

I am new to this .NET what is the difference between N-Tier and 3- Tier Architecture. If they are same. How to pass the values from presentation layer to business logic layer.

For Example

I have 10 controls in presentation layer. I passing values to these controls. How the architecture works.

View 3 Replies

MVC :: How To Make Business Layer Seperate From Presentation Layer

Feb 23, 2011

I've even got my JQuery Ajax submission going on now but I've encountered another problem. I *think* it's something to do with the structure I'm using but like I say, I'm fairly newo this.I have my AJAX form submission which builds my "PersonViewModel" (model for the presentation layer) in JSON and sends it to "@Url.Action("RegisterSubmit")" in my Person Controller. Now, I seperate my business layer from my View/presentation layer so in "RegisterSubmit"I'm verifying the model is valid then instantiating a new instance of my business model "Person", adding the values from "PersonViewModel" and then calling my "Save" function.

View 7 Replies

Unit Test The Presentation Layer Of A Web Forms Application?

Jan 8, 2011

What is the best way to unit test the presentation layer of a web forms application? I have been told that there are frameworks available like Watin. Are there better tools around?

View 1 Replies

Designing System With Presentation Layer And Web Service Based API

Oct 19, 2010

We are designing a system that has functionality that is essentially the same at the presentation layer and the exposed API layer. My question is what technique / strategy to use so we can get the most reuse out of our code with performance in mind? Here's a simplified example: A user can add a Customer via a web form. This will fire the Customer.Create() method. An API consumer / user can add a Customer via a SOAP / HTTP-POST to a web service which will call the Customer.Create() method.

Imagine these layers:
PRESENTATION
|
|
WEB SERVICE API (Customer.Create() is available here
|
|
FACADE Business Object Interface - Customer.Create() signature is here
|
|
BUSINESS Business object - Customer.Create method() is fleshed out here
|
|
DATA ACCESS - Writes data

The presentation layer SOAP calls the Create() web method, which calls the facade's Create() method which calls the business object's Create() method which wires via the data access layer.

Questions:

Is there a concern about performance in using the API's web services in our presentation layer, or are there alternatives to connect the presentation layer directly to the facade? If so, what technology to use (WCF, Remoting, Web Services, etc)?

View 2 Replies

Architecture :: Should DAL Reference Added In Presentation Layer? How To Access The Instance Of Table In Presenta

Mar 3, 2011

I creating 3 tier arch wpp in VS 2010. I added the BusinessAccessLayer refernce in Presentation Layer. and I created DataAccessLayer[DAL] and ORM [DBModel.DBML]. when i try to create the instance for the Table in presenation layer[default.aspx], The Table name is not shown.After adding the DataAccessLayer refernce in the presentation layer, the table name[MM_User] instance are shown.Is it the right method [Adding the DAL refernce in Presenation Layer]? If not, whats the solution for for accessing the instance of the tables[MM_User].Is it related to the Creating the DataContextWrapper class in DAL?

View 5 Replies

Web Forms :: Store PowerPoint Presentation File (PPT) In SQL Server Database?

Aug 6, 2012

How to upload Power Point Presentation in sql server using asp application and

also how to show the PPT to user

View 1 Replies

SQL Server :: Insert Gridview's Multiple Rows Into Sql Server Through Store Procedure?

Jan 23, 2011

Actually I have a gridview with many rows and I want to insert the all rows in sql server through one store procedure first row can inserted but what should we do for other rows

View 3 Replies

Architecture :: Using Data Sources Vs. Using Data Access Layer To Populate Presentation Controls?

Mar 17, 2010

We are using a tierd design with a Data Access Layer and classes for everything we need. This serves as an advantage because we do not have to write querys over and we can separate the Presentation layer from the Data Access Layer and Business Rules.I have always in the past populated GridViews, DataLists, repeaters,etc with SqlDataSources. This is what I have become accustomed to and I feel like it is simple. For querys such as Select * from Members, I feel like using a DataSource is simpler than having to go in the code and calling methods to populate and DataBind these presentation controls.


I am working with a gentleman who has introduced me to the world of Data Access Layers and we are breaking everything down into simeple, but effective queries to populate controls and do what we need to accomplish with this application. He is not very approving of using any type of DataSource. We are disagreeing on the time and place to use these class methods to call the database.So my question is, which is more widely used in the programming world? Do most people use DataSources to populate presentation controls regardless of the Data Access Layer they are working with? Which type of queries are best suited for a DAL - simple, populating queries or complicated joins and upserts?

View 9 Replies

Iterate Through Rows In An HTML Table With C#

Jan 6, 2010

I have an html table in an aspx page (C#) that has columns like

1.CheckBox 2.Text 3.Text 4.TextBox

I want to iterate through the table one row at a time and process (run a stored procedure based on column2) based on whether the checkbox is checked or not. How will I be able to do that?

View 4 Replies

Iterate Over Rows/checkboxes In A RadGrid

Apr 5, 2010

I have a Telerik RadGrid with a GridTemplateColumn that contains a checkbox, as follows:

<telerik:GridTemplateColumn HeaderText="MINE" UniqueName="MyTemplateColumn">
<ItemTemplate>
<asp:CheckBox id="MyCheckBox" runat="server"></asp:CheckBox>
</ItemTemplate>
</telerik:GridTemplateColumn>

I want to set the box to be "checked" based on a value read from the database. I could handle the ItemDataBound event and read the database when each row is bound, but that results in n lookups. Instead, I want to handle DataBound, and then set all the values at once. So, in that method, I want code like this:

[code]....

View 2 Replies

Select And Iterate Through Multiple Rows From The Database In C#?

Jul 20, 2010

I want to select many rows from my SQL Server database and combine them in a certain manner. Currently, I've been using the following method to get these rows:

[code]....

View 1 Replies

SQL Server :: How To Iterate Through Rows Of A Temp Table

Mar 21, 2011

Suppose I have a temporary table (Shown below). The table is defined and populated in my stored procedure. After it is populated, I need to go through every row in the table. Here is what I need to do :

Check if Amount2 > Amount1 If Amount2 > Amount1 then set Amount1 = Amount2

It feels a little akward for me to use the temp table.

[code]....

View 2 Replies

DataSource Controls :: Iterate Through Rows To Check If Row Has Been Displayed?

Jul 9, 2010

I am having a problem. I need to check to see if a row has been displayed once, and if so don't display it again. I have the following code:

[Code]....

This all works perfectly, but displays the body row repeatedly. So i need to add a counter or something to check this and make sure it is only displayed once..

I tried with DISTINCT in the sql but that didn't work, so i think it may be better doing it through iteration? Can this be done?

View 11 Replies

DataSource Controls :: Iterate Through The Rows And Add The Data To A Placeholder?

Apr 21, 2010

I've got a datatable in a dataset which contains 44 rows. I can iterate through the rows and add the data to a placeholder - it's all there. However, if I bind a control (say a gridview or dropdownlist) to the datatable, all I get is one record (from the "middle" of the table). I get the same result when I create a dataview of the table - one row.

View 4 Replies

Forms Data Controls :: Store Gridview Datatable In Session And Then Retrieve From Session And Store Database

Nov 11, 2010

Its related to datatable in gridview store in session and then session retrive and store to database. basically i am using gridview here creating new row for button click and these row adding untill user's last entry then submit all these entry to database. so i want to use session variable to store this data temporarily and after final entry user click on submit button and all data shold be save in db.

View 9 Replies

How To Store Store Procedure Results In A Dataset When There Are 3 Sql Datasets Returned

Mar 11, 2011

My SQL stored procedure returns 3 different datasets as follows:

team_id name
1 Team1
2 Team2
...and more

location_id name
1 Dallas
2 New York
...and more

branch_id name
1 Austin
2 New Jersey
...and more

How do I put this data into one Dataset so that I can loop through the data and manipulate it?

View 1 Replies

SQL Server :: Stored Procedure In 3 Layer Architecture?

Sep 17, 2010

I am using stored procedure in my Web application. I am creating SQL Command binding this command with Stored procedure name and parameters and executing.

The problem is for each Stored procedure i need to create separate function for each stored procedure defined.

Is there any way that I can define a single function for n number of stored procedure.

View 4 Replies

Best Way To Insert Values Multiple Times From Data Layer To Stored Procedure?

Feb 16, 2011

I have DAL Layer, from where invoking a stored procedure to insert values into the table.

E.g.:-

[code]....

Now as requirement changed, per client request i have to add values 5 times. So what is the best practice?

Do i call this Stored Procedure 5 times from my DAL?

View 4 Replies

Web Forms :: Store And Retrieve Images From Database To Webpage?

Nov 23, 2012

i have a web page in asp.net.vb code and sql database.

the persons number is called PNUMB and i have stored all photos of persons in a folder with the persons number (PNUMB) as their file name. when i search for a PNUMB i want to display the photo of the persons whose dtata is displayed. how i sit possible

View 1 Replies

Web Forms :: Bind DropdownList Or GridView With Store Procedure

Jun 24, 2012

Can we bind drop down list or gridview with Store procedure type query on close of popup window at java script side or on server side?

View 1 Replies

Web Forms :: How To Create A Chart For Statistic With SQL Store Procedure

Jun 4, 2012

I am very new to ASP.net with C#. I am creating the report that need to have a statistic (chart). I don't kow how.

I have 3 dropdowns on first page and Start Date, Ending Date and the store procedure have all the the count for statistic.  When I select something from the dropdown and enter the date in the textbox for both Start Date and Ending Date then click OK button. It will take me to another page or the same with the chart have statistics.

View 1 Replies

Web Forms :: Return Integer Result From Store Procedure

Feb 21, 2012

I want to return integer result from storeprocedure.I have used dataset to return values.My store procedure which i have wrotewhich return three result 0,1,2I want to get this result..how to get that result.

View 1 Replies

Web Forms :: How To Store And Retrieve Ms Word Document In Sql Server 2000

Jul 1, 2010

iam using asp.net with c# with back end as sql server 2000 i want to store and retreive ms word document 2003 or 2007 using asp.net with c#...

View 1 Replies

Web Forms :: How To Retrieve Click From Image Buttons And Store In Database Using C#

Jun 28, 2013

if (Session["ads1"] != null && Session["ads2"] != null && Session["ads3"] != null && Session["ads4"] != null && Session["ads5"] != null && Session["ads6"] != null)
{
this.Label1.Text = Session["ads1"].ToString();
this.Label2.Text = Session["ads2"].ToString();
this.Label3.Text = Session["ads3"].ToString();
this.Label4.Text = Session["ads4"].ToString();

[Code] ....

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved