Home ›
All Tags » database » 2.0 (RSS)

Browse by Tags

Related Posts

  • Error connecting to ASPNETDB - Cannot open database

    Hi everyone, i have already created posts about this problem and im aware theres millions of replys, but i still cant get this to work and its driving me mad. The posts i have seen i dont understand? Im using the standard ASPNETDB Database, i have never opened up SQL Server Management studio, although...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Dan2e on 02-15-2007, 12:00 AM
    Filed under: Remote Connection Enabled Sql 2005, ASP.NET, Vwd 2005, Connnection String, Microsoft SQL Server 2005, .NET SQL Server 2005, Database, aspnet_regsql.exe, SQL 2005 ASP.NET, sql 2000 "sql server express 2005", 2.0, referencing ASPNETDB, Custom Provider, asp .net sql 2005 express standard, SQL 2000 Server Connection

  • convert .net type to DbType (SqlDbType)

    Hello, I have following problem: I have object property (type of byte[]) which is null and I need to insert it into datatable in my sql database. But I have problems with DbParameter - when I set DbNull as its value, in DbParameter remains type of String. Which throw exception during execution of command...
    Posted to Data Access and ObjectDataSource Control (Forum) by vipi on 02-16-2007, 12:00 AM
    Filed under: ASP.NET, .NET SQL Server 2005, Database, Dataset population problems, 2.0, c#

  • 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

  • Can you have a FormView use SELECT FROM WHERE IN?

    How can I generate the following command with VB Code Behind in NET 2.0 and have a FormView access the command. The 4 and 20 below may be 3 and 100 and etc. " SELECT * FROM [Solution] WHERE ([SolutionID] IN ( '4' , '20' ))" The List is generated by two multiselect controls (ListBox and CheckBoxList)...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by unhistoric on 03-04-2007, 12:00 AM
    Filed under: Connnection String, Database, 2.0, asp .net sql 2005 express standard, SqlDataSource.SelectCommand

  • 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

  • Advanced Identity Fields

    Hi! a) PROBLEM 1: I have set up my main database like this (of course I'm showing an abbreviation): company - int (identity) name - nchar I have several companies stored in the previous table. Now I have another table with messages: company - int (related with the company of the previous table) messageID...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by ctellez69 on 04-19-2007, 12:00 AM
    Filed under: Database Export, .NET SQL Server 2005, Database, 2.0, identity, asp .net sql 2005 express standard, ASP.NET 2.0 Data Binding SQL Server 2005 XML, database options

  • There's always an easier way.

    Hello All, Right now I am getting ready to write an onSubmit handler. In the event handler, I would like to write a function that: - validate some information in a text box Should be 'RO' + 6 numbers(ex. RO152465) - builds a SQL query based on checkboxes selected and then the values that are in the drop...
    Posted to Web Forms (Forum) by dohertyk on 04-24-2007, 12:00 AM
    Filed under: event validation, TextBox, ASP.NET, form, radio button, DropDownList, submit, "Asynchronous Operation", <%@ Page Language="VB" %>, ASP.NET 2.0, codebehind, View, Database, Validators, DataGrid, event, ASP.NET 2.0 VB.NET, ASP.NET 2.0 IIS, SQLDataSource, visual studio, validation, IIS, validate, aspx, .net, ASP.NET 2.0 webform, Valdiation Controls, ASP.NET 2.0 Ajax Control Toolkit Ajax Tab Control, asp, Webforms, Beginner, dropDownList radiobuttonlist, events, event handlin, vb.net, CustomValidator, Button Event OnClick, validation Controls, SQL SERVER, 2.0

  • PostBackUrl and "Insert"

    When a user submits data in a form, I want to tell the user that the information has been saved to the database. But when I use the PostBackUrl="~/success.aspx", the data is not written. However, it works without the PostBackUrl. For example: <asp:Button ID="InsertButton1" runat...
    Posted to Web Forms (Forum) by steldingc on 07-09-2007, 12:00 AM
    Filed under: ASP.NET, form, postbackurl, ASP.NET 2.0, Database, PostBack, postback event handling, data entry insert auto, postback data expiration, 2.0, .aspx.vb, asp .net 2.0, postBackback postbackurl

  • Filtering a table for specific users

    Hey everyone, i have a gridview on a login page of a website i'm working on and i would like it to only show certain columns depending on a value in that column. For example, I have a table with Company, Customer ID, Date, Image, Description etc as the definitions.. and im trying to get the page...
    Posted to Data Presentation Controls (Forum) by zakman411 on 02-23-2008, 12:00 AM
    Filed under: Datalist, database, databinding, collections, Data table, .NET Gridview Problems, asp .net 2.0, .Net 2.0, asp.net ... ... Data access datagrid, 2.0, 1.1, .NET 2.0 GridView ImageField ImageStyle, asp .NET 2005

  • 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 (12 items) 1 2 Next >

Advertise on ASP.NET

About this Site