Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C#4.0 GUI
con1.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\DATA\AddressBK.mdb";
            con1.Open();
            
                String query = "select Name,Gender,Phone,MobileNo,Address,E_mail,City,Country,Pin,Company,JobTitle from Details where Name like ('" + textBox1.Text + "')";
                cmd1 = new OleDbCommand(query, con1);
                OleDbDataReader read;
                read = cmd1.ExecuteReader();
                
                while (read.Read())
                {
                    label7.Text = Convert.ToString(read.GetValue(0));
                    label11.Text = Convert.ToString(read.GetValue(1));
                    label12.Text = Convert.ToString(read.GetValue(2));
                    label13.Text = Convert.ToString(read.GetValue(3));
                    label14.Text = Convert.ToString(read.GetValue(4));
                    label15.Text = Convert.ToString(read.GetValue(5));
                    label16.Text = Convert.ToString(read.GetValue(6));
                    label17.Text = Convert.ToString(read.GetValue(7));
                    label18.Text = Convert.ToString(read.GetValue(8));
                    label19.Text = Convert.ToString(read.GetValue(9));
                    label20.Text = Convert.ToString(read.GetValue(10));
                }
 
                con1.Close();
Posted 20-Oct-10 19:02pm
Edited 20-Oct-10 23:11pm
v2

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

"select Name,Gender,Phone,MobileNo,Address,E_mail,City,Country,Pin,Company,JobTitle from Details where Name like '%" + textBox1.Text + "%'";
 
use like It.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Mathew Soji 330
1 BillWoodruff 260
2 Sergey Alexandrovich Kryukov 240
3 OriginalGriff 216
4 Afzaal Ahmad Zeeshan 208
0 OriginalGriff 6,168
1 Sergey Alexandrovich Kryukov 5,853
2 DamithSL 5,028
3 Manas Bhardwaj 4,539
4 Maciej Los 3,845


Advertise | Privacy | Mobile
Web02 | 2.8.1411019.1 | Last Updated 21 Oct 2010
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100