Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > .NET > .NET 2.0 and Visual Studio. 2005 > .NET Framework 2.0
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
.NET Framework 2.0 For discussion of the Microsoft .NET Framework 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the .NET Framework 2.0 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old January 29th, 2008, 03:45 PM
Friend of Wrox
 
Join Date: Mar 2007
Location: West Palm Beach, Florida, USA.
Posts: 205
Thanks: 4
Thanked 0 Times in 0 Posts
Default DataGridView column value

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")


Reply With Quote
  #2 (permalink)  
Old January 29th, 2008, 07:00 PM
samjudson's Avatar
Friend of Wrox
Points: 8,687, Level: 40
Points: 8,687, Level: 40 Points: 8,687, Level: 40 Points: 8,687, Level: 40
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2007
Location: Newcastle, , United Kingdom.
Posts: 2,128
Thanks: 1
Thanked 189 Times in 188 Posts
Default

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

/- Sam Judson : Wrox Technical Editor -/
Reply With Quote
  #3 (permalink)  
Old January 30th, 2008, 09:44 AM
Friend of Wrox
 
Join Date: Mar 2007
Location: West Palm Beach, Florida, USA.
Posts: 205
Thanks: 4
Thanked 0 Times in 0 Posts
Default

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?

Reply With Quote
  #4 (permalink)  
Old January 30th, 2008, 10:06 AM
samjudson's Avatar
Friend of Wrox
Points: 8,687, Level: 40
Points: 8,687, Level: 40 Points: 8,687, Level: 40 Points: 8,687, Level: 40
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2007
Location: Newcastle, , United Kingdom.
Posts: 2,128
Thanks: 1
Thanked 189 Times in 188 Posts
Default

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

/- Sam Judson : Wrox Technical Editor -/
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
not showing column in datagridview jomet .NET Framework 2.0 6 March 15th, 2008 04:02 AM
DataGridView - allow column resize snufse .NET Framework 2.0 0 January 31st, 2008 10:33 AM
Datagridview & combobox column p2pmarit .NET Framework 2.0 1 July 31st, 2006 02:31 AM
check Box column in DataGridView control tiyyob .NET Framework 2.0 0 June 24th, 2006 09:49 AM
Add User Control in DatagridView Column HemaChaudhry Visual Basic 2005 Basics 0 January 23rd, 2006 08:43 AM



All times are GMT -4. The time now is 10:23 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.