How to change the name of a field in a dataset?

s9340372

Because you want to bind the names of the same field in two different tables to the same gridview at the same time, but there is a problem, because the field names are the same, an error is prompted, is there any way to change the field names of the tables in the dataset, or Two tables containing different data with the same fields are bound to the same dataset?

For example, both tables contain the two fields "ID", but the data is different. I want to generate a horizontal comparison by adding columns. That is, there are two tables with "ID" in a row. Can the name be changed? Want the data for the two "ID" columns to appear in the same row?

There is also a question, can you dynamically bind the datafield property of a column in the gridview, or can you dynamically bind a field in the dataset as required

thank you.

s9340372

Requires that the fields of the database cannot be changed. . . .

sabs_nn

Ask the landlord, how did you bind two different tables to the gridview at the same time?
As far as I know, if the gridview is directly bound to a dataset, the default is to bind dataset.tables (0) to this table.

s9340372

Use the merge or Columns.Add method to merge into a table and then bind

klongvv

yourDataSet.Tables [0] .Columns [0] .ColumnName = "YourFieldName";

shenmue024

1. change its name
ds.Tables [0] .Columns [0] .ColumnName = "NewFiled"

2. Or specify alias in sql


select A.ID AS ID1, B.ID ....

shenmue024

There is also a question, can you dynamically bind the datafield property of a column in the gridview, or can you dynamically bind a field in the dataset as required
==========

can.

aspx. <% # GetString (Container.DataItem)%>

protected string GetString (object o)
    {
        DataRowView row = (DataRowView) o;
        return row ["field"]. ToString (); // This field can be specified according to conditions.
      
    }