Eg Net Solution

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

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...

Users Countries


Monday, August 19, 2019

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

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


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

Saturday, July 20, 2019

Windows & .Net Snippet

July 20, 2019 0
Windows & .Net Snippet
MSSQL SERVER LOCAL DB: 
(LocalDb)\MSSQLLocalDB
Run Snippet:
sqlplus
SQLSERVERMANAGER12.msc
SQLServerManager15.msc
services.msc
inetmgr
eventvwr
mmc.exe
appdata
wf.msc  Windows Firewall With Advanced Security
To Install IIS Server
 Microsoft Web Platform Installer  windows server 2012r2

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 )



Tuesday, November 27, 2018

Programming language & library Exceptions that occurred while developing in C#, JavaScript, Jquery, SQL, Entity framework

November 27, 2018 0
Programming language & library Exceptions that occurred while developing in C#, JavaScript, Jquery, SQL, Entity framework
C#-SQL: Procedure or function SPROC_GET_DBTEXQuality_SearchBatchCardDetails has too many arguments specified. 
It occurs when System.Data.SqlClient SqlCommand command.Parameters have more parameter rather than declared in the Stored procedure

Parse String to Date Time: Worked For ME:
   string CreatedDateStr = "2018-12-13 11:05:45.313";
   DateTime CreateDate = DateTime.Parse( CreatedDateStr );

Thursday, November 1, 2018

Using SqlClient connect to sql server and CRUD in Databse thorough Stored Procedure

November 01, 2018 0
Using SqlClient  connect to sql server and CRUD in Databse thorough Stored Procedure

  1.   public List<LDNo> LDNoList(Int64? LDNo)
  2.         {

  3.             ResultModel result = new Models.ViewModel.CommonViewModel.ResultModel();
  4.             string error = String.Empty;
  5.             QUERY2 query = new QUERY2();
  6.             Dictionary<string, object> dict = new Dictionary<string, object>();//= new Dictionary<string, string> 
  7.             List<LDNo> ldnoList = new List<LDNo>();

  8.             dict.Add("@LDNO", LDNo);
  9.             dict.Add("@Result", 1.ToString());
  10.             dict.Add("@Message", "Message".ToString());
  11.             query.SQL = @"SPROC_GET_tblDyesForecastingHead_LDNO";
  12.             query.PARAMETER = dict;
  13.             clsDataprocess cls = new clsDataprocess();
  14.             result = cls.ExecuteSqlStoredProcedureSaveEdit(query, "get", out error);
  15.             if (result.Result && result.DtTable != null && result.DtTable.Rows.Count > 0)
  16.             {
  17.                 Int64 tempi = 0;
  18.                 for (int i = 0; i < result.DtTable.Rows.Count; i++)
  19.                 {
  20.                     LDNo lDNo = new LDNo();
  21.                     Int64.TryParse(result.DtTable.Rows[i]["LDNO"].ToString(), out tempi);
  22.                     lDNo.LdNo = tempi;
  23.                     ldnoList.Add(lDNo);

  24.                 }
  25.                 string Message = result.Message;
  26.                 string Result = result.Result.ToString();
  27.             }
  28.             else if (!result.Result)
  29.             {
  30.                 throw new Exception(result.Message);
  31.             }

  32.             return ldnoList;
  33.         }

Thursday, October 18, 2018

Programming Or Algorithms Snippet

October 18, 2018 0
Programming Or Algorithms Snippet
1. Swap value of 2 variable with out using any third variable.
Suppose

  1.  a= 5
  2.  b = 7
  3.  a = a + b;  = 12;
  4.  b =  a - b ;  =  5;
  5.  a = a -b; = 7

 You can also swap two equal length array with out using any temporary third variable by looping and traversing the arrays. 

Tuesday, October 9, 2018

C# Snippet

October 09, 2018 0
C# Snippet

1. Formatting Date-time:  string.Format("{0:dd/MM/yy}", DateTime.Today)
2. Storing List Data in ViewBag and retrieve the List Data in View Or Getting List Data From ViewBag :

3. If you want to pass multiple different list in a View from ASP .Net MVC Controller Action How can you pass it?
Answer: 
In Action:  ViewBag.MyClassList = new List<MyClass>() ;
 List<MyClass> MyClassList = ViewBag.MyClassList as List<MyClass>;

Returning JSON Data From Server To Client :: 
  1.  var data = obj_dal.LoadAllProductCode(TKTCode, "1", allMenu.User.USER_ID.ToString());    
  2.             var MaxJson = Json(new { ListProductCode = data});
  3.             MaxJson.MaxJsonLength = 999999999;
  4.             return MaxJson;
Or
  1. var MaxJson =   Json(new { ListOrderBooking = obj_dal.LoadOrderBookingDL(OrderNo, allMenu.User.EMPLOYEE_ID.ToString()) });
  2. MaxJson.MaxJsonLength = 999999999;
  3. return MaxJson;

Add Choice