ATUL_v1.Atul_v1Data.GetAllActivity C# (CSharp) Method

GetAllActivity() public method

Gets all activity.
public GetAllActivity ( ) : DataTable
return System.Data.DataTable
        public DataTable GetAllActivity()
        {
            SqlCommand cmd = new SqlCommand("exec dbo.Atul_ActivityGet_sp", this._connection);
            SqlDataAdapter da = new SqlDataAdapter();
            da.SelectCommand = cmd;
            DataTable returnTable = new DataTable(); returnTable.TableName = "atultblactivity";
            da.Fill(returnTable);
            return returnTable;
        }

Usage Example

Beispiel #1
0
 /// <summary>
 /// Gets all activity.
 /// </summary>
 /// <returns></returns>        
 public string GetAllActivity()
 {
     DataTable returnTable = new DataTable();
     Atul_v1Data adb = new Atul_v1Data();
     returnTable = adb.GetAllActivity();
     return JsonMethods.GetJSONString(returnTable);
 }
Atul_v1Data