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 George Jonsson 215
1 Kornfeld Eliyahu Peter 169
2 OriginalGriff 120
3 PIEBALDconsult 110
4 BillWoodruff 85
0 OriginalGriff 6,165
1 DamithSL 4,658
2 Maciej Los 4,087
3 Kornfeld Eliyahu Peter 3,649
4 Sergey Alexandrovich Kryukov 3,294


Advertise | Privacy | Mobile
Web03 | 2.8.141220.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