自制工具,将SqlServer数据导入到SqlCE数据库

            StringBuilder strclass = new StringBuilder();
//strclass.AppendLine("if exists (select * from sysobjects where id = OBJECT_ID('[" + tablename + "]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) ");
//strclass.AppendLine("DROP TABLE [" + tablename + "]");

//string PKfild = "";//主键字段
//bool IsIden = false;//是否是标识字段
            StringBuilder ColdefaVal = new StringBuilder();//字段的默认值列表			

            Hashtable FildtabList = new Hashtable();//字段列表（字段名，字段类型）
            StringBuilder FildList = new StringBuilder();//字段列表

           DataTable dt = （1中语句查询后得到的表）; //包含表详细信息的DataTable

//开始生成创建表语句。
//建表第一句…..终于开始了
            strclass.AppendLine("CREATE TABLE [" + tablename + "] (");

if (dt != null)
            {
                DataRow[] dtrows;
                dtrows = dt.Select();  //这里可以做点简单的筛选

////也可以这样
//foreach (DataRow row in dt.Rows)
//{
//   //。。。。。。。 
//}

foreach (DataRow row in dtrows)
                {
string columnName = row["ColumnName"].ToString();
string columnType = TypeMap.GetMapedDataType(row["TypeName"].ToString());//转换后的数据类型

string IsIdentity = row["IsIdentity"].ToString();
string Length = row["Length"].ToString();
string Preci = row["Preci"].ToString();
string Scale = row["Scale"].ToString();
string ispk = row["isPK"].ToString();
string isnull = row["cisNull"].ToString();
string defaultVal = row["defaultVal"].ToString();

                    strclass.Append("[" + columnName + "] [" + columnType + "] ");

switch (columnType.Trim())
                    {
case "varchar":
case "char":
case "nchar":
case "binary":
case "nvarchar":
case "varbinary":
                            {
string len = this.GetDataTypeLenVal(columnType.Trim(), Length);//获取字符串长度（注2）
                                strclass.Append(" (" + len + ")");
                            }
break;
case "decimal":
case "numeric":
                            strclass.Append(" (" + Preci + "," + Scale + ")");
break;
                    }
if (isnull == "√")
                    {
                        strclass.Append(" NULL");
                    }
else
                    {
                        strclass.Append(" NOT NULL");
                    }
if (defaultVal != " ")
                    {
                        strclass.Append(" DEFAULT " + defaultVal);
                    }
                    strclass.AppendLine(",");

                    FildtabList.Add(columnName, columnType);
                    FildList.Append("[" + columnName + "],");

//if(defaultVal!="")
//{
//	ColdefaVal.Append("CONSTRAINT [DF_"+tablename+"_"+columnName+"] DEFAULT "+defaultVal+" FOR ["+columnName+"],");
//}

//if((ispk=="√")&&(PKfild==""))
//{						
//    PKfild=columnName;//得到主键
//}
                }
            }
string s = strclass.ToString();

//去掉strclass（）中最后一个豆号
int n = s.LastIndexOf(',');
string ss = s.Substring(0, n) + ")";
            strclass.Remove(0, strclass.ToString().Length);
            strclass.Append(ss);
            strclass.Append(";");//添加一个分号（;）用于分割字符串
            strclass.AppendLine(" ");
            strclass.AppendLine(" ");

//去掉FildList（字段列表）中最后一个豆号
            s = FildList.ToString();
            n = s.LastIndexOf(',');
            ss = s.Substring(0, n);
            FildList.Remove(0, FildList.ToString().Length);
            FildList.Append(ss);

//开始获取表中数据，dtdata中包含了查询数据库得到的数据
            DataTable dtdata = this.getData(dbname,tablename);
//生成插入数据语句
if (dtdata != null)
            {
foreach (DataRow row in dtdata.Rows)//循环表数据
                {
                    StringBuilder strfild = new StringBuilder();
                    StringBuilder strdata = new StringBuilder();
//字段数组
string[] split = FildList.ToString().Split(new Char[] { ',' });

foreach (string fild in split)//循环一行数据的各个字段
                    {
string colname = fild.Substring(1, fild.Length - 2);
string coltype = " ";
foreach (DictionaryEntry myDE in FildtabList)
                        {
if (myDE.Key.ToString() == colname)
                            {
                                coltype = myDE.Value.ToString();
                            }
                        }
string strval = " ";
switch (coltype)
                        {
case "binary":
                                {
//我的数据库中没有binary型数据，这里没有处理;
                                }
break;
case "bit":
                                {
                                    strval = (row[colname].ToString().ToLower() == "true") ? "1" : "0";
                                }
break;
default:
                                strval = row[colname].ToString().Trim().Replace(';','；');
break;
                        }
                        strdata.Append("'" + strval.Replace('\'', '°') + "',"); //字段中剔除分号“’”
                        strfild.Append("[" + colname.Replace('\'', '°') + "],");//数据中剔除分号“’”

                    }
//还是三删除最后一个逗号
                    n = strdata.ToString().LastIndexOf(',');
                    ss = strdata.ToString().Substring(0, n);
                    strdata.Remove(0,strdata.ToString().Length);
                    strdata.Append(ss);

                    n = strfild.ToString().LastIndexOf(',');
                    ss = strfild.ToString().Substring(0, n);
                    strfild.Remove(0, strfild.ToString().Length);
                    strfild.Append(ss);


//导出数据INSERT语句
                    strclass.Append("INSERT [" + tablename + "] (");
                    strclass.Append(strfild.ToString());  //插入字段集
                    strclass.Append(") VALUES ( ");
                    strclass.Append(strdata.ToString().Replace(';','；');//数据值。并将英文分号替换为全角分号。
                    strclass.AppendLine(");");
//一条插入语句完成
                }
            }

//删除语句中最后一个分号
            n = strclass.ToString().LastIndexOf(';');
            ss = strclass.ToString().Substring(0,n);
            strclass.Remove(0, strclass.ToString().Length);
            strclass.Append(ss);

return strclass.ToString();
        }