c# - SQL Server CE executes the same prepared statement no matter what -

-

I read some data from XML files in my database. The problem is that it only executes a prepared statement (the first I is defined) and it causes the errors.

This works: 

  conn = getConnection (); conn.Open (); SqlCeCommand CMD = conn.CreateCommand (); CMD. COMMANDTEX = "Include in RA_STeuni ([denote], [ID_RA]) value (@Denyumer, @ ID_RA)"; SqlCeParameter numeParam = New SqlCeParameter ("@Nanumar", SKLDB type.NVarChar, 100); NumeParam.Value = denumire; cmd.Parameters.Add (numeParam); SqlCeParameter idRAParam = New SqlCeParameter ("@ id_ra", SqlDbType.Int); Idraparam.Value = idRA; Cmd.Parameters.Add (idRAParam); Cmd.Prepare (); Cmd.ExecuteNonQuery (); cmd.Dispose (); Conn.Close ();   
 It does not work anymore:  
  conn = getConnection (); conn.Open (); SqlCeCommand CMD = conn.CreateCommand (); CMD. Include in the values ​​of CommandsText = "RA-Active ([Denimir], [Gastien], [UPIATAR], [Tip_Active], [NR_Waver], [CARDIBRIEA-ACTIVE], [PATHOMONY], [ID_RA] (@Denyumer, @Gestionon, @ utilizator, @ tip_activ, @ nr_invetar, @ categorie_activ, @ patrimoniu, @ id_ra) "; SqlCeParameter numeParam = New SqlCeParameter (" @Nanumar ", SKLDB type: NVarChar, 100); NumeParam.Value = denumire; cmd.Parameters.Add (numeParam); SqlCeParameter gestiuneParam = New SqlCeParameter ("@ gestiune", SqlDbType.Int); GuestOnPuram value = Gestioun; cmd.Parameters.Add (gestiuneParam); SqlCeParameter utilizator Param = New SqlCeParameter ("Utility", SqlDbType.Int); UtilizatorParam.Value = Utility; cmd.Parameters.Add (utilizatorParam); SqlCeParameter nrInventarParam = New SqlCeParameter ("@nr_inventar", SqlDbType.NVarChar); NrInventarParam.Value = nrInventar; cmd.Parameters.Add (nrInventarParam); SqlCeParameter categorieActivParam = New SqlCeParameter ("@ categorie_activ", SqlDbType.NVarChar); ClassifyActiveParam. Value = rangeactive; cmd.Parameters.Add (categorieActivParam); SqlCeParameter PatrimoniuParam = New SqlCeParameter ("@Patimonu", SQLDBtype.int); PATTMONI PARAM. Value = petimoni; cmd.Parameters.Add (patrimoniuParam); SqlCeParameter TipActivParam = New SqlCeParameter ("@ tip_activ", SqlDbType.Int); Tip activePPRAM Value = tipactive; cmd.Parameters.Add (tipActivParam); SqlCeParameter idRAParam = New SqlCeParameter ("@Id_ra", SqlDbType.Int); Idraparam.Value = idRA; Cmd.Parameters.Add (idRAParam); Cmd.Prepare (); Cmd.ExecuteNonQuery (); cmd.Dispose (); Conn.Close ();   
 I get this exception:  
 
 The name of the column is not valid [node name (if any) =, column name = gastiune]   
 That is because he tries to include in the previous table (from the last statement) It's crazy, I have not found any solution for this.   
 
 
 What I see parameter @ nr_inventar is not present in your order text (you have @nr_invetar ). If you really need to prepare the command before executing, then you have to set a size for all the nerve parameters, as you did for @Denyumer.

Comments

Post a Comment

Popular posts from this blog

Pass DB Connection parameters to a Kettle a.k.a PDI table Input step dynamically from Excel -

-
Image
I have a requirement whenever I run my own kettle, dynamically took database connection parameters from an excel source Every run should go. I have an Excel column names: hostname, username, database, password. I want to pass these connection parameters to my table input stage dynamically whenever it runs the job. This is what I was trying to do. You can get it Connection parameters from the DB reading source (for example Excel or a CSV file in my example) < / Li> Store the parameters in the variable Using the variable in your connection's settings. Setting Variables Create another conversion for (you can not do it in the same conversion Uses): set variables element variable: The element that reads / writes your data creates a new connection and sets the connection parameter using $ {variable name_} Note that you will need to type in the field field in the field $ {password} Also keep in mind that this can be a security problem as the
Read more

multithreading - PhantomJS-Node in a for Loop -

-
I am trying to implement a screen-scraps application that opens a URL in which a parameter changes as it is for a loop: var data = [ '100', '101', '102', '103', '104']; (Var indexA = 0; indexA & lt; data.length; indexA ++) for {Phantom Generation ({'port': freeport}, function (pH) {ph.create page (function (page) {page.open ("http: //...++ data [index B] +" ... " , Status {console.log ("open site:" + data [index B], position); / * OLD * / indexB ++; page evaluation (function () {// page scrape and an object Return}, function {console.log (result.dataRequest); // here is the problem}); / * new and fixed * / indexB ++} first console Logs it: Open Site: 100 Success Opens Site: 101 Success B Ola Site: 102 Success Opening Site: 103 Success Opened Site: 104 Success Which is good. Data is verified in scrap HTML and from index to array Matches. So in page 101 I scrap '101 and retrieve' and pu
Read more

c++ - MATLAB .m file to .mex file using Matlab Compiler -

-
I know that it can speak as a very famous topic, but something that helps me with it Not found This scenario is: I have my functions function, no matter what's inside, it's a generic function that may depend on other toolboxes. Does. Has input and output; I want to generate the same myFun.mex function; : Lib myFun This way I get some new files: libmyfun.c libmyfun.dll Libmyfun.exp libmyfun.exports libmyfun .h libmyfun.lib Reading around and I think that Creating a myfun.cpp that is very famous is included: / * gateway function * / zero max function (ent NLHS, MXARRA * PLS [], int NRHS, CONST M Xeray * PHS []) Here is the Variable Deals * / / * code here * /} I have tried to do this and are called Regular of Max Generation: Max ('- v', 'myfun.cpp') But I get many errors, and I should say that my myfun.cpp copy / Paste Function is where I have a lot of doubts ... especially on input / output management. My q
Read more