how to create a procedure?In VB6 it was through Insert Menu > Add Procedure.Also (just out of interest) is it possible to read from a database and copy the data in to an array?I've not used Visual Express for a while and have forgotten how to do theses.
View 6 Replieswhat is the code to put in when you want to create a procedure for a sql database
View 1 RepliesHow do I create a stored procedure for mysql using VB .NET programmatically?
EDIT: I have tried using ExecuteNonQuery provided by MySQL .NET Connector. It prompts me error. Maybe it's because I put "Delimiter $$"? I know I can create using script (batch file) if I want to send it to my client (as commented below). But my objective is to keep MySQL password safe. So script is not the way.
how to create a progess bar which discribes the process of a SQL procedure?
View 1 RepliesI am extremly fresher in the above things. I want to create a store procedure in my programme and use it or call the store procedure. give me a standard sample code so that I can understandand.
View 4 Repliesi used to create sub procedures in vb6 under tools/ add procedure. Same is not available in vb2008. how can i create sub procedure in form.
[Code]...
I can create event prodcedures for form objects, but is there a way to create an event that triggers when a certain variable equals a certain value?
View 3 RepliesMy IDE is Visual studio 2008.I just want to ask how to create Stored Procedures in Microsoft Access Database (.mdb) and pass the values to a VB.NET Windows Application.
[Code]...
I am creating a front-end application for my company to track job details, customer appointments, upcoming appointments, and more. I had a developer create a back-end SQL database, which includes all of the corresponding stored procedures, such as insert, delete, update, detail, list.We are running SBS 2008, which includes Sharepoint for our internal website. So, I would like the final application to be hosted on our internal website.
I've talked to three different developers and all three had conflicting opinions regarding development. Where do I begin in the development of the application? Which template should be used? How are the stored procedures utilized? How can I create a button to call the stored procedure?
I have completed the coding for this assignment but have a few errors that I cannot figure out. I did create the new stored procedure 'getEmployees'
Error1Type 'PubsDataSetTableAdapters.getEmployeesTableAdapter' is not defined
Error2Type 'PubsDataSetTableAdapters.getEmployeesTableAdapter' is not defined.
Error3'getEmployees' is not a member of 'CIT263Lab5.PubsDataSet'.
I am trying to write a protection procedure, which will allow me to create a licence key for our users. This licence key will ensure that the software can only run on the registered system, and will allow the user to access only specific areas of my program which is relevant to them.
I am thinking of using an RSA style approach to this where I want to be the only person who can create the registration keys. But I want to allow the program to be be able to decrypt the key. This is to prevent the average user from being able alter the key and remove any restrictions which are being imposed on the program by the license key.
The process that this would take is to produce a host id which has went through a series of tasks to distort the actual value from the user will return this code us, and from this host id I can then work out the original value of the code. Using these public and private keys I can then encrypt license key information.
However I would like to know how I would implement the private key encryption and key generation program in .NET, so that I can get this setup working in a manner which will allow me to generate keys and allow the program to decrypt keys.
I have successfully create a user name = 'root' and host = '127 .0.0.1 ', use the mysql command (client mode) as follow: sql = String.Format("CREATE USER '{0}'@'{1}' IDENTIFIED BY '{2}'; GRANT ALL PRIVILEGES ON *.* TO '{0}'@'{1}' IDENTIFIED BY '{2}' WITH GRANT OPTION;", userName, serverHost, userPassword) When the script above I change it to store procedure (server mode) as below, I found the error as follows: (Error 1064 - You have an error in your SQL syntax; check the manual That corresponds to Yout MySQL server version for the right syntax to use near 'pass' at line 1)
[Code]....
how to create shorcut key in toolbar or shortcut to call both procedure or function
View 2 RepliesIn a DataSetIf I right-click on a TablesetAdd QueryCreate New Stored Procedure. The creation will fail for me using a SQL 2008 database. "There was a Problem with the UPDATE stored procedure. The stored procedure was not created."If I "Preview the SQL Script..." copy it and run it manually it fails because it is not putting brackets around my user name. "CREATE PROCEDURE SDSDBLUESKY.UpdateQuery" Fails"CREATE PROCEDURE [SDSDBLUESKY].UpdateQuery" WorksThis is a work around because it links to this if I do manually when it gives me the preview option, and don't rewrite it. But is there some setting change in VS2005 to get this to work correctly in the first place?
View 1 RepliesI am new to nodes() method. I am getting the foloowing syntax when trying to create a stored procedure using the nodes() method.
The syntax error:
Msg 170, Level 15, State 1, Procedure spmTestSelect, Line 19
Line 19: Incorrect syntax near '.'.
[code]...
My question is How can i create insert,update,delete query by using class file and store procedure. This query is use for 3 tier.
View 2 RepliesI am trying to create a procedure which will evaluate a string expression as if it were a line of code...Kind of like what a graphing calculator does when you enter a formula. Does anyone have any experience with this in VB? I have an example of C++ code which uses CodeDom, but I am a bit rusty with my C++!
View 4 Repliesdoes VBasic allow a MS Access Database DataSet create a Stored Procedure or will it only allow SQL Database DataSet create SP...
View 4 RepliesThe instructions are as follows:
1. Write a Visual Basic Console Application.Inside the main procedure call a function procedure to input and return a value for a double variable called x, the width of a right triangle.Inside the main procedure call the same function procedure a second time to get a value for a double variable called y, the height of a right triangle.
2. From the main procedure call a function procedure which calculates and returns a value for the hypotenuse equal to the square root of (x squared + y squared).You will have to pass the values of x and y to this function procedure.The procedure should calculate and return a double type value.The value that is returned by this function procedure should be equal to the square root of (x squared + y squared).
3. Also from the main procedure call a sub procedure to display the values of x, y, and the hypotenuse.
In a tic tac toe game I am making there are two blocks of code that are identical except that they access different arrays:[code]Arrays plyrTaken and plyrPairs are used in the first block and cmptrTaken and cmptrPairs are used in the second. Is it possible to wrap these blocks into one Sub Procedure passing the different arrays when the procedure is called?
View 5 RepliesWell i ran into some problems changing my getfwt to a independant sub procedure. This stuff is so confusing to me.[code]...
View 14 Repliesi able to get data then i click second time i got error Procedure or function "procedure name" display has too many arguments specified" why this error. [code]
View 2 RepliesIs there a way to terminate calling procedure from the callep up procedure? I tried 'Stop' from a called up procedure in an executable; it has gone stuck; I am not able to remove it(the form) from the screen!
View 18 RepliesI finished coding an application for converting Celsius to Fahrenheit, and vice versa. I used the Sub Procedure to convert them. What I need now is to modify it. I would have to use the Function Procedure instead of my Sub Procedure.
[Code]...
Im a student doing an assignment, how do i pass the value from a sub procedure to a function procedure....i want to pass the value from decSubtotal to a function procedure named CalculateDiscount; check out my code--
[Code]...
The store procedure which give me the information I need is:
USE [UCSMIS]
GO
SET ANSI_NULLS ON
[Code].....
When I try to add it to my report it gives an error, is it because of the temp table and how should I go about it?
I have to get a value in $.I have 2 radio buttons:
-Residential Customers
-Business Customers
I have 2 List boxes:
-Premium Channels
-Connections
I also have a total Text Box and a calculate button..My goal is to get a cost given the information from the user. the list boxes will have preassigned numbers in them..The residential Customers have to pay a $4.50 Processing fee, a Basic service fee of $30 and 5$ for ever Premium Chanel they buy. The Business Customers have to pay a processing fee of $16.50, a basic service fee of $80 for the first 10 connections (4$ for any connection after that) and 50$ per Premium Chanel (no limit)
I have a stored procedure to update a table, but needs a couple of values from another table.
the first two selects get the value from the table and then are used in the update statement.
The select statments:
Select @iStatusDropDownValueID = iDropDownValueID
From DropDownValue
Inner Join DropDownValueType On DropDownValue.iDropDownValueTypeID =
[Code].....
First, the values that are retrieved by the first two select statements are always the same. So they could be passed in by the code itself. I don't know that this will speed things up at all, just make the entire stored procedure better and easier to read.
Second, if the "Value Name" should change this store procedure will break (which is possible, but not often).
I am looking for any insight into the Best Practices for this situation.
I want use a stored procedure in my project but I have no idea about it. Please could you tell me a little bit about how to use I can use one in my vb.net application ?
View 2 RepliesOK. So I have a class-level array:
Dim terrain()() As Double and I want to add the bounds in a procedure:
Dim terrain()() As Double = New Double(divisions + 1)() {}I can't add the bound for the seconds dimension.
Then I want to assign a value to any element of the array inside the procedure.
terrain(0)(0) = 0.5 This gives the error: Object reference not set to an instance of an object You can see my problem. What solution can there be to this problem that involves one array.