JustAcMilan
جمعه 23 فروردین 1392, 19:04 عصر
با سلام من متد جستجو در بانک اطلاعاتی sql server 2008 رو بصورت زیر نوشتم ولی نمی دونم چرا حساس به حروفه (نمی خوام باشه) لطفا راهنماییم کنید
void search()
{
string query = null;
try
{
switch (comboBox1.Text)
{
case "Fisrt name": { query = "SELECT id,name,family,phone FROM phoneTable WHERE name like '" + textBox1.Text + "%'"; break; }
case "Last name": { query = "SELECT id,name,family,phone FROM phoneTable WHERE family like '" + textBox1.Text + "%'"; break; }
case "Phone number": { query = "SELECT id,name,family,phone FROM phoneTable WHERE phone like '" + textBox1.Text + "%'"; break; }
default: { break; }
}
con = new SqlConnection(connect);
con.Open();
command = new SqlCommand();
command.CommandText = query;
command.Connection = con;
adapter = new SqlDataAdapter();
adapter.SelectCommand = command;
objDataTable = new DataTable();
adapter.Fill(objDataTable);
con.Close();
dataGridView1.DataSource = objDataTable;
}
catch { MessageBox.Show("File Not Found"); }
}
void search()
{
string query = null;
try
{
switch (comboBox1.Text)
{
case "Fisrt name": { query = "SELECT id,name,family,phone FROM phoneTable WHERE name like '" + textBox1.Text + "%'"; break; }
case "Last name": { query = "SELECT id,name,family,phone FROM phoneTable WHERE family like '" + textBox1.Text + "%'"; break; }
case "Phone number": { query = "SELECT id,name,family,phone FROM phoneTable WHERE phone like '" + textBox1.Text + "%'"; break; }
default: { break; }
}
con = new SqlConnection(connect);
con.Open();
command = new SqlCommand();
command.CommandText = query;
command.Connection = con;
adapter = new SqlDataAdapter();
adapter.SelectCommand = command;
objDataTable = new DataTable();
adapter.Fill(objDataTable);
con.Close();
dataGridView1.DataSource = objDataTable;
}
catch { MessageBox.Show("File Not Found"); }
}