static public List<string> a=new List<string>();
///////////这里是导出
String commStr = ConfigurationManager.ConnectionStrings["CommStr"].ConnectionString; //需要去添加引用
using (SqlCeConnection comm = new SqlCeConnection(commStr))
{
comm.Open();
using (SqlCeCommand cmd = comm.CreateCommand())
{
cmd.CommandText = "select * from TBLSYS_PINYIN";
using (SqlCeDataReader dataReader = cmd.ExecuteReader()) //对数据库进行逐行读取,只能读取,不能修改
{
while (dataReader.Read())
{
ProvinceItem item = new ProvinceItem();
item.Name = dataReader.GetString(dataReader.GetOrdinal("hanzi"));
a.Add(item.Name);
}
MessageBox.Show("导出成功!");
}
}
}\\\\\\\\这里是导入
String commStrs = ConfigurationManager.ConnectionStrings["CommStrs"].ConnectionString;
using (SqlConnection comm = new SqlConnection(commStrs))
{
comm.Open();
MessageBox.Show("进入");
using (SqlCommand cmd = comm.CreateCommand())
{
cmd.CommandText = "Insert into T_table(mz)values(@mz)";
foreach (string strs in a)
{
cmd.Parameters.Clear();
cmd.Parameters.Add(new SqlParameter("mz",strs));
cmd.ExecuteNonQuery();
} MessageBox.Show("导入成功");
}
}
}
是把CE离线数据库中的数据导入到我自己的数据库中,需要重复导入几十个字段,但是不会写函数,谢谢高手拉
///////////这里是导出
String commStr = ConfigurationManager.ConnectionStrings["CommStr"].ConnectionString; //需要去添加引用
using (SqlCeConnection comm = new SqlCeConnection(commStr))
{
comm.Open();
using (SqlCeCommand cmd = comm.CreateCommand())
{
cmd.CommandText = "select * from TBLSYS_PINYIN";
using (SqlCeDataReader dataReader = cmd.ExecuteReader()) //对数据库进行逐行读取,只能读取,不能修改
{
while (dataReader.Read())
{
ProvinceItem item = new ProvinceItem();
item.Name = dataReader.GetString(dataReader.GetOrdinal("hanzi"));
a.Add(item.Name);
}
MessageBox.Show("导出成功!");
}
}
}\\\\\\\\这里是导入
String commStrs = ConfigurationManager.ConnectionStrings["CommStrs"].ConnectionString;
using (SqlConnection comm = new SqlConnection(commStrs))
{
comm.Open();
MessageBox.Show("进入");
using (SqlCommand cmd = comm.CreateCommand())
{
cmd.CommandText = "Insert into T_table(mz)values(@mz)";
foreach (string strs in a)
{
cmd.Parameters.Clear();
cmd.Parameters.Add(new SqlParameter("mz",strs));
cmd.ExecuteNonQuery();
} MessageBox.Show("导入成功");
}
}
}
是把CE离线数据库中的数据导入到我自己的数据库中,需要重复导入几十个字段,但是不会写函数,谢谢高手拉
public void Method1(List<string> a)
{
String commStr = ConfigurationManager.ConnectionStrings["CommStr"].ConnectionString; //需要去添加引用
using (SqlCeConnection comm = new SqlCeConnection(commStr))
{
comm.Open();
using (SqlCeCommand cmd = comm.CreateCommand())
{
cmd.CommandText = "select * from TBLSYS_PINYIN";
using (SqlCeDataReader dataReader = cmd.ExecuteReader()) //对数据库进行逐行读取,只能读取,不能修改
{
while (dataReader.Read())
{
ProvinceItem item = new ProvinceItem();
item.Name = dataReader.GetString(dataReader.GetOrdinal("hanzi"));
a.Add(item.Name);
}
MessageBox.Show("导出成功!");
}
}
}
}