public void InsertMeterManagementData(MeterManagementData newData) { this.ConnectToDB(); try { String sqlCommand = @"INSERT INTO meter_management VALUES (@p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11)"; using (SqlCommand cmd = new SqlCommand(sqlCommand, connection)) { String[] data = newData.GetData(); cmd.Parameters.AddWithValue("@p1", Int32.Parse(data[0])); cmd.Parameters.AddWithValue("@p2", Int32.Parse(data[1])); cmd.Parameters.AddWithValue("@p3", Int32.Parse(data[2])); cmd.Parameters.AddWithValue("@p4", Int32.Parse(data[3])); cmd.Parameters.AddWithValue("@p5", Int32.Parse(data[4])); cmd.Parameters.AddWithValue("@p6", data[5]); cmd.Parameters.AddWithValue("@p7", data[6]); cmd.Parameters.AddWithValue("@p8", data[7]); cmd.Parameters.AddWithValue("@p9", Int32.Parse(data[8])); cmd.Parameters.AddWithValue("@p10", data[9]); cmd.Parameters.AddWithValue("@p11", data[10]); cmd.ExecuteNonQuery(); } } catch (Exception e) { Console.WriteLine(e.Message); this.CloseConnection(); } this.CloseConnection(); }