Home ›
All Tags » DataSet » DAL (RSS)

Browse by Tags

Related Posts

  • Problem Creating DataSet at design time.

    Hi friends, I am working in Visual Web Developer 2005 and Oracle9i. I am creating a dataset at design time to make DAL. But in TableAdapter Configuration Wizard there is only one option is enabled and remaining 2 option is desabled . In the same PC if i connect with sql then all 3 option appear enabled...
    Posted to Oracle (Forum) by Deepak Rai on 03-26-2008, 12:00 AM
    Filed under: dataset, XSD, DAL

  • Re: Return a DataReader - Is this good practice?

    [quote user="ElCapitan"]...Yeh I understand that this is a good way of doing things too but not without its drawbacks. Many hits to a page that constantly calls a couple of hundred 'rows' of business objects will be much heavier on the application surely because all the data is 'in...
    Posted to Architecture (Forum) by SergeyS on 03-24-2008, 12:00 AM
    Filed under: scalability, SQL Server 2005, 3-Layer Architecture, 3tier, 3-Tier Architecture, 3-tier programming, asp .NET 2.0, Basic Architecture Design, Best Practices, bll, Buisness layer, business logic layer, Connection pooling, dal, data access layer, datalogic layer, dataobjects, Dataset, dataset datareader 3-tier mvc, datatable, database object, asp.net2.0, ASP.NET Architecture, sql server, Typed DataSet tableadapter, arcitecture, asp.net 2.0 sql server, datareader, load balancing, Patterns & Practices, N-Tier, Asp.Net 2.0

  • Re: Return a DataReader - Is this good practice?

    [quote user="ElCapitan"]...The function in the DAL is called by the BLL and the DAL opens a connection, and the command does an ExecuteReader. I understand that it is a good option for retrieving data. Surely though if the dr is returned to the BLL, the connection is still open...[/quote] It's...
    Posted to Architecture (Forum) by SergeyS on 03-22-2008, 12:00 AM
    Filed under: scalability, SQL Server 2005, 3-Layer Architecture, 3tier, 3-Tier Architecture, 3-tier programming, architecture, asp .NET 2.0, Basic Architecture Design, Best Practices, bll, Buisness layer, business logic layer, dal, data access layer, datalogic layer, dataobjects, Dataset, dataset datareader 3-tier mvc, datatable, database driven, database object, asp.net2.0, ASP.NET Architecture, Typed DataSet tableadapter, "system Design", arcitecture, asp.net 2.0 sql server, datareader, N-Tier, Asp.Net 2.0

  • Missing TableAdapter from DataSet or Business Object Empty

    The Scenario: I created a DataSet called GetHouses.xsd that gets data from a table based on which user is logged in. I named the Return a DataTable Method name: GetDataByUser. I have tried Google and these forums but I haven't found anything matching what I am experiencing. I've done similar...
    Posted to Data Access and ObjectDataSource Control (Forum) by dune44 on 01-31-2008, 12:00 AM
    Filed under: Empty, object data source, objectdatasource, sql, Table Adapter, Business Object, DAL, data set, DataAdapter, DataSet, datatable tableadapter, Gridview - dataset, Gridview DataGrid, Gridview

  • Strongly Typed Data Set errors out looking for local file!

    This one is driving me crazy! I'm building a 3 tier application. My DAL is a strongly typed dataset and I created a separate project for it (VS2005). The connection string to the database was saved to the app.config file in the project that has the DAL. When the application became ready, I changed...
    Posted to Data Access and ObjectDataSource Control (Forum) by cunharubens on 08-31-2007, 12:00 AM
    Filed under: strongly typed dataset, DAL, dataset, Connection Strings

  • Update Database structure after Strongly-Typed DataSet is built

    This is my first 3 tier application... I'm using a Stongly Typed Dataset as DAL. After everything was finished, I realized I had to make 2 changes to the database: 1- Add a new column 2- Change a SQL Data type from int to Bool What is the best way to update my Strongly Typed Dataset and make sure...
    Posted to Data Access and ObjectDataSource Control (Forum) by cunharubens on 06-09-2007, 12:00 AM
    Filed under: newbie, OOP, Visual Studio 2005, beginner, Best Practice, C#, DAL, data, dataset, DataSet DataTable TableAdapters, DataTable.Select Method, help me, xsd, Newbbie, SQL, sql express, 3-tier architecture

  • Decode query does not take parameter!

    I am trying to use a Decode Query to define a DataTable method which looks like this: SELECT CDTS, '', '', '', LOC, NULL, DECODE(DTYPE, 'L', CONCAT(CONCAT(CONCAT('***** LOI MATCH:', LOI_DATA.NUM_1), ' ADDRESS: '), LOI_DATA.LOC), 'D', CONCAT('CLETS...
    Posted to Data Access and ObjectDataSource Control (Forum) by Chabo on 05-22-2007, 12:00 AM
    Filed under: outputparameter, Paramter, Performance : Stored Procedure with many params, Table Adapter, TableAdapter, TableAdapters, ADO.NET, ASP.NET, Asp.Net 2.0, DAL, Data, data Acces, Data Access, Data Access connections, data connections, data set, DataAdapter, Database, databind, DataGrid GridView Paging, DataSet, DataSource, Select, SQL Server ADO.NET Transactions

  • DataTableAdapter with several SCOPE_IDENTITY and Variables

    Hi, i'm trying to set up a dataset which is using a DataTableAdapter with the following SQL Query: INSERT INTO Master (param1, param2) VALUES (@param1, @param2); SET @masteridentity = SCOPE_IDENTITY(); INSERT INTO Details1 (param3, param4) VALUES (@param3, @ param4); UPDATE Master SET Detail1ID = @SCOPE_IDENTITY...
    Posted to Data Access and ObjectDataSource Control (Forum) by dmdba on 04-26-2007, 12:00 AM
    Filed under: ASP.NET, Asp.Net 2.0, DAL, data Acces, DataSet

  • Datagrid / Repeater with .JPG or .SWF File

    I have a repeater control, in which I have to show two types of illustrations(images). One with extension .JPG and other with extension .SWF (flash file) I am using custom built classes and binding to the repeater. I wanted to know what ASP.net server control should i bind it to inside the repeater,...
    Posted to Getting Started (Forum) by mayuresh_s on 03-01-2007, 12:00 AM
    Filed under: "asp.net 1.1", repeater user control panels visible, .NET 1.1, .Net 2.0, ASP.ne, ASP.Neet 2.0, asp.net 2.0, C#, DAL, data, data handling, datagrid, dataset, asp 2.0, .cs

  • Datagrid / Repeater with .JPG or .SWF File

    I have a repeater control, in which I have to show two types of illustrations(images). One with extension .JPG and other with extension .SWF (flash file) I am using custom built classes and binding to the repeater. I wanted to know what ASP.net server control should i bind it to inside the repeater,...
    Posted to Getting Started (Forum) by mayuresh_s on 03-01-2007, 12:00 AM
    Filed under: "asp.net 1.1", repeater user control panels visible, .NET 1.1, .Net 2.0, ASP.ne, ASP.Neet 2.0, asp.net 2.0, C#, DAL, data, data handling, datagrid, dataset, asp 2.0, .cs
Page 1 of 2 (20 items) 1 2 Next >

Contact | Advertise | Issue Management by Axosoft's OnTime | Running IIS7
All Rights Reserved. | Terms of Use | Trademarks | Privacy Statement
© 2009 Microsoft Corporation.