Browse by Tags

Related Posts

  • Table Adapter Insert Problem

    Hi Guys I am hoping someone kind person would help me out here, I a have just starting using tableAdapters but I am not quite confident just yet, although I have come a long way in the last few days and " Nights ", the problem I have is very simple I am sure, but I cannot solve it for the life...
    Posted to Data Access and ObjectDataSource Control (Forum) by Web Design Devon on 06-13-2009, 12:00 AM
    Filed under: Data, TableAdapter, TableAdapters, Table Adapter, DataSet, DataSet Access Parameter C#.NET 2.0, DataAdapter, Insert, Data Access Layer, DataAdapter DataTable SQL Server, DataRow, tableadapter dataset datatable, datatable.rows, dataadapter.fill(), insert datatable, database add records, Insert data, tableadapter passing parameter, data accesss layer, Insert Data Values into SQL Database
  • Binding data to objects in a form

    Hello all, I'm working on what should be a simple web application in C#.NET and I'm having some noobie trouble with data. I basic need is to populate a hidden text box with data from a database (called availableDownloads) and depending on whether a cookie exists or not, the value in the availableDownloads...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Deucallion on 10-13-2008, 12:00 AM
    Filed under: asp .NET 2.0, attach database on the fly, c#, C# SQL, Data, data access, data access insert mssql, Data set, Database, DataBind, Databinding, dataset, datasource, ASP .NET 2
  • Need help with SQL Statement (combined SELECT and WHERE at same time)

    I am building a file repository page. For data source I use SQLDataSource and Repeater to display the categories. I am trying to achieve the result of displaying the following data: List of all "Main Categories" and all "Sub Categories" under each main category name. Also, "Total...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by alex3003 on 10-29-2007, 12:00 AM
    Filed under: object data source, objectdatasource, ObjectDataSource "rows returned", SqlCommand CommandBuilder, sqldataSource, Access DataSource in code-behind, ADO, ADO.NET, ADO.NET data access, ADO.NET data access, Data, data access, dataset, DataView SqlDataSource, asp .NET 2 datatable tableadapter, SQL Server ADO.NET Transactions
  • Update Database structure after Strongly-Typed DataSet is built

    This is my first 3 tier application... I'm using a Stongly Typed Dataset as DAL. After everything was finished, I realized I had to make 2 changes to the database: 1- Add a new column 2- Change a SQL Data type from int to Bool What is the best way to update my Strongly Typed Dataset and make sure...
    Posted to Data Access and ObjectDataSource Control (Forum) by cunharubens on 06-09-2007, 12:00 AM
    Filed under: newbie, OOP, Visual Studio 2005, beginner, Best Practice, C#, DAL, data, dataset, DataSet DataTable TableAdapters, DataTable.Select Method, help me, xsd, Newbbie, SQL, sql express, 3-tier architecture
  • Performance - Which way is faster to select a row in a DataTable?

    Assuming that we "know" that we will always receive a single row on a table select, is this faster? Private Sub MoveData() Dim ColumnName As String = "some value" Dim ColumnValue As String = "some value" Dim objRow As DataRow For Each objRow in MyTable.Rows objRow( "ColumnName"...
    Posted to Getting Started (Forum) by hismightiness on 05-25-2007, 12:00 AM
    Filed under: .Net 2.0, approach, asp.net 2.0, asp.net 2.0., Best Practice, data, data access, data handling, data manipulation, dataset, datatable, DataTable.Select Method, asp.net2.0
  • 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
  • Updating a Dataset with Seperate Stored Procedures / datatables

    Hi I have a SQL server table that I need to update. The data with which I will update it comes from two different sources, both sources contain an identifier column that can be used to identify one record that could have data from both sources. My plan therefore is to: Create a dataset called dstmain...
    Posted to Data Access and ObjectDataSource Control (Forum) by adammillsy on 04-27-2007, 12:00 AM
    Filed under: VB.Net, Data, data Acces, data set, DataSet, DataTable, Merge
  • 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
  • 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
  • Datagrid / Repeater with .JPG or .SWF File

    I have a repeater control, in which I have to show two types of illustrations(images). One with extension .JPG and other with extension .SWF (flash file) I am using custom built classes and binding to the repeater. I wanted to know what ASP.net server control should i bind it to inside the repeater,...
    Posted to Getting Started (Forum) by mayuresh_s on 03-01-2007, 12:00 AM
    Filed under: "asp.net 1.1", repeater user control panels visible, .NET 1.1, .Net 2.0, ASP.ne, ASP.Neet 2.0, asp.net 2.0, C#, DAL, data, data handling, datagrid, dataset, asp 2.0, .cs
Page 1 of 3 (23 items) 1 2 3 Next >