Home ›
All Tags » sql » DAL (RSS)

Browse by Tags

Related Posts

  • Can't find the error!!!???

    Anyone, I am just trying to do a simple insert, but can't figure out what the cause of my unhandled exception is. I am just trying to do a simple insert into a backend sql table. I'm using VB and sql '05. My codebehind calls this method in my Business Layer: Public Sub Insert( ByVal createdBy...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by bcoffey on 09-12-2008, 12:00 AM
    Filed under: sql, sql insert query, Sql Parameters, Sql server 2000, sql server2005 ADO.NET, sql update management studio, 2.0, 3 tier applications, ASP VB Data, asp.net 2.0, Asp.Net 2.0, bll business layer objects, BLL DAL Tier Separation, BLL Data 3 tiers business logic DAL ObjectDataSource sql connection, DAL, Data, data Acces, Insert, Insert data, asp.net2.0, sql data control, ASP.NET 2.0 search multiple keyword term sql server express 2005, BLL, Data Access and ObjectDataSource Control, .net 2.0, DAL Provider Interfaces

  • 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

  • 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

  • Re: Stored Procedures, Data Set and Data Table Adapters

    Swaino, If this helps you at all. When you use stored procedures you can benefit in several ways, including security and performance or making processes that require procedural action callable. Security because, for example, you may have a user that has read-only access to a table BUT, through a stored...
    Posted to Data Access and ObjectDataSource Control (Forum) by jrlopezp on 01-26-2007, 12:00 AM
    Filed under: sql, SQL Performance, Stored Procedures, ADO.NET, ADO.NET Tutorial, DAL, Data, SQL Security, SQL Server ADO.NET Transactions

  • Data inserting twice

    Is anyone aware of a bug or am I doing something wrong or blind .... that I am getting two records inserted in db? < asp:DetailsView ID= "DetailsViewInsert" runat= "server" Height= "50px" Width= "100%" DataSourceID= "ObjectDataSource1" DataKeyNames= "MemoID" InsertRowStyle-BackColor= "Azure" AutoGenerateRows...
    Posted to Data Access and ObjectDataSource Control (Forum) by punkbd on 01-03-2007, 12:00 AM
    Filed under: objectdatasource, ObjectDataSource DataSet Multitable, OnInsert, sql, ADO.NET, BLL, DAL, DataGrid GridView Paging, DetailsView

  • Using ObjectDataSource to run stored procedure with data input by user into web controls

    I am attempting to have a form where the user inputs data, it verifies the data, and then posts the data into a SQL database using a stored procedure and the INSERT command. I need some assistance in using the ObjectDataSource control combined with a submit button correctly. What do I specifically have...
    Posted to Data Access and ObjectDataSource Control (Forum) by JPortnoy on 12-15-2006, 12:00 AM
    Filed under: objectdatasource, sql, DAL

  • Strongly Typed DAL and Filtered Searching

    Hey All, I have built a Strongly Typed DAL for a system I am working on and I am trying to add filtered searching to it. Example: Before I put the Strongly Typed dataset in place I had a class file that made all the calls to the database/stored procedures. To accomplish this I simply added to the SQL...
    Posted to Data Access and ObjectDataSource Control (Forum) by Matthews on 10-24-2006, 12:00 AM
    Filed under: sql, TableAdapter, TableAdapters, DAL, Data Access, Database, Help

  • Trouble Understand the BLL

    Hi All, I am quite new to ASP.NET. I am using VWD and I have been spending a lot of time watching the videos on asp.net/learn ... I am really getting into understanding how the data access works with the DAL, and have made a couple practice sites on my own with a remote SQL DB, a DAL using the .XSD method...
    Posted to Getting Started (Forum) by zyman10 on 09-17-2009, 12:00 AM
    Filed under: DAL, SQL, data handling, data layer methods, data access, BLL, business layer, Data Access Layer

  • Data Access Layers and App Data database information question

    I have two questions that I know are very beginner. First question has to do with my data source. I am using an SQL Express server hosted on a different machine and it is listed in my server explorer just fine. It is listed as my connection string in my web.config just fine as well and lastly it seems...
    Posted to Data Access and ObjectDataSource Control (Forum) by shawn.bordeaux on 01-02-2010, 12:00 AM
    Filed under: vb.net, DAL, SQL, datasource, table adapters, as.net
Page 1 of 1 (9 items)

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