Browse by Tags

Related Posts

  • 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 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
  • 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
  • Dataset showing inconsistent results

    This is a tricky one. I created a dataset using the designer, to produce a data table for use in a report. The query selects a student's name and other details based on a parameter, their student ID. I tested the results in the designer, using one student's ID. Everything worked fine. However, later...
    Posted to Data Access and ObjectDataSource Control (Forum) by wibblet on 02-22-2007, 12:00 AM
    Filed under: asp.net 2.0, output, data layer methods, database, DataTable.Select Method, Query string, dataset, data access, C#, data, asp.net.c#, newbie
  • 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
  • Datatable adaptor not returning complete set of results

    This is so frustrating. I have a dataset, which I created using the designer. It has a reasonably complex query which pulls data from several tables in my database. I use it to create a report. The daft thing is is was working fine till yesterday at which point I am suddenly not getting all the records...
    Posted to Data Access and ObjectDataSource Control (Forum) by wibblet on 03-01-2007, 12:00 AM
    Filed under: database connection, Caching, asp.net 2.0, database, dataset, Dataset database connection DataAdapter Dbconnection, data access, Connection Strings, data, asp.net.c#
  • 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
  • Trouble with DataSet

    Hi, I developed a VB.Net WebForm, I read from an Oracle DataBase and get all the data into a DataSet. After the user works with it I save the Data into the Database again. The issue is that sometimes it fails. It seems like sometimes when the page is reloaded (ie: clicking on a server component) the...
    Posted to Data Access and ObjectDataSource Control (Forum) by Roi_Babel on 03-30-2007, 12:00 AM
    Filed under: Database, VB.Net, DataSet, ADO.NET, data set, Asp.Net 2.0, ASP.NET
  • 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 3 (22 items) 1 2 3 Next >