ASP.NET C# and OLEDB.JET problem

[chonthy]

Hello!

I'm in trouble with the ASP.NET and OLEDB.JET connector.
When I put the data into an XLS file from a dataset of my webpage, everything's OK, but in the destination file there is an apostrophe in front of every numeric data.
It's problem for me, because there are some aritmethical operation with my datas in the XLS.
Here is my source code, what put the data into the file:

OleDbConnection connect = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath(docpath)+"myfile.xls;Extended Properties=\"Excel 8.0;Readonly=False;IMEX=0;\"");
connect.Open();
...
PushToXls("A", objDataset1.Tables[0].Rows[i][3].ToString(), objDataset1.Tables[0].Rows[i][4].ToString(), objDataset1.Tables[0].Rows[i][5].ToString(), connect);
...
connect.Close();
 
 
private void PushToXls(string table, string first, string second, string third, OleDbConnection connect)
    {
 
            OleDbParameter pmfirst, pmsecond, pmthird;
 
 
            if (first != "0")
            {
                pmfirst = new OleDbParameter("@first", OleDbType.Numeric);
                pmfirst.Value = Convert.ToInt32(first);
            }
            else
            {
                pmfirst = new OleDbParameter("@first", OleDbType.VarChar);
                pmfirst.Value = "";
            }
            if (second != "0")
            {
                pmsecond = new OleDbParameter("@second", OleDbType.Numeric);
                pmsecond.Value = Convert.ToInt32(second);
            }
            else
            {
                pmsecond = new OleDbParameter("@second", OleDbType.VarChar);
                pmsecond.Value = "";
            }
            if (third != "0")
            {
                pmthird = new OleDbParameter("@third", OleDbType.Numeric);
                pmthird.Value = Convert.ToInt32(third);
            }
            else
            {
                pmthird = new OleDbParameter("@third", OleDbType.VarChar);
                pmthird.Value = "";
            }
 
            string insertCommStr = "INSERT INTO " + table + "tart VALUES (@first, @second, @third)";
            OleDbCommand insertcommand = new OleDbCommand(insertCommStr, connect);
            insertcommand.Parameters.Add(pmfirst);
            insertcommand.Parameters.Add(pmsecond);
            insertcommand.Parameters.Add(pmthird);
 
            insertcommand.ExecuteNonQuery();
 
    }

I've used parametric command, but it not seems helpful.
If anybody has any idea about this problem, please share with me. :)

Thanks.

[jhardman]

HI and welcome to the scripts Developer Network. I have moved your post to the .NET forum (there is a technical difference between ASP and ASP.NET. The latter is a part of the .NET package and belongs here). I have also added code tags to your post to make it more readable. Please do this yourself in the future (notice the button marked - # -)

Jared, moderator
ASP forum