for (int j = 1; j < lineData.Length; j++) { query2.Append("insert into "); query2.Append(tableName); query2.Append(" values"); query2.Append("("); string[] Row = lineData[j].Split('\t'); for (int k = 0; k < ((Row.Length) - 1); k++) { query2.Append("@"); query2.AppendFormat("[{0}]",fields[k]); } query2.Append(");"); SqlCommand command2 = new SqlCommand(query2.ToString(),myConnection); for (int k=0; k < (Row.Length - 1); k++) { StringBuilder parm = new StringBuilder(); parm.Append("\""); parm.Append("@["); parm.Append(fields[k]); parm.Append("]"); parm.Append("\""); Console.WriteLine(parm.ToString()+" "+Row[k]); command2.Parameters.AddWithValue(parm.ToString(), Row[k]); } command2.ExecuteNonQuery(); }
@
SqlParameter
@[colname]
[colname]
[]
@varname
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)