當前位置: 首頁>>代碼示例>>C#>>正文


C# MySqlCommandBuilder.ToString方法代碼示例

本文整理匯總了C#中MySql.Data.MySqlClient.MySqlCommandBuilder.ToString方法的典型用法代碼示例。如果您正苦於以下問題:C# MySqlCommandBuilder.ToString方法的具體用法?C# MySqlCommandBuilder.ToString怎麽用?C# MySqlCommandBuilder.ToString使用的例子?那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在MySql.Data.MySqlClient.MySqlCommandBuilder的用法示例。


在下文中一共展示了MySqlCommandBuilder.ToString方法的5個代碼示例,這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚,您的評價將有助於係統推薦出更棒的C#代碼示例。

示例1: UpdateNullTextFieldToEmptyString

        public void UpdateNullTextFieldToEmptyString()
        {
            CreateDefaultTable();
              execSQL("INSERT INTO Test (id, id2, name) VALUES (1, 1, NULL)");

              MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM Test", conn);
              MySqlCommandBuilder cb = new MySqlCommandBuilder(da);
              cb.ToString();  // keep the compiler happy

              DataTable dt = new DataTable();
              da.Fill(dt);

              dt.Rows[0]["name"] = "";
              int updateCnt = da.Update(dt);

              Assert.AreEqual(1, updateCnt);

              dt.Rows.Clear();
              da.Fill(dt);

              Assert.AreEqual(1, dt.Rows.Count);
              Assert.AreEqual("", dt.Rows[0]["name"]);
        }
開發者ID:schivei,項目名稱:mysql-connector-net,代碼行數:23,代碼來源:DataAdapterTests.cs

示例2: UpdateExtendedTextFields

        public void UpdateExtendedTextFields()
        {
            execSQL("CREATE TABLE Test (id int, notes MEDIUMTEXT, PRIMARY KEY(id))");
              execSQL("INSERT INTO Test VALUES(1, 'This is my note')");

              MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM Test", conn);
              MySqlCommandBuilder cb = new MySqlCommandBuilder(da);
              cb.ToString();  // keep the compiler happy
              DataTable dt = new DataTable();
              da.Fill(dt);

              dt.Rows[0]["notes"] = "This is my new note";
              da.Update(dt);

              dt.Clear();
              da.Fill(dt);
              Assert.AreEqual("This is my new note", dt.Rows[0]["notes"]);
        }
開發者ID:schivei,項目名稱:mysql-connector-net,代碼行數:18,代碼來源:DataAdapterTests.cs

示例3: Bug5798

        public void Bug5798()
        {
            CreateDefaultTable();
              execSQL("INSERT INTO Test (id, id2, name) VALUES (1, 1, '')");

              MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM Test", conn);
              MySqlCommandBuilder cb = new MySqlCommandBuilder(da);
              cb.ToString();  // keep the compiler happy
              DataTable dt = new DataTable();
              da.Fill(dt);

              Assert.AreEqual(String.Empty, dt.Rows[0]["name"]);

              dt.Rows[0]["name"] = "Test";
              da.Update(dt);

              dt.Clear();
              da.Fill(dt);
              Assert.AreEqual("Test", dt.Rows[0]["name"]);
        }
開發者ID:schivei,項目名稱:mysql-connector-net,代碼行數:20,代碼來源:DataAdapterTests.cs

示例4: OriginalInName

        public void OriginalInName()
        {
            CreateDefaultTable();
              MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM Test", conn);
              MySqlCommandBuilder cb = new MySqlCommandBuilder(da);
              cb.ToString();  // keep the compiler happy
              DataTable dt = new DataTable();
              da.Fill(dt);

              DataRow row = dt.NewRow();
              row["id"] = DBNull.Value;
              row["id2"] = 1;
              row["name"] = "Test";
              row["dt"] = DBNull.Value;
              row["tm"] = DBNull.Value;
              row["ts"] = DBNull.Value;
              row["OriginalId"] = 2;
              dt.Rows.Add(row);
              da.Update(dt);

              Assert.AreEqual(1, dt.Rows.Count);
              Assert.AreEqual(2, dt.Rows[0]["OriginalId"]);
        }
開發者ID:schivei,項目名稱:mysql-connector-net,代碼行數:23,代碼來源:DataAdapterTests.cs

示例5: UpdateDataSet

        /// <summary>
        /// Updates the given table with data from the given <see cref="DataSet"/>
        /// </summary>
        /// <param name="connectionString">Settings to use for the update</param>
        /// <param name="commandText">Command text to use for the update</param>
        /// <param name="ds"><see cref="DataSet"/> containing the new data to use in the update</param>
        /// <param name="tablename">Tablename in the dataset to update</param>
        public static void UpdateDataSet( string connectionString, string commandText, DataSet ds, string tablename )
        {
            MySqlConnection cn = new MySqlConnection( connectionString );
            cn.Open();
            MySqlDataAdapter da = new MySqlDataAdapter( commandText, cn );
            MySqlCommandBuilder cb = new MySqlCommandBuilder(da);
            cb.ToString();
            da.Update( ds, tablename );
            cn.Close();
        }
開發者ID:LittlePeng,項目名稱:ncuhome,代碼行數:17,代碼來源:MySqlHelper.cs


注:本文中的MySql.Data.MySqlClient.MySqlCommandBuilder.ToString方法示例由純淨天空整理自Github/MSDocs等開源代碼及文檔管理平台,相關代碼片段篩選自各路編程大神貢獻的開源項目,源碼版權歸原作者所有,傳播和使用請參考對應項目的License;未經允許,請勿轉載。