Double quotes problem

Question

Hello, I am inserting value 36-48" in database table. But it inserts "36-48""" Same as 1/2 Standard Dis. Heavy (90cm/36" Stem) inserts as "1/2 Standard Dis. Heavy (90cm/36"" Stem)". Please help to solve this. How can I insert exact data in sql table?

Nilesh Shah · Answer

How do you insert this value in SQL server? post your code for inserting in SQL server, that code must have something which does this.

Ankit Shukla · Answer

Hello Sir, Actually I am importing data from csv to sql and my code is: 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('
')) { 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("","").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 { 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('
')) { 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()=="") { 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); }

Double quotes problem

aeroswan

eksypnos123

aeroswan