Questions




Answers
1
How can I get application root folder location in C# Console application?

I am creating a C# console application for some test project, in which I need to get Root folder location (application path) of project, for example, if my project is in "C:\Project\Program.cs", so i should get "C:\Project\" drive as root location. 

How can I get it using C# console application, in web-application we get it using Server.MapPath("~/") but I am not sure about console application.

...
Read More
Answers
0
SUM and JOIN 2 columns with different tables but do not SUM Qty

Good day!

Need help to SUM and JOIN 2 columns with different tables but do no want to SUM qty and duplicates row result

here's the sample data tables;

 

Transfer Shipment table;

TransTO - TransFROM -  ItemNo   -   Desc   -   Desc2   -   VariantCode   -   Qty

Location1      HO                Item01         Active      Black         Variant01             5           <------ Delivery

Location1      HO                 Item01         Active      Black        Variant01             5           <------ Delivery

HO                Location1       Item01         Active     Black        Variant01             2          <------ Pull-out

HO                Location1       Item01         Active      Black       Variant01             1            <------ Pull-out

 

Sales Entry table;

Loc Code   -   Item No   -   Variant Code   -   Qty

Location1       Item01          Variant01            -1       <------ PSales

Location1       Item01          Variant01            -1       <------ PSales

 

Item Entry table;

Loc Code   -   Item No   -   Desc   -   Desc2- VariantCode-   Qty - EntryType  - DocNo

Location1       Item01         Active     Black         Variant01      4         2           ItemAdj0001   <------ PAdj

Location1       Item01         Active     Black         Variant01      1          2           StrAdj0001       <------ PAdj

Location1       Item01         Active     Black         Variant01     -1          1           MSales0001     <------ MSales

Location1       Item01         Active     Black         Variant01     -1           1           MSales0002     <------ MSales

Location1       Item01         Active     Black         Variant01     -1          3           LocAdj0005      <------ NAdj

Location1       Item01         Active     Black         Variant01     -1          3           BtqAdj0008      <------ NAdj

 

SUM and JOIN (the sql query result should be like this)

Loc Code  - Item No - Desc  - Desc2 -VarCode- Delivery -PAdj- Pull-out - PSales - MSales - NAdj  -  Total

Location1    Item01   Active    Black   Variant01     10            5           3             -2             -2         -2            6

 

here's my sql query code;

...
Read More
Answers
1
Cannot connect to WMI Provider SQL server configuration manager error

I am trying to open SQL server configuration manager, after following this question "How to open sql server configuration manager in windows 10?" and steps to show it on Start menu, but when opening configuration manager getting error pop-up with message

Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager.
Invalid namespace

...

Read More
Answers
4
SUM and JOIN 2 columns with different tables but it duplicates results

Trying to SUM and JOIN 2 columns with different tables but it duplicates results, here is my query

...
Read More
Answers
2
How do I enable CORS in C# web-api 2?

I have read and implemented "Token based authentication in C# using Web API" in my web-api project, now, I would like to enable CORS in my web-api so anyone can access api from different domain also. How can enable CORS in web-api?

...
Read More
Answers
1
How to ignore files while committing code on GitHub using Visual Studio?

Hello, I am using Visual Studio and I was constantly adding "/bin/projectname.dll" files on GitHub until now, but now I want to ignore these .dll files. So How can I ignore these build files and push only files like .cs, .html,.js ,.css etc to GitHub Repository.

...
Read More
Answers
1
How to auto hide bootstrap date-picker after selecting date?

I am using Bootstrap datepicker in my web-application, but once I have selected date, date-picker is not hiding, how can I auto-hide date-picker once date is selected? Here is the date-picker Javascript code, which I am  using

...
Read More
Answers
1
Console error "Syntax error Unexpected token 'export' popper.min.js"

I am using below scripts in my page and have included popper.min.js using CDN but getting an error, "Syntax error Unexpected token 'export' popper.min.js"

    <script src="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.5/js/select2.full.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.15.0/popper.min.js"></script>

Here is the error image, take a look

...

Read More
Answers
1
How to pass Model to Partial View in ASP.NET MVC?

I have created Bootstrap tabs inside ASP.NET MVC razor view and calling Partial View from inside bootstrap, but I would like to know how can I pass Model to partial view while rendering it?

...
Read More
Answers
1
How to add / remove class in jQuery dynamically on click?

I am trying to create a list of anchor tags, and want to add or remove CSS class on a button click, Suppose this is my sample code

...
Read More

Page 1 of 46