110,499
社区成员
发帖
与我相关
我的任务
分享
/// <summary>
/// 执行 SQL 语句,并返回受影响的行数
/// </summary>
/// <returns></returns>
public int ExecuteNonQuery()
{
if (string.IsNullOrEmpty(_ConnectionString))
{
throw (new Exception("无传入数据连接字串"));
}
if (string.IsNullOrEmpty(_CommandText))
{
throw (new Exception("无传入SQL语句"));
}
if (!DSAFConnectionTest())
{
throw (new Exception("尝试数据库连接失败"));
}
int iQuery = 0;
MySqlTransaction Transaction = null;
try
{
MySqlCommand Comm = new MySqlCommand();
Conn = new MySqlConnection();
Conn.ConnectionString = _ConnectionString;
Conn.Open();
Comm.Connection = Conn;
Comm.CommandText = _CommandText;
Transaction = Conn.BeginTransaction();
Comm.Transaction = Transaction;
iQuery = Comm.ExecuteNonQuery();
Transaction.Commit();
return iQuery;
}
catch (MySqlException MySqlEx)
{
Transaction.Rollback();
throw MySqlEx;
}
catch (Exception ex)
{
throw ex;
}
finally
{ Transaction.Dispose();
Conn.Close();
Conn.Dispose();
}
}
insert into aa values('SSS測試,测试þØ')
select * from aa
a
--------------------
SSS測試,??tO
(1 row(s) affected)
//批量数据转换
//其实就是将dataset的内容读出到xml文件,然后再输出
public DataSet ISO8859_GB2312(DataSet ds)
{
string xml;
xml = ds.GetXml();
ds.Clear();
//声明字符集
System.Text.Encoding iso8859, utf8;
//iso8859
iso8859 = System.Text.Encoding.GetEncoding("iso8859-1");
//国标2312
utf8 = System.Text.Encoding.GetEncoding("utf-8");
byte[] bt;
bt = iso8859.GetBytes(xml);
xml = utf8.GetString(bt);
ds.ReadXml(new System.IO.StringReader(xml));
return ds;
}
IF OBJECT_ID('TEMPDB..#TEMP') >0 DROP TABLE #TEMP
CREATE TABLE #TEMP(TXT CHAR(100))
INSERT INTO #TEMP
SELECT * FROM
(
SELECT A= N'SSS測試,测试þØ'
) B
SELECT * FROM #TEMP
IF OBJECT_ID('TEMPDB..#TEMP') >0 DROP TABLE #TEMP
CREATE TABLE #TEMP(TXT NVARCHAR(100))
INSERT INTO #TEMP
SELECT * FROM
(
SELECT A= N'SSS測試,测试þØ'
) B
SELECT * FROM #TEMP