DataGridView column value

snufse · January 29th, 2008, 03:45 PM

I am displaying a DataGridView using DataSet and call to a stored procedure. My stored procedure populates a temp table and result is being displayed in the DataGridView. Everything works fine except for following:

I am using alternating row color and the value in for "qty_delivered' column is zero at yellow lines and blank at white lines. Any ideas what could cause this?

Here is the table that is being read and fed to the DataGridView:

Code:

CREATE TABLE    #JobListTable
        (
            job_date datetime,
            job_number char(15),
            job_phase char(15),
            qty_delivered decimal(8,2),
            qty_received decimal(8,2),
                        plant_id char(10)
                                                )

Code:

EquentialCommand.CommandType =  CommandType.StoredProcedure

Code:

           EquentialCommand.CommandText = ("sp_GetJobList")
           EquentialCommand.Connection = EquentialConnection
           mySqlDataAdapter.SelectCommand = EquentialCommand
           mySqlDataAdapter.Fill(mySqlDataSet, "JobListTable")
           EquentialCommand.Parameters.Clear()
           EquentialConnection.Close()
           DataGridView1.DataSource = Nothing
           DataGridView1.Rows.Clear()
           DataGridView1.DataSource = mySqlDataSet.Tables("JobListTable")

samjudson · January 29th, 2008, 07:00 PM

I don't suppose its just white text on a white background?

/- Sam Judson : Wrox Technical Editor -/

snufse · January 30th, 2008, 09:44 AM

I am using alternating row color and the value in for "qty_delivered' column is zero at yellow rows and blank at white rows. Any ideas what could cause this?

samjudson · January 30th, 2008, 10:06 AM

The answer is no, unless you are displaying the qty_delivered column in white text on a white background.

/- Sam Judson : Wrox Technical Editor -/