Microsoft Development Help & Support

Need .NET Framework VDI / VM Preconfigured

Are there VDI's where Visual Studio / SQL Server / Source Code Management

come pre-installed? That would save me some potential aggravation...

Thanks

4 Comments

C#: Please explain relationship between "async" and "await"

I generally see how this code works:

https://docs.microsoft.com/en-us/dotnet/csharp/programming-guide/concepts/async/

but need a better understanding of when to use both "async" and "await" together. I was a little confused by the transition of one paradigm to the the better paradigm in this one example...so, a simple explanation would be helpful.

Thanks.

3 Comments

Need to install Node.js on my Windows 10 .NET Development machine

I need to install Node so I can install jsinspect so I can find code duplication that got there through heavy us of copy-paste.

I have worked with Node in the past. But, I want to be 100% sure I am not going to in any way harm my Windows PC, since that is my bread-and-butter machine.

Can you provide me the safest set of steps to do this?

Thanks

2 Comments

Need an automation test tool for QA testers

We are considering Selenium...

I need a test tool for non-programmers, because i need the following:

- The first test on a new feature is done by a human
- Before they start the test, the QA tester clicks the Start button.
- The QA tester clicks on various controls and enters various amounts of information
- The tester adds Assertions to the test script, that will be used by the automation to Pass or Fail the test
- When the test is done, the QA testers clicks Done

This is what I want. Does Selenium do this? Any programming required?

Or, are the other tools?

Not sure if it matters, but this is a .NET Framework website...

Thanks

4 Comments

LVL 1

Question by

mastiSoft

2020-01-15Solved

image as circle

Hi, I have an question about what language or technology I can use to do following.
Let say I have an image normally shows as rectangle with height and width.
I need to transform this image into circle . The same bitmap but not rectangular form but circle form.
Can you suggest what I can use to do this. I program in C#, C++, vb using Visual Studio 2019. If I
need to use another language it is no problem.

13 Comments

Office applications have numerous Task Panes. I need to determine which are open/visible. Some are activated via ribbon toggle buttons and/or dialog box launchers while others are activated with buttons.

I can detect those activated with toggle buttons as in this example:

bSelectionPaneOpen = CommandBars.GetPressedMso("SelectionPane")

Open in new window

This doesn;t actually get the state of the task pane but the toggle button associated with it.

Conversely, I cannot do the same for those activated with a button. This example fails because the button isn't a toggle:

bFormatPaneOpen = CommandBars.GetPressedMso("ObjectFormatDialog")

Open in new window

Is there a way to return the visible state of task panes that are activated via buttons?

Word has a TaskPane object but Excel and PowerPoint don't :-(

lTaskPanes = Application.TaskPanes.Count

Open in new window

1 Comment

I am administering NetBox v2.5. Browse the following link to get a basic introduction to NetBox if you are not familiar. I need to sync VMware 6x with NetBox for the purpose of capturing vCenter inventory of all VMs across all clusters and datacenters. Scripting is an option, but I prefer to avoid scripting the task. Based on my research, I believe there is a module within NetBox to achieve this objective. Is there a way to configure NetBox without scripting the task.

Thank you.

Lipotech

2 Comments

Does Entity Framework sometimes auto-convert DateTime to EST?

My Javascript call is making an MVC call to a C# web method with a date that is set to midnight. But, when I query the database, I see the correct date was added to the DB table, as expected. However, there is time added, and it turns out to be UTC time:

I am on the East Cost of the US and am currently 4 hours behind UTC/GMT.

Here is the format of the data:

2019-11-01 04:00:00.000

I was expecting:
2019-11-01 00:00:00.000

Since, the JSON date/time I am passing in was at midnight.

Is there a setting in Entity Framework which may cause this?

Or, is there a JSON parser doing this?

Thanks

21 Comments

Using Word 2019 (for Mac) Need to set a word's color

I have a word that repeats hundreds of times and in dozens of point sizes. But I need to make every instance of that word the same color.

What kind of automation is there for that?

Thanks.

4 Comments

Trouble adding comma to bar graph data using Windows Chart Class

I am using the library:
System.Windows.Forms.DataVisualization.Charting

and found I could format (with comma) for values > 1,000

with this line of code:
ca.AxisY.LabelStyle.Format = ("##,#");

But, I can't figure out how to get the data to display also with the comma.

Best I get is the following:

Here is the Microsoft reference document:
https://docs.microsoft.com/en-us/dotnet/api/system.windows.forms.datavisualization.charting.chart?view=netframework-4.0

5 Comments

Hi,
I am using VS2017 with TFS. I can see files in my local repository but they do not display in Solution Explorer,
see below

any guidance appreciated,
thanks

1 Comment

Noob to APIs here, so please bear with me.

I need to send an API request to Office 365 to assign a new user. Can someone help point me in the right direction for the command, or the builder, so that I can get the correct API (URL) request?

For example, I need to assign user 'John Smith' a new license in O365.

Thanks for the help! Any links to tutorials on the how-to for this would be greatly appreciated as well!

4 Comments

Hello Experts

I am trying Use wildcards (or other method) to Unzip a file in C# where the file name can be found based on first part of text only. So far am unable to accomplish this.

For example I have the following code:

string targetDirectory = @"C:\TestDirectory";
string zipFile = @"C:\TestDirectory\Test_09/20/2019.ZIP";
ICSharpCode.SharpZipLib.Zip.FastZip fz = new ICSharpCode.SharpZipLib.Zip.FastZip();
fz.ExtractZip(zipFile, targetDirectory, "");

This code works fine to unzip files as long as the exact zipped file name is listed...

I want to be able to use wild cards or other method to unzip a file called Test_09/20/2019.ZIP without the program having to know about the _09/20/2019 part of the file.

In other words I would like to unzip a Test_"Any date or other text".ZIP file by only knowing about Test.ZIP a the file name.

I tried Test*.ZIP in the above code but the * was an unrecognized character.

Does anyone know how to do this?

Thanks!

1 Comment

Hi there,

I haven't used Access in a while and I'm trying to help someone make some changes to their current Access DB forms. In a few forms, there is a border around some fields, which is preventing me from moving the fields around or even insert new ones. Attached is a picture of what I'm seeing. Can someone please help?? I'm stuck!

Thanks,
- Christian
Access-Border.JPG

11 Comments

I have C# program that has multiple classes. how can I create a really global variable that can be accessed by any class and change the value before passing it to another class.

3 Comments

I am trying to fill a combo Box with a list of items from a SQLite DB.
have been using/following with this https://docs.microsoft.com/en-us/windows/uwp/data-access/sqlite-databases#choose-an-abstraction-layer

SO in my
DataAcsess.cs Class i have

 public static List<String> ProductList()
        {

            List<String> entries = new List<string>();

            using (SqliteConnection db =
                new SqliteConnection("Filename=DataStorage.db"))
            {
                db.Open();

                SqliteCommand selectCommand = new SqliteCommand
                    ("SELECT DOTProductname from QPL", db);

                SqliteDataReader reader = selectCommand.ExecuteReader();

                while (reader.Read())
                {
                    entries.Add(reader.GetString(0));
                }
            
                db.Close();             
              
            }

            return entries;
        }

Open in new window

(which I am not sure what it is doing)

then i have a

I have my XAML:

                    <ComboBox  x:Name="PName" HorizontalContentAlignment="Center" MinWidth="140" ItemsSource="{Binding}">

                    </ComboBox>

Open in new window

(not sure how i get the item source to work)

and finally my

XAML.CS code:

            
  private void ProductList(object sender, RoutedEventArgs e)
        {
          ComboBox.ItemsSource = DataAccess.ProductList();
        }

Open in new window

Which is throwing some errors because i am not understanding what is required.

How is the standard method to get the query convert it to a item
and then put a foreach item loop to add to my combo box or similar?
appreciate your help in advance.

1 Comment

I re-organized my UWP app. I created a set of folders in the solution explorer and moved the XAML files around accordingly.
I go to recreate my menu items and i run into a trouble where it doesn't recognize some of the new folders and some of the new files.
Is there a way to clean out the old references to make way for a new one? see pictures for details

1 Comment

Hi EE,

This question is more of a query looking for approaches to resolve the following issue:

The user has an SSRS 2016 report and filters the datasets efficiently with filters they have been given.

However, the user wants to save specific rows within the report to key the data into another system e.g Desktop application. Exporting initial the result set data to XML result is a simple task. My question is can you have a button on the SSRS which launches a subform that asks what rows /columns specifically do you want to save from the resultset in XML format. Completing the necessary criteria on the subform, SSRS exports the data to the user via a download.

Is this possible in SSRS if so are there examples out there?

Any links or tips, advice are welcome.

Thank you.

2 Comments

Correct philosophy/topology for SQLite syncing back to Azure.
And querying items in Azure/storing in SQLite
I have just learn that in UWP you cannot store a .DB file in the solution and connect to it with code, instead the .db file is created in a place in appdata when the app is started.
This means I cannot load up the .DB file prehand with lots of data to be used by the app. This must mean the .DB file needs to “sync” in someway to the main data storage this is touched on in this Microsoft doc
https://docs.microsoft.com/en-us/azure/app-service-mobile/app-service-mobile-windows-store-dotnet-get-started-offline-data

My question is what is the correct philosophy/topology to obtain data stored in Azure interact with that data in a UWP app and then sync that data back up to Azure?

2 Comments

THis is a duplicate question that i asked on a reddit subforum.
but without much response.
https://www.reddit.com/r/UWP/comments/cth82z/is_it_just_me_or_is_there_not_1_single_good_guide/

Iv been looking for weeks to find a comparable guide on using a UWP app with SQLite. All the guides i find are either out of date or using nugget packages that no longer exist. or provide super complex methods.

Im using VS 2019 Community

with this: https://www.nuget.org/packages/Microsoft.EntityFrameworkCore.Sqlite/

Trying to connect to a local .DB file

Maybe i am just not googling the correct words?

Does anyone know of a good resource that demonstrates how to connect to a local .DB file submit entry's and retrieve entry's?

7 Comments

Hi,

I have set up a very simple update panel page as I was getting a full postback each time on a new site I have set up in VWD, it refuses to update just the update panel, but if I copy over the page to the older site it works fine.

They have identical web configs and I'm not using a master page so no interference there.

Same on the live server, one work, one doesn't - any ideas?

Cheers
Karl

6 Comments

Hello all,
I am writing a DLL (in windows), with a function that needs a lot of stack size.
The problem is that I am not creating the thread.
So is there a way to change the stack size while the thread is running ?
Alternatively, is there a way to "catch" thread creation, and vrify that the stack size is big enough ?

Thanks
zmau

9 Comments

So I am trying to connect Office 365 and WebMerge together so that data can be extrapolated from Excel. How exactly does this whole API process work. Do both applications need to typically have an API id and secret or just one? What exactly is an API and how does it work?

8 Comments

Hi EE,

For the following function borrowed from the following site: http://www.kodyaz.com/articles/fuzzy-string-matching-using-levenshtein-distance-sql-server.aspx

CREATE FUNCTION edit_distance(@s1 nvarchar(3999), @s2 nvarchar(3999))
RETURNS int
AS
BEGIN
 DECLARE @s1_len int, @s2_len int
 DECLARE @i int, @j int, @s1_char nchar, @c int, @c_temp int
 DECLARE @cv0 varbinary(8000), @cv1 varbinary(8000)

 SELECT
  @s1_len = LEN(@s1),
  @s2_len = LEN(@s2),
  @cv1 = 0x0000,
  @j = 1, @i = 1, @c = 0

 WHILE @j <= @s2_len
  SELECT @cv1 = @cv1 + CAST(@j AS binary(2)), @j = @j + 1

 WHILE @i <= @s1_len
 BEGIN
  SELECT
   @s1_char = SUBSTRING(@s1, @i, 1),
   @c = @i,
   @cv0 = CAST(@i AS binary(2)),
   @j = 1

  WHILE @j <= @s2_len
  BEGIN
   SET @c = @c + 1
   SET @c_temp = CAST(SUBSTRING(@cv1, @j+@j-1, 2) AS int) +
    CASE WHEN @s1_char = SUBSTRING(@s2, @j, 1) THEN 0 ELSE 1 END
   IF @c > @c_temp SET @c = @c_temp
   SET @c_temp = CAST(SUBSTRING(@cv1, @j+@j+1, 2) AS int)+1
   IF @c > @c_temp SET @c = @c_temp
   SELECT @cv0 = @cv0 + CAST(@c AS binary(2)), @j = @j + 1
 END

 SELECT @cv1 = @cv0, @i = @i + 1
 END

 RETURN @c
END

Open in new window

How do I convert this so it reads a column of values pseudo code example:

DECLARE @TableCOLUMN VARCHAR(200);

SET @TableCOLUMN='ContainerID';

with cte AS; (select TrackingID
from table 1
where var1 = 'ASDF1234' and var2 ='LKJH9786')

-- This Returns a Single TrackingID.

select * dbo.edit_distance(CTE, @COLUMN) any values in the column 'ContainerID' that have distance of more than 2 as compared with CTE.

I hope this makes sense.

Any assistance is welcome.

Thank you

4 Comments

Hi,

I d like to see an example of a public Azure Devops Powershell project.
Specifically the Boards I d like to see how that is arranged.

That way I know howto start organizing my project into Azure Devops Boards (what kind of items are put in an epic, what in sprints, what with features or items that have no specific date of implementatie etc.

There is a lot on documentation but that doesn't tell anything of there isn t a good example.

Thanks!

Thanks,
J

1 Comment

Microsoft Development

Related Topics

Microsoft Development

Related Topics