the error occures in 2 files my DataConnection. asmx.cs and Funtions.cs
error 1 is this il also paste a part of the code were the error is
DotNet.Function s' does not contain a definition for 'QuoteFix the filename were the code out is DataConnection. asmx.cs
Expand|Select|Wrap|Line Numbers
- if (nieuw == true)
- {
- NoteID = "";
- strNotes1 = "INSERT INTO offertesql (of_ref, of_datum, of_deb, of_klant, of_contact, of_straat, of_pcode, of_plaats, of_omschr, of_ordernr, of_uwref, of_totaalbtw_sql, of_btwbedr_sql, of_btw_sql, of_subtotaal_sql";
- strNotes2 = "VALUES ('" + sReferentie + "', '" + sDatum + "', '" + sDebNr + "', '" + sKlant + "', '" + sContact + "', '" + sStraat + "', '" + sPcode + "', '" + sPlaats + "', '" + sOmschrijving + "', '" + sOrderNr + "', '" + sUwRef + "', " + dTotBTW + " , " + dBTW + " , " + dOf_BTW + " , " + dTotaal + " ";
- if (iAant1 != "")
- {
- strNotes1 += ", of_dat1, of_art1, of_aant1, of_stuk_sql1, of_prijs_sql1";
- strNotes2 += ", " + Functions.QuoteFix(Functions.DateToUS(sDat1)) + " , '" + sArt1 + "', " + iAant1 + " , " + dPStuk1 + " , " + dPrijs1;
- }
- if (iAant2 != "")
- {
- strNotes1 += ", of_dat2, of_art2, of_aant2, of_stuk_sql2, of_prijs_sql2";
- strNotes2 += ", " + Functions.QuoteFix(Functions.DateToUS(sDat2)) + " , '" + sArt2 + "', " + iAant2 + " , " + dPStuk2 + " , " + dPrijs2;
- }
- if (iAant3 != "")
- {
- strNotes1 += ", of_dat3, of_art3, of_aant3, of_stuk_sql3, of_prijs_sql3";
- strNotes2 += ", " + Functions.QuoteFix(Functions.DateToUS(sDat3)) + " , '" + sArt3 + "', " + iAant3 + " , " + dPStuk3 + " , " + dPrijs3;
- }
- if (iAant4 != "")
- {
- strNotes1 += ", of_dat4, of_art4, of_aant4, of_stuk_sql4, of_prijs_sql4";
- strNotes2 += ", " + Functions.QuoteFix(Functions.DateToUS(sDat4)) + " , '" + sArt4 + "', " + iAant4 + " , " + dPStuk4 + " , " + dPrijs4;
- }
- if (iAant5 != "")
- {
- strNotes1 += ", of_dat5, of_art5, of_aant5, of_stuk_sql5, of_prijs_sql5";
- strNotes2 += ", " + Functions.QuoteFix(Functions.DateToUS(sDat5)) + "', '" + sArt5 + "', " + iAant5 + " , " + dPStuk5 + " , " + dPrijs5;
- }
- if (iAant6 != "")
- {
- strNotes1 += ", of_dat6, of_art6, of_aant6, of_stuk_sql6, of_prijs_sql6";
- strNotes2 += ", " + Functions.QuoteFix(Functions.DateToUS(sDat6)) + " , '" + sArt6 + "', " + iAant6 + " , " + dPStuk6 + " , " + dPrijs6;
- }
- if (iAant7 != "")
- {
- strNotes1 += ", of_dat7, of_art7, of_aant7, of_stuk_sql7, of_prijs_sql7";
- strNotes2 += ", " + Functions.QuoteFix(Functions.DateToUS(sDat7)) + " , '" + sArt7 + "', " + iAant7 + " , " + dPStuk7 + " , " + dPrijs7;
- }
- if (iAant8 != "")
- {
- strNotes1 += ", of_dat8, of_art8, of_aant8, of_stuk_sql8, of_prijs_sql8";
- strNotes2 += ", " + Functions.QuoteFix(Functions.DateToUS(sDat8)) + " , '" + sArt8 + "', " + iAant8 + " , " + dPStuk8 + " , " + dPrijs8;
- }
- if (iAant9 != "")
- {
- strNotes1 += ", of_dat9, of_art9, of_aant9, of_stuk_sql9, of_prijs_sql9";
- strNotes2 += ", " + Functions.QuoteFix(Functions.DateToUS(sDat9)) + " , '" + sArt9 + "', " + iAant9 + " , " + dPStuk9 + " , " + dPrijs9;
- }
- if (iAant10 != "")
- {
- strNotes1 += ", of_dat10, of_art10, of_aant10, of_stuk_sql10, of_prijs_sql10";
- strNotes2 += ", " + Functions.QuoteFix(Functions.DateToUS(sDat10)) + " , '" + sArt10 + "', " + iAant10 + " , " + dPStuk10 + " , " + dPrijs10;
- }
- strNotes1 = strNotes1 + ") " + strNotes2 + ")";
- dbConn.Open();
- SqlCommand SqlCmd = new SqlCommand(strNotes1, dbConn);
- SqlCmd.ExecuteNonQuery();
- dbConn.Close();
- dbConn.Open();
- SqlCommand SqlCmdID = new SqlCommand("SELECT MAX (NoteID) AS NoteID from offertesql", dbConn);
- SqlDataReader SqlDrID = SqlCmdID.ExecuteReader(CommandBehavior.CloseConnection);
- if(SqlDrID.Read())
- {
- NoteID = SqlDrID["NoteID"].ToString();
- }
- SqlDrID.Close();
- dbConn.Close();
the next error is this in my DataConnection. asmx.cs file again
DotNet.Function s' does not contain a definition for 'chkValue
Expand|Select|Wrap|Line Numbers
- iAant1 = iAant1.Replace(",", ".");
- iAant2 = iAant2.Replace(",", ".");
- iAant3 = iAant3.Replace(",", ".");
- iAant4 = iAant4.Replace(",", ".");
- iAant5 = iAant5.Replace(",", ".");
- iAant6 = iAant6.Replace(",", ".");
- iAant7 = iAant7.Replace(",", ".");
- iAant8 = iAant8.Replace(",", ".");
- iAant9 = iAant9.Replace(",", ".");
- iAant10 = iAant10.Replace(",", ".");
- strSQL1 = "INSERT INTO Offerte (OfferteID, OfferteNr, Datum, DebNr, KlantNaam, Klantcontact, KlantStraat, KlantPcode, KlantPlaats, Omschrijving, OrderNr, ReferentieNr, BTW_bedr, SubTotaal, BTW, Totaal";
- strSQL2 = "VALUES (" + NoteID + " , '" + sReferentie + "', '" + sDatum + "', '" + sDebNr + "', '" + sKlant + "', '" + sContact + "', '" + sStraat + "', '" + sPcode + "', '" + sPlaats + "', '" + sOmschrijving + "', '" + sOrderNr + "', '" + sUwRef + "', " + Functions.chkValue(dBTW) + " , " + Functions.chkValue(dTotaal) + " , " + Functions.chkValue(dOf_BTW) + " , " + Functions.chkValue(dTotBTW) + " ";
- if (iAant1 != "")
- {
- strSQL1 += ", Datum1, Aantal1, Artikel1, PrijsStuk1, Prijs1";
- strSQL2 += ", '" + sDat1 + "', " + iAant1 + " , '" + sArt1 + "', " + Functions.chkValue(dPStuk1) + " , " + Functions.chkValue(dPrijs1) + " ";
- }
- if (iAant2 != "")
- {
- strSQL1 += ", Datum2, Aantal2, Artikel2, PrijsStuk2, Prijs2";
- strSQL2 += ", '" + sDat2 + "', " + iAant2 + " , '" + sArt2 + "', " + Functions.chkValue(dPStuk2) + " , " + Functions.chkValue(dPrijs2) + " ";
- }
- if (iAant3 != "")
- {
- strSQL1 += ", Datum3, Aantal3, Artikel3, PrijsStuk3, Prijs3";
- strSQL2 += ", '" + sDat3 + "', " + iAant3 + " , '" + sArt3 + "', " + Functions.chkValue(dPStuk3) + " , " + Functions.chkValue(dPrijs3) + " ";
- }
- if (iAant4 != "")
- {
- strSQL1 += ", Datum4, Aantal4, Artikel4, PrijsStuk4, Prijs4";
- strSQL2 += ", '" + sDat4 + "', " + iAant4 + " , '" + sArt4 + "', " + Functions.chkValue(dPStuk4) + " , " + Functions.chkValue(dPrijs4) + " ";
- }
- if (iAant5 != "")
- {
- strSQL1 += ", Datum5, Aantal5, Artikel5, PrijsStuk5, Prijs5";
- strSQL2 += ", '" + sDat5 + "', " + iAant5 + " , '" + sArt5 + "', " + Functions.chkValue(dPStuk5) + " , " + Functions.chkValue(dPrijs5) + " ";
- }
- if (iAant6 != "")
- {
- strSQL1 += ", Datum6, Aantal6, Artikel6, PrijsStuk6, Prijs6";
- strSQL2 += ", '" + sDat6 + "', " + iAant6 + " , '" + sArt6 + "', " + Functions.chkValue(dPStuk6) + " , " + Functions.chkValue(dPrijs6) + " ";
- }
- if (iAant7 != "")
- {
- strSQL1 += ", Datum7, Aantal7, Artikel7, PrijsStuk7, Prijs7";
- strSQL2 += ", '" + sDat7 + "', " + iAant7 + " , '" + sArt7 + "', " + Functions.chkValue(dPStuk7) + " , " + Functions.chkValue(dPrijs7) + " ";
- }
- if (iAant8 != "")
- {
- strSQL1 += ", Datum8, Aantal8, Artikel8, PrijsStuk8, Prijs8";
- strSQL2 += ", '" + sDat8 + "', " + iAant8 + " , '" + sArt8 + "', " + Functions.chkValue(dPStuk8) + " , " + Functions.chkValue(dPrijs8) + " ";
- }
- if (iAant9 != "")
- {
- strSQL1 += ", Datum9, Aantal9, Artikel9, PrijsStuk9, Prijs9";
- strSQL2 += ", '" + sDat9 + "', " + iAant9 + " , '" + sArt9 + "', " + Functions.chkValue(dPStuk9) + " , " + Functions.chkValue(dPrijs9) + " ";
- }
- if (iAant10 != "")
- {
- strSQL1 += ", Datum10, Aantal10, Artikel10, PrijsStuk10, Prijs10";
- strSQL2 += ", '" + sDat10 + "', " + iAant10 + " , '" + sArt10 + "', " + Functions.chkValue(dPStuk10) + " , " + Functions.chkValue(dPrijs10) + " ";
- }
- strSQL1 = strSQL1 + ") " + strSQL2 + ")";
- dbConn.Open();
- SqlCommand SQLCmd = new SqlCommand(strSQL1, dbConn);
- SQLCmd.ExecuteReader(CommandBehavior.CloseConnection);
- dbConn.Close();
I understand thats its a method and that i shud be in Functions.cs but i cant find those names anywere in the document with the search option. and i dont no what to do with it i dont whanne delete it right away thous anyone have on idee about what those functions cud do
Tanx Guys