Home ›
All Tags » database » 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

  • 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: OOP, Parameter, Sql Parameters, visual studio 2005, .net, .net 2.0, 2.0, ADO.NET, asp .NET 2.0, ASP.NET, Asp.Net 2.0, C#, Class, Database, databind, asp.net2.0, asp.net2.0(c#), ASP .NET 2

  • 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: .Net 2.0, .NET 2.0 GridView ImageField ImageStyle, .NET Gridview Problems, 1.1, 2.0, asp .net 2.0, asp .NET 2005, asp.net ... ... Data access datagrid, collections, Data table, database, databinding, Datalist

  • 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: PostBack, postback data expiration, postback event handling, postBackback postbackurl, postbackurl, 2.0, asp .net 2.0, ASP.NET, data entry insert auto, Database, .aspx.vb, form, ASP.NET 2.0

  • 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: radio button, SQLDataSource, TextBox, Valdiation Controls, Validators, vb.net, View, visual studio, <%@ Page Language="VB" %>, "Asynchronous Operation", .net, 2.0, asp, ASP.NET, ASP.NET 2.0 Ajax Control Toolkit Ajax Tab Control, ASP.NET 2.0 VB.NET, ASP.NET 2.0 webform, aspx, Beginner, codebehind, CustomValidator, Database, DataGrid, DropDownList, dropDownList radiobuttonlist, event, event handlin, event validation, events, Webforms, IIS, validation, form, SQL SERVER, submit, validate, validation Controls, ASP.NET 2.0, ASP.NET 2.0 IIS, Button Event OnClick

  • 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: 2.0, asp .net sql 2005 express standard, ASP.NET 2.0 Data Binding SQL Server 2005 XML, Database, identity, Database Export, database options, .NET SQL Server 2005

  • 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

  • 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: SqlDataSource.SelectCommand, 2.0, asp .net sql 2005 express standard, Database, Connnection String

  • 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

  • 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: 2.0, ASP.NET, c#, Database, Dataset population problems, .NET SQL Server 2005
Page 1 of 2 (13 items) 1 2 Next >

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