Thursday, March 27, 2014

Convert DataSet to C# List

You can simply try like this

  public static List<AttendenceManual> PreocessData(DataSet data)  
     {  
       List<AttendenceManual> _AttendenceManualList = new List<AttendenceManual>();  
       for (int i = 0; i < data.Tables[0].Rows.Count; i++)  
       {  
         AttendenceManual Student = new AttendenceManual();  
         Student.StrEmpID = data.Tables[0].Rows[i]["F2"].ToString();  
         _AttendenceManualList.Add(Student);  
       }  
       return _AttendenceManualList;  
     }  


SQL Get all Index create script from Database

To get all script from database as a create new index into another database you can use the following --Get all Index Script SELECT...