Kako da dodam where u select komandu

[ boguda @ 31.05.2013. 17:36 ] @

napisao sam komandu select
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Baza1.mdf;Integrated Security=True;User Instance=True");
SqlDataAdapter dap = new SqlDataAdapter("select * from uplate", con);
DataSet ds = new DataSet();
dap.Fill(ds);
dataGridView2.DataSource = ds.Tables[0];
e sada bi dodao where mesecID=@mesecID
a vrednos mesec ID je u combobox-u

kad radim sa sqlcomand znam da napisem upit nps sqlcommand con=new sqlcommand(...
com.parametars.addwithvalue("@mesecID",combobox.selectedvalue);

ali ne znam kako da dodelim vrednos parametru kad radim sa sqldataadapter_om

[ Dusan Kondic @ 31.05.2013. 17:44 ] @

Nešto kao:

Code:

SqlDataAdapter dap = new SqlDataAdapter("select * from uplate where mesecID = " + combobox.selectedvalue.ToString(), con);

[ boguda @ 01.06.2013. 15:04 ] @

uspeo sam i ovako ne znam da li te pravilno ali radi

private void button2_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Baza1.mdf;Integrated Security=True;User Instance=True");
SqlDataAdapter dap = new SqlDataAdapter("select * from uplate where racunID=@racunID", con);

dap.SelectCommand.Parameters.AddWithValue("@racunID",comboBox4.SelectedValue); OVO SAM DODAO
DataSet ds = new DataSet();
dap.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];