public Location()
        {
            InitializeComponent();

            //set variable then call the method for dataset to datagridview1
            //var test = DatabaseProcess.DataSetUsers();
            //var test = DatabaseProcess.DataSetHumanServices();
            //var test = DatabaseProcess.DataSetEmergencyServices();
            //var test = DatabaseProcess.DataSetServicesOffered();

            //join table datasets
            //var test = DatabaseProcess.TwoTableDataSetHumanOffered();
            //var test = DatabaseProcess.TwoTableDataSetEmergencyOffered();
            var test = DatabaseProcess.AllUserDataSet();

            dataGridView1.DataSource = test;
            dataGridView1.DataMember = test.Tables[0].ToString();


            //calling methods with return string value to a label named lblLocations
            //lblLocations.Text = DatabaseProcess.ReadDataBase();
            //lblLocations.Text = DatabaseProcess.ReadHumanServices();
            //lblLocations.Text = DatabaseProcess.ReadEmergencyServices();
            //lblLocations.Text = DatabaseProcess.ReadServicesOffered();
        }
        public List <string> SearchDataset(string wordSearched)
        {
            List <string> rowList = new List <string>();

            if (wordSearched != null)
            {
                //connection.ConnectionString = "Server=cis1.actx.edu;Database=project2;User Id=db2;Password=db20;";
                //connection.Open();

                //using (SqlCommand search = connection.CreateCommand())
                //{
                //    System.Diagnostics.Debug.WriteLine(connection.ServerVersion);

                //    search.CommandText = "select ..."; // haven't figure the SQL code out.


                //    connection.Close();
                //}
                var testForEmergencyServices = DatabaseProcess.DataSetEmergencyServices();
                var subset1 = testForEmergencyServices.Tables[0].Select("Company >= '" + wordSearched +
                                                                        "' or Email >= '" + wordSearched +
                                                                        "' or Phone >= '" + wordSearched +
                                                                        "' or City >= '" + wordSearched +
                                                                        "' or State >= '" + wordSearched +
                                                                        "' or Address >= '" + wordSearched + "'");

                // Print column 0 of each returned row.
                for (int i = 0; i < subset1.Length; i++)
                {
                    rowList.Add(subset1[i].ToString());
                }

                var testForHumanServices = DatabaseProcess.DataSetHumanServices();
                var subset2 = testForHumanServices.Tables[0].Select("Company >= '" + wordSearched +
                                                                    "' or Email >= '" + wordSearched +
                                                                    "' or Phone >= '" + wordSearched +
                                                                    "' or City >= '" + wordSearched +
                                                                    "' or State >= '" + wordSearched +
                                                                    "' or Address >= '" + wordSearched + "'");
                // Print column 0 of each returned row.
                for (int i = 0; i < subset2.Length; i++)
                {
                    rowList.Add(subset2[i].ToString());
                }
            }
            return(rowList);
        }