Advertisement
Guest User

Untitled

a guest
Jul 19th, 2017
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.   Dim sql As String = "call MAKESECCODEUpdate"
  2.  
  3.         Using cnX As New System.Data.Odbc.OdbcConnection("DRIVER={Adaptive Server Anywhere 9.0};ENG=ASA9;DBN=ASWINFO;Uid=" & dbuzivatel & ";Pwd=" & dbuzivatelheslo & ";Links=tcpip(Host=xxxx.cz);"), cmdX As New System.Data.Odbc.OdbcCommand(sql, cnX)
  4.             cnX.Open()
  5.  
  6.             cmdX.Parameters.Add("@a_ID", SqlDbType.VarChar, 50).Value = id
  7.             cmdX.Parameters.Add("@a_OPERACE", SqlDbType.VarChar, 50).Value = nazevbk
  8.             cmdX.Parameters.Add("@a_UZIVATEL", SqlDbType.VarChar, 50).Value = uzivatel
  9.             cmdX.Parameters.Add("@a_DATUM", SqlDbType.VarChar, 50).Value = datum
  10.             cmdX.Parameters.Add("@a_PARAM1", SqlDbType.VarChar, 50).Value = ""
  11.             cmdX.Parameters.Add("@a_PARAM2", SqlDbType.VarChar, 50).Value = ""
  12.             cmdX.Parameters.Add("@a_PARAM3", SqlDbType.VarChar, 50).Value = ""
  13.             cmdX.Parameters.Add("@a_KOMENTAR", SqlDbType.VarChar, 50).Value = ""
  14.  
  15.             MsgBox("YYYYY" & cmdX.ExecuteScalar().ToString())
  16.             cnX.Close()
  17.  
  18.         End Using
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement