Database

<br />
static private string GetConnectionString()<br />
        {<br />
<br />
            return<br />
            "Driver={Microsoft Access Driver (*.mdb)};"<br />
                + "Dbq=c:\\Users\\Tichaona\\Documents\\My Dropbox\\SET10101  Software Architecture\\coursework1\\patients.mdb;Uid=java;Pwd=password;";<br />
        }<br />
<br />
        private void BtnSearch_Click(object sender, EventArgs e)<br />
        {<br />
            String nameSearch = TxtBxName.Text; <<<The variable I wish to use<br />
            try<br />
            {               <br />
<br />
                string connectionString = GetConnectionString();<br />
                string queryString = "SELECT Name FROM patients WHERE Name LIKE '%nameSearch%';"; <<<Here<br />
                using (OdbcConnection connection =<br />
                           new OdbcConnection(connectionString))<br />
                {<br />
                    OdbcCommand command = connection.CreateCommand();<br />
                    command.CommandText = queryString;<br />
<br />
<br />
                    try<br />
                    {<br />
                        connection.Open();<br />
<br />
                        OdbcDataReader reader = command.ExecuteReader();<br />
<br />
                        <br />
<br />
                        while (reader.Read())<br />
                        {<br />
<br />
                            LstBxResults.Items.Add(reader.GetString(0));<br />
<br />
                           <br />
                        }<br />
<br />
                        reader.Close();<br />
                    }<br />
<br />
                    catch (Exception ex)<br />
                    {<br />
                        MessageBox.Show(ex.Message);<br />
<br />
<br />
                    }<br />
                }<br />
            }//<br />
            catch (Exception er)<br />
            {<br />
                MessageBox.Show("There is an error {0}" + er);<br />
            }<br />
<br />
<br />
        }<br />
<br />
       <br />
    }<br />
}<br />
<br />
<br />