Double quotes problem

if (fileuploader.HasFile)

{

DataTable tblcsv = new DataTable();

//getting full file path of Uploaded file

string CSVFilePath = Path.GetFullPath(fileuploader.PostedFile.FileName);

//Reading All text

string filename = Path.GetFileName(fileuploader.FileName);

string excelPath = Server.MapPath("~/Files/") + Path.GetFileName(fileuploader.PostedFile.FileName);

fileuploader.SaveAs(excelPath);

string ReadCSV = File.ReadAllText(excelPath);

string str1 = @"select Code,Name,Genus_Code,Species_Code,Cultivar_Code,Color_Code,

Height_Code,Structure_Code,Grade_Code,Item_Price_Group_Code,

Financial_Year,No_Per_Carton,Label_Code,Grade_CM,US_Grade,

Grade_Colour,Obsolete,Availability_Group,Reporting_Group,Hours,Hooks,Availability_Sort from Item where Financial_Year='" + Settings.Instance.FY + "'";

tblcsv = DbConnectionDAL.GetDataTable(CommandType.Text, str1);

tblcsv.Clear();

//spliting row after new line

int CSVROWNO = -1;

foreach (string csvRow in ReadCSV.Split('\n'))

{

CSVROWNO++;

if (!string.IsNullOrEmpty(csvRow))

{

//Adding each row into datatable

int count = 0;

if (CSVROWNO > 0)

{

tblcsv.Rows.Add();

foreach (string FileRec in csvRow.Replace("\r","").Split(','))

{

if (FileRec.ToString() == "")

{

tblcsv.Rows[tblcsv.Rows.Count - 1][19] = 0.00; tblcsv.Rows[tblcsv.Rows.Count - 1][20] = 0.00;

count++;

}

else

{

tblcsv.Rows[tblcsv.Rows.Count - 1][count] = FileRec;

count++;

}

}

}

}

}

for (int i = 0; i < tblcsv.Rows.Count; i++)

{

string del = "delete from Item where Financial_Year='" + Convert.ToString(tblcsv.Rows[i]["Financial_Year"]) + "' and Code='" + Convert.ToString(tblcsv.Rows[i]["Code"]) + "'";

DbConnectionDAL.ExecuteNonQuery(CommandType.Text, del);

// int ret = itm.Insert(0, Convert.ToString(tblcsv.Rows[i]["Code"]), Convert.ToString(tblcsv.Rows[i]["Name"]), Convert.ToString(tblcsv.Rows[i]["Genus_Code"]), Convert.ToString(tblcsv.Rows[i]["Species_Code"]), Convert.ToString(tblcsv.Rows[i]["Cultivar_Code"]), Convert.ToString(tblcsv.Rows[i]["Color_Code"]), Convert.ToString(tblcsv.Rows[i]["Height_Code"]), Convert.ToString(tblcsv.Rows[i]["Structure_Code"]), Convert.ToString(tblcsv.Rows[i]["Grade_Code"]), Convert.ToString(tblcsv.Rows[i]["Item_Price_Group_Code"]),

// Convert.ToString(tblcsv.Rows[i]["Financial_Year"]), Convert.ToString(tblcsv.Rows[i]["No_Per_Carton"]), Convert.ToString(tblcsv.Rows[i]["Label_Code"]), Convert.ToString(tblcsv.Rows[i]["Grade_CM"]), Convert.ToString(tblcsv.Rows[i]["US_Grade"]), Convert.ToString(tblcsv.Rows[i]["Grade_Colour"]), Convert.ToString(tblcsv.Rows[i]["Obsolete"]), Convert.ToString(tblcsv.Rows[i]["Availability_Group"]), Convert.ToString(tblcsv.Rows[i]["Reporting_Group"]), Convert.ToDecimal(tblcsv.Rows[i]["Hours"]), Convert.ToDecimal(tblcsv.Rows[i]["Hooks"]), tblcsv.Rows[i]["Availability_Sort"].ToString());

}

string csvPath = Server.MapPath("~/CSVFiles/") + Path.GetFileName(fileuploader.PostedFile.FileName);

fileuploader.SaveAs(csvPath);

DataTable dt = new DataTable();

dt.Columns.Add("ID").SetOrdinal(0);

dt.Columns.AddRange(new DataColumn[22] {

new DataColumn("Code", typeof(string)),

new DataColumn("Name", typeof(string)),

new DataColumn("Genus Code",typeof(string)),

new DataColumn("Species_Code", typeof(string)),

new DataColumn("Cultivar_Code",typeof(string)),

new DataColumn("Color_Code", typeof(string)),

new DataColumn("Height_Code", typeof(string)),

new DataColumn("Structure_Code",typeof(string)),

new DataColumn("Grade_Code", typeof(string)),

new DataColumn("Item_Price_Group_Code",typeof(string)),

new DataColumn("Financial_Year", typeof(string)),

new DataColumn("No_Per_Carton", typeof(int)),

new DataColumn("Label_Code", typeof(string)),

new DataColumn("Grade_CM",typeof(string)),

new DataColumn("US_Grade", typeof(string)),

new DataColumn("Grade_Colour",typeof(string)),

new DataColumn("Obsolete", typeof(string)),

new DataColumn("Availability_Group", typeof(string)),

new DataColumn("Reporting_Group",typeof(string)),

new DataColumn("Hours", typeof(decimal)),

new DataColumn("Hooks",typeof(decimal)),

new DataColumn("Availability_Sort", typeof(int))

});

string csvData = File.ReadAllText(csvPath);

foreach (string row in csvData.Split('\n'))

{

if (csvData.IndexOf(row) != 0)

{

if (!string.IsNullOrEmpty(row))

{

dt.Rows.Add();

int i = 1;

foreach (string cell in row.Split(','))

{

if (cell.Contains(@""""))

{

string h = cell.Replace(@"""","\"").ToString();

dt.Rows[dt.Rows.Count - 1][i] = h;

i++;

}

else

{

if (cell.ToString() == "" || cell.ToString()=="\r")

{

if (i == 20 || i == 21 || i == 22)

{

dt.Rows[dt.Rows.Count - 1][20] = 0.00; dt.Rows[dt.Rows.Count - 1][21] = 0.00; dt.Rows[dt.Rows.Count - 1][22] = 0;

}

i++;

}

else

{

dt.Rows[dt.Rows.Count - 1][i] = cell;

i++;

}

}

//if (cell.Contains(@""""))

//{

// string yty= string.Format(@"""{0}""", cell);

// dt.Rows[dt.Rows.Count - 1][i] = string.Format(@"""{0}""", cell);

// i++;

//}

//else

}

}

}

}

string consString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

using (SqlConnection con = new SqlConnection(consString))

{

using (SqlBulkCopy sqlBulkCopy = new SqlBulkCopy(con))

{

//Set the database table name

sqlBulkCopy.DestinationTableName = "dbo.item";

con.Open();

sqlBulkCopy.WriteToServer(dt);

con.Close();

}

}

this.FILLRepeater();

System.Web.UI.ScriptManager.RegisterStartupScript(this, GetType(), "Successmessage", "Successmessage('Import Completed Successfully.');", true);

}

else

{

System.Web.UI.ScriptManager.RegisterStartupScript(this, GetType(), "errormessage", "errormessage('Kindly Upload a file.');", true);

}