大家做系统更新或者升级都可能要触及到数据的转换
对于ORACLE中的数据转换可以用写存储过程来放之游标将你要的数据一条一条的转换
而对于SERVER虽然你可以将它转换到ORACLE中(升级的方式)但有问题你会发现有的表是不可以直接转换的!
所以我就用代码控制直接转换!也是一种比较容易控制容易写的方法!
首先你要在程序中建立连接(server的)
string strCon=workstation id=XJ;packet size=;user id=sa;data source=automap\automap;persist security info=True;initial catalog=bgxtrmt;password=sa;
string strTxt = SELECT tworder_code stru_b layer_b area_ub area_b east south west north area_sb densy_b grean_b park park_bike other_areagrean_bsp_build_p FROM bgxtpab_;
SqlConnection SqlCon = new SqlConnection(strCon);
SqlCommand SqlCmd = new SqlCommand(strTxtSqlCon);
SqlConOpen();
然后将你要读的数据用dataReaderreader方法读进来!
SqlDataReader SqlDR = SqlCmdExecuteReader(CommandBehaviorCloseConnection);
while(SqlDRRead())
{
try
{
OracleConOpen();
Bgxtpab_ bg = new Bgxtpab_();
//Doc d = new Doc();
//int i = ;
bgTworder_Code = SqlDRGetString()Trim();
bgStru_B = SqlDRIsDBNull()?:SqlDRGetString()Trim();
bgLayer_B = SqlDRIsDBNull()?:SqlDRGetInt();
bgArea_UB = SqlDRIsDBNull()?:SqlDRGetString();
bgArea_B = SqlDRIsDBNull()?:SqlDRGetString();
bgEast_B = SqlDRIsDBNull()?:SqlDRGetString()Trim();
bgSouth_B = SqlDRIsDBNull()?:SqlDRGetString()Trim();
bgWest_B = SqlDRIsDBNull()?:SqlDRGetString()Trim();
bgNorth_B = SqlDRIsDBNull()?:SqlDRGetString()Trim();
//bgLayer_BD = SqlDRIsDBNull(++i)?F:SqlDRGetInt(i);
bgArea_SB = SqlDRIsDBNull()?:SqlDRGetString();
bgDensy_B = SqlDRIsDBNull()?:SqlDRGetString();
bgPark = SqlDRIsDBNull()?F:SqlDRGetFloat();
bgPark_Bike = SqlDRIsDBNull()?F:SqlDRGetFloat();
bgOTher_Area = SqlDRIsDBNull()?F:SqlDRGetFloat();
bgGrean_B = SqlDRIsDBNull()?F:SqlDRGetFloat();
bgSp_build_P = SqlDRIsDBNull()?:SqlDRGetString();
这样你就获得了你要的数据还要提到的是!你必须为你想读的表写个数据表的类!
using System;
namespace ProjectBulid
{
/// <summary>
/// Bgxtpab_工程数据表
/// </summary>
public class Bgxtpab_
{
string tworder_code;
//string project_b;
string densy_b;
string stru_b;
int layer_b;
string area_ub;
string area_b;
string usage_b;
string east;
string south;
string west;
string north;
string area_sb;
float grean_b;
float park;
float park_bike;
// decimal other_area_b;
string sp_build_p;
float other_area;
public Bgxtpab_()
{
tworder_code = ;
//project_b= ;
stru_b = ;
layer_b = ;
area_ub = ;
area_b = ;
usage_b = ;
east = ;
south= ;
west = ;
north = ;
//layer_db = ;
area_sb = ;
densy_b = ;
grean_b = F;
park = F;
park_bike = F;
sp_build_p = ;
other_area = F;
}
public string Tworder_Code
{
get
{
return tworder_code;
}
set
{
tworder_code = value;
}
}
public string Densy_B
{
get
{
return densy_b;
}
set
{
densy_b = value;
}
}
// public int Project_B
// {
// get
// {
// return project_b;
// }
// set
// {
// project_b = value;
// }
// }
public string Stru_B
{
get
{
return stru_b;
}
set
{
stru_b = value;
}
}
public int Layer_B
{
get
{
return layer_b;
}
set
{
layer_b = value;
}
}
public string Area_UB
{
get
{
return area_ub;
}
set
{
area_ub = value;
}
}
public string Area_B
{
get
{
return area_b;
}
set
{
area_b = value;
}
}
public string Usage_B
{
get
{
return usage_b;
}
set
{
usage_b = value;
}
}
public string East_B
{
get
{
return east;
}
set
{
east = value;
}
}
public string South_B
{
get
{
return south;
}
set
{
south = value;
}
}
public string West_B
{
get
{
return west;
}
set
{
west = value;
}
}
public string North_B
{
get
{
return north;
}
set
{
north = value;
}
}
// public int Layer_BD
// {
// get
// {
// return layer_db;
// }
// set
// {
// layer_db = value;
// }
// }
public string Area_SB
{
get
{
return area_sb;
}
set
{
area_sb = value;
}
}
public float Grean_B
{
get
{
return grean_b;
}
set
{
grean_b = value;
}
}
public float Park
{
get
{
return park;
}
set
{
park = value;
}
}
public float Park_Bike
{
get
{
return park_bike;
}
set
{
park_bike = value;
}
}
public string Sp_build_P
{
get
{
return sp_build_p;
}
set
{
sp_build_p = value;
}
}
public float OTher_Area
{
get
{
return other_area;
}
set
{
other_area = value;
}
}
}
}