Hi,
Update your code as below.
private DataTable select(string con)
{
DataTable k = new System.Data.DataTable();
try
{
string str = "Data Source=C:\\Documents and Settings\\almas\\Desktop\\BazarKhodro\\khodro.sdf";
Qconnection.ConnectionString = str;
Qcommand.Connection = Qconnection;
Qcommand.Parameters.AddWithValue("@type", comboBox1 .Text );
Qcommand.Parameters.AddWithValue("@name", textBox3.Text);
Qcommand.Parameters.AddWithValue("@lname", textBox4.Text);
string commandText = " select kharid.date, moshtari.name, moshtari.lname, kharid.type, kharid.modelfrom, kharid.modelto, kharid.tip, kharid.karkardfrom, kharid.karkardto, kharid.color, kharid.pricefrom, kharid.priceto , kharid.parvande FROM kharid INNER JOIN moshtari ON kharid.mid = moshtari.id where "+con;
Qconnection.Open();
Qcommand.CommandText = commandText;
Qcommand.CommandType = CommandType.Text;
SqlCeDataAdapter a = new SqlCeDataAdapter(Qcommand);
a.Fill(k);
Qconnection.Close();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return k;
}
private void button1_Click(object sender, EventArgs e)
{
string u="";
if (textBox3.Text == "" || textBox4.Text == "")
MessageBox.Show("لطفا نام و نام خانوادگي را وارد نماييد");
else
{
if (radioButton9.Checked == true)
{
u = " moshtari.name like '%'+@name+'%' and moshtari.lname like '%'+@lname+'%' ";
}
else if (radioButton8.Checked == true)
{
u = "moshtari.name like '%'+@name+'%' and moshtari.lnamename like '%'+@lname+'%' and kharid.parvande=" + "'فعال'";
}
else
{
u = "moshtari.name like '%'+@name+'%' and moshtari.lnamename like '%'+@lname+'%' and kharid.parvande!=" + "'فعال'";
}
}
dataGridView1.DataSource= select(u);
dataGridView1.DataBind();
}
Hope this will resolve your problem.
I think you are facing the problem because you are not binding the gridview.