This is Windows Forms, C#.

I have a Dataset with 3 datatables.  For datatable ST_MER_POS_Product_Online_List_AA, I want to only keep the rows that have been changed.

1. This is is how I check if the datatable has rows changed:

                  var ttest = IsDataSetChanged(Onlineds); //**** check to see if row is changed
                //var p = Onlineds.ST_MER_POS_Product_Online_List;

               ws.UpdateOnlineProducts_AA(Authorize.MAC_IDs, Onlineds); //call to update 
                this.Onlineds.AcceptChanges();

Select all Open in new window

2. Check to see if row has changed or not

 public bool IsDataSetChanged(DataSet m_DSet)
        {
            if (m_DSet == null)
                return (false);

            foreach (DataTable dt in m_DSet.Tables)
            {
                foreach (DataRow dr in dt.Rows)
                {
                    if (dr.RowState != DataRowState.Unchanged)
                        return (true);
                    
                }
            }
            return (false);
        }

Select all Open in new window

3. I  tried dr.Delete(); but I think it deleted all the rows

 public DataSet IsDataSetChangedOnlineProduct(DataSet m_DSet)
        {
            if (m_DSet != null)
            {
                foreach (DataTable dt in m_DSet.Tables)
                {
                    //var p = dt.Rows.Count;

                  //  var p = dt.GetChanges();

                    foreach (DataRow dr in dt.Rows)
                    {
                       if (dr.RowState == DataRowState.Unchanged) 
                       {
                          dr.Delete();

                       }



                    }
                }

                m_DSet.AcceptChanges();

                return m_DSet;
            }


            return m_DSet;
        }

Select all Open in new window

How can I do this?

I understand that this is not easy to debug and help with but I'm posting some screenshots...hopefully someone can give me an idea where to look and how to do this...

(My first day of working with Crystal Reports and I'm not a CR developer )

1. The report looks like this. You see the tab "Main Report"? I want to add another tab but I don't know how this tab is built. I did a search in the code for "Main Report" and I don't find it. Did a search in stored procs and I don't see "Main Report". Did a search in our Web Services code and I don't see the word "Main Report"

2. The report itself looks like this and I see the file


3. This is the Windows Forms that's the container. Maybe I need to check all the User Controls but still....where is that tab coming from?


It's ok if no one can help.  I know it's hard to debug it without the code. I can ask my manager if it's ok to give the code and someone here could tell us how this all comes together.

Working on my first Crystal Report code. It was done by another developer and now I have to make changes to it.

The datasource is a stored proc. I added a new column.

How can I bind the column from the stored proc to the field? The other fields are already there. It's the Phone field I need to add.

I'm planning to get the first letter of  a sentence ignoring propositions like "in , of, etc
For example  The Planning Group of USA. Only what I want to get are  PGU omitting "The" and"of" , or "in" if it shows in C#.

I'm having to support an ancient VB6 application. Currently, I'm writing a COM object class for it. Everything works except for assigning a value to a property. This particular property needs to behave like a VB6 variant data type when used in VB6 code.

I have the simplest little class in C#

    [ComVisible(true)]
    [Guid("1EB35E9B-60EE-4A26-BAEB-6A2D7AC32FF0")]
    [ClassInterface(ClassInterfaceType.AutoDual)]
    public class FooThingy
    {
        private object _value;

        public object Value
        {
            get
            {
                return _value;
            }
            set
            {
                _value = value;
            }
        }

        public FooThingy()
        {

        }
    }

Select all Open in new window

And I call it via the simplest VB6 code. I have added line numbers for easy reference.

Public Sub Main()
    
1    Dim foo As FooThingy
2    Set foo = New FooThingy
3    If (foo.value <> "hello") Then
4        foo.value = "Testing"
5    End If

End Sub

Select all Open in new window

At line 4 it fails with a runtime error 424 "Object required" yet line 3 evaluates with no problem. I know VB6 has this weird distinction between Property Let and Property Set and I'm guessing that is somehow related. What I need to figure out is how do I get my C# class to work with the VB6 code above. Perhaps there's some kind of marshaling declaration that will do the trick? I'm really hoping there's an answer to this because my alternative is to go through this very old VB6 program that was very badly written and find all the places where assignment is being done and replace it with a SetValue() method call which DOES work.

Coding in ASP.NET and C#

Hello Experts,
I am trying to run a Windows Service job only once everyday at a time specified in App.Config file.  How can I use make use of Timer class?  As soon as the job is done, the job will go to sleep mode and again wake up next day.  Is there a simple way?

Here is the requirement.

 1. Process Schedule Task
    Add code to Process the task here
    .
    .

 2. Once the job is executed, reset next run to every 24 hours

Thank you very much in advance!

I have installed the visual studio 2019 community but after some days it showing that my license has expired and I cant use it. Weird because it’s a community edition so shouldn’t it be free? I have done a ton of things – restarted my pc, reinstalled but still the same issue. Can someone guide here…what’s going on?
Thanks
VS-weird-issue.png

I am working on a desktop application using C#, WPF, and .net core 3.1. I was reading on Microsoft's website that DataGrid was being deprecated and should be replaced with DataGridView in .net core 3.1 applications. The issue I am having is that it doesn't seem to actually be supported or at least according to Visual Studio 2019. First, the DataGrid tool still exists in the toolbox while DataGridView does not. In addition, even if I manually type the DataGridView code in VS2019, the code is shown as invalid code. I was looking online and have been having issues finding any info on this so I am guessing I am doing something wrong.

My question is what should I be using, DataGrid of DataGridView? Being it is a new application I would have preferred to use the most up to data version (DataGridView) so my code doesn't break in a year, but if I have to still use DataGrid, I will.

In C#, what are the differences between using a DataRow, a DataSet or a DataTable? Are these interchangeable? Are there advantages or disadvantages to using one over another? In the scenario I am working with right now I have a dataadapter tied to a command that queries a SQL table. I need to loop through each record and populate an Excel spreadsheet. Right now I have this and it works fine but is there a better, more efficient, way?

MyDataTable dt = new DataTable();                           /* Create the data table to hold the data */
MyDataAdapter = new System.Data.SqlClient.SqlDataAdapter(); /* Create the SQL Data Adapter to contain the returned data */
MyDataAdapter.SelectCommand = MyDataCommand;                /* Assign the SQL data command to the SQL data adapter */
MyDataAdapter.Fill(dt);                                     /* Populate the data table with the results of the query */

foreach (DataRow row in dt.Rows)
{
    Write record to Exel (row["DATA"].ToString())
}

Select all Open in new window

I have to code a c# solution to convert a txt file to xml using vs 2017.

What is the best way to do this task

Hi,
I have already done some webform development, however I am thinking of developing a new project and I think it makes no sense to use a technology that I think is becoming obsolete.
As I usually develop in .NET I thought about using Blazor, since I don't have many skills in java framework either.
It makes sense to choose blazor, or it would be better to choose asp.net core controls or another java framework. Will blazor succeed?

best regards

I'm working on a Windows Forms application/desktop written in 2002. Yes, you read that right.... Windows Forms that uses Crystal Reports.

We can't upgrade the code to web at this time. Too many clients on it and the owner doesn't want to invest in a web application.

We want to replace the Crystal Reports section of this application.

These are some of the options we've been talking about:

1. SSRS (a developer here said SSRS is being replaced)
2 . Power BI - how would this work with an old code like the one we have?
3. A developer here said we can write the stored procs and have one of the web developers design and code the pages. Custom web pages that act like reports. Don't think we can do this because clients are not setup for web. They all use our desktop application.

A developer here is pushing for Power BI. I don't know how it would work with Windows Forms/desk top.

Any ideas?

Hello Experts,
I have a Console App, which imports some data thru an API call.  In this all the methods are defined inside the Main().  I am trying to define some methods such as xxxSearch and XxxxDetail, return type List, outside of the Main() method.  When I do that, I am getting the Error: CS0120 An object reference is required for the non-static field, method, or property 'XxxxImport.XxxxSearch(DateTime, DateTime)'.

The reason I need to do this, because I need to convert this to a Windows Service Program comfortably.

Please let me know how to define them outside of Main() method and call them,

Thank you very much in advance.

Below is the Skeleton of the Code
----------------------------------------------------

public static void Main(string[] args)
{
    DataSet ds = new DataSet();

    var fromDate = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")).AddDays(-1);
    var toDate = DateTime.Parse(fromDate.ToString("yyyy-MM-dd")).AddDays(0);

    MainHub(fromDate, fromDate);

    Environment.Exit(0);


    void MainHub(DateTime FromDate, DateTime ToDate)
    {
      var xxxFound = xxxSearch(FromDate, ToDate);

      if (xxxFound != null)
      {
          InsertxxxRaw(xxxFound, FromDate);
      }

      foreach (var xxx in xxxFound)
      {
          var list = new List<string>();
          list.Add(xxx.xxxNumber);

          var details = xxxDetail(xxx.validatingxxxDesignator, list);

          if (details != null)
          {
            …