Writing To Sql Server From C#, No Errors Returned

I am trying to write to a database from c#: using (SqlConnection connection = new SqlConnection()) { try { connection.ConnectionString = 'Data Source=nesoi;Initial

Solution 1:

Try this:

using (SqlConnectionconnection=newSqlConnection("Data Source=nesoi;Initial Catalog=SalesDWH;Integrated Security=True"))
{
    stringqueryString="INSERT INTO SalesDWH.dbo.PendingSpecimens([Date Entered], [Specimen ID], Test, Agency) VALUES (" + fields[0] + ", " + fields[1] + ", " + fields[2] + ", " + fields[4] + ")";
    SqlCommandcommand=newSqlCommand(queryString, connection);
    command.Connection.Open();
    command.ExecuteNonQuery();
}

Solution 2:

Maybe you are missing the parentheses in the values clause?