Browse by Tags

Related Posts

  • Re: How to join more than two DataTables into one DataTable?

    Thank you again Lolli. Do you mean Add Query... ? If I will add query to the DesignationTableAdapter ... this warning... will prompt. If I will make that query... [quote user="Lolli"] SELECT Employees.EmployeeID, Employees.EmployeeName, Branches.BranchID, Branches.BranchName FROM Employees...
    Posted to Data Access and ObjectDataSource Control (Forum) by van.net on 11-05-2008, 12:00 AM
    Filed under: Typed dataset, VB.Net, .net 2.0, Data Access, DataAdapter, DataColumn, DataReader, DataRelation, DataRow, DataSet, DataTable, XML Schema Definition, VB.NET 2005
  • How to join more than two DataTables into one DataTable?

    Hi, I am using .NET 2.0 and new in developing a web application. This is the first time I use Typed DataSet or XML Schema Definition in accessing data. The three DataTable s that I want to join into one DataTable : Employees EmployeeID EmployeeName 1 Steve Nash 2 Jason Kidd 3 Kobe Bryant 4 Tony Parker...
    Posted to Data Access and ObjectDataSource Control (Forum) by van.net on 11-05-2008, 12:00 AM
    Filed under: Typed dataset, VB.Net, .net 2.0, Data Access, DataAdapter, DataColumn, DataReader, DataRelation, DataRow, DataSet, DataTable, XML Schema Definition, VB.NET 2005
  • How to join more than 2 DataTables into a single DataTable?

    Hi, I am using .NET 2.0 and new in developing a web application. This is the first time I use Typed DataSet or XML Schema Definition in accessing data. The three DataTable s that I want to join into one DataTable : Employees EmployeeID EmployeeName 1 Steve Nash 2 Jason Kidd 3 Kobe Bryant 4 Tony Parker...
    Posted to Data Access and ObjectDataSource Control (Forum) by van.net on 11-05-2008, 12:00 AM
    Filed under: Typed dataset, VB.Net, .net 2.0, Data Access, DataAdapter, DataColumn, DataReader, DataRelation, DataRow, DataSet, DataTable, XML Schema Definition, VB.NET 2005
  • Re: Return a DataReader - Is this good practice?

    [quote user="ElCapitan"]...Yeh I understand that this is a good way of doing things too but not without its drawbacks. Many hits to a page that constantly calls a couple of hundred 'rows' of business objects will be much heavier on the application surely because all the data is 'in...
    Posted to Architecture (Forum) by SergeyS on 03-24-2008, 12:00 AM
    Filed under: scalability, SQL Server 2005, 3-Layer Architecture, 3tier, 3-Tier Architecture, 3-tier programming, asp .NET 2.0, Basic Architecture Design, Best Practices, bll, Buisness layer, business logic layer, Connection pooling, dal, data access layer, datalogic layer, dataobjects, Dataset, dataset datareader 3-tier mvc, datatable, database object, asp.net2.0, ASP.NET Architecture, sql server, Typed DataSet tableadapter, arcitecture, asp.net 2.0 sql server, datareader, load balancing, Patterns & Practices, N-Tier, Asp.Net 2.0
  • Re: Return a DataReader - Is this good practice?

    [quote user="ElCapitan"]...The function in the DAL is called by the BLL and the DAL opens a connection, and the command does an ExecuteReader. I understand that it is a good option for retrieving data. Surely though if the dr is returned to the BLL, the connection is still open...[/quote] It's...
    Posted to Architecture (Forum) by SergeyS on 03-22-2008, 12:00 AM
    Filed under: scalability, SQL Server 2005, 3-Layer Architecture, 3tier, 3-Tier Architecture, 3-tier programming, architecture, asp .NET 2.0, Basic Architecture Design, Best Practices, bll, Buisness layer, business logic layer, dal, data access layer, datalogic layer, dataobjects, Dataset, dataset datareader 3-tier mvc, datatable, database driven, database object, asp.net2.0, ASP.NET Architecture, Typed DataSet tableadapter, "system Design", arcitecture, asp.net 2.0 sql server, datareader, N-Tier, Asp.Net 2.0
  • Cannot find column [tblSpotID]. System.Data.EvaluateException

    Hi all, I have been reading in foruns but there is any problem when I try to put a row filter and I can not find it, the code is: connPargroup = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString); connPargroup.Open(); SqlCommand cmdPargroup = new...
    Posted to Data Access and ObjectDataSource Control (Forum) by cmspinto on 11-19-2007, 12:00 AM
    Filed under: ADO, ADO.NET data access, DataReader, DataSet, DataSets, DataTable, ADO.NET data access
  • How to copy data from one excel file to other excel file

    Hi I have two excel file (Ex1 and Ex2), both have same template (headers) and data will be populated from the dataset. Upto this step its works fine. My question : How to copy the data form 6th row to last row of "Ex2" and paste it into the "Ex1" after the last row in Ex1. Advance...
    Posted to Enterprise Services Integration (Forum) by SudhaYogesh on 09-12-2007, 12:00 AM
    Filed under: postback variables, querystring, selection, sql, sqldatabase, t code behind, update, VB.Net, ado.net, asp, ASP.NET, Asp.Net 1.1, Asp.Net 2.0, Asp.Net 2.0 and MS SQL Server 2005, asp.net 2.0 asp.net, asp.net 2.0 export to excel, Asp.Net 2.0 session, ASP.net 2.0 Tutorials, ASP.NET Sites, ASP.NET.NET 2.0, c#, C# code, database, datareader, dataset, datasource, excel, GridView field, Asp.NET2.0, grid view, reports, DotNet, Find Control
  • Updating/Insert with Dataset or Queries

    Hi, Ive got a class in my code which contains data from several tables. A user profile has a single record in a user_profile tables, for each of these records there is several records in a another table, which itself has several records in a tags table. So far the save method on the class saves the record...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by staplebottom on 06-01-2007, 12:00 AM
    Filed under: Database, datareader, dataset
  • ADO.net FAQ collection

    What is ADO.net ADO.net is data access architecture for the Microsoft .NET Framework. <!--[if !supportEmptyParas]--> <!--[endif]--> Difference between ADO and ADO.net ADO used connected data usage, while ADO.net used disconnected data environment. ADO used OLE DB to access data and is COM...
    Posted to Tips & Tricks (Forum) by dotnetguts on 04-18-2007, 12:00 AM
    Filed under: ado.net, dataset, dotnetguts, ado.net faq, datareader
  • Anyone IdiotsGuide-like Tutorial on Extending DataSets

    This may sound very simple to some who do this on a daily basis but I am starting at a low to mid-range level. I have found a good article on building a DAL with Typed Data Sets by Brian Noyes at http://www.theserverside.net/tt/articles/showarticle.tss?id=DataSetDesigner where he goes a little in how...
    Posted to Data Access and ObjectDataSource Control (Forum) by jrlopezp on 01-26-2007, 12:00 AM
    Filed under: Table Adapter, TableAdapter, TableAdapters, Typed dataset, ADO.NET, DAL, Data Access, data set, DataAdapter Update, DataReader, DataSet, DataTable
Page 1 of 2 (16 items) 1 2 Next >