Browse by Tags

Home ›

All Tags » database » ado.net » ASP.NET (RSS)

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
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
Trouble with DataSet

Hi, I developed a VB.Net WebForm, I read from an Oracle DataBase and get all the data into a DataSet. After the user works with it I save the Data into the Database again. The issue is that sometimes it fails. It seems like sometimes when the page is reloaded (ie: clicking on a server component) the...

Posted to Data Access and ObjectDataSource Control (Forum) by Roi_Babel on 03-30-2007, 12:00 AM
Filed under: Database, VB.Net, DataSet, ADO.NET, data set, Asp.Net 2.0, ASP.NET
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
retrieving images from database and displaying on Image control

Hi all i need a solution for displaying an image which must be retrieved from database table(photo displaying).I used the following code,but it shows error as "Invalid Parameter used" page_load() { cn.Open (); SqlCommand command = new SqlCommand ("select *from image1 ", cn); byte [] image = ( byte [...

Posted to Data Access and ObjectDataSource Control (Forum) by magesh22 on 05-09-2007, 12:00 AM
Filed under: Database, ADO.NET, C#, ASP.NET
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: TableAdapter, TableAdapters, Select, ASP.NET, DataGrid GridView Paging, DataSet, SQL Server ADO.NET Transactions, ADO.NET, Performance : Stored Procedure with many params, Table Adapter, DAL, Data, data Acces, Data Access, Data Access connections, Paramter, outputparameter, data connections, data set, DataAdapter, Database, databind, Asp.Net 2.0, DataSource
What are your thoughts?

For intranet development, our DBAs are asking web developers to use fixed domain NT ID accounts instead of SQL accounts to connect to backend databases in all web applications. We are: Windows XP workstations in a 2003 Active Directory Topology. I don’t think that this is a good idea (I could say more...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by wfudge on 08-20-2007, 12:00 AM
Filed under: ASP.NET, ASP.Net 2.0 Login Control, Asp.Net 1.1, asp, ASP.net 2.0 Tutorials, .Net FAQ Links, asp.NET 2.0 asp.net control template referencing codebehind findcontrol, Asp.NET2.0, ado.net faq, ado.net, datareader, sqldatasource, database, datasource, Asp.Net 2.0 and MS SQL Server 2005, sqldatabase
How to copy data from one excel file to other excel file

Hi I have two excel file (Ex1 and Ex2), both have same template (headers) and data will be populated from the dataset. Upto this step its works fine. My question : How to copy the data form 6th row to last row of "Ex2" and paste it into the "Ex1" after the last row in Ex1. Advance...

Posted to Enterprise Services Integration (Forum) by SudhaYogesh on 09-12-2007, 12:00 AM
Filed under: Asp.Net 2.0, Asp.Net 2.0 session, ASP.NET, Asp.Net 1.1, asp.net 2.0 asp.net, GridView field, ASP.NET Sites, VB.Net, asp, DotNet, reports, grid view, ASP.net 2.0 Tutorials, selection, C# code, Asp.NET2.0, ado.net, dataset, datareader, ASP.NET.NET 2.0, postback variables, c#, sql, database, datasource, Asp.Net 2.0 and MS SQL Server 2005, querystring, update, sqldatabase, t code behind, Find Control, excel, asp.net 2.0 export to excel
ASP.NET FAQ for Interviews for fresher

I would like share some best ASP.NET FAQ Interview Questions ans Answers web sites. Here Some best sites, 1) http://aspnet35.blogspot.com 2) http://msvs2008.blogspot.com 3) http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=4081&lngWId=10 5) http://www.techinterviews.com/?p=176 &...

Posted to FAQ - Frequently Asked Questions (Forum) by girish7375 on 09-29-2007, 12:00 AM
Filed under: AJAX, Asp.Net 2.0, ASP.NET, Asp.Net 1.1, Interview Question, .NET Framework 3.0, asp.net 2.0 asp.net, adding, DataGrid, search results, Interview Questions, .Net FAQ Links, .NET Interview Questions, ado.net faq, ado.net, AJAX problems, .Net Framework, database, Asp.Net 2.0 and MS SQL Server 2005, answers, asp on vista, Quickstart, AJAX problems (Modal popup ext in IE7), Array, Active Directory, AJAX update panel, 3rd Party controls for asp.net
Re: Problem sending values to stored procedure

when i tried to Convert.ToDouble i got this error message "Cannot implicitly convert type 'double' to 'float'. An explicit conversion exists (are you missing a cast?)" the stored procedure works fine. I tried it with 20.1 Also it doesn't matter to using 20.1 or 20,1 a.proTocusWt...

Posted to Data Access and ObjectDataSource Control (Forum) by murat.tufanoglu on 02-26-2008, 12:00 AM
Filed under: Database, ADO.NET, C#, databind, Asp.Net 2.0, ASP.NET, Class, .net 2.0, .net, ASP .NET 2, Parameter, asp .NET 2.0, Sql Parameters, visual studio 2005, asp.net2.0, asp.net2.0(c#), 2.0, OOP

Page 1 of 2 (15 items) 1 2 Next >

Advertise on ASP.NET

About this Site

Browse by Tags

Related Posts