Another Gridview Question

Hi All,
I have populate data in gridview manually.
SqlCommand cmd = new SqlCommand(strS QL, cn);
SqlDataAdapter da = new SqlDataAdapter( cmd);
DataSet ds = new DataSet();
da.Fill(ds, "hzFileUpload") ;
gvFile.Visible = true;
gvFile.DataSour ce = ds;
gvFile.DataBind ();
cn.Close();
>
The question is if I want dynamically change the source data / strSQL, how
can I change the boundfield to certain field in table. For example
column[0] I want to change bound to productid if I query from Products and
when query to Customers bound to CustomerID. I would like to change it
programmaticall y.
>
Thank you.
>
Regards,
Gun
>