15,896,606 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View Python questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by Dirk C De Winnaar (Top 29 by date)
Dirk C De Winnaar
1-Dec-11 14:44pm
View
What mother calls her child "YONOP"? here's something to translate yonop. Your a POES!
Dirk C De Winnaar
29-Sep-11 11:15am
View
Is it giving you a error?
Dirk C De Winnaar
29-Sep-11 11:10am
View
Use a timer to close your app in say 1.5 sec after starting the new one.
Dirk C De Winnaar
29-Sep-11 11:07am
View
Post you code please Tim.
Dirk C De Winnaar
26-Sep-11 11:08am
View
Use the Webbrowser to host the .doc (word) document. Here's and topic about it:
http://social.msdn.microsoft.com/Forums/en/netfxbcl/thread/cd4d7cb7-6021-4a3b-88fa-7a861595c7e2
Dirk C De Winnaar
26-Sep-11 11:05am
View
Hi Have a look at this: http://www.foxite.com/search.aspx?m=tags&q=DataGridView
Dirk C De Winnaar
26-Sep-11 11:03am
View
http://technet.microsoft.com/en-us/sqlserver/Video/dd941934
http://www.sqlteam.com/article/using-bulk-insert-to-load-a-text-file
Here's two links to look at.....
Have fun!
Dirk C De Winnaar
26-Sep-11 11:01am
View
http://msdn.microsoft.com/en-us/library/ms996472.aspx
Dirk C De Winnaar
26-Sep-11 10:59am
View
http://msdn.microsoft.com/en-us/library/ms996472.aspx
Dirk C De Winnaar
26-Sep-11 10:58am
View
stringFormat.Alignment = StringAlignment.Center;
Dirk C De Winnaar
26-Sep-11 10:56am
View
Are you passing the the coarseId?
Dirk C De Winnaar
26-Sep-11 10:55am
View
Show the "connection" section of you code. Please ShockShock
Dirk C De Winnaar
10-Sep-11 7:48am
View
this.BackgroundImage = //Image
this.FormBorderStyle = FormBorderStyle.None;
this.Width = this.BackgroundImage.Width;
this.Height = this.BackgroundImage.Height;
this.TransparencyKey = Color.FromArgb(0, 255, 0); //Contrast Color
Also look at this:
http://www.codeproject.com/KB/WPF/wpfpopup.aspx
Dirk C De Winnaar
10-Sep-11 7:39am
View
try this:
http://www.codeproject.com/KB/vb/Skin_for_Form_in_VB.Net.aspx
Dirk C De Winnaar
9-Sep-11 18:02pm
View
Put a break point in and step through to see what gets loaded.
Are you using a table or a DataSet?
Dirk C De Winnaar
9-Sep-11 17:40pm
View
Give us your code so we can have a look at it....?
Dirk C De Winnaar
9-Sep-11 17:11pm
View
Do you want to cover your forms with your own skins?
Dirk C De Winnaar
6-Sep-11 13:35pm
View
Post your code please.
Dirk C De Winnaar
1-Sep-11 10:15am
View
Don't worry! It's working. Your foreach worked 100%
Thank you very much!
Dirk C De Winnaar
1-Sep-11 10:13am
View
It's not working.
This is how I build my Columns
private void SetupColumns(DataTable table)
{
DataGridViewTextBoxColumn caseColumn = new DataGridViewTextBoxColumn();
caseColumn.Width = 140;
caseColumn.DataPropertyName = "case";
caseColumn.HeaderText = "Case No";
caseColumn.ValueType = typeof(string);
caseColumn.Frozen = true;
dataGridView1.Columns.Add(caseColumn);
DataGridViewTextBoxColumn RegNoColumn = new DataGridViewTextBoxColumn();
RegNoColumn.DataPropertyName = "regnum";
RegNoColumn.HeaderText = "Reg No";
RegNoColumn.Frozen = true;
RegNoColumn.ValueType = typeof(string);
dataGridView1.Columns.Add(RegNoColumn);
DataGridViewTextBoxColumn AreaColumn = new DataGridViewTextBoxColumn();
AreaColumn.DataPropertyName = "issuing_authority";
AreaColumn.HeaderText = "Area";
AreaColumn.Frozen = true;
AreaColumn.ValueType = typeof(string);
dataGridView1.Columns.Add(AreaColumn);
DataGridViewTextBoxColumn OffenceDateColumn = new DataGridViewTextBoxColumn();
OffenceDateColumn.DataPropertyName = "date_entered";
OffenceDateColumn.HeaderText = "Offence Date";
OffenceDateColumn.Frozen = true;
OffenceDateColumn.ValueType = typeof(DateTime);
dataGridView1.Columns.Add(OffenceDateColumn);
DataGridViewTextBoxColumn OriginalCostColumn = new DataGridViewTextBoxColumn();
OriginalCostColumn.Width = 90;
OriginalCostColumn.DataPropertyName = "amount";
OriginalCostColumn.HeaderText = "Original Cost";
OriginalCostColumn.Frozen = true;
OriginalCostColumn.ValueType = typeof(string);
dataGridView1.Columns.Add(OriginalCostColumn);
DataGridViewTextBoxColumn ReducedCostColumn = new DataGridViewTextBoxColumn();
ReducedCostColumn.DataPropertyName = "reduced_cost";
ReducedCostColumn.HeaderText = "Reduced Cost";
ReducedCostColumn.Frozen = true;
ReducedCostColumn.ValueType = typeof(string);
dataGridView1.Columns.Add(ReducedCostColumn);
DataGridViewTextBoxColumn StatusColumn = new DataGridViewTextBoxColumn();
StatusColumn.DataPropertyName = "status";
StatusColumn.HeaderText = "Status";
StatusColumn.Frozen = true;
StatusColumn.ValueType = typeof(string);
dataGridView1.Columns.Add(StatusColumn);
DataGridViewTextBoxColumn ServiceFeeColumn = new DataGridViewTextBoxColumn();
ServiceFeeColumn.Width = 80;
ServiceFeeColumn.DataPropertyName = "Cost";
ServiceFeeColumn.HeaderText = "Service Fee";
ServiceFeeColumn.Frozen = true;
ServiceFeeColumn.ValueType = typeof(string);
dataGridView1.Columns.Add(ServiceFeeColumn);
DataGridViewTextBoxColumn DescriptionColumn = new DataGridViewTextBoxColumn();
DescriptionColumn.Width = 165;
DescriptionColumn.DataPropertyName = "Description";
DescriptionColumn.HeaderText = "Description";
DescriptionColumn.Frozen = true;
DescriptionColumn.ValueType = typeof(string);
dataGridView1.Columns.Add(DescriptionColumn);
Dirk C De Winnaar
30-Aug-11 15:11pm
View
Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= "1/1/2010"
AND DATE_FORMAT(fine.date_entered, '%d-%m-%Y') = "31/12/2010"' at line 4
The second "=" sign is not accepted.
Dirk C De Winnaar
30-Aug-11 14:53pm
View
It Return nothing.
Dirk C De Winnaar
30-Aug-11 14:02pm
View
Nothing. No Results.
Dirk C De Winnaar
30-Aug-11 13:51pm
View
Please Note that I also can't change to DataType of this column as the original program still needs to work off it I'm using TEST DB now, so it's ok, My Addition just needs to get this Data back from the MySql DB.
Dirk C De Winnaar
30-Aug-11 13:43pm
View
I did the first select to convert. and changed the "/" separator. Nothing shows now if I execute.
Dirk C De Winnaar
30-Aug-11 13:21pm
View
It's CHAR(10)
Dirk C De Winnaar
30-Aug-11 13:11pm
View
Hi I still don't work. date_entered does not have the DT datatype. It's not a DB I designed. It's another one I'm writting an addition to.
Sorry should have mentioned it before.
:-)
Dirk C De Winnaar
30-Aug-11 12:31pm
View
Hi RaisKazi. It still does not work. It filters all the needed data but all the other dates from 2011 , 2009, 2010 even if I change the month part to order between the month of '5' eg. It show everything not just that month.
Dirk C De Winnaar
30-Aug-11 11:31am
View
Hi I know the date format of MySql is yyyy-mm-dd the date inside the table is dd/MM/yyyy.
Query still don't work.
Show More