31 January 2009, 11:30 PM

DataGridView after connection is made you can now use it search by adding this do a Button and Text Feild. Then once is searched it will add information to dataGridView1

 using (MySqlConnection conn = new MySqlConnection(CONN_STRING))

                {

                    conn.Open();

                    MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM users WHERE domain LIKE '%" + search.Text + "%' ORDER BY id DESC LIMIT 100", conn);

                    da.Fill(dt);

                }

                if (!object.ReferenceEquals(dt, null))

                {

                    bs.DataSource = dt.DefaultView;

                }

 

                this.dataGridView1.ClearSelection();

                this.dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;

                this.dataGridView1.DataSource = bs;




We have a large portfolio of work we have completed for clients. Our portfolio always carries our current new iPhone applications. Take a look

Follow us on Twitter, We aim to provide Live Information - @olliekett
 



© OKD Limited 2012 | Contact Us
OKD Limited is a private registered company in England and Wales.
 
Ollie Kett Designs - Tracking System