hi,
this will help you
<pre lang="cs">
public class MyClass
{
public DataSet GetList(string txt1,string txt2,string txt3)
{
SqlConnection cs1 = new SqlConnection("Data Source=nemesisfc; Initial Catalog=FreezerTemps; Integrated Security=TRUE");
SqlCommand cmd1 = new SqlCommand();
cs1.Open();
cmd1.CommandText = "write ur sql select query here";
DataSet dtst = new DataSet();
SqlDataAdapter dp = new SqlDataAdapter(cmd1);
dp.Fill(dtst);
cs1.Close();
return dtst;
}
}
//---in your form
public void BindDrops()
{
MyClass cl= new MyClass();
combobox.DataSource = DTL.GetList(txtbx1.Text,txt2.Text,txt3.Text));
combobox.DataBind();
}