public static DataSet GetTrafficHandledL2Dataset(string Frequency, string Direction, string From = null, string To = null) { DataSet ds = new DataSet(); var sqlParam = new SqlParameter[4]; sqlParam[0] = new SqlParameter("@Frequency", Frequency) { SqlDbType = SqlDbType.NVarChar }; sqlParam[1] = new SqlParameter("@From", From) { SqlDbType = SqlDbType.DateTime }; sqlParam[2] = new SqlParameter("@To", null) { SqlDbType = SqlDbType.DateTime }; sqlParam[3] = new SqlParameter("@Direction", Direction) { SqlDbType = SqlDbType.NVarChar }; ds = SqlDBHelper.ExecuteQueryGetDataset("sp_TrafficHandled_L2", sqlParam); return(ds); }
public static DataSet GetTrafficHandledDataset(string Frequency, string From = "", string To = "") { DataSet dt = new DataSet(); var sqlParam = new SqlParameter[3]; sqlParam[0] = new SqlParameter("@Frequency", Frequency) { SqlDbType = SqlDbType.NVarChar }; sqlParam[1] = new SqlParameter("@From", From) { SqlDbType = SqlDbType.NVarChar }; sqlParam[2] = new SqlParameter("@To", To) { SqlDbType = SqlDbType.NVarChar }; dt = SqlDBHelper.ExecuteQueryGetDataset("sp_TrafficHandled_L1", sqlParam); return(dt); }