There are so many things wrong with this I don't even know where to begin. Or maybe I do....
1) Your syntax is horrible. It might have been the way you posted it but keywords like "ByVal" have no space in them. Same with "divisionid".
2) You attempt to use the connectionstring property of an object called sqlconn. Perhaps you mean conn, because that is what you defined.
3) Your array of parameters is chopped to bits. Remove the unneeded spaces, use a double quote to end the argument "@divisionid" (you are using two single quotes), if you are attempting to initalize you have to use something like....
CODE
Dim param() As SqlParameter = {New SqlParameter("@divisionid", divisionID), New SqlParameter("@divisionname", divisionname)}
Notice the use of the curly braces.
4) You attempt to use ExecuteNonQuery on a sqlparameter object. Perhaps you meant to use a sqlCommand object, which you also have not defined.
5) Perhaps you will build in something later, but if both the sqlexception and the exception catches are just going to throw, take out the sqlexception and let the exception catch do all the throwing.
Most of this could have been caught by your compiler. So use it! Then we can go tackling your connection problem. In the meantime, take a look at the site below for using a command object to pass in parameters to a stored procedure.
The Ins and Outs of Stored Procedures in VB.NetYour specific piece of this article is under the title "Using the Parameters Collection to Pass Parameters To and From Stored Procedures"
Enjoy!
| 