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

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) 

1. =RowNumber(Nothing)

1.   public List<LDNo> LDNoList(Int64? LDNo)
2.         {
3. 
   
4.             ResultModel result = new Models.ViewModel.CommonViewModel.ResultModel();
5.             string error = String.Empty;
6.             QUERY2 query = new QUERY2();
7.             Dictionary<string, object> dict = new Dictionary<string, object>();//= new Dictionary<string, string> 
8.             List<LDNo> ldnoList = new List<LDNo>();
9. 
   
10.             dict.Add("@LDNO", LDNo);
11.             dict.Add("@Result", 1.ToString());
12.             dict.Add("@Message", "Message".ToString());
13.             query.SQL = @"SPROC_GET_tblDyesForecastingHead_LDNO";
14.             query.PARAMETER = dict;
15.             clsDataprocess cls = new clsDataprocess();
16.             result = cls.ExecuteSqlStoredProcedureSaveEdit(query, "get", out error);
17.             if (result.Result && result.DtTable != null && result.DtTable.Rows.Count > 0)
18.             {
19.                 Int64 tempi = 0;
20.                 for (int i = 0; i < result.DtTable.Rows.Count; i++)
21.                 {
22.                     LDNo lDNo = new LDNo();
23.                     Int64.TryParse(result.DtTable.Rows[i]["LDNO"].ToString(), out tempi);
24.                     lDNo.LdNo = tempi;
25.                     ldnoList.Add(lDNo);
26. 
    
27.                 }
28.                 string Message = result.Message;
29.                 string Result = result.Result.ToString();
30.             }
31.             else if (!result.Result)
32.             {
33.                 throw new Exception(result.Message);
34.             }
35. 
    
36.             return ldnoList;
37.         }

2.  SqlClientCode For Calling StoredProcedure for Getting Data

1.   public JsonResult BuyerList()
2.         {
3.             Chemical_DAL obj_dal = new Chemical_DAL();
4.             return Json(obj_dal.BuyerList());
5.         }

2. Service

1. public class QUERY
2. {
3.     public string SQL { get; set; }
4.     public Dictionary<string, string> PARAMETER { get; set; }
5.     public Dictionary<string, byte[]> BYTEPARAMETER { get; set; }
6. }

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 DateTime Date range January 1, 1753, through December 31, 9999 in SQL Server
Ans: https://stackoverflow.com/questions/1334143/datetime2-vs-datetime-in-sql-server

2.  Dictionary  value different types use object as datatype of the eky value

3. If one property of a class is list<> of another class then how to deal with it if we want to initialize it in essential place to avoid Null Reference. See question 17 below.

4. How to create multi valued dictionary rather  than one valued dictionary.


5. Instance Methods as Delegates
6.  Generic:  Base Class Constraint
7. Defference btn logical ("AND, OR") vs  shortcircuit ("AND, OR")repectively

8. Use ref and out Parameters
9. Indexer vs Property Difference
10.Variable Number of Arguments function Arguments

11. How you copy one object to another object . Not reference of the object?

12. Make a simple character stack by a C# class and push pop public member function

13. How to use one constructor to invoke another Constructor and which one will execute first
Optional Arguments vs. Overloading: How optional argument become an alternative to Function Overloading

14. Static class and static method

15. C# 4.0: The Complete Reference: 296 PG: When Are Constructors Called?
 For multilevel hierarchy inheritance : During creation of  child class object which class constructor is executed first? The one in the derived class or the one defined by the base class? Or only one constructor will be called?


16. Dynamic method dispatch/ C# runtime polymorphism: (C# 4.0: The Complete Reference 297 - 305 PG-  : Base Class References and Derived Objects and Virtual Methods and Overriding)
For multilevel hierarchy inheritance, because of calling the virtual method with any level base class reference variable referring to a any of the child /base class object.
case 1: When both have the virtual method then Object  being referred class method/reference class overridden method will be called?
Case 2:  If a derived class does not override a virtual
method, then, while moving up the hierarchy/down the hierarchy,  the only first override of the method that is encountered is the one executed or only the last? or All from first to last vice versa?




        clsDataprocess  cls2 = new clsDataprocess();// Wrong
static  public   SqlConnection Con = cls2.getConnection253_Mymun(); // cls2 showing the errror

                static clsDataprocess  cls2 = new clsDataprocess(); // Correct  put static in both  variable 

               static  public   SqlConnection Con = cls2.getConnection253_Mymun();// Correct

18.Why can't I use alias in a count(*) “column” and reference it in a having clause?

STRING_SPLIT (Transact-SQL) is avail able from SQL Server 2016 

As there is no built in split string function in sql server 2014, 2010, 2008 I have build the bellow function from getting help from stackloverflow.com . 

1. This is single paged query to under standing split string.