|
Hello all,
I am cracking my brains for two weeks now on the following problem:
I have to update records on a table but i am now in the stiuation that i get the message "parameter @NummerNaam has no default value"
I have posted this question once, thanks for the tips.
I also read several documentation but still get stuck.
Below my code.
Thanks,
Bas
Dim command As System.Data.OleDb.OleDbCommand = New System.Data.OleDb.OleDbCommand("Update Agent" & _
" SET Nummer_Naam = @NummerNaam, Agentnummer = @AgentNummer, Agentnaam = @AgentNaam" & _
" WHERE(Agentnummer = @agentNummerOud)", dcAgent)
command.Parameters.Add("@NummerNaam", OleDb.OleDbType.VarChar, 20, "Nummer_Naam")
command.Parameters.Add("@AgentNummer", OleDb.OleDbType.Integer, 10, "Agentnummer")
command.Parameters.Add("@AgentNaam", OleDb.OleDbType.VarChar, 20, "Agentnaam")
Dim parameter As System.Data.OleDb.OleDbParameter = command.Parameters.Add( _
"@agentNummerOud", OleDb.OleDbType.Integer, 10, agentNummerOud)
parameter.SourceVersion = DataRowVersion.Original
command.Connection.Open()
command.ExecuteNonQuery()
command.Connection.Close()
|
|
|
|
|
You created four parameter objects, but you didn't assign values to any of the parameters. You can change that by doing something like this:
command.Parameters.Add(new OleDbParameter("@NummerNaam", OleDb.OleDbType.VarChar, 20, "Nummer_Naam")).Value = somevalue
command.Parameters.Add(new OleDbParameter("@AgentNummer", OleDb.OleDbType.Integer, 10, "Agentnummer").Value = somevalue
command.Parameters.Add(new OleDbParameter("@AgentNaam", OleDb.OleDbType.VarChar, 20, "Agentnaam").Value = somevalue
|
|
|
|
|
Hello Dave,
Thanks for the tip.
Now i get it.
I wil try this.
|
|
|
|
|
Hello Dave,
I tried, it works fantastic.
Thanks guru!!
|
|
|
|
|
Is it write to say that
an event is
private sub Form_Load(byval sender as system.Object,byval e as System.Eventargs)handes MyBase.Load
End sub
and functions is
private function abc()as string
end function
|
|
|
|
|
Nilish wrote: handes MyBase.Load
This bit means that this function will be called in response to an event.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
private sub Form_Load(byval sender as system.Object,byval e as System.Eventargs)handes MyBase.Load
End sub
This Form_Load is a event handler for Load event. That means when the page load event fires this handler will be invoked.
Then, then function
private function abc()as string
end function
This is need to call as abc() for executing.
Gg
|
|
|
|
|
Private sub Form_Load... isn't an event. It's a procedure that handles an event. Any procedure can handle an event as long as it matches the signature of the event. A function returns a value while a procedure does not.
This is how you could define an event.
Public Event SomeEvent(ByVal sender As Object, ByVal e As System.EventArgs) The signature would be the parameters in the definition. I could also create an event like this.
Public Event AnotherEvent(ByVal someText As String)
In this case the procedure to handle this event would need to accept a string. Any procedure that does so can handle this event. It's good practice to create events that with the .net signature of (sender, e) where sender is an object and 'e' inherits from system.eventargs.
|
|
|
|
|
What is the meaning of List<AssemblyInformation>assemblies.Actually this code line belongs to C#.I am writing in this fomum because i wanted the equivalant syntax in vb.net.And one more thing what is the meaning of this line.
|
|
|
|
|
It defines a strongly-typed List of AssemblyInformation objects called assemblies. The VB.NET version would read:
Dim assemblies As New List(Of AssemblyInformation)
|
|
|
|
|
please can any one tell me :
how can i give access permission to Active directory user in vb.net
it's urgent
thankx in adv.
- Koolprasad2003
Be A Good S/W Eng... Life is swing with you..Enjoy..
|
|
|
|
|
koolprasad2003 wrote: how can i give access permission to Active directory user in vb.net
So, what permissions do you want to give this user? What you do is going to be very different for very resources. Also, which version of VB.NET are you using?
koolprasad2003 wrote: it's urgent
In a forum environment like this, the only thing that's urgent is if you have to go to the bathroom. Go ahead, we'll wait...
|
|
|
|
|
Hi-
I'm new here, trying to convert an asp project into asp.net, and tidying up as i go. I have a background of VB6, but have not coded for a long time. So have come up against many problems (so i expect to be active here for a while!)
And i am using the .net studio
The first query is trivial, it must be:
One problem i have is the adovbs.inc constants, which i have read ought to be in a class: but you cannot have public constants in a class, so to use enums.
I have found examples: but i cannot get them to work at all, however simple they look. Ideally, i will have a cls.ADOConstants that is separate to my clsDBRead: but even initally, i cannot get the code below (which is a class, clsDBRead) to see adUseServer, it is underlined in blue with "not declared"
---------------
Imports Microsoft.VisualBasic
Public Class Class1
Enum ADO_constants
adUseServer = 2
adUseClient = 3
End Enum
Public Function getKingdoms() As colKingdoms
MsgBox(adUseServer)
End Function
End Class
-------------------------
It has to be really trivial, but it is stopping my progress (to the next bit which is database access: i have controls bound to SQL statements no problem, but now i need to store the DB results in a dataset or class or collection: more fun! )
thanks -
aitch
--x---
|
|
|
|
|
aitch42 wrote: but you cannot have public constants in a class
Yes, you can.
aitch42 wrote: trying to convert an asp project into asp.net,
You'd do better to rewrite it in ASP.NET, there's no logical conversion possible, really.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
thanks -but i couldn;t get them to work, and I also think that enums are more elegant than long lsits of constants anyway: so really, i'd like to know why the code i quoted cannot find the constant: especially as i want to remove that declaration and put it into a separate class.
So a class of Database access routines/methods/functions can access a class of public enums, which have grouped together public constants.
Oh, i ought not have said "convert", it *is* a complete re-write: my terms were wrong 
I have 6 files so far, and will end up with about 60 i think, so i really want to get it right, right from the start. The asp version is a real mess, so I welcome the need to start again and build up a new clean project
If only i can get my public constants into a class of enums 
It ought to be simple? I keep find samples that quote what I have done, but i get the "not-declared" wiggly blue line every time 
aitch
--x--
|
|
|
|
|
Sorry, I see the problem. You can't just do the name. IF you have an enum called MyEnum and it has values of val1 and val2, you can't say val1, you need to say MyEnum.val1.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hi, and thanks.
So i guess i really have a bigger question: WHat do you think is the best way to use constants in a VB.net app?
I have recently discovered i can use project-references to libraries as i did in VB, but could not do in asp: so the adovb.inc include can be replaced by a library/project reference rather than a need to copy in the constants into a class -
But for my own constants, where i thought enums would be a better way to structure their storage, i would then need to qualify every constant use which i don;t really want to do.
Given i will have 100's of constants, some of which make sense to be enums, (well, they are currently grouped together with sequential numbers), am I better off using enums that then need to be qualified, or constants?
Either would work.. but what is better?
Ditto, what is the *best* way to use adovbs.inc constants?
Though i have just ordered yet-another VB-2005 book, so maybe i had better wait till i have read that one before asking more queries... I find it very difficult getting back into a programming enviornment, that is "same same but different" to what i was familiar with a few years back
I need a work-environment and an expert and a template to get me started...
thanks -
aitch
--x---
|
|
|
|
|
I was doing the deployment in vb.net 2005 .
There are few things that i want to incorporate into my setup.
like my messages during the setup .As such .... I will not be able to do these implementation with the help of deployment wizard which is provided into the visual studio 2005
Can i do it manually .I want to start from the scratch.So which kind of knowledge should I acquire , so that i can accomplish this problem.
|
|
|
|
|
You need to write a C++ program that doesn't use .NET, so you know it will run on the target machine, which does the installation. You'll find it much easier to write a program which launches your MSI.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Christian , What is MSI
|
|
|
|
|
It's an installer program.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
currently i am working in vb.net .U suggested to write a program in C++.
If i am going to write the program at official timing then....boss will fire me.Bcos i am suppose to wite programs in vb.net
Is there any other another way out . Does vb6 has anything to do with this problem.
|
|
|
|
|
Nilish wrote: .U suggested to write a program in C++.
Yes, a program that does the install would need to be C++.
Nilish wrote: If i am going to write the program at official timing then....boss will fire me.Bcos i am suppose to wite programs in vb.net
Then your boss is a moron.
Nilish wrote: Is there any other another way out
No, if you want to write your own program that does installation, it's a dumb idea to start with, but it needs to be in C++, unless you know for sure that all the machines you deploy to will have .NET installed
Nilish wrote: Does vb6 has anything to do with this problem.
No, why would it ? VB6 also requires a runtime AFAIK, but I never use it, it's worse than VB.NET. If it can make an exe that runs anywhere, you could use it. Your core idea is dumb tho, you should not write your own installer program, you should create an MSI. Writing an installer will take you a long time, if you do it properly.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
well,
there are articles about customizing your setup program in codeproject itself, try to search for those articles.
Vilsad P P
MCTS (Windows Applications) .Net 2.0
|
|
|
|
|
I'm working on a regex code that will display the no. of times that a string appears before 'Says', like in the examples below:
1. "JohnnyBoy234 Says"
2. " Top 5 - Group Writing Project Day 3 Says: "
String regex = "([a-zA-Z]*[_:/ ]* [Ss][Aa][Yy][Ss] ";
The regex will return the string in front of 1. but not for 2. WHAT could be the problem. I'd appreciate some help with my regex statement, especially the special characters & spaces as seen in example 2.
THANKS!!!
Belief is a beautiful armour.
Knowledge is the sword.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
