Comments by Dirk C De Winnaar (Top 29 by date)

Hi Have a look at this: http://www.foxite.com/search.aspx?m=tags&q=DataGridView

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!

http://msdn.microsoft.com/en-us/library/ms996472.aspx

http://msdn.microsoft.com/en-us/library/ms996472.aspx

stringFormat.Alignment = StringAlignment.Center;

Are you passing the the coarseId?

Show the "connection" section of you code. Please ShockShock

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

try this:
http://www.codeproject.com/KB/vb/Skin_for_Form_in_VB.Net.aspx

Put a break point in and step through to see what gets loaded.
Are you using a table or a DataSet?

Give us your code so we can have a look at it....?

Do you want to cover your forms with your own skins?

Post your code please.

Don't worry! It's working. Your foreach worked 100%

Thank you very much!

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

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.

It Return nothing.

Nothing. No Results.

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.

I did the first select to convert. and changed the "/" separator. Nothing shows now if I execute.

It's CHAR(10)

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.
:-)

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.

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.