c# - 修改数据表

Question

比如我有这张表

EmployeeName     EmpoyeeID
John Mark        60001
Bent Ting        60002
Don  Park        60003

如何显示 EmployeeID 在数据表中有一个前导星号？示例:*60001 *60002 *60003

  public DataTable ListOfEmployee()
    {
        DataSet ds = null;
        SqlDataAdapter adapter;
        try
        {
            using (SqlConnection myDatabaseConnection = new SqlConnection(myConnectionString.ConnectionString))
            {

                myDatabaseConnection.Open();
                using (SqlCommand mySqlCommand = new SqlCommand("Select * Employee", myDatabaseConnection))
                {
                    ds = new DataSet();
                    adapter = new SqlDataAdapter(mySqlCommand);
                   adapter.Fill(ds, "Users");
                }
            }
        }

        catch (Exception ex)
        {
            throw new Exception(ex.Message);
        }
        return ds.Tables[0];
    }

我需要在 Crystal 报表中显示带有员工 ID 前导星号的数据表

public void Employees()
    {
        ReportDocument rptDoc = new ReportDocument();
        Employees ds = new Employees(); // .xsd file name
        DataTable dt = new DataTable();

        // Just set the name of data table
        dt.TableName = "Employees";
        dt = ListOfEmployee(); //This function is located below this function
        ds.Tables[0].Merge(dt);

        string strReportName = "Employees.rpt";
        string strPath = Application.StartupPath + "\\Reports\\" + strReportName;
        // Your .rpt file path will be below
        rptDoc.Load(strPath);

        //set dataset to the report viewer.
        rptDoc.SetDataSource(ds);

        ReportViewer newReportViewer = new ReportViewer();
        newReportViewer.setReport(rptDoc);
        newReportViewer.Show();
    }

Answer 1

最简单不是最好的方法是获取该格式的数据，当且仅当它不打算在其他任何地方使用时。您可以在查询中执行此操作

Select '*'+id,col1,col2,col3 from employee

虽然最好的方法是在消费时修改列值。但显然这比在查询中简单地添加更令人头疼。