Browse by Tags

Home ›

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: object data source, TableAdapter, 3 tier applications, DataAdapter, DataAdapter DataTable SQL Server, Database, FormView
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: outputparameter, Paramter, Performance : Stored Procedure with many params, Table Adapter, TableAdapter, TableAdapters, ADO.NET, ASP.NET, Asp.Net 2.0, DAL, Data, data Acces, Data Access, Data Access connections, data connections, data set, DataAdapter, Database, databind, DataGrid GridView Paging, DataSet, DataSource, Select, SQL Server ADO.NET Transactions
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: object data source, ObjectDataSource DataSet Multitable, passing object, sql, SQL Performance, Stored Procedures, VB.Net, ADO.NET, ASP.NET, Business Object, Data, Data Access, data set, DataAdapter, Database, databind, DataSet, DataTable, DataView SqlDataSource, design, SQL Server ADO.NET Transactions
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: Table Adapter, Asp.Net 2.0, BLL DAL Login Membership SQL Express, DAL, data Acces, Data Access, data set, DataAdapter, Database, DataTable, Any help on ADO.NET 2.0 MARS feature, BLL
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: ORM, sql, Business Object, Data, Data Access, data set, Data Set Binding, DataAdapter, Database, DataSet, 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: object data source, objectdatasource, parameter datatype, Stored Procedures, Table Adapter, TableAdapter, TableAdapters, VB.Net, ADO.NET, Columns, combining data sources, DAL, Data, Data Access, DataAdapter, Database, DataGrid GridView Paging, DataSet, DataTable, DataView SqlDataSource, DropDownList, XML, Gridview
Copying or Duplicating a Table from one Database to another using strongly typed datasets.

I have an MS SQL2005 database on one server that I want to transfer to another MS SQL2005 DB on another server. The new hosting company will not allow .bak files to be used, so I want to copy some of my large tables over to the new DB. I want to use a strongly typed Dataset to do this. Here is what I...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by egraffius on 09-09-2009, 12:00 AM
Filed under: Database, Dataset population problems, strongly type dataset, Strongly type dataset update delete, dataset, dataadapter, ADO.NET 2.0, datasets moving tables from one DB to Another Transfering Tables
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: object data source, objectdatasource, ObjectDataSource DataSet reuse, Table Adapter, TableAdapter, TableAdapters, Typed dataset, ADO.NET, ADO.NET Tutorial, BLL, DAL, Data Access, data set, DataAdapter, Database
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: SqlDataSource, STOREd Procedures COMMAND ADO.NET ASP.NET, Table Adapter, TableAdapter, TableAdapters, ADO.NET, ADO.NET LOCKING BLOCKING data access, ADODB MSDataShape Shaping ASP.NET C# Child Record Sets, BLL DAL Login Membership SQL Express, DAL, Data, data Acces, Data Access, Data Access Application block, Data Access connections, data connections, data set, Data Set Binding, DataAdapter, DataAdapter Update, Database, databind, DataColumn Expression, DataGrid GridView Paging, DataReader, DataSet, DataSet Access Parameter C#.NET 2.0, DataTable, DataTable.GetError, DataView SqlDataSource, Gridview column visible, GridViewiew, database connection, Select, Any help on ADO.NET 2.0 MARS feature, SQL Server ADO.NET Transactions

Page 1 of 1 (9 items)

Browse by Tags

Related Posts