C 'SQL INSERT IRROM Ошибка Якобы не совпадает? ⇐ C#

[Anonymous]

У меня есть таблица SQL, где я не могу заставить вставку работать. Я сравнил и так много искал!
Я не вижу никаких ошибок! query = "CREATE TABLE dbo.Firmen(" +
"Art varchar(255) NOT NULL," +
"FirmaArt varchar(50) NOT NULL," +
"FirmaNummer int NOT NULL," +
"FirmaName varchar(255) NOT NULL," +
"Bild varchar(255) NULL," +
"Strasse varchar(255) NULL," +
"Hausnummer varchar(255) NULL," +
"PLZ varchar(255) NULL," +
"Ort varchar(255) NULL," +
"Land varchar(255) NULL," +
"Bundesland varchar(255) NULL," +
"GeoX varchar(50) NULL," +
"GeoY varchar(50) NULL," +
"Telefon1 varchar(255) NULL," +
"Telefon2 varchar(255) NULL," +
"Fax1 varchar(255) NULL," +
"Fax2 varchar(255) NULL," +
"Mobil1 varchar(255) NULL," +
"Mobil2 varchar(255) NULL," +
"EMail1 varchar(255) NULL," +
"EMail2 varchar(255) NULL," +
"Internet varchar(255) NULL," +
"Geschaeftszeiten varchar(255) NULL," +
"FirmenForm varchar(255) NULL," +
"Inhaber varchar(255) NULL," +
"Geschaeftsfuehrer varchar(255) NULL," +
"Handelsregister varchar(255) NULL," +
"SteuerID varchar(255) NULL," +
"USTID varchar(255) NULL," +
"SteuerLand varchar(255) NULL," +
"Bemerkung varchar(max) NULL " +
" CONSTRAINT PK_Firmen PRIMARY KEY CLUSTERED" +
" ( " +
"Art ASC, " +
"FirmaArt ASC, " +
"FirmaName ASC " +
")WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) " +
" ON [PRIMARY]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]";

...
...
...

Que = "INSERT INTO dbo.Firmen VALUES(" +
"@Art,@FirmaArt,@FirmaNummer,@FirmaName,@Strasse,@Hausnummer,@PLZ,@Ort,@Land,@Telefon1,@Fax1,@EMail1" +
");";

SqlCommand cmd = new SqlCommand(Que, con);

int fn = Convert.ToInt32(INI_FirmaNummer);
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@Art", SQLDB);
cmd.Parameters.AddWithValue("@FirmaArt", "Firma");
cmd.Parameters.AddWithValue("@FirmaNummer", INI_FirmaNummer);
cmd.Parameters.AddWithValue("@FirmaName", INI_FirmaName);
cmd.Parameters.AddWithValue("@Strasse", INI_FirmaStrasse);
cmd.Parameters.AddWithValue("@Hausnummer", INI_FirmaHausnummer);
cmd.Parameters.AddWithValue("@PLZ", INI_FirmaPLZ);
cmd.Parameters.AddWithValue("@Ort", INI_FirmaOrt);
cmd.Parameters.AddWithValue("@Land", INI_FirmaLand);
cmd.Parameters.AddWithValue("@Telefon1", INI_FirmaTel);
cmd.Parameters.AddWithValue("@Fax1", INI_FirmaFax);
cmd.Parameters.AddWithValue("@EMail1", INI_FirmaMail);
cmd.ExecuteNonQuery();
...
...
...
Que = "INSERT INTO dbo.Firmen VALUES(" +
"@Art,@FirmaArt,@FirmaNummer,@FirmaName,@Strasse,@Hausnummer,@PLZ,@Ort,@Land,@Telefon1,@Fax1,@EMail1" +
")";

SqlCommand cmd = new SqlCommand(Que, con);

cmd.Parameters.Clear();
int fn = Convert.ToInt32(INI_FirmaNummer);
cmd.Parameters.Clear();
cmd.Parameters.Add("@Art", SqlDbType.NVarChar).Value = SQLDB;
cmd.Parameters.Add("@FirmaArt", SqlDbType.NVarChar).Value = "Filiale";
cmd.Parameters.Add("@FirmaNummer", SqlDbType.Int).Value = Convert.ToInt32(INI_FilialeNummer);
cmd.Parameters.Add("@FirmaName", SqlDbType.NVarChar).Value = INI_FilialeName;
cmd.Parameters.Add("@Strasse", SqlDbType.NVarChar).Value = INI_FilialeStrasse;
cmd.Parameters.Add("@Hausnummer", SqlDbType.NVarChar).Value = INI_FilialeHausnummer;
cmd.Parameters.Add("@PLZ", SqlDbType.NVarChar).Value = INI_FilialePLZ;
cmd.Parameters.Add("@Ort", SqlDbType.NVarChar).Value = INI_FilialeOrt;
cmd.Parameters.Add("@Land", SqlDbType.NVarChar).Value = INI_FilialeLand;
cmd.Parameters.Add("@Telefon1", SqlDbType.NVarChar).Value = INI_FilialeTel;
cmd.Parameters.Add("@Fax1", SqlDbType.NVarChar).Value = INI_FilialeFax;
cmd.Parameters.Add("@EMail1", SqlDbType.NVarChar).Value = INI_FilialeMail;
cmd.ExecuteNonQuery();
...
...
...

< /code>
Ошибка:
-2146232060
Имя столбца или количество поставляемых значений не соответствует определению таблицы. SQL Server 2019, последнее обновление
ms Windows Server 2019, последнее обновление < /p>
С наилучшими пожеланиями < /p>
bernd < /p>

Подробнее здесь: https://stackoverflow.com/questions/797 ... dont-match