How to map data from dataAdaptater to dataset correctly

[tom572007]

Hi I need a few help to make a correct mapping from my dataAdaptater to my dataSet:

SqlConnection conn = new SqlConnection("Data Source=localhost;Initial Catalog=JWDTA016;Integrated Security=True");
DataAdaptater.SelectCommand = new SqlCommand(QueryString, conn);

//I try to create mapping
DataTableMapping mapping = DataAdaptater.TableMappings.Add("Table", "dt");
mapping.ColumnMappings.Add("IXROOT", "Client root");
mapping.ColumnMappings.Add("IXADID", "Addres id");
mapping.ColumnMappings.Add("IXPATH", "PDF Path");
mapping.ColumnMappings.Add("IXID", "Document id");
mapping.ColumnMappings.Add("IXESEQ", "Extraction sequence");
mapping.ColumnMappings.Add("ISSTAT", "Status");
mapping.ColumnMappings.Add("DIFREQ", "Sending frequence");
mapping.ColumnMappings.Add("IXPID", "Production id");

//But when I display the ds into my datagrid, it can just display all my dataquery result and not only the colums i want to map
DataAdaptater.Fill(dt);
Ultragrid.DataSource = dataGridData.Tables[0].DefaultView;
Ultragrid.DataBind();

If somebody has an idea or see some wrong in my thought process... regards

[tom572007]

No response as usual!

[tom572007]

Useless forum ....