Home ›
All Tags » database » dal (RSS)

Browse by Tags

Related Posts

  • Generic DAL, Multiple tables with same fields ?

    Dear sir,,, I would like to thank you all here for the great site & info ,,, I got the idea about DAL,BLL and BO from "The Beer house" project , I have done a lot of classes for different tables, but now I have to deal with database as it without any changing .. The database contains about...
    Posted to Architecture (Forum) by kh.asp on 01-29-2008, 12:00 AM
    Filed under: bll, dal, data access layer, database, dataobjects, database object

  • 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

  • Rows as Colums

    I know this is possible in DB2 and Oracle, but what about for SQL-server 2005 1) select X number of rows from table1 2) I need colums for each row of table1 in a new table 3) As such, Select (select * from X where x.id = @ID), a,b,c from table Y where y.Id = @ID And I dont want to use IfExists. Thanks...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by DkUltra on 05-08-2007, 12:00 AM
    Filed under: outer join, sql 2005, Sql 2005 .NET, SQL 2005 ASP.NET, SQL 2005 ASP.NET Navision aspx.vb, SQL datatable, sql datatable stored procedure creation script, SQL datatable synchronize, SQL Programming, sql Query, SQL Server 2005, ASP.NET, ASP.NET 2.0 Data Binding SQL Server 2005 XML, dal, Database, Dynamic Table Creation/Modification, database options, .NET SQL Server 2005

  • How to pass null value to a function in business logical layer?

    Hi Guys, I meet a problem. I need pass null value to a funtion in business logical layer. Public Function JobSearch(ByVal sSkill As String, ByVal iCountryID As Nullable(Of Integer), ByVal iStateId As Nullable(Of Integer)) As JobPostingsDataTable Return Adapter.GetDataSearchForJobs(sSkill, iCountryID...
    Posted to Data Access and ObjectDataSource Control (Forum) by redmaple on 04-01-2007, 12:00 AM
    Filed under: Table Adapter, Asp.Net 2.0, BLL DAL Login Membership SQL Express, DAL, data Acces, Data Access, data set, DataAdapter, Database, DataTable, Any help on ADO.NET 2.0 MARS feature, BLL

  • ISNULL statements replaced when DataTable is reconfigured

    Hi, I've got the following problem: I have in my XSD document a TableAdapter with several queries in it. One of them is a query in which I replace null-values by another value (like: ISNULL(field_name,'value') AS field_name). All is well to this point, but when I reconfigure the 'standard' GetData()...
    Posted to Data Access and ObjectDataSource Control (Forum) by tim_ster on 03-23-2007, 12:00 AM
    Filed under: TableAdapter, DAL, Data Access, Database, xsd

  • How to retrieve data as XML from SQL database

    Hi, I have a website which is designed to search for employee information. I have the search system working which does exactly what I want to, but as an added feature I want there to be a button which, when someone clicks on it, it takes whatever the previous search was and generates a set of data in...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by tomosap on 02-28-2007, 12:00 AM
    Filed under: object data source, objectdatasource, parameter datatype, Stored Procedures, Table Adapter, TableAdapter, TableAdapters, VB.Net, ADO.NET, Columns, combining data sources, DAL, Data, Data Access, DataAdapter, Database, DataGrid GridView Paging, DataSet, DataTable, DataView SqlDataSource, DropDownList, XML, Gridview

  • Adding (appending) a new row of data using TableAdapter

    Hi, I am having a few problems that I can't seem to find an answer to and any help you can provide would be greatly appreciated. Problem 1: I have a webform (page1) with a listbox where a user can select up to 5 selections. I need those selections to be available for use on page 2 where the method below...
    Posted to Data Access and ObjectDataSource Control (Forum) by sillyrabbit on 12-22-2006, 12:00 AM
    Filed under: Session Variables, DAL, Data Access, Database, DataGrid GridView Paging, DataSet, DataTable

  • Mass insert / update External data into Internal SQL Database

    Hola! I'm currently building a site that uses an external database to store all the product details, and an internal database that will act as a cache so that we don't have to keep hitting the external database to retrieve the products every time a customer requests a list. What I need to do is retrieve...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by blackred on 11-15-2006, 12:00 AM
    Filed under: update, DAL, Data, Data Access, DataAdapter Update, Database, DataSet, BLL, Help

  • Preset radiobuttonlist with defualt value read from database

    Hi there, this is the situation: I have a table that contains a bit field called "IsAllowed". It is either set to "False" or "True" or "NULL". Next, I have a gridview control that is bound to this table (actually it is more complicated, but for the sake of simplicity...
    Posted to Data Access and ObjectDataSource Control (Forum) by Balthazaar on 10-27-2006, 12:00 AM
    Filed under: DAL, Data Access, Database

  • 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
Page 1 of 2 (13 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.