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
  • How to add columns in datatable already containing records

    Hi , I want to change schema of a DataTable which already contains some records. Basically I want to add one column Named "RowNo", Data type int and will contain value as Row Number in DataTable. Further I will do RowFilter on the basis of "RowNo" Column. Please provide appropriate...
    Posted to Data Access and ObjectDataSource Control (Forum) by jeetendra18 on 03-25-2008, 12:00 AM
    Filed under: 2.0, ADO, ADO.NET data access, ADO.NET LOCKING BLOCKING data access, ADO.NET Tutorial, asp 2.0, ASP 2.0 custom paging, asp .NET 2.0, ASP.NET, Asp.Net 2.0, Columns, Data, Data Access Layer, data set, data table, DataList, DataRow, DataTable, datatable full join, dataTable join, datatable tableadapter, DataTable To String Array, asp.net2.0, ASP .NET 2, ADO.NET data access, Filter, STOREd Procedures COMMAND ADO.NET ASP.NET, ADO.NET, DataColumn
  • Performance - Which way is faster to select a row in a DataTable?

    Assuming that we "know" that we will always receive a single row on a table select, is this faster? Private Sub MoveData() Dim ColumnName As String = "some value" Dim ColumnValue As String = "some value" Dim objRow As DataRow For Each objRow in MyTable.Rows objRow( "ColumnName"...
    Posted to Getting Started (Forum) by hismightiness on 05-25-2007, 12:00 AM
    Filed under: .Net 2.0, approach, asp.net 2.0, asp.net 2.0., Best Practice, data, data access, data handling, data manipulation, dataset, datatable, DataTable.Select Method, asp.net2.0
Page 1 of 1 (3 items)