C# DataTable.ToString方法代码示例

 public DataTable selectUser(string Username)
 {
     SqlConnection con = new SqlConnection(constr);
     SqlCommand com = new SqlCommand("select_user");
     SqlDataAdapter adp = new SqlDataAdapter(com);
     DataTable userData = new DataTable();
     com.CommandType = CommandType.StoredProcedure;
     com.Parameters.AddWithValue("@Username", Username);
     com.Connection = con;
     try
     {
         con.Open();
         //System.Diagnostics.Debug.Write("HERE 1");//DEBUG
         adp.Fill(userData);
     }
     catch(Exception ex)
     {
         throw ex;
     }
     finally
     {
         System.Diagnostics.Debug.Write("HERE 2");
         con.Close();
     }
     System.Diagnostics.Debug.Write("HERE 3: "+userData.ToString());
     return userData;
 }

 private void Form_mostrar_populcao_Load(object sender, EventArgs e)
 {
     dt = new DataTable();
     
     for(int i = 0; i< ds.Tables.Count; i++)
     {
         dt= ds.Tables[i].Clone(); //Tabela recebe dados XML
         listView1.Items.Add(dt.ToString());
     }
 }

        public TableViewer(frmMain owner, DataTable dt)
        {
            #if (DEBUG_1||DEBUG_2||DEBUG_3)
            debugLogger = new DebugLogger("frmTable.log");
            #endif
            debugLogger.WriteDebug_3("Begin Method: frmTable.frmTable(frmMain,DataTable) (" + owner.ToString() + "," + dt.ToString() + ")");

            this.owner = owner;
            local=true;
            InitializeComponent();
            dataGrid.ReadOnly = true;
            dbTable = dt;
            dataGrid.SetDataBinding(dbTable,"");
            this.dbTable.RowChanged += new DataRowChangeEventHandler(dbTable_Changed);
            this.dbTable.RowDeleted += new DataRowChangeEventHandler(dbTable_Changed);

            debugLogger.WriteDebug_3("End Method: frmTable.frmTable()");
        }

        public AddRemoveDialog(frmMain owner, DataTable dt, int addOrRemove, string raidname, DateTime date)
        {
            #if (DEBUG_1||DEBUG_2||DEBUG_3)
            debugLogger = new DebugLogger("frmAddRemove.log");
            #endif
            debugLogger.WriteDebug_3("Begin Method: frmAddRemove.frmAddRemove(frmMain,DataTable,int,string,DateTime) ("
                + owner.ToString() + "," + dt.ToString() + "," + addOrRemove.ToString() + "," + date.ToShortDateString() + ")");
            InitializeComponent();
            this.owner = owner;
            cboPeople.DataSource = dt;
            cboPeople.DisplayMember = "Name";
            lblRaid.Text = "Raid: " + raidname;
            lblDate.Text = "Date: " + date.Month + "/" + date.Day + "/" + date.Year;
            if (addOrRemove == ADD) { btnAddRemove.Text = "Add"; add = true; }
            else if (addOrRemove == REMOVE) { btnAddRemove.Text = "Remove"; add = false; }

            debugLogger.WriteDebug_3("End Method: frmAddRemove.frmAddRemove()");
        }

        public ForeignKey MapToForeignKey(DataRow row, DataTable schema)
        {
            var dbForeignKey = new ForeignKey
            {
                Name                  = row["FK_NAME"].ToString(),
                OriginalName          = row["FK_NAME"].ToString(),
                ForeignKeyTableName   = row["FK_TABLE_NAME"].ToString(),
                PrimaryKeyTableName   = row["PK_TABLE_NAME"].ToString(),
                ForeignKeyTableSchema = schema.ToString()
            };

            var fkc = new ForeignKeyColumn { Name = row["FK_COLUMN_NAME"].ToString() };
            dbForeignKey.ForeignKeyColumns.Add(fkc);

            var pkc = new PrimaryKeyColumn { Name = row["PK_COLUMN_NAME"].ToString() };
            dbForeignKey.PrimaryKeysColumns.Add(pkc);

            return dbForeignKey;
        }

        public AppAltDialog(frmMain owner, string name, DataTable dt)
        {
            #if (DEBUG_1||DEBUG_2||DEBUG_3)
            debugLogger = new DebugLogger("frmAppAlt.log");
            #endif
            debugLogger.WriteDebug_3("Begin Method: frmAppAlt.frmAppAlt(frmMain,string,DataTable) (" + owner.ToString() +
                "," + name.ToString() + "," + dt.ToString() + ")");

            InitializeComponent();
            this.owner = owner;
            this.name = name;
            lblNotFound.Text = name + " not found in database.  Who is s/he?";
            cboPeople.DataSource = dt;
            cboPeople.DisplayMember = "Name";
            rdoApp.Checked = true;
            cboClass.Items.AddRange( new object[] {	  "BER", "BRD", "BST", "CLR", "DRU", "ENC",
                                                      "MAG", "MNK", "NEC", "PAL", "RNG", "ROG",
                                                      "SHD", "SHM", "WAR", "WIZ" });

            debugLogger.WriteDebug_3("End Method: frmAppAlt.frmAppAlt()");
        }

        public MainWindow()
        {
            InitializeComponent();

            string pokedex_filepath = filepath + "pokedex\\data\\csv\\";

            try
            {
                using (StreamReader sr = new StreamReader(pokedex_filepath + "pokemon_species.csv"))
                {
                    string data = sr.ReadToEnd();
                    sr.Close();

                    List<string> lines = new List<string>(data.Split('\n'));

                    string[] colnames = lines[0].Split(',');

                    lines.RemoveAt(0);

                    DataTable Species = new DataTable("Species");

                    foreach (string colname in colnames)
                        Species.Columns.Add(new DataColumn(colname));

                    foreach (string line in lines)
                    {
                        DataRow dr = Species.Rows.Add();
                        dr.ItemArray = line.Split(',');
                    }

                    Species.ToString();
                }
            }
            catch (Exception ex)
            {
                AddLog("Something went wrong.", MessageType.Error);
            }
        }

        private void equals_Click(object sender, EventArgs e)
        {
            try
            {
                input = this.resultWindow.Text;
                object result = new DataTable().Compute(input, null);

                this.resultWindow.Text = result.ToString();

                addToHistory(input);
                updateResultHistory();
                input = "";

            }
            catch
            {

                this.resultWindow.Text = "ERROR";

                addToHistory(input);
                updateResultHistory();
                input = "";
            }
        }

 private string GetXmlSchema(DataTable dt)
 {
     using (var writer = new StringWriter())
     {
         dt.WriteXmlSchema(writer);
         return dt.ToString();
     }
 }

		public void ToStringTest()
		{
			DataTable dt = new DataTable();
			dt.Columns.Add("Col1", typeof(int));

			dt.TableName = "Mytable";
			dt.DisplayExpression = "Col1";

			string cmpr = dt.TableName + " + " + dt.DisplayExpression;
			Assert.AreEqual (cmpr, dt.ToString());
		}

        //public static bool ValidarCodigoPostal(string pCodigo)
        //{
        //    int i;
        //    for (i = 0; i <= pCodigo.Length - 1; i++)
        //    {
        //        if (Information.IsNumeric(pCodigo(i)))
        //        {
        //            return true;
        //        }
        //    }
        //    return false;
        //}
        public static string ConvertDataTableToXML(DataTable dtBuildSQL)
        {
            DataSet dsBuildSQL = new DataSet();

            StringBuilder sbSQL;
            StringWriter swSQL;
            string XMLformat;
            sbSQL = new StringBuilder();
            swSQL = new StringWriter(sbSQL);
            dsBuildSQL.Merge(dtBuildSQL);//, true, MissingSchemaAction.AddWithKey);
            dsBuildSQL.Tables[0].TableName = dtBuildSQL.ToString();
            foreach (DataColumn col in dsBuildSQL.Tables[0].Columns)
            {

                col.ColumnMapping = MappingType.Attribute;

            }
            dsBuildSQL.WriteXml(swSQL, XmlWriteMode.WriteSchema);
            XMLformat = sbSQL.ToString();
            return XMLformat;
        }

        public void UpdateLoot(DataTable dt)
        {
            debugLogger.WriteDebug_3("Begin Method: Raid.UpdateLoot(DataTable) (" + dt.ToString() + ")");

            foreach (DataRow r in dbRaid.Select("(PTS<0)")) { dbRaid.Rows.Remove(r); }
            foreach (DataRow r in dt.Rows) { dbRaid.Rows.Add(r.ItemArray); }

            debugLogger.WriteDebug_3("End Method: Raid.UpdateLoot()");
        }

        void Math(Id id, string text)
        {
            Dialogue dialogue = Sessions[id];

            try
            {
                var result = new DataTable().Compute(text, null);
                botClient.SendReply(id.chat_id, MessageId(dialogue), result.ToString());
            }
            catch
            {
                botClient.SendReply(id.chat_id, MessageId(dialogue), "I can't solve this");
            }
        }