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

Browse by Tags

Related Posts

  • ANN: myLittleBackup for SQL Server, Backup/Restore solution for Shared SQL Server Hosting

    myLittleBackup for SQL Server 2000 and 2005 is the first Backup/Restore solution specially designed for shared SQL Server hosting. With myLittleBackup, shared SQL Server hosting companies will be able to give their customers an easy and secure solution to backup/restore their databases. It is really...
    Posted to Announcements (Forum) by myLittleTools.net on 12-14-2006, 12:00 AM
    Filed under: ASP.NET 2.0, sqlserver, tools, ADO.NET, .NET 2.0, .NET, sql, restore, hosting, user mapping, backup, web hosting, c#

  • Data inserting twice

    Is anyone aware of a bug or am I doing something wrong or blind .... that I am getting two records inserted in db? < asp:DetailsView ID= "DetailsViewInsert" runat= "server" Height= "50px" Width= "100%" DataSourceID= "ObjectDataSource1" DataKeyNames= "MemoID" InsertRowStyle-BackColor= "Azure" AutoGenerateRows...
    Posted to Data Access and ObjectDataSource Control (Forum) by punkbd on 01-03-2007, 12:00 AM
    Filed under: OnInsert, ObjectDataSource DataSet Multitable, sql, DataGrid GridView Paging, DAL, DetailsView, BLL, ADO.NET, objectdatasource

  • Re: Stored Procedures, Data Set and Data Table Adapters

    Swaino, If this helps you at all. When you use stored procedures you can benefit in several ways, including security and performance or making processes that require procedural action callable. Security because, for example, you may have a user that has read-only access to a table BUT, through a stored...
    Posted to Data Access and ObjectDataSource Control (Forum) by jrlopezp on 01-26-2007, 12:00 AM
    Filed under: Data, sql, ADO.NET Tutorial, DAL, SQL Server ADO.NET Transactions, ADO.NET, SQL Performance, SQL Security, Stored Procedures

  • 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

  • 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

  • Use xml to populate table in SQL 2005

    I have an asp.net form that has a checkboxlist control. I have a table that I want to populate more than one value from this checkboxlist. How can I use xml to populate this table? Anyone know of any good online tutorials that cover this topic? Regards, ~mike~
    Posted to Data Access and ObjectDataSource Control (Forum) by mhestness on 02-28-2007, 12:00 AM
    Filed under: XML, sql, SQL Server ADO.NET Transactions, ADO.NET

  • Unable to run complex SQL in DataList Data Source Config?

    Hi guys, I've written a SQL query that allows me to do paging (10 records per page view or as required), which I want to control using query strings. I've tested this in the SQL Server Management Studio and it seems to be working great. Just when I go into my DataList control's data source config and...
    Posted to Data Presentation Controls (Forum) by ziggy_911 on 03-05-2007, 12:00 AM
    Filed under: Datalist, paging custom control, paging, sqldatasource, datalist paging database, datasource, T-SQL, SQL Datasource TransactSQL JOIN SELECT, sql, SQL Datasets, ADO.NET, Pagination for Datalist, SELECT

  • How to maintain users permission and access level

    Hi guys, We have a scenario where there are about 50 tables in our database and we want to build an intranet web application for users to with the office to access those tables. Users ability to access tables falls into diferent category: Some users can NOT view some tables at all Some users can ONLY...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Mehdi6002 on 03-09-2007, 12:00 AM
    Filed under: SQL datatable, SQL Server 2005, ASP.NET, SQL Permissions, Microsoft SQL Server 2005, SQL, Database, SQL Server 2000, SQL 2005 ASP.NET, Roles, sql server database diagram asp.net, ADO.NET, sql 2000, sql 2000 "sql server express 2005", 2.0, sql 2005, SQL Server 2005 ADO.NET ASP.NET Large File, Membership, SqlCommand

  • Do I do dataset fill operations in a using or try block?

    Hi, I'm not used to using datacontainers, and I generally use a using statement for sql operations such as: using (conn = new SqlConnection(connString)) { //etc } What about if I'm using a dataset or data adapter. I put the connection in the constructor, but should this be inside a using block? Thanks...
    Posted to Data Access and ObjectDataSource Control (Forum) by btipling on 03-25-2007, 12:00 AM
    Filed under: sql, ADO.NET, DataAdapter, using
Page 1 of 3 (24 items) 1 2 3 Next >

Advertise on ASP.NET

About this Site