Windows Forms

6-Feb-22 1:43

Message Closed

6-Feb-22 1:46

6-Feb-22 1:46

Message Closed

6-Feb-22 1:46

6-Feb-22 1:46

Message Closed

6-Feb-22 1:46

6-Feb-22 1:46

Message Closed

6-Feb-22 1:46

6-Feb-22 1:46

Message Closed

6-Feb-22 1:46

6-Feb-22 1:46

Message Closed

6-Feb-22 1:46

6-Feb-22 1:46

Message Closed

6-Feb-22 1:46

Replace text with image in DataGridView

6-Feb-22 1:46

Message Closed

Member 1524267116-Jul-21 19:40

Re: Replace text with image in DataGridView

16-Jul-21 19:40

My WinForms project has a DataGridView component which among other things shows PASS/FAIL text data.

I would like to replace any "PASS" with a check-mark image and any "FAIL" with a cross image but I'm not sure how to achieve this. Any assistance would be appreciated.

Richard MacCutchan16-Jul-21 21:35

Richard MacCutchan

16-Jul-21 21:35

Display Images in Cells of DataGridView Control - Windows Forms .NET Framework | Microsoft Docs[^]

Re: Replace text with image in DataGridView

Member 1524267117-Jul-21 14:10

Re: Replace text with image in DataGridView

17-Jul-21 14:10

Thanks. It is working now. I first created an image column.

DataGridViewImageColumn iconColumn = new DataGridViewImageColumn();
iconColumn.HeaderText = "Pass/Fail";
iconColumn.Width = 60;
iconColumn.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
iconColumn.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
iconColumn.SortMode = DataGridViewColumnSortMode.NotSortable;
CalGrid.Columns.Insert(2, iconColumn);

I then used the CellFormatting event to set the correct image.

private void CalGrid_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (CalGrid[3,e.RowIndex].Value.ToString() == "PASS")
{
e.Value = imageList1.Images[0];
}
else
{
e.Value = imageList1.Images[1];
}
}

Gerry Schmitz17-Jul-21 5:58

Gerry Schmitz

17-Jul-21 5:58

Use a symbol font with a larger FontSize; e.g. Wingdings.

If it's Windows 10, the MS font Segoe MDL2 Assets has the windows icons and Segoe UI Symbol are the "pre" MDL2 icons. And there's Segoe UI Emoji ✅✔☠ for color.

It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food

Zero detected as Null in Crystal Report

Member 152426714-Jul-21 12:56

4-Jul-21 12:56

I am currently writing a WinForms application in C# with a Microsoft Access database backend and using Crystal Reports for reporting.

One table in the database contains a numeric field which can allow any numeric value including zero, but is can also be Null. Currently when I display a report any field that contains a zero value is displayed as empty. I have played around with the "Show zero as" setting but it is either blank for both zero and Null values or it shows "0" for both zero and Null values.

I would like to display "0" for zero values and "" for Null values.

Any Crystal Reports gurus out there?

tarco5-Jul-21 13:44

tarco

5-Jul-21 13:44

Been a while since I have used crystal reports, you will need to use a formula field. In your formula, it is also important to test IsNull first.

Crystal Syntext below,

Copy Code

If IsNull({Table.Field})
   " "
Else
   {Table.Field}

Hope this helps,

Regards,
Tarco

Member 152426715-Jul-21 14:30

5-Jul-21 14:30

I tried this however the syntax has to be:

If IsNull({Table.Field})
" "
Else
totext({Table.Field})

Even when I do this it displays "0". For some reason CR is converting all null values to zeros.

tarco5-Jul-21 15:27

tarco

5-Jul-21 15:27

If you don't mind me asking, how are you connecting to the access database?

Member 152426715-Jul-21 16:51

5-Jul-21 16:51

I'm using c# code to connect to the database as follows:

string sql = null;
OleDbConnection cnn = new OleDbConnection(Global.connectionStringAccess);
cnn.Open();
sql = "SELECT * FROM Register WHERE ItemNo = '" + Global.CurrentItem + "'";
OleDbDataAdapter dscmd = new OleDbDataAdapter(sql, cnn);
DataSet ds = new DataSet();
dscmd.Fill(ds, "Register");
cnn.Close();
string rptName = rptPath + "\\rptWorksheet.rpt";
cryRpt.Load(rptName);
cryRpt.SetDataSource(ds.Tables["Register"]);
crystalReportViewer1.ReportSource = cryRpt;
crystalReportViewer1.Refresh();