ATUL_v1.Atul_v1Data.GetProcessSubProcessByProcessIDSubProcessID C# (CSharp) Method

GetProcessSubProcessByProcessIDSubProcessID() public method

public GetProcessSubProcessByProcessIDSubProcessID ( long ProcessID, long SubProcessID ) : DataTable
ProcessID long
SubProcessID long
return System.Data.DataTable
        public DataTable GetProcessSubProcessByProcessIDSubProcessID(long ProcessID, long SubProcessID)
        {
            SqlCommand cmd = new SqlCommand("exec dbo.Atul_ProcessSubprocessGetByProcessIDSubProcessID_sp @AtulProcessID, @AtulSubProcessID", this._connection);
            cmd.Parameters.Add(new SqlParameter("@AtulProcessID", ProcessID));
            cmd.Parameters.Add(new SqlParameter("@AtulSubProcessID", SubProcessID));

            SqlDataAdapter da = new SqlDataAdapter();
            da.SelectCommand = cmd;
            DataTable returnTable = new DataTable(); returnTable.TableName = "ProcessSubProcess";
            da.Fill(returnTable);
            return returnTable;
        }

Usage Example

Beispiel #1
0
 public string GetProcessSubProcessByProcessIDSubProcessID(long ProcessID, long SubProcessID)
 {
     DataTable returnTable = new DataTable();
     Atul_v1Data adb = new Atul_v1Data();
     returnTable = adb.GetProcessSubProcessByProcessIDSubProcessID(ProcessID, SubProcessID);
     return JsonMethods.GetJSONString(returnTable);
 }
Atul_v1Data