public List <EnrollingProjectData> searchProjectdata(string text) { string query = "SELECT * from EnrollingprojectTable WHERE projectName LIKE '%" + text + "%' OR totalAmount LIKE '%" + text + "%' OR willServe LIKE '%" + text + "%' OR duration LIKE '%" + text + "%' OR createdate LIKE '%" + text + "%'"; List <EnrollingProjectData> asList = new List <EnrollingProjectData>(); DatabaseConnectionClass dcc = new DatabaseConnectionClass(); dcc.ConnectWithDB(); SqlDataReader sdr = dcc.GetData(query); while (sdr.Read()) { EnrollingProjectData a = new EnrollingProjectData(); a.ProjectName = sdr["ProjectName"].ToString(); a.TotalAmount = sdr["TotalAmount"].ToString(); a.WillServe = sdr["WillServe"].ToString(); a.Duration = sdr["Duration"].ToString(); a.Createdate = sdr["Createdate"].ToString(); asList.Add(a); } return(asList); }
public List <EnrollingProjectData> GetallEnrollingProjectdata() { string query = "SELECT * from EnrollingprojectTable"; List <EnrollingProjectData> asList = new List <EnrollingProjectData>(); DatabaseConnectionClass dcc = new DatabaseConnectionClass(); dcc.ConnectWithDB(); SqlDataReader sdr = dcc.GetData(query); while (sdr.Read()) { EnrollingProjectData a = new EnrollingProjectData(); a.ProjectName = sdr["ProjectName"].ToString(); a.TotalAmount = sdr["TotalAmount"].ToString(); a.WillServe = sdr["WillServe"].ToString(); a.Duration = sdr["Duration"].ToString(); a.Createdate = sdr["Createdate"].ToString(); asList.Add(a); } return(asList); }