Browse by Tags

Related Posts

  • Re: tableAdapter Headaches. I need help

    It seems nobody wants to help. I am completely stuck and I need help. All I want is to be able to use my tableadapter and its insert method to insert data into my database ORDER table. my problem is using the tableadapter and my insert method to get the values of my textbox fields and dropdownlistbox...
    Posted to Data Access and ObjectDataSource Control (Forum) by derry1406 on 10-13-2006, 12:00 AM
    Filed under: sql, TableAdapter, TableAdapters, Database
  • Strongly Typed DAL and Filtered Searching

    Hey All, I have built a Strongly Typed DAL for a system I am working on and I am trying to add filtered searching to it. Example: Before I put the Strongly Typed dataset in place I had a class file that made all the calls to the database/stored procedures. To accomplish this I simply added to the SQL...
    Posted to Data Access and ObjectDataSource Control (Forum) by Matthews on 10-24-2006, 12:00 AM
    Filed under: Help, sql, TableAdapter, TableAdapters, DAL, Data Access, Database
  • 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
  • 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
  • ISNULL statements replaced when DataTable is reconfigured

    Hi, I've got the following problem: I have in my XSD document a TableAdapter with several queries in it. One of them is a query in which I replace null-values by another value (like: ISNULL(field_name,'value') AS field_name). All is well to this point, but when I reconfigure the 'standard' GetData()...
    Posted to Data Access and ObjectDataSource Control (Forum) by tim_ster on 03-23-2007, 12:00 AM
    Filed under: TableAdapter, DAL, Data Access, Database, xsd
  • 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: TableAdapter, TableAdapters, Select, ASP.NET, DataGrid GridView Paging, DataSet, SQL Server ADO.NET Transactions, ADO.NET, Performance : Stored Procedure with many params, Table Adapter, DAL, Data, data Acces, Data Access, Data Access connections, Paramter, outputparameter, data connections, data set, DataAdapter, Database, databind, Asp.Net 2.0, DataSource
  • ObjectDataSource could not find a non-generic method 'Update' that has parameters

    Hi, I've spent months trying to solve this problem, using a Formview to enter/modify data connected to a SQL Server backend via an ObjectSource TableAdapter. After having another go tonight (an intense 6hrs+) I saw a post from the developers to say that this problem with original_{0} would be resolved...
    Posted to Data Access and ObjectDataSource Control (Forum) by Tushar101 on 10-09-2007, 12:00 AM
    Filed under: TableAdapter, Database, object data source, DataAdapter, FormView, 3 tier applications, DataAdapter DataTable SQL Server
  • Re: Anyone IdiotsGuide-like Tutorial on Extending DataSets

    Kevin, Thank you so much for you reply. My reply to you comes way late. I completely missed your response and didn't mark it as accepted. I apologize for that. You have pointed mi in the right direction. Best regards. Jose Lopez
    Posted to Data Access and ObjectDataSource Control (Forum) by jrlopezp on 02-16-2007, 12:00 AM
    Filed under: ObjectDataSource DataSet reuse, ADO.NET Tutorial, TableAdapter, TableAdapters, DAL, Data Access, Database, Table Adapter, BLL, ADO.NET, objectdatasource, data set, object data source, Typed dataset, DataAdapter
  • A large number of Records

    how can I display alarge number of records , about 2 million records, in a data grid? how should I select my data? and how should I paging my dataset or datatable? Thanx;
    Posted to Data Access and ObjectDataSource Control (Forum) by amohammadi on 05-01-2007, 12:00 AM
    Filed under: Data, BLL DAL Login Membership SQL Express, DataAdapter Update, DataGrid GridView Paging, TableAdapter, TableAdapters, DAL, Data Access, DataTable.GetError, Database, Table Adapter, DataSet, DataColumn Expression, DataSet Access Parameter C#.NET 2.0, SQL Server ADO.NET Transactions, DataReader, DataTable, ADO.NET, ADO.NET LOCKING BLOCKING data access, DataView SqlDataSource, Data Access Application block, data set, Data Set Binding, ADODB MSDataShape Shaping ASP.NET C# Child Record Sets, DataAdapter, Any help on ADO.NET 2.0 MARS feature, Select, Gridview column visible, databind, STOREd Procedures COMMAND ADO.NET ASP.NET, GridViewiew, data Acces, database connection, SqlDataSource, Data Access connections, data connections
Page 1 of 1 (9 items)