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 CodeNameGenus_CodeSpecies_CodeCultivar_CodeColor_Code Height_CodeStructure_CodeGrade_CodeItem_Price_Group_Code Financial_YearNo_Per_CartonLabel_CodeGrade_CMUS_Grade Grade_ColourObsoleteAvailability_GroupReporting_GroupHoursHooksAvailability_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 Codetypeof(string)) new DataColumn(Species_Code typeof(string)) new DataColumn(Cultivar_Codetypeof(string)) new DataColumn(Color_Code typeof(string)) new DataColumn(Height_Code typeof(string)) new DataColumn(Structure_Codetypeof(string)) new DataColumn(Grade_Code typeof(string)) new DataColumn(Item_Price_Group_Codetypeof(string)) new DataColumn(Financial_Year typeof(string)) new DataColumn(No_Per_Carton typeof(int)) new DataColumn(Label_Code typeof(string)) new DataColumn(Grade_CMtypeof(string)) new DataColumn(US_Grade typeof(string)) new DataColumn(Grade_Colourtypeof(string)) new DataColumn(Obsolete typeof(string)) new DataColumn(Availability_Group typeof(string)) new DataColumn(Reporting_Grouptypeof(string)) new DataColumn(Hours typeof(decimal)) new DataColumn(Hookstypeof(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); }