String finish_time_tt = importRow.ToString() String start_time_tt = importRow.ToString() String program_tt = importRow.ToString() In upload click event: foreach (DataRow importRow in importData.Rows)ĭouble cycle_tt = ConvertStringToDouble(importRow.ToString()) ĭouble length_tt = ConvertStringToDouble(importRow.ToString()) ĭouble total_time_tt = cycle_tt * length_tt Using (SqlConnection conn = new SqlConnection())Ĭmd.CommandType = Total_Time_S) IF NOT EXISTS(SELECT * FROM Silver_Robot WHERE AND AND AND AND AND AND AND AND AND AND INTO public void Insert_Silver_Robot(String Program_S, String Grpup_S, DateTime Start_Date_S, String Start_Time_S, Decimal Pieces_S, DateTime Finish_Date_S, String Finish_Time_S, double Average_Part_Cycle_Time_S, String Mode_S, double Length_S, double Total_Time_S) This is how i fixed it, and so far everything working perfectly fine.
With something like this: SqlCommand cmd = new SqlCommand("IF NOT EXISTS (SELECT * FROM Silver_Robot WHERE Program_S = AND Grpup_S = AND Start_Date_S = AND Start_Time_S = AND Pieces_S = AND Finish_Date_S = AND Finish_Time_S = AND Average_Part_Cycle_Time_S = AND Mode_S = AND Length_S = BEGIN INSERT INTO Silver_Robot(Program_S,Grpup_S,Start_Date_S,Start_Time_S,Pieces_S,Finish_Date_S,Finish_Time_S,Average_Part_Cycle_Time_S,Mode_S,Length_S) END", conn) īut, as you can see in the first link it might be a good idea to create a stored procedure, because in that case you'll have a better performance. So probably if you just replace your SQL command: SqlCommand cmd = new SqlCommand("INSERT INTO Silver_Robot(Program_S,Grpup_S,Start_Date_S,Start_Time_S,Pieces_S,Finish_Date_S,Finish_Time_S,Average_Part_Cycle_Time_S,Mode_S,Length_S) conn) SqlCommand cmd = new SqlCommand("INSERT INTO Silver_Robot(Program_S,Grpup_S,Start_Date_S,Start_Time_S,Pieces_S,Finish_Date_S,Finish_Time_S,Average_Part_Cycle_Time_S,Mode_S,Length_S) length_tt ) Using(SqlConnection conn = new SqlConnection(myconnstring))įoreach(DataRow importRow in importData.Rows)ĭateTime Start_Date_tt = ConvertStringToDate(importRow.ToString()) ĭecimal Start_Time_tt = ConvertStringToDecimal(importRow.ToString()) ĭateTime Finish_Date_tt = ConvertStringToDate(importRow.ToString()) ĭecimal Finish_Time_tt = ConvertStringToDecimal(importRow.ToString()) ĭecimal Pieces_tt = ConvertStringToDecimal(importRow.ToString()) ĭecimal cycle_tt = ConvertStringToDecimal(importRow.ToString()) ĭecimal length_tt = ConvertStringToDecimal(importRow.ToString()) private void Save_Import_Data_SQL(DataTable importData) I was thinking to to insert csv data to a temporary table and filter out duplicate lines. Problem i have right now, if i import the file its gonna insert everything including old 15000 rows.
All i need is insert newly added rows to the already existing database. I got more than 15000 rows and it keeps adding new rows everyday to the CSV file. I am trying to import CSV file data to a SQL Server Database.
0 kommentar(er)
