Eg Net Solution

Eg Net Solution

Here in this sites web and software developer can get some essential information.

Breaking

MY Favorite .Net Question For Interview

This are not tidy. Just for rough. In Sha Allah will make it tiddy soon. 1.  DateTime2 Date range 0001-01-01 through 9999-12-31  vs Date...

Wednesday, July 8, 2020

Microsoft Excel , Google Spread Sheet Snippet

July 08, 2020 0
Microsoft Excel , Google Spread Sheet Snippet


Exel: Check if a column value exists in another column or not
Here we are checking if column E2 exist between Column D2 to Column D1000; if yes then output "True",  if not then false.
=NOT(ISERROR(MATCH(E2,$D$2:$D$1000,0)))

Monday, May 18, 2020

Github create a new repository or add a project to a repository on the command line

May 18, 2020 0
Github create a new repository or add a project to a repository on the command line
echo "# BANGLA-TEXT-TO-SPEECH-CONVER-KAKATUATER" >> README.md
git init
git add README.md
git commit -m "first commit"
git remote add origin https://github.com/ashikcse20/BANGLA-TEXT-TO-SPEECH-CONVER-KAKATUATER.git
git push -u origin master
                

Monday, August 19, 2019

বাঁকানাজ ঘাঁটকুল

August 19, 2019 0
বাঁকানাজ ঘাঁটকুল
বাঁকানাজ প্রায় কচুর মত  দেখতে এক প্রকার গাছ


ঘাঁটকুল প্রায় কচুর মত  দেখতে এক প্রকার গাছ 

Saturday, July 20, 2019

Windows & .Net Snippet

July 20, 2019 0
Windows & .Net Snippet

Tuesday, April 16, 2019

Solved Problem :: Scenario While Hosting ASP MVC4 Application in IIS 6.1 at Windows Server 2012 R2

April 16, 2019 0
Solved Problem :: Scenario While Hosting ASP MVC4 Application in IIS 6.1 at Windows Server 2012 R2
How To Install IIS on Server 2012 r2

https://www.youtube.com/watch?v=mPwlxP5Nxcg&t=146s

Install .Net Framework 4.5.2 from Microsoft Web Platform Installer

https://stackoverflow.com/questions/37557199/how-to-troubleshoot-a-503-error-in-iis
https://stackoverflow.com/questions/8232922/asp-pages-in-iis-using-localhost-401-3-error-do-not-have-permission
https://stackoverflow.com/questions/18981118/http-error-403-14-forbidden-the-web-server-is-configured-to-not-list-the-con
https://stackoverflow.com/a/4794716/2014745
https://stackoverflow.com/questions/34199976/iis-config-error-this-configuration-section-cannot-be-used-at-this-path
https://stackoverflow.com/a/35332431/2014745
https://stackoverflow.com/questions/9794985/config-error-this-configuration-section-cannot-be-used-at-this-path
https://stackoverflow.com/a/25698312/2014745
https://stackoverflow.com/questions/2659544/cant-run-asp-net-mvc-2-web-app-on-iis-7-5
https://stackoverflow.com/questions/18981118/http-error-403-14-forbidden-the-web-server-is-configured-to-not-list-the-con/50863817
https://www.codeproject.com/Questions/1076591/A-default-document-is-not-configured-for-the-reque
https://stackoverflow.com/a/12867753/2014745
https://stackoverflow.com/questions/19162553/iis-401-3-unauthorized
https://stackoverflow.com/questions/32014912/how-do-i-tell-iis-to-serve-static-files-from-the-web-root-with-an-underlying-cat/32526842
https://stackoverflow.com/questions/8723763/iis-6-0-suddenly-shows-directory-listing-instead-of-mvc-3-app
https://stackoverflow.com/questions/13162545/handler-extensionlessurlhandler-integrated-4-0-has-a-bad-module-managedpipeli?rq=1
https://stackoverflow.com/questions/4654547/a-default-document-is-not-configured-for-the-requested-url-and-directory-browsi
https://stackoverflow.com/q/40428074/2014745
https://stackoverflow.com/questions/45207154/could-not-load-file-or-assembly-microsoft-reportviewer-processingobjectmodel-v#
https://stackoverflow.com/questions/33412042/configuration-error-related-to-targetframework-in-web-config/33412841#33412841
https://stackoverflow.com/questions/40428074/iis-7-5-only-shows-directory-list-or-403-instead-of-asp-net-application
https://stackoverflow.com/questions/1376717/unable-to-make-the-session-state-request-to-the-session-state-server
https://stackoverflow.com/questions/9216158/the-requested-page-cannot-be-accessed-because-the-related-configuration-data-for

Regards ---Muhammad Ashikuzzaman

Wednesday, March 13, 2019

My Favorite Attar/ Fragrant list

March 13, 2019 0
My Favorite Attar/ Fragrant  list
                     Attar name                             Company Name       
                     Al-Fares                                   Al-Rehab
                     Sultan                                       Al-Rehab
                     Dalal                                         Al-Rehab
                     Sad Safa                                   Al-Rehab
                     Shadha                                     Al-Rehab
                     Choko Mask                            Al-Rehab
                     Soft                                           Al-Rehab
                     Lord                                         Al-Rehab
                     White Wood                            Al-Rehab
                     Black Wood                             Al-Rehab
                     Cute Blue bottle                      Tibbet
                     Fawakih                                   Opened
                     Orange                                     Alif
                     Lemon                                      Opened
                     kachi Beli                                 Opened
                     Magnet                                     Opened
                     Marjan                                     Opened/Company 
                     Jannatul Fedaus                      Opened/Company 



Regards ---Muhammad Ashikuzzaman

Thursday, December 27, 2018

SQL TRICKS

December 27, 2018 0
SQL TRICKS
1. Student Table have:ID, STUDENT_ID, STUDENT_NAME, YEAR, CLASS, ROLL
Find each student  name, the last year in database, class  name

  1. ID, STUDENT_ID    STUDENT_NAME  YEAR   CLASS   ROLL
  2. 1          2                           A                           2010       I             5
  3. 2          2                           A                           2012      III           5
  4. 3          5                          C                           2010      IX           5
  5. 4          2                           A                           2014      V             5
  6. 5          7                           E                           2018      IX           5
  7. 6          2                           A                           2016      VII          5
   Query: 
  1.      Select ST1.ID, ST1.STUDENT_ID, ST1.STUDENT_NAME, ST1.YEAR, ST1.CLASS, ROLL from STUDENT ST1 INNER JOIN
  2.   (
  3.      SELECT  STUDENT_ID ,  MAX(YEAR)  MAXYEAR from STUDENT GROUP BY  STUDENT_ID    
  4.    )
  5.    ST2 on ST1.STUDENT_ID     = ST2.STUDENT_ID    AND ST1.ID = ST2.ID

Monday, December 24, 2018

RDLC Report Definition Language Client Site Snippet

December 24, 2018 0
RDLC Report Definition Language Client Site Snippet
1. FormatDateTime to required Format

  1. =FormatDateTime(Fields!OrderDate.Value, DateFormat.ShortDate)
  2. =Format(now( ),"dd-MMM-yyyy HH:mm:ss tt")
  3. =Format( Fields!CreateDate.Value, "dd-MMM-yyyy")
  4. =FormatNumber(Sum(Fields!FinishQty.Value),0)
  5. =FormatDateTime(Fields!DeliveryDate.Value, DateFormat.ShortDate) 

        For Printing Serial In RDLC
  1. =RowNumber(Nothing)
     If Condition in RDLC
     =IIf(Parameters!UnitListId.Value = "6", "Color City Ltd.",                       
            IIf(Parameters!UnitListId.Value = "1", "Mymun Textile Ltd.", 
                 IIf(Parameters!UnitListId.Value = "2", "Hamza  Textile Ltd",
                       "Mymun Complex")))
    Switch case in RDLC
        = Switch( Fields!FlagGroup.Value =  0, "00-60 days",
          Fields!FlagGroup.Value =  1, "61-120 Days",
          Fields!FlagGroup.Value =  2, "121-180 Days",
          Fields!FlagGroup.Value =  3, "181-270 Days",
          Fields!FlagGroup.Value =  4, "271-365 Days",
          Fields!FlagGroup.Value = 5,  "More than 365 Days" ,

  1 = 1,                          "default value" )
   Formatting number to Desired Decimal Points:
    =FormatNumber(Sum(Fields!FinishQty.Value), 0)

  Iff condition in Function: 
   =FormatNumber( Sum(IIf(Fields!FlagColumn = 0, Fields!FinishQty.Value ,0 )    ),0)
   =IIf(Fields!FlagColumn = 0, FormatNumber( Sum(Fields!FinishQty), 0),0 )



Add Choice