C# Discussion Boards - CodeProject

8-Oct-20 4:10

At a guess, some of the information on which the ExecuteQuery request depends.

Use the debugger: look at the ComObject and it's properties - are there any there that are null, that it might be using?

We can't do that for you: we have no idea what yoru object is, what it is talking to, what data it might require - and no way to find out as we can't run your code under the same conditions you do!

So break out the debugger, and start looking at exactly what is going on!

"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!

Scanning for servers

pkfox4-Oct-20 21:52

pkfox

4-Oct-20 21:52

Hi all, the code below broadcasts on a lan for Logitech media servers listening on UDP port 3483 - it works perfectly unless I run it more than once in the same session which results in the error Only one usage of each socket address is normally permitted. Now I understand that you can't bind to a socket twice with the same ip/port pairing but I'm not trying to do that - I'm simply resending the broadcast. I don't have servers running on the same machine as this code is run on ( that's bitten me before ) Any ideas ?

public async Task<LMSResponseParser> ScanForServer()
     {
         try
         {
             this.listener = new UdpClient(UDPPort); // This is where it bombs on the second run
             this.ReceiveIP = new IPEndPoint(IPAddress.Broadcast, UDPPort);
             this.Result = await listener.ReceiveAsync();
             // The buffer should contain "eIPAD0\JSON0\UUID0\VERS0" in a byte array
             this.RequestData = this.Result.Buffer;
             this.ReceiveIP = this.Result.RemoteEndPoint;
             // Send the buffer back to initiate a response
             this.BytesSent = await this.listener.SendAsync(this.RequestData, this.RequestData.Length, this.ReceiveIP);

             this.Result = await this.listener.ReceiveAsync();
             // This should contain information about our server ( Port number , IP etc etc )
             this.BytesReceived = this.Result.Buffer;

             if (this.BytesReceived != null && this.BytesReceived.Length > 0)
                 this.RetVal = Encoding.UTF8.GetString(this.BytesReceived);
             // Parse the response and place the values in a dictionary
             this.parseLMSResponse = new LMSResponseParser(BytesReceived);
         }
         catch (Exception ex)
         {
             Console.WriteLine(ex.Message);
         }
         finally
         {
             if (this.listener != null && this.listener.Client.Connected)
                 this.listener.Close();
         }
         return this.parseLMSResponse;
     }

"I didn't mention the bats - he'd see them soon enough" - Hunter S Thompson - RIP

modified 5-Oct-20 5:30am.

Re: Scanning for servers

Richard Deeming5-Oct-20 2:44

Richard Deeming

5-Oct-20 2:44

The UspClient class implements IDisposable, so you could try wrapping it in a using block.

I'd also be inclined to use local variables for objects which aren't meant to live beyond the current method, rather than storing everything in class-level fields.

public async Task<LMSResponseParser> ScanForServer()
{
    using (var listener = new UdpClient(UDPPort))
    {
        this.ReceiveIP = new IPEndPoint(IPAddress.Broadcast, UDPPort);
        
        var result = await listener.ReceiveAsync();
        var requestData = result.Buffer;
        this.ReceiveIP = result.RemoteEndPoint;
        
        this.BytesSent = await listener.SendAsync(requestData, requestData.Length, this.ReceiveIP);
        
        result = await listener.ReceiveAsync();
        var bytesReceived = result.Buffer;
        if (bytesReceived != null && bytesReceived.Length != 0)
        {
            this.RetVal = Encoding.UTF8.GetString(bytesReceived);
        }
        
        return new LMSResponseParser(bytesReceived);
    }
}

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: Scanning for servers

pkfox5-Oct-20 3:44

pkfox

5-Oct-20 3:44

Thanks Richard I'll give it a shot

"I didn't mention the bats - he'd see them soon enough" - Hunter S Thompson - RIP

Re: Scanning for servers

pkfox5-Oct-20 4:17

pkfox

5-Oct-20 4:17

Hi Richard, I tried your code and it worked fine, I think it's the using statement that's key here - I modded my code to call Dispose() on the listener object and that also worked fine so I think you nailed it noticing UDPClient implements IDispose - a lesson learnt - thanks for your help

"I didn't mention the bats - he'd see them soon enough" - Hunter S Thompson - RIP

version mismatch

Member 149246074-Oct-20 9:30

Member 14924607

4-Oct-20 9:30

Visual studio 2019 16.7.5

I'm getting this warning":

Version mismatch between the analyzer package '3.3.1' and Microsoft.CodeAnalysis '2.1.0.0'

I have the latest version of Microsoft.CodeAnalysis and FxCopAnalyser installed.

I don't understand what causes the system to look at Microsoft.CodeAnalysis '2.1.0.0'.

Re: version mismatch

Richard Deeming5-Oct-20 2:33

Richard Deeming

5-Oct-20 2:33

Looks like the same problem that was already reported:
VS Mac build fails after adding FxCopAnalyzer package · Issue #2289 · dotnet/roslyn-analyzers · GitHub[^]

NB: The latest released version of Microsoft.CodeAnalysis is 3.7.0:
Microsoft.CodeAnalysis 3.7.0[^]

The latest released version of Microsoft.CodeAnalysis.FxCopAnalyzers is 3.3.0:
Microsoft.CodeAnalysis.FxCopAnalyzers 3.3.0[^]
Although it's listed as "prerelease" on the GitHub site:
Release v3.3.0 · dotnet/roslyn-analyzers · GitHub[^]

Where have you found v3.3.1 of FxCopAnalyzers, since it's not on NuGet or GitHub?

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: version mismatch

Member 149246075-Oct-20 7:45

Member 14924607

5-Oct-20 7:45

I have installed MicroCodeAnalysis v3.70 and FxCopAnalyzers v3.3.0. I don't have version 3.3.1

Re: version mismatch

Richard Deeming5-Oct-20 21:22

Richard Deeming

5-Oct-20 21:22

Member 14924607 wrote:
I don't have version 3.3.1

Member 14924607 wrote:
Version mismatch between the analyzer package '3.3.1' ...

The error message suggests you do. Unless there's a different analyzer package installed which you haven't mentioned?

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

printDocument

Member 149437371-Oct-20 19:02

Member 14943737

1-Oct-20 19:02

Hi,

I am using the printDocument function to print out my datagridview data. However, I am using the debugger to trace my program execution and I have found out that the "printDocument1_BeginPrint" and "printDocument1_PrintPage" never get executed during the program execution.

Can anyone tell me what I have done wrong? Why the printDocument1_PrinPage and printDoucument1_BeginPrint never got executed?

PS. I am pasting my code below of the printing logic.

Thanks,
John

#region Print Button Click Event
        /// <summary>
        /// Handles the print button click event
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnPrint_Click(object sender, EventArgs e)
        {
            //Open the print dialog
            PrintDialog printDialog = new PrintDialog();
            PrintDocument printDocument1 = new PrintDocument();
            printDialog.Document = printDocument1;
            printDialog.UseEXDialog = true;

            //Get the document
            if (DialogResult.OK == printDialog.ShowDialog())
            {
                printDocument1.DocumentName = "Lottery Tickets Priniting";
                printDocument1.Print();
            }

            //Open the print preview dialog
            //PrintPreviewDialog objPPdialog = new PrintPreviewDialog();
            //objPPdialog.Document = printDocument1;
            //objPPdialog.ShowDialog();
        }
        #endregion

        #region Begin Print Event Handler
        /// <summary>
        /// Handles the begin print event of print document
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void printDocument1_BeginPrint(object sender, System.Drawing.Printing.PrintEventArgs e)
        {
            try
            {
                strFormat = new StringFormat();
                strFormat.Alignment = StringAlignment.Near;
                strFormat.LineAlignment = StringAlignment.Center;
                strFormat.Trimming = StringTrimming.EllipsisCharacter;

                arrColumnLefts.Clear();
                arrColumnWidths.Clear();
                iCellHeight = 0;
                iRow = 0;
                bFirstPage = true;
                bNewPage = true;

                // Calculating Total Widths
                iTotalWidth = 0;
                foreach (DataGridViewColumn dgvGridCol in dataGridView1.Columns)
                {
                    iTotalWidth += dgvGridCol.Width;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
        #endregion

        #region Print Page Event
        /// <summary>
        /// Handles the print page event of print document
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void printDocument1_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
        {
            try
            {
                //Set the left margin
                int iLeftMargin = e.MarginBounds.Left;
                //Set the top margin
                int iTopMargin = e.MarginBounds.Top;
                //Whether more pages have to print or not
                bool bMorePagesToPrint = false;
                int iTmpWidth = 0;

                //For the first page to print set the cell width and header height
                if (bFirstPage)
                {
                    foreach (DataGridViewColumn GridCol in dataGridView1.Columns)
                    {
                        iTmpWidth = (int)(Math.Floor((double)((double)GridCol.Width /
                                       (double)iTotalWidth * (double)iTotalWidth *
                                       ((double)e.MarginBounds.Width / (double)iTotalWidth))));

                        iHeaderHeight = (int)(e.Graphics.MeasureString(GridCol.HeaderText,
                                    GridCol.InheritedStyle.Font, iTmpWidth).Height) + 11;

                        // Save width and height of headres
                        arrColumnLefts.Add(iLeftMargin);
                        arrColumnWidths.Add(iTmpWidth);
                        iLeftMargin += iTmpWidth;
                    }
                }
                //Loop till all the grid rows not get printed
                while (iRow <= dataGridView1.Rows.Count - 1)
                {
                    DataGridViewRow GridRow = dataGridView1.Rows[iRow];
                    //Set the cell height
                    iCellHeight = GridRow.Height + 5;
                    int iCount = 0;
                    //Check whether the current page settings allo more rows to print
                    if (iTopMargin + iCellHeight >= e.MarginBounds.Height + e.MarginBounds.Top)
                    {
                        bNewPage = true;
                        bFirstPage = false;
                        bMorePagesToPrint = true;
                        break;
                    }
                    else
                    {
                        if (bNewPage)
                        {
                            //Draw Header
                            e.Graphics.DrawString("Lottery Tickets Listing", new Font(dataGridView1.Font, FontStyle.Bold),
                                    Brushes.Black, e.MarginBounds.Left, e.MarginBounds.Top -
                                    e.Graphics.MeasureString("Lottery Tickets Listing", new Font(dataGridView1.Font,
                                    FontStyle.Bold), e.MarginBounds.Width).Height - 13);

                            String strDate = DateTime.Now.ToLongDateString() + " " + DateTime.Now.ToShortTimeString();
                            //Draw Date
                            e.Graphics.DrawString(strDate, new Font(dataGridView1.Font, FontStyle.Bold),
                                    Brushes.Black, e.MarginBounds.Left + (e.MarginBounds.Width -
                                    e.Graphics.MeasureString(strDate, new Font(dataGridView1.Font,
                                    FontStyle.Bold), e.MarginBounds.Width).Width), e.MarginBounds.Top -
                                    e.Graphics.MeasureString("Lottery Tickets Listing", new Font(new Font(dataGridView1.Font,
                                    FontStyle.Bold), FontStyle.Bold), e.MarginBounds.Width).Height - 13);

                            //Draw Columns                 
                            iTopMargin = e.MarginBounds.Top;
                            foreach (DataGridViewColumn GridCol in dataGridView1.Columns)
                            {
                                e.Graphics.FillRectangle(new SolidBrush(Color.LightGray),
                                    new Rectangle((int)arrColumnLefts[iCount], iTopMargin,
                                    (int)arrColumnWidths[iCount], iHeaderHeight));

                                e.Graphics.DrawRectangle(Pens.Black,
                                    new Rectangle((int)arrColumnLefts[iCount], iTopMargin,
                                    (int)arrColumnWidths[iCount], iHeaderHeight));

                                e.Graphics.DrawString(GridCol.HeaderText, GridCol.InheritedStyle.Font,
                                    new SolidBrush(GridCol.InheritedStyle.ForeColor),
                                    new RectangleF((int)arrColumnLefts[iCount], iTopMargin,
                                    (int)arrColumnWidths[iCount], iHeaderHeight), strFormat);
                                iCount++;
                            }
                            bNewPage = false;
                            iTopMargin += iHeaderHeight;
                        }
                        iCount = 0;
                        //Draw Columns Contents                
                        foreach (DataGridViewCell Cel in GridRow.Cells)
                        {
                            if (Cel.Value != null)
                            {
                                e.Graphics.DrawString(Cel.Value.ToString(), Cel.InheritedStyle.Font,
                                            new SolidBrush(Cel.InheritedStyle.ForeColor),
                                            new RectangleF((int)arrColumnLefts[iCount], (float)iTopMargin,
                                            (int)arrColumnWidths[iCount], (float)iCellHeight), strFormat);
                            }
                            //Drawing Cells Borders 
                            e.Graphics.DrawRectangle(Pens.Black, new Rectangle((int)arrColumnLefts[iCount],
                                    iTopMargin, (int)arrColumnWidths[iCount], iCellHeight));

                            iCount++;
                        }
                    }
                    iRow++;
                    iTopMargin += iCellHeight;
                }

                //If more lines exist, print another page.
                if (bMorePagesToPrint)
                    e.HasMorePages = true;
                else
                    e.HasMorePages = false;
            }
            catch (Exception exc)
            {
                MessageBox.Show(exc.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
        #endregion

modified 2-Oct-20 1:56am.

Gerry Schmitz1-Oct-20 19:11

1-Oct-20 19:11

You didn't wire up your printing event handlers.

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

Member 149437371-Oct-20 22:54

Member 14943737

1-Oct-20 22:54

Works great now. Thanks for the help.

OriginalGriff1-Oct-20 20:03

1-Oct-20 20:03

As Gerry has said, you need to add the handlers:

PrintDocument printDocument1 = new PrintDocument();
printDialog.Document = printDocument1;
printDocument1.BeginPrint += printDocument1_BeginPrint;
printDocument1_PrintPage += printDocument1_PrintPage;

But when you post a large chunk of code, please use the code widget to insert the pre tags - it preserves formatting and engages the appropriate syntax highlighter. I added them to your post, but without the you get this:

if (bMorePagesToPrint)
e.HasMorePages = true;
else
e.HasMorePages = false;

With them you get this:

                if (bMorePagesToPrint)
                    e.HasMorePages = true;
                else
                    e.HasMorePages = false;

which is a whole load more readable for everyone!
All the tags look like in a post is this:

<pre lang="cs">                if (bMorePagesToPrint)
                    e.HasMorePages = true;
                else
                    e.HasMorePages = false;</pre>

Member 149437371-Oct-20 22:37

Member 14943737

1-Oct-20 22:37

Thanks for the tips. I am new to this. Will do it next time when I post codes in here. Thanks again.

OriginalGriff1-Oct-20 22:40

How to compare on DPFP.Template to another DPFP.Template

1-Oct-20 22:40

You're welcome!

Member 144684061-Oct-20 3:07

Member 14468406

1-Oct-20 3:07

I want tout compare templates between them stored in my database.
Can you help me please

This is an example:

if (template1 == template2)
{
MessageBox.Show("Fingerprint matched");
}

Re: How to compare on DPFP.Template to another DPFP.Template

Gerry Schmitz1-Oct-20 4:49

Re: How to compare on DPFP.Template to another DPFP.Template

1-Oct-20 4:49

What's the template made out of? Ink? A finger print template?

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

Member 144684061-Oct-20 8:39

Member 14468406

1-Oct-20 8:39

A fingerprint template in c#

I want to compare fingerprints between them. The templates are already stored in MySQL database.

streamCompare = new MemoryStream((Byte[])lignemysql["FingerprintRight"]);
TemplateCompare = new DPFP.Template(streamCompare);

ImmatriculationCompare = (String)lignemysql["Immatriculation"];

foreach (DataRow lignemysqlTemp in tablemysqlTemp.Rows)
{
if (lignemysqlTemp["FingerprintRight"] != DBNull.Value)
{
streamTemp = new MemoryStream((Byte[])lignemysqlTemp["FingerprintRight"]);
TemplateTemp = new DPFP.Template(streamTemp);

if (TemplateCompare == TemplateTemp)
{
MessageBox.Show("Fingerprints matched"]);
}

}
}

I want you to help me please

Re: How to compare on DPFP.Template to another DPFP.Template

Gerry Schmitz2-Oct-20 4:31

Re: How to compare on DPFP.Template to another DPFP.Template

2-Oct-20 4:31

Read the links too.

How to verify Finger print template with the SQL Server

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

Member 144684062-Oct-20 20:35

Member 14468406

2-Oct-20 20:35

Hi dear Gerry
I already Know to verify fingerprint template with MySQL or SQL Server.
But my problem is how to check if there are duplicate fingerprints template saved on the database without placing the finger on the fingerprint reader.
Would you help me please

Re: How to compare on DPFP.Template to another DPFP.Template

Gerry Schmitz3-Oct-20 3:11

Copy DataTable into a Ms Access table

3-Oct-20 3:11

If you want to determine "duplicates" (and figure out how), then add a known duplicate and compare it with the original.

The template has "properties", including a byte array that you can compare.

http://www.warf.com/download/5744_9677_One%20Touch%20for%20Windows%20SDK%20.NET%20Developer%20Guide.pdf

c# - Checking equality for two byte arrays - Stack Overflow

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

modified 3-Oct-20 9:27am.

Member 1464251030-Sep-20 21:31

Member 14642510

30-Sep-20 21:31

I need to copy a DataTable inside another table (MS Access) which has the same structure. I did this:

DataTable dtBit = new DataTable(); 
dtBit.TableName= "Macchine_Bit"; 

using (OleDbCommand cmd = new OleDbCommand("SELECT * FROM [Macchine_Bit] ORDER BY [FIELD_ID]", cnn))
{
	using (OleDbDataAdapter da = new OleDbDataAdapter(cmd))
	{
		da.MissingSchemaAction = MissingSchemaAction.AddWithKey;
		da.Fill(dtBit = new DataTable());
	}
}

When I got my DataTable, I open a connection to another mdb file and try to put the contents of dtBit table into another:

cnn.ConnectionString = String.Format(myConnectionString, mdbCopyName);
cnn.Open();

using (OleDbDataAdapter a = new OleDbDataAdapter("SELECT * FROM [Macchine_Bit]", cnn))
{
	OleDbCommandBuilder cb = new OleDbCommandBuilder(a);
	a.MissingSchemaAction = MissingSchemaAction.AddWithKey;
	a.InsertCommand = cb.GetInsertCommand();
	a.DeleteCommand = cb.GetDeleteCommand();
	a.UpdateCommand = cb.GetUpdateCommand();
	a.TableMappings.Add("Macchine_Bit", "Macchine_Bit");                

	DataTable dtBit2 = new DataTable();
	a.Fill(dtBit2);

	dtBit2.Merge(dtBit);
	a.Update(dtBit2);
}

Basically no rows are written. What's wrong with my code? I got non error

Re: Copy DataTable into a Ms Access table

OriginalGriff30-Sep-20 21:59