.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Mulptiple Layer Budget

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :SharePoint

So I am still getting my head wrapped around the potenital of Infopath and Shrepoint.  In my position of managing the budget and tracking spending I have some plans that I am unable to execute do to my lack of understanding what I need to be asking. I currently work in a system where purchase requests are made on a form and place into a sharepoint library.  I know what I am looking for in a primtative Access sense so thats how I will try to explain it.

I essentially want my form to work in three sections but one form if possible:

A) Employee A Requests an item, fills in all the information in Part 1 with details about the who what when where and why.

B) A budget advisor assign a line of accounting from the budget as well as other important information regarding the classification of the funding

C) Purchasing officals assign a status to the request and can apply multiple lines of transactions to the same purchase request

In Access I would ask this to store in three seperate databases and create relationships and subforms, but I dont know how to do that in InfoPath/SharePoint.  I want use on form because of the quanitity of requests and transactions.  It makes it easier to guarantee that all moneys are assigned to the correct information.  I am sure I am not revolutionizing business systems so I bet some has bu

View Complete Post

More Related Resource Links

Cutting Edge: Building A Secure AJAX Service Layer


This month Dino builds a service layer that authenticates users of Silverlight 2 and ASP.NET AJAX services to prevent illegal access to sensitive back-end services.

Dino Esposito

MSDN Magazine September 2008

Easy UI Testing: Isolate Your UI Code Before It Invades Your Business Layer


The User Interface Process Application Block (UIP) from the Microsoft Patterns & Practices team can help you isolate your UI, write unit tests for your UI logic, and write a UI that really is the thin layer it was always meant to be. Mark Seemann shows you how it's done in this article.

Mark Seemann

MSDN Magazine August 2005

Know Thy Code: Simplify Data Layer Unit Testing using Enterprise Services


If you want to employ unit testing and test-driven development techniques in your database application development process, you'll have different factors to consider than you do when you're not involving a database. For example, you have to maintain a consistent state within the database and be able to roll back transactions when necessary. This article shows you how to get the best of unit testing for your database apps in a safe, usable manner.

Roy Osherove

MSDN Magazine June 2005

Data Access: Implement a Data Access Layer for Your App with ADO.NET


Implementing data access functionality is a core activity of most developers working with the .NET Framework, and the data access layers they build are an essential part of their applications. This article outlines five ideas to consider when building a data access layer with Visual Studio .NET and the .NET Framework. The tips include taking advantage of object-oriented techniques and the .NET Framework infrastructure by using base classes, making classes easily inheritable by following guidelines, and carefully examining your needs before deciding on a presentation method and external interface.

Dan Fox

MSDN Magazine April 2003

.NET Reflection: Dynamically Bind Your Data Layer to Stored Procedures and SQL Commands Using .NET M


One major inconvenience of using SQL stored procedures from code is having to match type information. You have to write long wrapper functions around the procedures just to expose the data types. In the .NET Framework, however, the reflection services of the System.Reflection namespace allow you to query rich metadata that describe data types. This article explains how to use reflection in .NET to end your stored procedure nightmares. The author creates four custom classes, including one that generates a SQLCommand object based on the metadata of a method. Using this library, you'll be on your way to automating the generation of stored procedures.

Atif Aziz

MSDN Magazine August 2002

MSLU: Develop Unicode Applications for Windows 9x Platforms with the Microsoft Layer for Unicode


The Microsoft Layer for Unicode (MSLU) provides Unicode support on Windows platforms that don't provide their own support, including Windows 98, Windows 95, and Windows Me. With MSLU you can write Unicode applications easily for these platforms. MSLU is simple to install, small (even though it wraps more than 400 APIs), and easy on system resources. This article explains the design criteria behind MSLU and how to put the layer to work for you.

Michael Kaplan and Cathy Wissink

MSDN Magazine October 2001

Secure Sockets Layer: Protect Your E-Commerce Web Site with SSL and Digital Certificates


Security is one of the most important factors in the future growth of e-businesses. Making sure that communications remain secure between customers and the Web server is a critical issue. Secure Sockets Layer (SSL) is the standard that secure Web sites are built upon today. This article presents an overview of SSL-based Web security, explaining such fundamental concepts as digital certificates and their distribution, encryption, and the proper configuration of Microsoft Internet Information Services (IIS). Acquiring a certificate, installing it, and configuring IIS for SSL are outlined in a step-by-step process.

John Papa

MSDN Magazine April 2001

Beyond ASP: XML and XSL-based Solutions Simplify Your Data Presentation Layer


The combination of XML and XSL can provide a powerful alternative to ASP development. This article presents arguments for building even small-scale Internet applications on the XML model. An example written with traditional ASP programming is compared to the same example written with XML and XSL in order to show the benefits of this approach. The example is followed by nine good reasons to make the switch. These reasons include separation of presentation and data, reusability, extensibility, division of labor, enhanced testing, and legacy integration. The XML/XSL solutions described hold the promise of greater simplicity, flexibility, and durability than ASP solutions built the traditional way.

Scott Howlett and Jeff Dunmall

MSDN Magazine November 2000

Webservice using socket layer programming



   I want to access a webservice in asp.net programming. This webservice was done using socket layer programming and also i am having the ipaddress and port address. Did any one know about how to access webservice using socket layer and if know let me know how to access the webservice. Thank you

is there any impact of using static methods in Business Access layer in 3 tier applciation


is there any impact of using static methods in Business Access layer in 3 tier applciation,

Please suggest me what are the best practices and standards

What is the difference between component,tier and layer?

We often heard about these word  like component, tier, layer of an asp.net application. Please explain the difference between  component , tier and layer?We often heard about these word  like component, tier, layer of an asp.net application.Please explain the difference between  component , tier and layer?

Package 'DataWarehouse VSIntegration layer' has failed to load properly

Hi, In my VSTS, I am not able to create a new SSIS project. When VSTS Opens It gives me following error: --------------------------- Microsoft Visual Studio --------------------------- Package Load Failure Package 'DataWarehouse VSIntegration layer' has failed to load properly ( GUID = {4A0C6509-BF90-43DA-ABEE-0ABA3A8527F1} ). Please contact package vendor for assistance. Application restart is recommended, due to possible environment corruption. Would you like to disable loading this package in the future? You may use 'devenv /resetskippkgs' to re-enable package loading. --------------------------- Yes   No   ---------------------------   Also, in Tools the options for Business Intelligence designer is missing.   Please help me!!Sonia Mawandia http://sqldeveloper-sonia.blogspot.com/

How to separate Presentation Layer, DA Layer and BLL?

Hello Everyone, Can anyone help me to understand how to separate layers in 3-tier architecture if it is possible here? I have a form (Default.aspx) that collects the user inputs (txtFirstName, txtLastName, txtStreetAddress, txtCity and txtZipCode) and save into a table (tblStudentInfo) and display that data into the GridView, Form View and Datalist. I have four buttons on this page. First one is the "Submit" button to submit the data into Database. Other three buttons are to display the data either in GridView, FormView or DataList. When users click on one of these three buttons it will redirect the user to Display.aspx, formview.aspx and datalist.aspx. This page also contains label to show the message weather the insertion was successful or not. "tblStudentInfo" has following definition. tblStudentID--------int--------Primary key tblFirstName-------varchar(50) tblLastName-------varchar(50) tblStreetAddress---varchar(200) tblCity--------------varchar(100) tblZipCode--------varchar(10) Stored Procedure: "InsertStudentInfo" ALTER PROCEDURE dbo.InsertStudentInfo         (@tblFirstName VARCHAR(50),         @tblLastName   VARCHAR(50),         @tblStreetAddress VARCHAR(200),         @tblCity VARCHAR(100), &

Issue with Data Access Layer DLL

Hi, I am working on a project in which I have made changes to LINQ to SQL code in data access layer project. Initially the code was using Single() extension method, I have changed it to SingleOrDefault() was earlier method was throwing exception if no records found in db. After making changes I ran the project but during debugging VS 2008 was showing that file is changed and do you want to reload the file box. When selected the file, the debugger was still executing the commented code (Single() method). I tried cleaning the entire solution and rebuilding it but it did not help. All the projects (Presentation, BL, DAL) are under single solution. Can any one please help me to solve the issue? Thanks in advance.

Need help: "Adding Parameterized Methods to the Data Access Layer"

Hi all, em all new in C# and .NET.I am following this tutorial: http://www.asp.net/data-access/tutorials/creating-a-data-access-layer-csAnd i am at step 3: Adding Parameterized Methods to the Data Access Layer - i have No problems in getting out all information from my database.But when i try to get a specific item by CategoryID i get a Error.This is what i type in my Query in the table adapter:SELECT     ProductID, ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, DiscontinuedFROM         ProductsWHERE CategoryID = @CategoryIDHere is the error i get when i click finish:The wizard detected the following problems when configuring TableAdapter Query "FillByCategoryID":Details:             Generated SELECT statement.              Error in WHERE clause near '@'.              Unable to parse query text.Can anyone help me with this problem?Someone who knows what i am doing wrong?Thanks

"The Windows Security layer always falls back to NTLM when connections are made locally"

Using Kerberos with SQL Server tells (in Comments): "Il-Sung Lee 27 Nov 2006 4:12 PM The Windows Security layer always falls back to NTLM when connections are made locally.  This appears to be the design of SSPI when NEGOTIATE is used so what you are seeing is expected" And how to avoid "NEGOTIATE"? I am curious about 2 aspects: 1) Why BEGOTIATE is used for local connections? What os the point in it for internal connections? 2) Does it mean that I cannot force/trick into using  Kerberos developing against local SQL Sever?

A SOA based Customizable Data Access Layer.Please comment

Hi, Actually I have an idea  to built a reusable package software .. The detail mentioned below.. ------------------------------------------------------------------------------------------ A SOA based Customizable Data Access Layer. Data access layer (DAL) is an essential part of almost every project. A data access layer can be build with all required methods(Like methods for fetching, inserting, updating data and also other methods can be built with required number of input parameters, which execute stored procedures.) in any language. Interfacing with the DAL would be a webservice. A webservice can be build with webmethods. The web service contains all web methods, which call all the methods in DAL, passing the appropriate parameters. Addition to those methods, webservice contains a method which takes database details as input parameters and passes the parameters to the method in DAL, which makes connection with database. Thus, the DAL layer and webservice, as a whole are acting as a complete package If the DAL and webservice can be built one time, it can be reused in any project with out modifying it.As the webservice is platform independent and language independent, any project can access the project/software for data operation. Using this product time can be saved so, deadline can be met easily. If this product is developed one time and can be reused by sever
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend