Home ›
All Tags » database » dal (RSS)

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

  • 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

  • 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: Data, Help, DataAdapter Update, update, DAL, Data Access, Database, BLL, DataSet

  • 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: DataGrid GridView Paging, DAL, Data Access, Database, Session Variables, DataSet, DataTable

  • 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: Data, XML, parameter datatype, DataGrid GridView Paging, TableAdapter, TableAdapters, DAL, Data Access, Columns, Database, VB.Net, Table Adapter, DataSet, DropDownList, DataTable, ADO.NET, Gridview, objectdatasource, DataView SqlDataSource, object data source, Stored Procedures, DataAdapter, combining data sources

  • 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 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: BLL DAL Login Membership SQL Express, DAL, Data Access, Database, Table Adapter, BLL, DataTable, data set, DataAdapter, Any help on ADO.NET 2.0 MARS feature, Asp.Net 2.0, data Acces

  • 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: TableAdapter, TableAdapters, Select, ASP.NET, DataGrid GridView Paging, DataSet, SQL Server ADO.NET Transactions, ADO.NET, Performance : Stored Procedure with many params, Table Adapter, DAL, Data, data Acces, Data Access, Data Access connections, Paramter, outputparameter, data connections, data set, DataAdapter, Database, databind, Asp.Net 2.0, DataSource

  • 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, database object, database, dataobjects, data access layer

  • Re: Anyone IdiotsGuide-like Tutorial on Extending DataSets

    Kevin, Thank you so much for you reply. My reply to you comes way late. I completely missed your response and didn't mark it as accepted. I apologize for that. You have pointed mi in the right direction. Best regards. Jose Lopez
    Posted to Data Access and ObjectDataSource Control (Forum) by jrlopezp on 02-16-2007, 12:00 AM
    Filed under: ObjectDataSource DataSet reuse, ADO.NET Tutorial, TableAdapter, TableAdapters, DAL, Data Access, Database, Table Adapter, BLL, ADO.NET, objectdatasource, data set, object data source, Typed dataset, DataAdapter
Page 1 of 2 (11 items) 1 2 Next >

Advertise on ASP.NET

About this Site