Sending User Input As Parameters To SQL?
Mar 11, 2010
I created a stored procedure in SQL which will accept parameters from a vb.net textbox.I want it to output the count of records.
stored proc:
USE [Traffic]
GO
/****** Object: StoredProcedure [CENTRALTIMOVKP].[spReturnValue] Script Date: 08/02/2010 08:57:13 ******/
SET ANSI_NULLS ON
[code]....
I get the following error after I input my values (strRoadName and US45):Syntax error converting the nvarchar value 'SELECT COUNT(*) FROM tblSpeedStudy WHERE strRoadName = 'US45'' to a column of data type int.
View 1 Replies
ADVERTISEMENT
Mar 6, 2009
have a web form using Asp.net 2.0 with vb.net. I have two date fields on the form but I would like to validate them before my gridview uses them as parameters. I am using a Dataset for the source of the gridview and two parameters called StartDate and EndDate.
Basically in the code I am setting the values of the fields to the current date at runtime. Also the date fields in the SQL Server table are datetime and I only want the user to have to enter the date and it would grab all records within that date range regardless of the time. When the user enters the two dates and clicks a button on the form I need it to reset the parameters to the enter dates and refresh the data.
Here is the
Partial Class DispatchRequestList
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
[code]....
View 8 Replies
Feb 24, 2011
I have 2 pages, one is HTML and the other is ASPX. In the HTML I am able to get input from a user and then process a return email to them.The HTML looks like this:
<input type="text" class="input" value="e-mail" id="txtEmail" name="contactEmail" onclick="SelectAll('txtEmail');" >
[code]....
View 2 Replies
Feb 28, 2010
I managed to open a program from the start>run (commandline) and pass parameters. I write "C:myprogram.exe" parameter1 parameter2 etc.. in my program I retrieve it using the enivroment.getcommandlines(). This works fine, however when I try the same command in a url I only get the the path "C:myprogram.exe" and not the parameters.
View 15 Replies
Apr 20, 2011
I have a datagridview that is populated by a datatable and I want to be able to pass the value of a cell to the next page when a user clicks on that cell. The value of that cell is then passed to a sql stored procedure.
View 3 Replies
Dec 8, 2009
how to send a procedure call to a Command Button.
What I would like to do is have one button be able to call any number of other sub routines when needed. In other words...the app is running and I need it to stop so the user can either read information presented...or make choices...then click the CONTINUE button to pick up where the app left off. However, I need this to happen many times across several forms and modules.
I know I can use a MessageBox and get the same effect..
View 5 Replies
Jan 15, 2011
I need some help with the input validation of my application. Attached is the code that I have written as well as a screenshot of the front end. I specifically need input validation to verify that the user selected input for cbLengthOfStay is a number between 1-10 as well as input validation to verify the user input for txtMedication, txtSurgicalCharges, txtLabFees and txtRehabilitation is a positive numerical number. Please feel free to critique my attached code. [Code]
View 2 Replies
Feb 19, 2012
If my Category and Forum selection is incorrect I am sorry and feel free to move it. I'd like to have the users input in the message box that will show. For example: There is a textbox and the user puts in their name as Bob. Then the message box would be: What my main goal is, is being able to include the users input they type inside the textbox inside the message box.
View 6 Replies
Apr 4, 2010
Should I validate input parameters on all functions I create? Input isn't passed from a user, but from other routines as part of an automatic process.
I use error handling. I'm not sure what more validating input could do for me. If the input isn't valid, that's pretty much the same thing as an error, isn't it?
View 1 Replies
Oct 7, 2010
I have a stored procedure with two input and one output parameters. I need to execute the stored procedure from VB 2008 code passing it two parameters and returning the output parameter. How might I go about doing this? I don't have how to do this. Newbie here.
View 1 Replies
Apr 12, 2011
I'm using VB.net. I need to send keystrokes to an application. Is this possible? I'm sure it is. I need to be able to do other things while this program is doing this!
View 3 Replies
Feb 23, 2011
I have a form that requires input from a user that will update a database table. So they are offered input boxes. What the input box will do is ask the user to enter a date, what that will then do is to mark a field marked 'code' in my sql table as "holiday" for that entire day.
View 4 Replies
Nov 3, 2011
Option Strict On Public Class Form1 Private Sub btnDistance_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDistance.Click 'The btnEnterSpeed click event accepts and displays up to ten speeds from the user'and then calculates and displays average speed
[Code]...
I cannot figure out how to incorporate the number of days into the input box then get it to loop and count the number of times the User inputs in the number of days. Then I have to incorporate it into the equation to get the total distance D = MPH * Hours. What I have right now wil not count up the number of days and locks up after I input one number and will not add anything to the listbox. Because I also have to make sure that they cant add nonnumaric values and the number of hours per day cannot exceed 20. I have put things in and taken them out but it has been 2 days and I am lost now
View 1 Replies
Jul 8, 2009
I'm new to VB.Net how to send something to my email. Ex. If Guy A writes something to TextBox1 and clicks OK, it sends that to my email. Was that enough clear?
View 1 Replies
Feb 1, 2010
I am using vb2008.net express, I test vs2005term it work, can any tell me what is the input variable and output variable of this terminal? how to catch the input and output variable to a textbox1 for sending and a textbox2 for receiving when I press send button? is that possible? I attach the example of my question this is a a good source, but it is not relate to my problem: [url]...
View 1 Replies
Aug 19, 2009
I've created a simple licensing system for a friend who has created visual basic programs which he sells at a few dollars each (they're speciality programs).The licensing system is coded in PHP (I'm a PHP coder), and the system requires the user to input their license key upon start up, if there is not already an activated key (which is created in a .txt doc)
View 2 Replies
Jul 14, 2009
I'm trying to save what the user types in the vb code Dim user as Inputbox("") for example in a .txt file i can save the textbox and listbox but i cnt figure out how to save the inputbox i really need this to be saved the most.
View 7 Replies
Feb 11, 2011
I am creating a form for work where managers can report when they find a customer's personal information laying around on a desk (we work at a call center where agents answer calls for a wireless cell phone provider, so we take personal information security very seriously). Anyway, I am wondering if there is a way to have a text box autofill with that manager's windows username (since they will need to be logged into their own profile to use the form).
View 2 Replies
Mar 11, 2010
I need something tje user can type in data to such a parts QTY cost etc. There are no predefined parts list so the user can enter any part name/Number and there is no limit to amount of parts that can be entered.
Does anyone have any idea what might be useful. It was thinks of a listview bu i can't see that you can type into that. I cant use comboboxs because there are no predefined list and i know there is some way to generate text at runtime (i think) but i don't know how to do it and i would prefer a clearer approach.
View 3 Replies
Oct 16, 2010
I'm trying to execute CREATE USER with a given username (via sql parameter)
exec sp_executesql N'CREATE USER @LoginName
FOR LOGIN @LoginName;',
N'@LoginName varchar(5)', @LoginName='myuser'
Heres the code thats generating the above:
Dim myCommand As SqlCommand = New SqlCommand("CREATE USER @LoginName
FOR LOGIN @LoginName;",
ClassDatabaseConnection.CustomInstance)
[code].....
I get and error:Incorrect syntax near '@LoginName'.I think this is due to the parameters being passed as VarChar causing 'MyUser' rather than MyUser Can I not do this with sql parameters?
View 2 Replies
Nov 30, 2010
I am writing a program where the user has to log in before the program loads. Right now I have all the users and passwords hard coded into the program. Recently I have written a Oracle function that the username and password is sent to the DB and a yes or no is sent back after comparing the passwords. I am getting the correct response back and it will display in a label (I tried it to make sure the response is correct). The problem I am having is that the program after receiving the response doesn't recognize the response so I always get an incorrect password error.
Below is my code:
empName = tbxUser.Text
passWord = tbxPassword.Text
dbConn.ConnectionString =
"Data Source=!!!!; User Id=!!!!; Password=!!!!"
[Code] .....
View 3 Replies
May 8, 2011
Just have a quick question really, I am just making a simple application that allows me to check if a user exists in SQL here's my code
Public Function Check(ByVal textbox1, ByVal textbox2) As String
Dim comm As New SqlCommand
Dim conn As New SqlConnection
Dim Adap As New SqlDataAdapter
[Code] .....
And when it comes to the Comm line I get this error
Operator '&' is not defined for string "Select * from Login where Userna" and type 'TextBox'.
I've tried removing the "&" and well i cant figure it out.
View 1 Replies
Aug 24, 2011
My app needs the user to send me an email.How can they do this if they only use web mail and therefore haven't specified a default mail service?
View 4 Replies
Mar 29, 2011
I have this web application (LAN) that sends an email when users registers to one of our events.[code]...
The application sends the email without problems. The issue is that somehow a third person is enlisted in the cc, and receives a copy of the email!
View 2 Replies
Sep 7, 2009
I have a field called "payor" where the user selectes either "All, Medicare, Managed care" from a drop down list. I am sending the value of payor to the Fill query once the user selects the one they want.
I have no problem with coding 'Where (payor = @payor) if the user doesn't pick ALL, but what code do I need to include ALL records if the user selects "ALL" in the where statement?
View 7 Replies
Apr 22, 2009
I would need samples/hints on how to progammatically generate executable files after taking custom parameters from the user.I have looked into codedom and I almost got it to work except for the little fact that my application launches the console too and it's meant to be a simple windows form.
View 1 Replies
Sep 19, 2011
I have a table in my DB that needs to be updated. Whats a good way for a user to enter these 50 or so changes and have it update the db.
View 1 Replies
Jun 8, 2009
My winforms application will display 100 different names, and I will need the user to enter a number 1 through 4 next toeach name.I will then store this data.I know I can use the spreadsheet control,but is there something much simpler that I can use? Maybe an array of textboxes or a datagrid?
View 3 Replies
Jul 27, 2005
I am trying to have my program time out if the user lets it sit idle for an amount of time. Is there an easy way to find the last user input? I am using VB.NET.
View 4 Replies
May 17, 2011
In my program, I need to have the user input a list of numbers separated by commas. How would I go about storing those numbers? Would I put them into an array? If so, how?
View 5 Replies
