Home ›
All Tags » sql » 2.0 (RSS)

Browse by Tags

Related Posts

  • Combine 3 tables to one gridview with Select Count

    I have 3 tables that i am trying to join to create one gridview that shows a detailed count of different items. My gridview works fine when it only joins two tables but when i add the third table it throws my counts completely off here is my code. If you have any suggestions on how to work this please...
    Posted to Data Access and ObjectDataSource Control (Forum) by cgreene.gsu on 10-16-2008, 12:00 AM
    Filed under: Paramter, sql, SQL Query, sql reader, sqlclient, Sqlconnection, .net 2.0 c#, 2.0, asp 2.0, C#, Columns, data Acces, Data Access, Data Access ASP.net vs. ASP, Database, DataColumn, datatable full join, dataTable join, Gridview - dataset, joins, database connection, Gridview DataGrid, codebehind

  • Can't find the error!!!???

    Anyone, I am just trying to do a simple insert, but can't figure out what the cause of my unhandled exception is. I am just trying to do a simple insert into a backend sql table. I'm using VB and sql '05. My codebehind calls this method in my Business Layer: Public Sub Insert( ByVal createdBy...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by bcoffey on 09-12-2008, 12:00 AM
    Filed under: sql, sql insert query, Sql Parameters, Sql server 2000, sql server2005 ADO.NET, sql update management studio, 2.0, 3 tier applications, ASP VB Data, asp.net 2.0, Asp.Net 2.0, bll business layer objects, BLL DAL Tier Separation, BLL Data 3 tiers business logic DAL ObjectDataSource sql connection, DAL, Data, data Acces, Insert, Insert data, asp.net2.0, sql data control, ASP.NET 2.0 search multiple keyword term sql server express 2005, BLL, Data Access and ObjectDataSource Control, .net 2.0, DAL Provider Interfaces

  • display images from SQL Server image across intranet using ado.net filestream object

    folks i recently attended an MCPD boot camp where they taught me to access and store images using SQL Server and the filestream object. Previously i had (sensibly) used a file server and impersonation to copy files. Uploading works fine. Viewing works fine in debug so i rolled out an app in my work where...
    Posted to Data Access and ObjectDataSource Control (Forum) by mike.waring on 08-06-2008, 12:00 AM
    Filed under: sql, SQL Server ADO.NET Transactions, sqlcommand, SqlDataSource, sqlserver 2000, Visual Basic 2005 Microsoft Access tableadapter loop, .net 2.0 c#, 2.0, ado .net, C#, Data Access, ADO.NET, display from database

  • 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: Roles, SQL, sql 2000, sql 2005, SQL 2005 ASP.NET, SQL Permissions, SQL Server 2005, SQL Server 2005 ADO.NET ASP.NET Large File, SqlCommand, 2.0, ADO.NET, Database, Membership, Microsoft SQL Server 2005, sql 2000 "sql server express 2005", SQL datatable, SQL Server 2000, ASP.NET, sql server database diagram asp.net

  • Cannot open SQL DB request for this login. (System.Data.SqlClient.SqlException)

    Hi guys, Everything seems to be fine, can browse the DB from VS, Preview data works fine in dataset, and the page works fine before adding any SQL DB code. I draged n dropped a new DropDownList, Bind it to an object from dataset. And when I want to run the page I get this error !!! I appreciate any help...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Mehdi6002 on 02-28-2007, 12:00 AM
    Filed under: SQL, SQL 2005 ASP.NET, SQL connection ControlParameter SelectParameters GridView, 2.0, .NET SQL Server 2005, aspnet_regsql.exe

  • 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, SQL 2005 ASP.NET, SQL connection ControlParameter SelectParameters GridView, SQL Server 2005, 2.0, ADO.NET, ASP.NET, Connection String, Connnection String, Database, Microsoft SQL Server 2005, .NET SQL Server 2005

  • Re: How to get the database file into .bak file format using C#

    Hi, They Above Article is useful for me. But this coding is stored is database Queries in text(txt) format but i need the database table values stored in .bak format. Give the solution please
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by subashini on 02-20-2007, 12:00 AM
    Filed under: SQL, sql 2000, SQL 2000 Server Connection, sql 2005, SQL 2005 ASP.NET, SQL 2005 Compact Edition, sql c# textbox asp.net, SQL Server 2000, 2.0, ADO.NET, ASP.NET, Database, Datatables, Database Export, .NET SQL Server 2000, .NET SQL Server 2005
Page 1 of 1 (7 items)

Contact | Advertise | Issue Management by Axosoft's OnTime | Running IIS7
All Rights Reserved. | Terms of Use | Trademarks | Privacy Statement
© 2009 Microsoft Corporation.