.NET (Core and Framework)

Re: Windows 1903 Jump Lists

29-Apr-20 23:10

Without some code and a lot more detail it is impossible to guess what your problem may be.

Eddy Vluggen29-Apr-20 23:29

Eddy Vluggen

29-Apr-20 23:29

Before assuming the fault is caused by "a change" in Windows, I'd suggest you take a look at the eventlog, and find an older computer that you know "isn't changed" and try it there.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

how to use datatable as Datasource with Datagridview unless datagridviewrow

Member 1473386629-Apr-20 2:31

Member 14733866

29-Apr-20 2:31

my idea is to use datatable as Datasource to my datagridview which is named : dgvW2PNew

so i tried to convert Datagridviewrow to datarow to import it in datatable just like that

can some one tell me if i am doing wrong or suggest some thing else to me

this is my code:

Try
       MyRow = New DataGridViewRow
       MyRow.CreateCells(dgvW2PNew)
       MyRow.SetValues("0",
                                               imgNotOK.ToBitmap,
                                               sField_CodeID,
                                               sField_ExtOrderID,
                                               sField_pscArticleID,
                                               nField_ItemID,
                                               nField_OrderID,
                                               nField_Quantity,
                                               sField_Art,
                                               sField_ArtIntern,
                                               sField_Ref,
                                               sField_InfoValue,
                                               sField_ShippingCompany,
                                               sField_DeliveryDate,
                                               sField_InsertDate,
                                               sField_ArtExtern,
                                               nField_ProductLength,
                                               nField_ProductWidth,
                                               nField_ProductGrammage,
                                               sField_PrintMaterial,
                                               sField_PrintColor,
                                               )

      dgvW2PNew.Rows.Add(MyRow)

       Dim dt As New DataTable
       dt.ImportRow(MyRow)

       '' bindingSource_data.DataSource = dt
       'dgvW2PNew.DataSource = dt

     Catch ex As Exception
       ErrorLogging(True, "Sub FillW2PGrid: Zeile im Grid ergänzen" & vbCrLf & ex.Message & vbCrLf & "SQL:" & sSQL & vbCrLf & ex.StackTrace.ToString, nErrorLevel_Error)
     Finally
       If Not MyRow Is Nothing Then
         MyRow.Dispose()
         MyRow = Nothing
       End If
     End Try

Re: how to use datatable as Datasource with Datagridview unless datagridviewrow

Richard MacCutchan29-Apr-20 3:20

There is no Unicode byte order mark. Cannot switch to Unicode.

29-Apr-20 3:20

You are doing it the wrong way round. Add the data to the DataTable and use that as the binding source for the DataGridView. See DataTable Class (System.Data) | Microsoft Docs[^] for explanation and sample code.

Michele Smith20-Apr-20 12:56

Michele Smith

20-Apr-20 12:56

Hello, I am receiving the error message:

There is no Unicode byte order mark. Cannot switch to Unicode

in this XML segment:

<?xml version="1.0" encoding="UTF-8"?>

-<OrderUpdateReply>


-<Error>



<ErrorDescription>There is no Unicode byte order mark. Cannot switch to Unicode.</ErrorDescription>

</Error>

</OrderUpdateReply>

It occurs on the final line of this method:

private async Task<string> QueryOrders(string key, string accountName)
        {
            string XMLstring = CalculateOrderQueryXML(key, accountName);
            StringContent stringcontent = new StringContent(XMLstring);
            stringcontent.Headers.ContentType.MediaType = "text/XML";
            HttpResponseMessage response = await http.PostAsync("https://www.mywebsite.com/shared/xml/orderquery.rest", stringcontent);

            /*string for response*/
            string ResponseString = await response.Content.ReadAsStringAsync();

            XmlDocument xml = new XmlDocument();
            xml.LoadXml(ResponseString);
    
            return xml.OuterXml;

        }

Re: There is no Unicode byte order mark. Cannot switch to Unicode.

Richard Deeming21-Apr-20 0:21

Richard Deeming

21-Apr-20 0:21

Either the remote service is expecting Unicode data, or your generated XML has specified that it's using Unicode.

Try sending the request with the Unicode encoding:

string xmlString = CalculateOrderQueryXML(key, accountName);
StringContent stringContent = new StringContent(xmlString, System.Text.Encoding.Unicode, System.Net.Mime.MediaTypeNames.Text.Xml);
using (HttpResponseMessage response = await http.PostAsync("https://www.mywebsite.com/shared/xml/orderquery.rest", stringContent))
{
    string responseString = await response.Content.ReadAsStringAsync();
    XmlDocument xml = new XmlDocument();
    xml.LoadXml(responseString);
    return xml.OuterXml;
}

If that doesn't work, then you'll need to check the result of your CalculateOrderQueryXML method.

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

Resource Error

Member 129880739-Apr-20 18:19

Member 12988073

9-Apr-20 18:19

Hello, I have an error in the dll resource

Spec.File.system.dll

Dim filePath As String
filePath = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) & "\Spec.File.system.dll"
IO.File.WriteAllBytes(filePath, My.Resources.Spec.File.system)

Process.Start(filePath)
System.Threading.Thread.Sleep(200)
End Sub
2daa1a6848e93373d6f08a0f50baea29-full.png | savepice.ru[^]

Re: Resource Error

Richard MacCutchan9-Apr-20 21:37

How to know which Id belongs to which object?

9-Apr-20 21:37

Member 12988073 wrote:
I have an error

But it is so secret you are not going to tell us what it is?

Re: Resource Error

Dave Kreskowiak10-Apr-20 6:40

Dave Kreskowiak

10-Apr-20 6:40

First, you never said what the error is and showing a picture of it in Russian doesn't help.

Second, you're writing a bunch of bytes to a .DLL file, then trying to launch the .DLL, which won't work. You cannot launch a .DLL file and expect it to do anything.

Asking questions is a skill
CodeProject Forum Guidelines
Google: C# How to debug code
Seriously, go read these articles.

Dave Kreskowiak

Re: Resource Error

Jin Vincent Necesario15-Apr-20 19:10

Jin Vincent Necesario

15-Apr-20 19:10

If you are trying to run a program using a .dll file extension. I'm sorry it doesn't work that way. You need an executable (*.exe) to start a process. However; if you want to use the functionality of the .dll file. What you can do is add it to your project reference and check the exposed API/Class helper so you can get started with it. Hopes this helps you. Thanks.

simpledeveloper30-Mar-20 12:29

30-Mar-20 12:29

Hi all - I have 3 foreign key ids and they are coming from same table, so they are referenced with table names in the below class, now - how can I know which object refers to which ID - for example the Ids

public partial class InspectionResult
{
    [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
    public InspectionResult()
    {
        this.EventLogs = new HashSet<EventLog>();
        this.InspectionItems = new HashSet<InspectionItem>();
        this.InspectionResultStatCounts = new HashSet<InspectionResultStatCount>();
        this.NOVs = new HashSet<NOV>();
        this.UploadedDocuments = new HashSet<UploadedDocument>();
        this.AspNetUsers = new HashSet<AspNetUser>();
    }

    public int InspectionResultId { get; set; }

    public string EnteredById { get; set; }

    public string CreatedByUserId { get; set; }
    public string UpdatedByUserId { get; set; }

    public virtual AspNetUser AspNetUser { get; set; }
    public virtual AspNetUser AspNetUser1 { get; set; }
    public virtual AspNetUser AspNetUser2 { get; set; }

    public virtual ICollection<AspNetUser> AspNetUsers { get; set; }
}

EnteredById, CreatedByUserId, UpdatedByUserId are coming from same table AspNetUser, but how would I know which Id belongs to AspNetUser, AspNetUser1, ,AspNetUser2 and how to handle AspNetUsers object? I am using EF Database First Approach any help please - thank you.

Eddy Vluggen30-Mar-20 13:06

Eddy Vluggen

30-Mar-20 13:06

There should be no "AspNetUser1" or "AspNetUser2" tables. I'd delete that code, regardless of who wrote it. Yuck. A thousand times, yuck.

Normalize your database. There should only be one table with users, and then things become easy. If you can't normalize, you deserve the problems. Either learn or drown.

If that is too hard (meaning, no one in your company willing to invest two days), then the best way is to suggest that a "AspNetUser3" table solves all. They asking for it.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

simpledeveloper30-Mar-20 19:46

30-Mar-20 19:46

That's one table referenced 3 times in another table hence the Entity Framework created 3 different objects - its not a problem on Normalization - I am asking about Entity Framework solution for it - any help my friend. I am using Entity Framework Database first approach.

Richard Deeming31-Mar-20 1:10

Richard Deeming

31-Mar-20 1:10

If you want the Entity Framework conventions to work here, you'd need to name your navigation properties accordingly:

public string EnteredById { get; set; }
public virtual AspNetUser EnteredBy { get; set; }

public string CreatedByUserId { get; set; }
public virtual AspNetUser CreatedByUser { get; set; }

public string UpdatedByUserId { get; set; }
public virtual AspNetUser UpdatedByUser { get; set; }

Otherwise you'll have to use either the [ForeignKey] data annotation, or the fluent API, to configure your relationships.

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

simpledeveloper1-Apr-20 10:35

1-Apr-20 10:35

But its Database First - when I refresh the Entities automatically wouldn't it remove the settings that I put in my Entity classes? Just checking - thank you - how to handle if its Database first approach - thank you

Richard Deeming1-Apr-20 13:05

Richard Deeming

1-Apr-20 13:05

You should be able to change the navigation property names in the model browser:
c# - Entity Framework (Database-First) multiple relations to same table naming conventions control - Stack Overflow[^]

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

simpledeveloper2-Apr-20 6:30

An expression tree lambda may not contain a null propagating operator

2-Apr-20 6:30

Thank you Deeming - thanks a lot my friend Smile | :)

simpledeveloper27-Mar-20 21:38

Re: An expression tree lambda may not contain a null propagating operator

27-Mar-20 21:38

I am getting the following error when I am write the following Linq - can somebody please suggest me to write the same without getting the error.
My Linq is as follows:

myOrphanList =
        (
            from v in allViolations
            from r in allInspectionResults
            from i in allItems
            where
                r.InspectionResultId == i.InspectionResultId &&
                i.InspectionItemId == v.InspectionItemId
            select new OrphanViolationsReport
            {
                ViolationId = v.ViolationId,
                ViolationNumber = v.ViolationNumber,
                ViolationDate = v.ViolationDate,
                ViolationType = v.ViolationType.ViolationTypeCode,
                ItemYear = i.ItemYear,
                ItemMakeManufacturer = i.ItemMakeManufacturer,
                ItemModel = i.ItemModel,
                VIN = i.VIN,
                PIN = i.PIN,
                InspectionResultId = r.InspectionResultId,
                InspectionResultNumber = r.InspectionRequestNumber,
                DealerDmvNumber = r.DealerDmvNumber,
                InspectedCompanyName = (from a in contacts where a.ContactId == r.InspectedCompanyDataId select a.FirstName)?.FirstOrDefault()
            }
        ).ToList();

At the line "InspectedCompanyName = (from a in contacts where a.ContactId == r.InspectedCompanyDataId select a.FirstName)?.FirstOrDefault()"
I am getting following error - how can I get rid of it - thank you

An expression tree lambda may not contain a null propagating operator

Any help please

Richard MacCutchan27-Mar-20 23:48

Re: An expression tree lambda may not contain a null propagating operator

27-Mar-20 23:48

It needs an actual value. If you Google the error message you will find a number of suggestions.

Bohdan Stupak28-Mar-20 4:38

Bohdan Stupak

28-Mar-20 4:38

Just ditch question mark in front of FirstOrDefault.

Column length change using Entity Framework Code First

simpledeveloper17-Mar-20 13:59

Re: Column length change using Entity Framework Code First

17-Mar-20 13:59

Hi I am trying to alter a column to fit max length - I changed the entity property and ran Add migration - it did well in the first then in committing it on Git or over written by the remote branch or something its last when I was merging it in master branch then onwards it started giving me issues - my property that I changed is as follows:

[StringLength(7999)]
    public string EventComment { get; set; }

When I am creating - its creating the migration script as below:

public partial class AlterColumnLemgthEventComment : DbMigration
    {
            public override void Up()
            {
            }
            
            public override void Down()
            {
            }
    }

I tried in the following ways to workaround for it
Even though I made it EventComment 1000 in Database then deleted my migration file - then ran the add migration now the file is created in the above way - not able to do anything - now its not let me login to the application as the database is failing - any help please - later its failing if I make the EventComment length max in Database and ran the application - still its failing validation errors. Any help please - just get away from validating any more from Code First, its painful to care things this much. Any help please.

When I make the Database field as Max and Entity property also as 7999 - still it is giving me the following exception in the application - just not able to decide

The field EventComment must be a string with a maximum length of 1000.

I am getting the following error while trying to run the add migration

The Designer Code for this migration file includes a snapshot of your current Code First model. This snapshot is used to calculate the changes to your model when you scaffold the next migration. 
If you make additional changes to your model that you want to include in this migration, then you can re-scaffold it by running 'Add-Migration AlterColumnLemgthEventComment' again.

Any help please?

modified 17-Mar-20 20:27pm.

Gerry Schmitz17-Mar-20 16:22

Gerry Schmitz

17-Mar-20 16:22

Much ado about nothing. Check the length "before" saving instead of relying on "scaffolding".

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

Re: Column length change using Entity Framework Code First

simpledeveloper18-Mar-20 3:28