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
  • 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
  • Deciding how may datasets...

    Hi, I'm developing a mid-size web application. My database contains 83 tables and I'm certainly sure it's not advisable to create only one dataset containing all the tables. What could the criteria for grouping tables and create the necessary datasets? Number of tables in each dataset? One dataset for...
    Posted to Data Access and ObjectDataSource Control (Forum) by luxur2007 on 04-08-2007, 12:00 AM
    Filed under: ADO.NET, Business Object, DAL, Data, data Acces
  • Reuse data from ObjectDataSource after postback (Persist Data)

    Hello, I'm new to this forum, fairly new to ASP.NET and I have a problem I that I can't figure out. I have a ajax enabled 3-teir application (Display, BLL, DAL). Almost all my pages connect to the database and return List(Of [Obj X]) through several ObjectDataSources that populate various drop downlist...
    Posted to Getting Started (Forum) by youngaj on 03-19-2007, 12:00 AM
    Filed under: UI, web application, web forms, 3-tier architecture, ajax, atlas, class, class design, DAL, data, data access, data layer methods, databinding, drop down list box, Listbox
  • 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
  • Re: importing flash .swf to aspx sites

    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
  • 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
  • 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
Page 1 of 2 (17 items) 1 2 Next >