Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x

Microsoft Development

47K

Solutions

32K

Contributors

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Share tech news, updates, or what's on your mind.

Sign up to Post

I am getting one problem after installing visual studio community  2017 .It is not showing "NEW WEBSITE"' in File menu while opening new menu. i tried with tools-> import and export settings-> reset settings-> General development settings. Though 'new website' option is not showing for creating website application. Also I tried Command tool resetting all still NEW WEBSITE. Attach you will find screen shot. Merry Christmas, Happy New year and Thanks in advance.
Screenshot--2-.png
0
Restore individual SQL databases with ease
LVL 1
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Currently, we have a small team of accountants/bookkeepers whose occasional job it is to carefully review a merchant's credit card statement. The purpose is to find and add up all the charges on that month statement, as many are hidden and hard to decipher. Once the total is found, that amount is divided by total gross credit card sales to find the monthly aggregate transaction rate.

This number can be low, like 2.55%, but can be very high, particularly when sales are low. Monthly fixed charges can cause slow months to cost as mush as 10-12%!

Anyway, currently, experts do this analysis, with an eagle eye developed over decades of doing this. They support over 40 different report types, so they need to make judgement calls, based on their collective experiences. I'd like to harness these skills into a system which can provide instant turn-around for this entire effort.

At first, I would have those same experts be the sole users of this system until they find zero errors for a prolonged period of time and/or for particular report formats.

I am looking for a basic idea of the best technologies to use for this program. I am a C#.NET developer with javascript and some node experience. But I would switch to an entirely different platform, particularly if open sourced frameworks already existed or there were some other advantage of a specific platform.

A key element of this process is pattern matching. For example, in theory, each line item in a merchant's credit …
0
Can anyone think of a good reason to declare variables as objects instead of the appropriate variable type in VB6?

I'm experimenting with converting a VB6 app to .NET (2008 for now, then, if it works, 2017) and looking over the code, the original dev declared everything as objects.  Dim intLoop1 As Object (why not integer?)  Is there (could there be) a good reason for this or was he being lazy as my gut tells me?)

Thanks!
0
I create this SP and I am expecting it to insert a new row but that is not happening.  What's the best way to handle this?

 (@BatchID         9cfb9462-6b85-495c-9b66-db2e8d41329a)


======================================================================

ALTER PROCEDURE [dbo].[PushNotificationBatchWrite]
      (
      @BatchID                          uniqueidentifier,
      @SentYN                        char(1) = null,
      @SentTimestamp            datetime = null,
      @MFUpdatedYN                    char(1) = null,
      @MFUpdatedTimestamp      datetime = null
      )
AS

IF (@SentYN = NULL) AND (@MFUpdatedYN = NULL)
      --insert the new batch ID row
      BEGIN
            SET NOCOUNT ON;

            INSERT INTO [dbo].[PushNotificationBatch] (BatchID) VALUES (@BatchID);

            SET NOCOUNT OFF;
      END
ELSE
      BEGIN
            IF @MFUpdatedYN IS NOT NULL
                  BEGIN
                        --set the batch ID as updated on the mainframe

                        UPDATE [dbo].[PushNotificationBatch]
                           SET [MFUpdatedYN] = @MFUpdatedYN
                                ,[MFUpdatedTimestamp] = @MFUpdatedTimestamp
                         WHERE BatchID = @BatchID
                        
                   END

            IF @SentYN IS NOT NULL
                  BEGIN
                        --set the batch ID as sent to the vendor
                        UPDATE [dbo].[PushNotificationBatch]
                           SET [SentYN] = @SentYN
                                ,[SentTimestamp] = @SentTimestamp
                         WHERE BatchID = @BatchID
                        
                   END
      END
0
Have a computer running windows 10.  Everytime i unzip a file that has a PDF file, windows 10 will change the default viewing app to Microsft edge.  I can change it so that the default app is adobe reader, and I can continue to open pdf files with adobe reader until I unzip a pdf file and then it reverts back to microsoft edge.  

Has anyone had this issue and how did you resolve it?

Thanks!
0
HI have misplaced my visual studio 2005 installation cd. Is there anything I can do other than buy a new cd?

Thanks
0
Good Morning

I need to discover in a server group all the Windows services that are configured to start with a specific user.

Would anyone have any scripts to help with this job?

Thank you very much
0
Hi
I have a got a list of files in a folder text file with names like this:
baseFile_03_17_2017 .txt
baseFile_04_17_2017  .txt
baseFile_05_17_2017  .txt

Keep in mind>> there is no date column within each the text file.

 I want to a do a SSIS (SQL Server Integration Services)  loop where I loop through each file and insert it into a stage table which has an extra empty “Reportdate” column at the very end.

The SSIS job then gets the date from the file name and inserts it into the very last “ReportDate” column in that stage table


How do I do that?

Thanks
0
I am trying to set me context menu right click location to open whenever the user clicks on my control (Me.GridSpread). It always seem to open on right click of the context control itself on the upper menu button area.

Private Sub frmSearch_MouseClick(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles Me.MouseClick
        If e.Button = Windows.Forms.MouseButtons.Right Then
            SearchContextMenu.Show(Me.GridSpread, New System.Drawing.Point(0, 200))
        End If
    End Sub

Open in new window

0
Using Excel 2016: In the following code:  Sub getIE_makeChild_ofXl() opens internet explorer as a child of ThisWorkbook.
As expected, when the workbook is dragged, the IE wondow moves. When the excel.App.window is clicked, the IE window remains on top of thisWorkbook

However, I could not release IE from its parent either via Sub releaseParent1() nor via Sub releaseParent2().

Can you help me to release the child window?
Thanks, Kelvin

Option Explicit

#If Win64 Then
    'source (Chip Pearson) https://www.pcreview.co.uk/threads/in-vba-make-ie-browser-object-always-in-foreground.2503326/
    Declare Function SetParent Lib "user32" (ByVal hWndChild As LongLong, ByVal hWndNewParent As Long) As LongLong

    'source: http://www.vbforums.com/showthread.php?526112-RESOLVED-Undo-SetParent
    Declare Function GetDesktopWindow Lib "user32.dll" () As LongLong
#Else
    Declare Function SetParent Lib "user32" (ByVal hWndChild As Long, ByVal hWndNewParent As Long) As Long
    Declare Function GetDesktopWindow Lib "user32.dll" () As Long
#End If

Private oIE As Object

'this places the IE window ontop of the Excel sheet window, U can drag it about to see the xl window,
'' but the VISIBLE part of the IE window is that WITHIN the margins of the xl window.
   
Sub getIE_makeChild_ofXl()
   
    Set oIE = CreateObject("InternetExplorer.application")
    oIE.Visible = True
    oIE.navigate ("http://bbc.co.uk")
    oIE.Visible = True
   
    'make child
 …
0
Get your Disaster Recovery as a Service basics
LVL 1
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Hi Guys,

I have a working VB Script - sending an e-mail.  (Please see script below)
I would like to modify the script to include a conditional trigger.

The script will be called every 5 minutes from Windows Task Scheduler, but should only trigger an e-mail, if a "file being monitored" is older than 15 minutes.

For example:  We have a reporting tool, writing a file to:  C:\OUTPUT\Report.PDF

We need an e-mail notification, if the time-stamp of the file (Report.PDF) is older than 15 minutes (Thus not replaced or updated)

My Current Working VB Script:

on error resume next
 
Const schema   = "http://schemas.microsoft.com/cdo/configuration/"
Const cdoBasic = 1
Const cdoSendUsingPort = 2
Dim oMsg, oConf
 
' E-mail properties
Set oMsg      = CreateObject("CDO.Message")
oMsg.From     = "user@domain.com"  ' or "Sender Name <from@gmail.com>"
oMsg.To       = "user@domain.com"    ' or "Recipient Name <to@gmail.com>"
oMsg.Subject  = "Messaging Script"
oMsg.TextBody = "Messaging Script"
 
' GMail SMTP server configuration and authentication info
Set oConf = oMsg.Configuration
oConf.Fields(schema & "smtpserver")       = "mail.domain.com" 'server address
oConf.Fields(schema & "smtpserverport")   = 587              'port number
oConf.Fields(schema & "sendusing")        = cdoSendUsingPort
oConf.Fields(schema & "smtpauthenticate") = cdoBasic         'authentication type
oConf.Fields(schema & "smtpusessl")       = "False"             'use
0
I am looking for how to properly move an ASP.NET website to a VS2013 website project or website application?

Thanks,
Andrew
0
With a lot of help, I have written a small c# app that will paste the contents of the clipboard to a specified folder.  Sadly, however, when I put the .exe file onto my RDP - it doesn't work (I'm guessing because it's looking at the RDP clipboard).  Any pointers (or nuget suggestions), would be greatly appreciated - here's the code that I've been working with:

using System;
using System.IO;
using System.Windows.Forms;

namespace TSPaste2
{
    class Program
    {
        //Getting destination foler
        String[] args = Environment.GetCommandLineArgs();

        [STAThread]
        static void Main(string[] args)
        {
            //Setting Destination foler
            string DestFolder = args[0];

            if (Clipboard.ContainsFileDropList())
            {
                //copy to folder as set in the Command line
                foreach (string source in Clipboard.GetFileDropList())
                {
                    string Dest = DestFolder + "\\" + Path.GetFileName(source);
                    File.Copy(source, Dest);
                }
            }
        }
    }
}

Open in new window

0
Hi Experts,

I have a gridview. one of its column has s plus sign. When I click the plus sign it makes the other gridview visible . When I click the minus sign it is invisible. Is there anyway I can save the data of the popup gridview in a dataset or a datatable when the minus sign is clicked. I have attached the screenshots.

Thanks in advance.


Code for + and -
----------------------------

 <script  type="text/javascript" src="Jqueries/jquery_nestedGrid.min.js"></script>
     <script type="text/javascript">
         $("[src*=plus]").live("click", function () {
             $(this).closest("tr").after("<tr><td></td><td colspan = '900'>" + $(this).next().html() + "</td></tr>")
             $(this).attr("src", "images/minus.png");
             
         });
         $("[src*=minus]").live("click", function () {
             $(this).attr("src", "images/plus.png");
             $(this).closest("tr").next().remove();
         });
     </script>


Gridview column
---------------------------
  <asp:TemplateField ItemStyle-Width="4%">
                    <ItemTemplate>
                        <asp:image alt = "" style="cursor: pointer;" src="images/plus.png" id="ImgPlusMinus" runat="server" />
                        <asp:Panel ID="pnlOrders" runat="server" Style="display: none">
                            <asp:GridView ID="gvVendors" runat="server" AutoGenerateColumns="false" CssClass = "ChildGrid SetLeftMarginChildGrid">
                          …
0
Hello

I have a program on Windows 10 that just does not want to uninstall. Any ideas? (I rather not post the name of the program in case anyone is wondering).
0
Can you please tell me why I am getting this error?
screenshot.pngscreenshot2.png
System.Data.Entity.Core.EntityCommandExecutionException was unhandled by user code
  HResult=-2146232004
  Message=An error occurred while executing the command definition. See the inner exception for details.
  Source=EntityFramework
  StackTrace:
       at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
       at System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues)
       at System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass3.<GetResults>b__2()
       at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
       at System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass3.<GetResults>b__1()
       at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation)
       at System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
       at System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__0()
       at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()
       at 

Open in new window

0
I am trying to understand this article:

http://www.codemag.com/article/1705021

and how they fulfill the WebAPI mentioned under the heading:

"Create Web API"

I see they stat with an empty C# Controller, but can not find what exactly they mean by WebAPI.

I am not understanding what is meant by the term.

Please explain.

Thanks
0
I am a Senior .NET Full Stack Developer but want to have a sharper eye on the new technologies that are coming and the current technologies which are passing into the dustbin of history. What on-line industry publications are good for this?

Thanks
0
I am refreshing my memory about the various things which can cause a long response time on .NET MVC web pages and the tools to fix them.

A badly written stored procedure is the most obvious and this kind of bug can be uncovered first by looking at the Network tab of the browser and when the response time's too high, you may need to debug into the code to the point where the stored procedure is executed. You can also use SSMS to execute and fix it until the overall execution time becomes acceptable.

What other things can cause slow response and what methods uncover the problem?

Thanks
0
Hire Technology Freelancers with Gigs
LVL 11
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Hi

I am looking for a VB script that would allow to type full name or users name in a search box that would run against certain LDAP groups (43 groups) to confirm if the user exists. If the user exists the output should be display on the screen and save in CSV file.

These 43 groups exists in AD (LDAP).

Thank you, M
0
I need to refresh my use of writing unit tests with Visual Studio and hope to download some simple program with a handful of working unit tests I can inspect.

Thanks
0
I know that strings are immutable and that C# offers the StringBuilder class which allows you to manipulate the string without constantly re-creating that string.

What other features of C# are there for large strings? Just the class name is fine.

Thanks
0
I am trying to get ready for a coding test and would like to have a list of C# looping constructs on the top of my mind.

I can think of:

- For loop (indexing and arrays)
- Foreach (items in a list)
- While
- Do while

and some reserved words which relate are:

break
continue
return
yield

what did I miss?

And how about LINQ?

Are there explicit loops possible?

Thanks.
0
I have not done unit testing for a little while and expect a test upcoming to verify I can quickly write unit tests.

Suggestions of the thing I should be practicing?

Unit tests generate their own mock data, but I doubt a test would include me setting up a mocking framework. I think hard coded lists of objects would be the ideal method, on a coding test.

I assume the object wold be written already for me (it's going to be a 15 minutes test only)

I would create an instance of the object, review the parameter list for that method being tested...

I could create multiple sets of test data. Would a switch statement be appropriate for this kind of knock em out unit test? I could iterate through and handle a handful of test conditions...


Assertions are key.

Once it fails, the unit test fails. I need to be sure the specific test condition which failed the assertion is visible in the console.

Am I approaching this test the right way?

Suggestions?

Thanks.
0
I use Visual Studio Code on Windows to code Angular, with a Node server running and Chrome as the browser.

Is there a way to set breakpoints?

I assume Chrome breakpoints work the same as with Javascript, with no issue.

I also know that Visual Studio debugs Javascript (with breakpoints) for the old Internet Explorer.

What are my options for setting breakpoints easily with Angular? I do not find Chrome easy since I need to find the file, find the line number, etc. I much prefer using Visual Studio since it's more like a WYSIWYG type of setting breakpoints.

Suggestions?

Is there a modern browser which works with Visual Studio the way VS once suppoted Internet Explorer?

Thanks
0

Microsoft Development

47K

Solutions

32K

Contributors

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.