Browse by Tags

Related Posts

  • Data submission to SQL, presented in Gridview (repeat data submissions)

    Hello.... Just curious about how to clear out any data that might be held in the browser during the following scenario: -User inputs a massive amount of data into a text box. -Contents of text box are moved into an SQL table -Gridview displays the data from table ( no prob so far ) -Now, if the user...
    Posted to Data Presentation Controls (Forum) by FZero on 06-16-2009, 12:00 AM
    Filed under: GridView, back button, sql, repeat data, refresh browser
  • Sum every column in Grid View

    i would like to ask how to sum each and every column in Grid View i've seen many posts on the web teaching how to sum a particular column. however, my GridView has some 40 columns. every column contains numbers which can be summed and there is no null value . is there a way which allows me to automatically...
    Posted to Data Presentation Controls (Forum) by kayson on 06-08-2009, 12:00 AM
    Filed under: sql, sum, gridview
  • Dealing with Images in SQL and ASP.net

    Hi There, I have a table in the database stored in SQL with the following specifications: IMAGES_TBL(SNO, ID,IMG) SNO- INT IDENTITY(1,1) ID - INT (can repeat through the table) IMG - of datatype IMAGE ( not stored as url but in bytes) In my code i upload images for a particular ID. There is no issue...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Deepa_Monteiro on 06-04-2009, 12:00 AM
    Filed under: sql, byte[], images, gridview
  • Re: How to use two values from a querystring?

    I presume you are using these values in a plain sql string. In this way you can use it like select * from tablename where column1 = '" + request.querystring["srname"].tostring() + "' and column2='" + request.querystring["name"].tostring() + "'
    Posted to Data Presentation Controls (Forum) by binobose on 02-24-2009, 12:00 AM
    Filed under: sql, GridView
  • DataBinding: 'System.Data.DataRowView' does not contain a property with the name '1'.

    the error: DataBinding: 'System.Data.DataRowView' does not contain a property with the name '1'. my case: getting this error when deleting a row from gridview and reloading the gridview with the changes using a single stored proc to delete and select.. dataset contains column names and...
    Posted to Access Databases and AccessDataSource Control (Forum) by snet on 01-09-2009, 12:00 AM
    Filed under: sql, stored procedure, visual studio, ASP.NET 2.0, c#, DataSet, Gridview Data Sources, .ASPX, GridView
  • GridView with custom columns which disappear

    I have a GridView which has three static columns then the rest are dynamic, they're added as needed using a snippet from codeproject (specifically the GridViewTemplate.cs class). The data is displayed correctly, but when a button in one of the cells is clicked and the page posts back, the columns...
    Posted to Data Presentation Controls (Forum) by Echilon on 11-17-2008, 12:00 AM
    Filed under: sql, GridView
  • SQL Columns Will not appera in my Grid. ???

    Hi, Most times I load my gridview with data from a database trough a Stored Procedure. This is my procedure: 1 Select SUM (korting) as Totaal_korting, ( SUM (korting)-( SUM (bedrag))) as totaal_betalen, 2 CASE 3 WHEN ( SUM (korting)-( SUM (bedrag)))=0 THEN 'Te Ontvangen' 4 WHEN ( SUM (korting...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by bakoven on 08-12-2008, 12:00 AM
    Filed under: SQL, SQL 2005 ASP.NET, sql queries, sql Query, sql stored procedure, "store result" " variable on Stored Procedure" "Stored Procedure", asp .NET 2.0 SQL data sqldataadapter, help, gridview, queries, ".NET 2", "ASP.NET and SQL Server"
  • Date format mismatch (Calendar - SQL)

    Hi folks. In my newest project I have to make use of the ASP calendar control along with the ussual data controls like GridViews etc. It works like this... The user will select a day on the calendar The gridview will check a database for any entries with that date and return them on screen The user also...
    Posted to Web Forms (Forum) by RyanMD on 08-12-2008, 12:00 AM
    Filed under: sql, datetime, GridView
  • Gridview and retreiving an image from SQL 2005

    I have searched and searched and searched. All of the results that have come back in regards to "how to retreive an image from SQL 2005" have been overly complicated, complex situational code, not in the right language, etc. Let's just take a barebones approach to this. How can I make a...
    Posted to Data Presentation Controls (Forum) by FZero on 03-28-2008, 12:00 AM
    Filed under: sql, System.Byte[], binary, image, GridView
  • Handling DBNull with a Gridview

    How do I handle a DBNull (coming from an SQL database) which wants to populate into a gridview? Error Message: " Conversion from type 'DBNull' to type 'Date' is not valid. " I want to be able to populate the gridview with both "blanks" (which in this case are technically...
    Posted to Data Presentation Controls (Forum) by FZero on 03-11-2008, 12:00 AM
    Filed under: sql, DBNull, GridView
Page 1 of 3 (26 items) 1 2 3 Next >