Populate data controls

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnecS"].ConnectionString);
SqlCommand cmd = new SqlCommand("select * from fast_collection where pid=@pid", con);
cmd.Parameters.AddWithValue("@pid", productID);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
con.Open();
da.Fill(ds);
con.Close();
if (ds.Tables[0].Rows.Count > 0)
{
ddlcollection.DataSource = ds.Tables[0];
ddlcollection.DataTextField = "collection";
ddlcollection.DataValueField = "cid";
ddlcollection.DataBind();
ddlcollection.Items.Insert(0, "--Select--");
}