Home ›
All Tags » ASP.NET » sql (RSS)

Browse by Tags

Related Posts

  • Inserting a new record into sql db using user-entered information

    Im trying to add a new rcord to my db on a button click usign the following code 'data adapter Dim dAdapt1 As New SqlClient.SqlDataAdapter 'create a command object Dim objCommand As New SqlClient.SqlCommand 'command builder Dim builderT As SqlClient.SqlCommandBuilder 'connection string Dim cnStr As String...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by rox163 on 11-22-2006, 12:00 AM
    Filed under: ASP.NET, Microsoft SQL Server 2005, Connection String, .NET SQL Server 2005, insert, SQL, Database

  • Not getting any data

    Hello I am not really new to ASP.NET but I am building my first site at my new job. I just built the computer that I will be developing on. I have XP Pro, SQL server 2000, and visual studio 2005 with AJAx extensions. I created a web app and put a datagrid on the default.aspx page. I created a connection...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by jgsteeler on 12-12-2006, 12:00 AM
    Filed under: table lookup, sql stored procedure, ASP.NET, .NET SQL Server 2000, Connnection String, Connection String, SQL, Database

  • Pull between 2 dates from user input

    I want to pull dates from my database that are between to set dates i have written a query that does this which looks like this: "SELECT OCH_ID, empno, Selected_OCD, Start_Time, End_Time, Selected_OCDay, Selected_DOM, Selected_Month, Selected_Year FROM dbo.ICT_On_Call_Hours WHERE (CONVERT (datetime,...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Dazza22 on 02-14-2007, 12:00 AM
    Filed under: ASP.NET, SQL, Database, sql Query

  • 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

  • ASP.NET 2.0 dinamic sites with web based admin

    Hello! What's the best, faster way to create a dinamic website, with an web admin page? Is there a tutorial, guideline or manual to do it? Here's the idea of the project: I received a proposal to do a magazine web site, and my client wants a web based admin, so the news could be put up by it. I have...
    Posted to Getting Started (Forum) by fabioss5 on 03-20-2007, 12:00 AM
    Filed under: asp.net, general, SQL, news publishing, login, web application

  • ASP.NET DEVELOPER in Addison, TX - Immediate Need

    We are seeking a mid-level ASP.Net programmer with DotNetNuke, Web Services, T-SQL, and XML experience. Candidate will design, code and debug content management systems for a commercial printing company. The candidate should have experience with web portals and database-driven websites using SQL Server...
    Posted to Jobs (Forum) by Jeff B on 04-06-2007, 12:00 AM
    Filed under: C#, .NET, sql server, XML, Job asp.net developer, SQL, Job, Resume, C# ASP.NET, vb.net, Junior Developer, C#.Net XML, ASP.Net, ado.net, vb dot net, asp dot net, visual studio .net, .ascx, .aspx

  • 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

  • Populating a drop down list with non-repeating values

    I am accessing a database in visual studio 2005 to get all the service routes in a table. I would like to populate a dropdownlist with all the routes in the table, but without repeating any routes (there are several service calls for each route). My first thought was to use a sql statement like "select...
    Posted to Data Presentation Controls (Forum) by cjbenedict on 04-27-2007, 12:00 AM
    Filed under: sqldatasource, asp.net 2.0, sql, SQL Datasets, Databinding DropDownList consistency, asp.net 2.0 GridView databound ItemTemplate, ASP.NET, SqlDataSource1, sql2005

  • Re: Conditional repeating with Repeater. I want Repeter to add "CssClass='active'' to hyperlink when content of column "file" for curent field equals "string active"

    Is "IIF" function also in C#? There is the same problem with it. Server Error in '/Kamil Szmit (szmitek)' Application. Compilation Error Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify...
    Posted to Data Presentation Controls (Forum) by szmitek on 04-28-2007, 12:00 AM
    Filed under: css, asp.net 2.0, advanced, data, c#, sql, SELECT, ASP.NET, web controls, c# code, CssClass, IIF
Page 1 of 4 (39 items) 1 2 3 4 Next >

Advertise on ASP.NET

About this Site