Koristite CODE tag sa strane sto ima kad upisujete code :)
Code:
public void AddAuthor_Click(Object sender, EventArgs E) {
OleDbConnection con = null;
OleDbCommand cmd = null;
string unos;
string strSQL = "SELECT * FROM TABELA Where IME LIKE'"+txtTextBox1.Text+ "%'" +
"And PREZIME LIKE '"+txtTextBox2.Text+ "%'" +
" AND GRAD LIKE '"+txtTextBox3.Text+ "%' "+
" AND DRZAVA = 'unos'" +
" AND GODINA LIKE '"+txtTextBox5.Text+ "%' "+
" AND POSAO LIKE '"+txtTextBox6.Text+ "%' ";
if (txtTextBox4.Text.EndsWith("%") )
{
unos="+txtTextBox4.Text+";
}
else if (txtTextBox4.Text.Equals("") )
{
unos="+%+";
}
else
{
unos="+txtTextBox4.Text+";
}
try {
con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Documents and Settings\\ivanb.LJUBOMIR_IVAN\\Desktop\\database\\Sites.mdb");
cmd = new OleDbCommand(strSQL, con);
con.Open();
grid.DataSource = cmd.ExecuteReader();
grid.DataBind();
} catch (Exception err) {
message.Text = "<p><font color=\"red\">Err: " +
err.Message + "</font></p>";
} finally {
if(con != null)
con.Close();
}
}