Home ›
All Tags » sql » datatable (RSS)

Browse by Tags

Related Posts

  • How can i create a sql function in a class?

    i've created this in a class: 1 public class TransClass 2 { 3 public static DataTable GetData() { 4 DataTable Library = new DataTable( "Library" ); 5 6 Library.Columns.Add( "ID" , typeof ( int )); 7 Library.Columns.Add( "NL" , typeof (String)); 8 Library.Columns.Add( "FR" , typeof (String)); 9 Library...
    Posted to Data Access and ObjectDataSource Control (Forum) by roxxe on 02-19-2007, 12:00 AM
    Filed under: sql, TableAdapter, DataTable, 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

  • 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

  • DataSet (xsd) Creating a DataTable

    We are trying to grab data from a System i (or iSeries or AS/400) using a DataSet. We have this working and can grab everything from the table. The end result is we want to output a Report (from Visual Studio 2005). The problem is Visual Studio doesn't like my SQL statement: select vcmplntnum, vvltnnum...
    Posted to Data Access and ObjectDataSource Control (Forum) by Koldark on 07-09-2007, 12:00 AM
    Filed under: sql, TableAdapter, DataSet, DataTable, AS/400, Report, iseries, system i

  • SQL JOIN between DataTables in a DataSet

    Hello, Am I correct in thinking that it is currently not possible to perform an SQL JOIN across multiple DataTables in a DataSet in .NET? I have a typed DataSet with three relational tables which need to be placed into one flat table, e.g.: Table A : PK, Table A Col 1, Table A Col 2... Table B : PK,...
    Posted to Data Access and ObjectDataSource Control (Forum) by WolfyUK on 07-12-2007, 12:00 AM
    Filed under: sql, DataSet, DataTable

  • How do obtain Primary Key value from one table aid insert it into another table?

    Hi I have one table called User profile and another table called User Reviews, basically I want to write a query or stored procedure( I don’t know what is best) so that when a registered writes a review, their Id in the User_Profile table is inserted into the User_Review Table in the User_Id field. This...
    Posted to Data Access and ObjectDataSource Control (Forum) by odxsigma on 12-10-2007, 12:00 AM
    Filed under: SQL, datatable, Data acces, primary key

  • Re: Between sql2005 db, tableAdapters, BLL and Codehinds, How do display data related error messages?

    This is the code for the method in question: 1 [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, false )] 2 public MarketingContacts.OwnershipDataTable GetOwnershipByContactIdAndStaffDivId( int ContactId, int StaffDivId) 3 { 4 return GetOwnershipByContactIdAndStaffDivId...
    Posted to Data Access and ObjectDataSource Control (Forum) by akuyali on 04-18-2008, 12:00 AM
    Filed under: SQL ASP OBJECTDATASOURCE, DataAdapter Update, ObjectDataSource DataSet Multitable, sql, BLL, DataTable, C#, DataAdapter, Insert, DataSource, BLL DAL Tier Separation, ADO.NET data access, strongly typed datatable, insert datatable
Page 1 of 1 (7 items)

Advertise on ASP.NET

About this Site