Browse by Tags

Related Posts

  • 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
  • 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 (8 items)