用c#程序时时从oacle倒到sqlserver2000里的数据为和出现乱码? 用c#程序时时从oacle倒到sqlserver2000里的数据为和出现乱码? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 把代码贴出来,大家帮着看看,要倒数据量较大,导出的前几条正常,后来的就乱码了不知道社么原因,怎么办??while(true) { string selectcmd = "select * from v_duanxin_query"; string insertcmd = ""; OracleDbConnection myoracle = new OracleDbConnection(ConfigurationSettings.AppSettings["oracleconnstring"]); OracleDbCommand myoraclecomm = new OracleDbCommand(selectcmd,myoracle); SqlConnection mysqlconn = new SqlConnection(ConfigurationSettings.AppSettings["sqlconnstring"]); SqlCommand mysqlcomm = new SqlCommand(insertcmd,mysqlconn); myoracle.Open(); mysqlconn.Open(); try { OracleDbDataReader myreader = myoraclecomm.ExecuteReader(); mysqlcomm.CommandText="delete fasong"; mysqlcomm.ExecuteNonQuery(); while(myreader.Read()) { mysqlcomm.CommandText="insert into fasong(calling_nbr,counts) values('"+myreader["calling_nbr"].ToString()+"','"+myreader["counts"].ToString()+"')"; mysqlcomm.ExecuteNonQuery(); Thread.Sleep(7200000); } } catch(Exception ev) { Console.WriteLine(ev.Message); } finally { myoracle.Close(); mysqlconn.Close(); } Console.WriteLine("Waiting..."); Thread.Sleep(7200000); } 把代码贴出来,大家帮着看看,要倒数据量较大,导出的前几条正常,后来的就乱码了不知道社么原因,怎么办??while(true) { string selectcmd = "select * from v_duanxin_query"; string insertcmd = ""; OracleDbConnection myoracle = new OracleDbConnection(ConfigurationSettings.AppSettings["oracleconnstring"]); OracleDbCommand myoraclecomm = new OracleDbCommand(selectcmd,myoracle); SqlConnection mysqlconn = new SqlConnection(ConfigurationSettings.AppSettings["sqlconnstring"]); SqlCommand mysqlcomm = new SqlCommand(insertcmd,mysqlconn); myoracle.Open(); mysqlconn.Open(); try { OracleDbDataReader myreader = myoraclecomm.ExecuteReader(); mysqlcomm.CommandText="delete fasong"; mysqlcomm.ExecuteNonQuery(); while(myreader.Read()) { mysqlcomm.CommandText="insert into fasong(calling_nbr,counts) values('"+myreader["calling_nbr"].ToString()+"','"+myreader["counts"].ToString()+"')"; mysqlcomm.ExecuteNonQuery(); Thread.Sleep(7200000); } } catch(Exception ev) { Console.WriteLine(ev.Message); } finally { myoracle.Close(); mysqlconn.Close(); } Console.WriteLine("Waiting..."); Thread.Sleep(7200000); } 可能是oracle客户端字符集设置的问题你看一下注册表里的字符集是否和服务器端的字符集设置一样程序在读取数据时也要统一一下字符集 【难】关于URL编码问题 基于asp.net ajax 的异步加载无限级联树状菜单 WPF中需要DoEvents吗? 只要from的关闭按钮,不要最小化,最大化按钮怎么弄啊? 可能理解的不对 敬请谅解 错误日志,大家是如何做的? c#如何后台模拟鼠标操作? 字符串"int"转换 C# 数据库还原 执行不成功,请指教! 谁可以给我举一个upd多路广播的例子? 大家帮帮忙!谢谢.给分! ado中 rs!["name"]的存取数据的方法在ado.net中是否有类似的
不知道社么原因,怎么办??
while(true)
{
string selectcmd = "select * from v_duanxin_query";
string insertcmd = "";
OracleDbConnection myoracle = new OracleDbConnection(ConfigurationSettings.AppSettings["oracleconnstring"]);
OracleDbCommand myoraclecomm = new OracleDbCommand(selectcmd,myoracle);
SqlConnection mysqlconn = new SqlConnection(ConfigurationSettings.AppSettings["sqlconnstring"]);
SqlCommand mysqlcomm = new SqlCommand(insertcmd,mysqlconn);
myoracle.Open();
mysqlconn.Open();
try
{
OracleDbDataReader myreader = myoraclecomm.ExecuteReader();
mysqlcomm.CommandText="delete fasong";
mysqlcomm.ExecuteNonQuery();
while(myreader.Read())
{
mysqlcomm.CommandText="insert into fasong(calling_nbr,counts) values('"+myreader["calling_nbr"].ToString()+"','"+myreader["counts"].ToString()+"')";
mysqlcomm.ExecuteNonQuery();
Thread.Sleep(7200000); }
}
catch(Exception ev)
{
Console.WriteLine(ev.Message);
}
finally
{
myoracle.Close();
mysqlconn.Close();
}
Console.WriteLine("Waiting...");
Thread.Sleep(7200000);
}
不知道社么原因,怎么办??
while(true)
{
string selectcmd = "select * from v_duanxin_query";
string insertcmd = "";
OracleDbConnection myoracle = new OracleDbConnection(ConfigurationSettings.AppSettings["oracleconnstring"]);
OracleDbCommand myoraclecomm = new OracleDbCommand(selectcmd,myoracle);
SqlConnection mysqlconn = new SqlConnection(ConfigurationSettings.AppSettings["sqlconnstring"]);
SqlCommand mysqlcomm = new SqlCommand(insertcmd,mysqlconn);
myoracle.Open();
mysqlconn.Open();
try
{
OracleDbDataReader myreader = myoraclecomm.ExecuteReader();
mysqlcomm.CommandText="delete fasong";
mysqlcomm.ExecuteNonQuery();
while(myreader.Read())
{
mysqlcomm.CommandText="insert into fasong(calling_nbr,counts) values('"+myreader["calling_nbr"].ToString()+"','"+myreader["counts"].ToString()+"')";
mysqlcomm.ExecuteNonQuery();
Thread.Sleep(7200000); }
}
catch(Exception ev)
{
Console.WriteLine(ev.Message);
}
finally
{
myoracle.Close();
mysqlconn.Close();
}
Console.WriteLine("Waiting...");
Thread.Sleep(7200000);
}
你看一下注册表里的字符集是否和服务器端的字符集设置一样程序在读取数据时也要统一一下字符集