setting up OleDbParameter in C# code

Question

How do you set up a parameter in c#. Also how will i pass the info to the parameter. I will have a dropdown list and once the user selects the specified article of clothing I will need the program to pass the id to this procedure here is the code I have right now...It's in the Page Load method
if (!IsPostBack)
{
oleDbConnection1.Close();
oleDbConnection1.Open();
ds = new DataSet();
daSizes = new System.Data.OleDb.OleDbDataAdapter(
"SELECT [Sizes].[Size] FROM [Sizes], [Items], [ProductSizes] WHERE (([Items].[Clot" +
"hingID] = [ProductSizes].[ClothingID]) AND ([ProductSizes].[SizeID] = [Sizes].[S" +
"izeID]) AND ([Items].[ClothingID] = @ClothingID))", oleDbConnection1);
daSizes.Fill(ds, "Sizes");
DropDownList1.DataSource = ds.Tables["Sizes"];
DropDownList1.DataTextField = "Size";
this.DataBind();
oleDbConnection1.Close();
}

zeeshan_kyo · Answer

Here is your solution.
private void page_load(object sender, EventArgs e)
{
if(!Page.IsPostBack)
{
string StrCon = "Provider=Microsoft.Jet.OleDb.4.0; Data Source = " + Server.MapPath("db/MyData.mdb");
string StrQuery = "Select Color, Size From Clothes Where ClothID = @ClothID";
OleDbConnection ObjCon = new OleDbConnection(StrCon);
OleDbDataAdapter ObjDap = new OleDbDataAdapter(StrQuery, ObjCon);
OleDbDataAdapter.SelectCommand.Parameters.Add("@ClothID", 7);
DataSet ObjDS = new DataSet();
ObjDap.Fill(ObjDS, "Clothes");
DrpList.DataSource = ObjDS.Tables["Clothes"];
DrpList.DataTextField = "Size";
DrpList.DataValueField = "Color";
DrpList.DataBind();
}
}
private void DrpList_SelectedIndexChanged(object sender, EventArgs e)
{
Response.Write(DrpList.SelectedItem.Text);
}
Setting OleDbParameter in C#