Browse by Tags

Related Posts

  • Re: Accessing a cell value for a record

    Hi David, Thanks for responding. You actually clarified a lot for me and I think I'm on the right path. For clarification sake, here is what I am doing: 1. Populating a table adapter by a stored procedure with 5 session parameters. 2. Displaying a gridview based on the table adapter 3. **this is where...
    Posted to Data Access and ObjectDataSource Control (Forum) by sh0ck on 12-07-2006, 12:00 AM
    Filed under: TableAdapter, TableAdapters, Database, VB.Net, Table Adapter, DataTable
  • 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 do I get the dataset from an ObjectDataSource?

    I have a business logic class tied to my ObjectDataSource control. The ObjectDataSource is tied to my AccordionControl. I want to give the user the ability to reorder the panels dynamically by pressing an up or down button. I want to avoid a database update penalty, which would slow down the user interface...
    Posted to Data Access and ObjectDataSource Control (Forum) by Mark Barnes on 12-29-2006, 12:00 AM
    Filed under: ObjectDataSource DataSet reuse, Database, DataSet, DataTable, ADO.NET
  • How To Loop Through Datatable

    Im trying to loop through the rows of my DataTable but keeping getting an error... Ive already set the datatable and rows with Dim rowRunData As System.Data.DataRow Dim ProjectData = New System.Data.DataTable() And Ive put the various data in the datatable.... so my code for looping I thought would be...
    Posted to Data Access and ObjectDataSource Control (Forum) by boomers on 01-03-2007, 12:00 AM
    Filed under: Database, DataTable, ADO.NET, looping
  • Omitting columns from Stored Procedures, DAL, BLL and PL

    I have been trying to do this with no luck. I get an 'Exception has been thrown by the target of the invocation.' error after the End Get here. Private ReadOnly Property Adapter() As System.Data.SqlClient.SqlDataAdapter Get If ( Me ._adapter Is Nothing ) Then Me .InitAdapter End If Return Me ._adapter...
    Posted to Getting Started (Forum) by mtsonic on 01-08-2007, 12:00 AM
    Filed under: database design, data handling, data mapping, datatable, database
  • Data Access Layer in ASP.NET 2.0

    I am very confused as to what i should be using as Data Access Layer. We have so many things to choose from - DAAB (Data Access application block). -We can use table adapter and can create strongly typed datasets (dataset.xsd) files to access data. -Then we have IBATIS and Hibernate. - we can have custom...
    Posted to Data Access and ObjectDataSource Control (Forum) by nav_nav2000 on 01-17-2007, 12:00 AM
    Filed under: Data, Database, DataSet, DataTable, ADO.NET, Data Access Application block
  • 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
  • DataSet or Business Objects (IS ORM a better solution?)

    Hello guys, I am in doubt what solution is the best for a case that we have in hand. We have to develop a web application (ASP.NET 2 with loads of reports which I think we will use SSRS) and on this particular project there are about 100 tables involved. As you know we can add a DataSet for each table...
    Posted to Data Access and ObjectDataSource Control (Forum) by Mehdi6002 on 03-07-2007, 12:00 AM
    Filed under: Data, sql, Data Access, Database, DataSet, DataTable, data set, Data Set Binding, DataAdapter, Business Object, ORM
  • 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
  • Saving listbox data - best approach?

    We have an ASP.NET 2.0 site that uses SQL Server 2000/2005. I am working on a page that updates our user table. But it will also update multiple related tables. For example, the user could be a member of several different companies and/or organizations and may have 1 to many roles out of a list of available...
    Posted to Data Access and ObjectDataSource Control (Forum) by nickpup on 04-19-2007, 12:00 AM
    Filed under: Data, ObjectDataSource DataSet Multitable, sql, Data Access, Database, VB.Net, DataSet, SQL Server ADO.NET Transactions, DataTable, ADO.NET, design, DataView SqlDataSource, passing object, data set, object data source, SQL Performance, Stored Procedures, DataAdapter, Business Object, databind, ASP.NET
Page 1 of 2 (17 items) 1 2 Next >