Home ›
All Tags » database » ado.net (RSS)

Browse by Tags

Related Posts

  • How do I get the dataset from an ObjectDataSource?

    I have a business logic class tied to my ObjectDataSource control. The ObjectDataSource is tied to my AccordionControl. I want to give the user the ability to reorder the panels dynamically by pressing an up or down button. I want to avoid a database update penalty, which would slow down the user interface...
    Posted to Data Access and ObjectDataSource Control (Forum) by Mark Barnes on 12-29-2006, 12:00 AM
    Filed under: ObjectDataSource DataSet reuse, Database, DataSet, DataTable, ADO.NET

  • How To Loop Through Datatable

    Im trying to loop through the rows of my DataTable but keeping getting an error... Ive already set the datatable and rows with Dim rowRunData As System.Data.DataRow Dim ProjectData = New System.Data.DataTable() And Ive put the various data in the datatable.... so my code for looping I thought would be...
    Posted to Data Access and ObjectDataSource Control (Forum) by boomers on 01-03-2007, 12:00 AM
    Filed under: Database, DataTable, ADO.NET, looping

  • Data Access Layer in ASP.NET 2.0

    I am very confused as to what i should be using as Data Access Layer. We have so many things to choose from - DAAB (Data Access application block). -We can use table adapter and can create strongly typed datasets (dataset.xsd) files to access data. -Then we have IBATIS and Hibernate. - we can have custom...
    Posted to Data Access and ObjectDataSource Control (Forum) by nav_nav2000 on 01-17-2007, 12:00 AM
    Filed under: Data, Database, DataSet, DataTable, ADO.NET, Data Access Application block

  • Retreving DataRow from the TextBoxes DataBinded

    I connect my TextBoxes to the dataRow by the following code TextBox1.Text = DataRow1.Item("ColumnName") TextBox1.DataBind() I have a set of TextBoxes databinded to the dataRow, Now I need to retrieve the DataRow which is connected to the TextBoxes. how can I get the DataRow. Thanks
    Posted to Data Presentation Controls (Forum) by bobbynad on 02-03-2007, 12:00 AM
    Filed under: database, Controls, asp.net 2.0, Bindable Property, databinding, data, databind, Bind, databinder, ADO.NET

  • Performance tips for Database access

    1.Use Stored Procedures whenever possible stored procedures are highly optimized tools that result in excellent performance when used effectively. 2.Use the Optimal Managed Provider Make the correct choice of managed provider, rather than relying on a generic accessor. 3. Pick Data Reader over Data Set...
    Posted to Tips & Tricks (Forum) by swap on 02-09-2007, 12:00 AM
    Filed under: SQL, ADO.Net, Performance, Access, Database

  • Data Data :|

    Ok, i have a very simple access database called score with just one table called high. This is just going to be used to keep the current score of a higher scorer and there name However, when the page loads i want the user to see this current high score and the persons name, but just one record i only...
    Posted to Data Access and ObjectDataSource Control (Forum) by tomehb on 02-15-2007, 12:00 AM
    Filed under: Data, Data Access, Database, ADO.NET

  • Optimizing connection pooling

    Hi, I'm trying to optimize an ASP.NET 2.0 app where, with a load of 100 users, the CPU usage on the web server is a reasonable <20% but the db server (SQL Server 2005) often goes up to 100% and never below 20%. When viewing the Performance Monitor counter SQL Server :General Statistics/User Connections...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by fimatronn on 02-16-2007, 12:00 AM
    Filed under: SQL Server 2005, ASP.NET, Connnection String, Microsoft SQL Server 2005, Connection String, .NET SQL Server 2005, SQL, Database, SQL 2005 ASP.NET, ADO.NET, SQL connection ControlParameter SelectParameters GridView, 2.0

  • problem with retrieving/displaying data based on form input

    Hi, I've developed a form which accesses a database through a data layer and sends parameters based on the form input. I have written the following code which works by checking if the textbox is empty and passing a null value as a string to the search parameter in the query, of which there are five:...
    Posted to Data Presentation Controls (Forum) by tomosap on 02-22-2007, 12:00 AM
    Filed under: GridView, problem, string, database, sqldatasource, label, datasource, rows, records, If Statement, Null, GridView asp.net, data access layer, table adapter, databinding, data, ASP.net 2.0 GridView InsertParameters ControlParameter PropertyName, Updateparameters, sql, search, VB, textbox, method, parameter, querystring, ADO.NET, access database, FORM, SELECT

  • setting label to visible with button click

    Hi, I'm having some problems with using a label to display a message "No Records Found" when the user clicks a Search button. What I want it to do is to check if there are any results from a database that get displayed on a GridView. I have the following method so far: ------------------------------...
    Posted to Data Presentation Controls (Forum) by tomosap on 02-27-2007, 12:00 AM
    Filed under: GridView, postback, Client, database, paging, DropDownList, asp.net 2.0, label, rows, records, If Statement, Visible, data access layer, table adapter, databinding, codebehind, data, databind, VB, textbox, ADO.NET, access database, asp.net 2.0 GridView databound ItemTemplate

  • 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
Page 1 of 5 (42 items) 1 2 3 4 5 Next >

Advertise on ASP.NET

About this Site