2009 第一问

Question

用OleDb向Excel里插入数据时,会在每单元格数据前加一个单引号,怎样导入才能去掉这个单引号，或者只要   sqlStr += "@" + "RawDataDesc" + "";列不要单引号string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + FileName  + ";" + @"Extended Properties=""Excel 8.0;HDR=Yes;""";                    OleDbConnection conn = new OleDbConnection(strConn);                    OleDbCommand cmd = new OleDbCommand();
                    cmd.Connection = conn;                    conn.Open();
                    string sqlStr = "insert into  [Sheet1$] values (";                                                                                         
                 strCom = "CREATE TABLE [Sheet1]( ";
                    for (int k = 0; k < ds.Tables[0].Columns.Count ; k++)                                                                                                           {
        sqlStr += "@" + ds.Tables[0].Columns[k].Caption + ",";
                                strCom += "[" + ds.Tables[0].Columns[k].Caption + "] ntext , ";
                            
                                        }
                    sqlStr += "@" + "RawDataDesc" + "";
                    strCom += "[" + "RawDataDesc" + "] char";
                    sqlStr += ")";
                    strCom += ") ";                cmd.CommandText = strCom;                 cmd.ExecuteNonQuery();                    OleDbCommand rcmd = new OleDbCommand();
                    rcmd.Connection = conn;
                    rcmd.CommandText = sqlStr;
                    rcmd.CommandType = CommandType.Text;
                 
                    int i = 0;
                    int j = 0;
                    int m = 0;
                    string address = "";
                    string key = "";
                    string guid = "";
                    string num = "";
                    for (m = index; m < ds.Tables[0].Rows.Count; m++)//huang
                    {
                        if (j < 60000)
                        {
                            for (int k = 0; k < ds.Tables[0].Columns.Count ; k++)//lie
                            {
      rcmd.Parameters.AddWithValue("@" + ds.Tables[0].Columns[k].Caption, ds.Tables[0].Rows[m][k].ToString());
                                
                                }
                         if (ds.Tables[0].Rows[m][1].ToString() == "TMSS")
                            {
                               // key = ds.Tables[0].Rows[m][17].ToString();
                                if (value == "BU")
                                {
                                    address = "http://192.168.132.25/ProblemCode/BURawDataDesc.aspx?ReplyId=" + key + "&DataSource=TMSS";
                                }
                                else
                                {
                                    address = "http://192.168.132.25/ProblemCode/CSCRawDataDesc.aspx?ReplyId=" + key + "&DataSource=TMSS";
                                }
                                rcmd.Parameters.Add("@RawDataDesc", OleDbType.Char);
                                rcmd.Parameters["@RawDataDesc"].Value = address;
                            }
                            else
                            {
                               // guid = ds.Tables[0].Rows[m][17].ToString();
                              //  num = ds.Tables[0].Rows[m][18].ToString();
                                if (value == "BU")
                                {
                                    address = "http://192.168.132.25/ProblemCode/BURawDataDesc.aspx?Guid=" + guid + "&Num=" + num + "&DataSource=eSupport";
                                }
                                else
                                {
                                    address = "http://192.168.132.25/ProblemCode/CSCRawDataDesc.aspx?Guid=" + guid + "&Num=" + num + "&DataSource=eSupport";
                                }
                                rcmd.Parameters.Add("@RawDataDesc", OleDbType.Char);
                                rcmd.Parameters["@RawDataDesc"].Value = address;                            }                            rcmd.ExecuteNonQuery();
                            rcmd.Parameters.Clear();
                            Console.WriteLine(i.ToString());
                            i++;                            j++;
                        }
                    }                    j = j - 1;
                    index = index + j;
                    conn.Close();