Browse by Tags

Related Posts

  • 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: Help, sql, TableAdapter, TableAdapters, DAL, Data Access, Database
  • 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: sql, DAL, objectdatasource
  • 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: OnInsert, ObjectDataSource DataSet Multitable, sql, DataGrid GridView Paging, DAL, DetailsView, BLL, ADO.NET, objectdatasource
  • 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: Data, sql, ADO.NET Tutorial, DAL, SQL Server ADO.NET Transactions, ADO.NET, SQL Performance, SQL Security, Stored Procedures
  • 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: DAL, SQL, 3-tier architecture, Newbbie, DataTable.Select Method, dataset, Visual Studio 2005, Best Practice, C#, data, help me, newbie, beginner, OOP, xsd, DataSet DataTable TableAdapters, sql express
  • 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: sql, DAL, Table Adapter, DataSet, Gridview, objectdatasource, data set, object data source, DataAdapter, Business Object, Gridview - dataset, datatable tableadapter, Gridview DataGrid, Empty
Page 1 of 1 (6 items)