Help C# + ms.access search function

PHPmaster

Jd gini gan..gw lg buat suatu program..trus ada fungsi search nya

nah mslhnya dsni..kata yg dipanggil itu (cth namanya) harus sama persis yang ada di db nya (huruf besar kecilnya jg), jd klu ada nama dr.amatirta trus mo search tirta ga bkal kluar..jd msti ketik lengkap

yg gw mo tanya gmn cara buatnya supaya klu gw search tirta nti bs ditampilin nama yg mngandung kata tirta itu..?

denger2 sih pake Like..tp dah ane coba msh lom jd..

jd tolong ya gan dibantu

,klu ada link tutornya jg oke

trims before

codenya :

Code:

private void btnsearch_Click(object sender, EventArgs e)
{
if (txtsearch.Text == "")
{
MessageBox.Show("Masukkan kata yang ingin dicari", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtsearch.Focus();
}
else
{
sqlQRY = "Select * from pegawai Where nama = '" + txtsearch.Text + "'";
cmd.CommandText = sqlQRY;
cmd.Connection = cn;
dr = cmd.ExecuteReader();
dr.Read();

if (dr.HasRows)
{
textBox1.Text = dr[0].ToString();
textBox2.Text = dr[1].ToString();
textBox3.Text = dr[2].ToString();
textBox4.Text = dr[3].ToString();
textBox5.Text = dr[4].ToString();
textBox6.Text = dr[5].ToString();
textBox7.Text = dr[6].ToString();
textBox8.Text = dr[7].ToString();
textBox9.Text = dr[8].ToString();
textBox10.Text = dr[9].ToString();
textBox11.Text = dr[10].ToString();
textBox12.Text = dr[11].ToString();
textBox13.Text = dr[12].ToString();
textBox14.Text = dr[13].ToString();
textBox15.Text = dr[14].ToString();
textBox16.Text = dr[15].ToString();

btnsave.Text = "Update";
btnsave.Enabled = true;
btndelete.Enabled = true;
textBox1.Enabled = true;
textBox2.Enabled = true;
textBox3.Enabled = true;
textBox4.Enabled = true;
textBox5.Enabled = true;
textBox6.Enabled = true;
textBox7.Enabled = true;
textBox8.Enabled = true;
textBox9.Enabled = true;
textBox10.Enabled = true;
textBox11.Enabled = true;
textBox12.Enabled = true;
textBox13.Enabled = true;
textBox14.Enabled = true;
textBox15.Enabled = true;
textBox16.Enabled = true;
}
else
{
btnnew.Enabled = true;
btnsave.Enabled = false;
btndelete.Enabled = false;
clear();

MessageBox.Show("Record tidak ditemukan", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
dr.Close();
dr.Dispose();
}
}

</div>

Terkait:

Menu