VB - User Substitutes Name On Query - Get The Data Set To Return Different Output Given A Variety Of Inputs
Nov 19, 2009
So, I run a select statement in SQL and then it has something like " where clientName = 'John Doe' " I can generate a datagrid or dataset off the SQL statement, but it will only be good fro one client...... I would like to be able to populate a dataset/grid using the select satement and then having something like a combo box of names the USER can choose. Then the user selects the name and the datagrid is populated with that clients info or w/e........
[Code]....
View 2 Replies
ADVERTISEMENT
May 1, 2010
I am wondering how do i Return a value that is set in a Radio Button and Add it to what Decimal a User inputs into a Text box?
Public Class Form1
Private Sub txtbasic_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles txtbasic.TextChanged
End Sub
[code]....
i have 2 Error and 1 Warning Function 'OverTime Doesn't Return a value on all code paths.
1 Expression is not an array or a method, and cannot have an argument list
2 Expression is not an array or a method, and cannot have an argument list
View 4 Replies
Nov 25, 2009
Im trying to improve some apps ive written, the first is a console app... Im trying to get it so that i wont get an invalidcastexception if the user inputs a string, when the variable is type "Double"
[Code]....
View 2 Replies
Mar 16, 2012
i am trying to find examples of getting data back from a stored procedure that has no parameters sent to it nor has any returned output parameter. Though it does display data.How can i get that from my code im using below?
Dim myCommandSQL As New SqlCommand
Dim myReaderSQL As SqlDataReader = Nothing
Dim intX As Integer = 0[code]....
The @return_value i just put there to see what would happen but i got nothing returned.
View 2 Replies
Dec 29, 2011
What I am about to do build is a UI that will allow a power user to build complex queries.
This is non-trivial, but very common. So before I re-invent the wheel, I would like to see if anybody can point me to some already-written free code or release some of their own.
Required:
To be able to specify some 'where-clause' type logic like this: Age>21 and (Citizen=True or HasGreeCard=True) but without having to type the query code, instead, use a UI with constrained options and on-the-fly syntax checking (e.g., no unclosed parenthesis or ending a term with an Operator).
I've seen this type of thing in many line-of-business apps, where you can say 'add condition' and another line appears on the UI like this:
Dropdown of fields Dropdown of ops (=, >, etc) Blank box for entry
And you can add more lines, and the lines are all and'ed, but you can also decide to OR a few, or insert parenthesis (explicity or via indenting), NOT a line, insert, delete, and move lines around, etc.
Not required but nice:
WPF - I could convert from winforms. Extensibility using OO constructs. Validate the sanity of the query. Emit a System.Linq.Expressions expression tree - or similar data structure. If it attempts to execute the query I don't need that; but I don't mind removing it.
View 1 Replies
Jan 8, 2010
Is it possible to have a Textbox on a form that when the user inputs data, ( during Runtime )that data remains in the Textbox for good and the Textbox then becomes read only ? Is it also possible to make it so that the CD with the programme on, is in the PC when the programme is being used. Perhaps writing the Textbox data back onto the CD ?
View 1 Replies
Nov 13, 2011
'Declare the price rate per night
Const decNightly_Rate As Decimal = 350D
Private Sub btnCalculateCharges_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCalculateCharges.Click
[code]...
I am trying to make a hospital form where the user inputs data for a hospital bill. I have to create three functions: CalcStayCharges, CalcMiscCharges, and CalcTotalCharges. I do not know why this code won't work.
View 13 Replies
Mar 8, 2011
What I'm trying to do is to write a generic rss reader that I plug in any URL into without worry if the feed has all the common properties. For instance in my example below I'm looking for pubDate, however if no pubDate exists in the xml I'd like to return the current Date. I cannot seem to get the syntax right though.
Dim xmldoc As New XDocument
xmldoc = XDocument.Load(url)
Dim feeds = From feed In xmldoc.Descendants("item") Select New With { _
[code].....
View 2 Replies
Jan 25, 2010
I'm trying to do a LINQ Query against a typed datatable that will return me duplicated data.With out going into too much detail, here's the basic setup:
strCode1 - string type
intCode1 - int32 type
intAdjustor - int32
There are more fields but these are the ones that are important.I'm going to do my best to describe this, as it's kind of confusing.In theory intCode1 is a key for strCode1 (hence the names). So each time intCode1 is duplicated, the same strCode1 should appear. Example:
[code]...
Ultimately I'd like to get a List(Of T) - where T is my typed data row. In SQL, I would simply use a sub query, to get a distinct list of strCode1 and intCode1, then do a count, grouped by strCode1 where I get more than one row.I'm not sure how to translate that into LINQ, AND get the original types data rows returned in a list.
View 7 Replies
Jun 27, 2012
I'd like to give a homework assignment to a person learning VB.NET. I'd like it to use basic inheritance and a variety of data structures including queues, lists, arrays, or stacks in a windows forms application. I was thinking of a pizza-ordering application. This would allow them to utilize some basic inheritance and practice using .NET UI elements.
View 2 Replies
Dec 12, 2011
I use this code to return records in a DataGridView:
[Code]....
View 3 Replies
Feb 17, 2011
It's been a good few years since I dabbled in VB and I'm very very rusty so any help would be great! What I'm looking to do is search an access database with user input and display the relevant record.I have a single table set up in an access database called school_info with the following fields and data:
Tres________DfE________Name_________Type
001________1234________School 1________Primary
002________4321________School 2________Secondary
[code]...
I've linked the database to my new project, connected the database and added the 4 fields to my form. When I run it, the data shows in the boxes fine.The Tres and DfE fields are show in text boxes on the VB form, and the school and Type are show in labels. What I really want to do is be able to manually type in either a Tres or DfE number into the relevant text field and have the other labels auto populate with the relevant data that's stored in the database table.
View 9 Replies
Mar 3, 2009
I'm not sure the best way to accomplish this, what i have is 10 checkboxes on a form named chkbox1 to chkbox10, say ther user selects 4 then clicks a button, i was wanting to execute code one after each other like[code]...
View 3 Replies
Dec 9, 2010
I'm trying to create a User form that has six inputs.
1.) User input textbox 5.00 to 60.0 inches only accepted.
2.) User input textbox 2.50 to 30.0 inches only accepted.
3.) User input textbox 6, 8, & 10 nominal input only accepted.
4.) User input textbox 60% or 65% only accepted.
5.) User input textbox 2.50 to 30.0 inches only.
6.) User input textbox where 500 shows up in the box as "standard" but can be changed by user input.
Then an "OK & Cancel" button. I don't know whether to use a dialog box or a form, what class, masked text box vs. not masked, etc.
View 14 Replies
Jan 18, 2012
How can I prevent users inserting sql injection in my database? How can I validate their inputs? I am new with this sql injection. I don't know how to prevent users to insert this sttmnentif and I don't have the idea of sql injection how can I be sure that I am safe with sql injection??
View 1 Replies
Apr 28, 2010
I am connecting to an Access database and using a parameter query with the LIKE operator to return all rows that match query. The string to search for is taken from a Textbox
sql =
"Select * FROM Allview WHERE Info Like" &
"*" &
CStr(TextBox1.Text) &
"*"
The query does not return any data in vb, but when run from access with same string, there is data returned.The connection to the database is done correctly, as I am able to return data with various other queries.
Partial code :
Dim
con As
New OleDb.OleDbConnection[code]....
View 8 Replies
Jun 25, 2009
I was trying to find examples of how one would make a webpage using asp so that I could have the visitor enter information on a form and then when they hit submit it will be attached to my webpage indefintaly and any visitor can view it.
View 4 Replies
Sep 3, 2009
How do i check if user has entered all inputs and go to the next form.
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
t1.Focus()
End Sub
[code]....
In this code it gives an error, but after displaying the error it jumps to next form.
View 5 Replies
Jan 22, 2011
i have created a simple form which takes some input from the user. Now, I want that the input should be saved to my harddisk and can be seen later as well. Can you please tell me how to save the inputs as a record on my harddisk.
I mean the first time the form appears, it has four options. All the four options will be a record. The next time the form is re-loaded, then the same four fields will have data for someother client. It should be saved as another user.
View 3 Replies
Apr 28, 2012
I have several text boxes which a user is supposed to input a numeric value and the program will use an array to verify whether the input in each text box falls within the numeric range allowed for that text box. So one text box will only accept number 3-7 and i'm supposed to create an array that will verify the input in that text box falls within that range. Personally, I would just do:
Dim intInput1 as Integer
intInput1 = CInt(txtInput1.Text)
If intInput1 >= 3 or <= 7 Then
messagebox.show("Input Verified")
Else
messagebox.show("Input must be a numeric value between 3 and 7")
End If
But this isn't what the assignment asks.
View 1 Replies
Jul 13, 2009
I have created a page that creates a number textboxes at runtime depending on the result of a database query, (ie one textbox per row in query result). My problem is that I can't for the life of me work out how on earth to access the text from the textbox that is posted back to the server by the user when they press submit.
View 4 Replies
Nov 4, 2009
I am building a program where all the inputs (10) required from the user are asked on one form. Since it is not possible to let fields blank on the database, I would like to know how can I build an 'IF' saying that if all fields are full, then the database CAN save all the input. So that if there are any field blank, it won't save. I just dont know how to do the database condition. Thats all.
View 3 Replies
May 3, 2012
I'm currently trying to improve the speed of my program. Basically the user inputs min and max values for a, b, c, and d and a constant n, and then it tries to find the curve/line in the form a (x/b + c) ^ n + d. However for large ranges (1-100 for a,b,c, and d; total of 100 million values to try), it would take around 100 minutes at the current rate (approx 800k values/minute). I'm wondering whether I can further improve the speed. [Code]
View 6 Replies
Oct 14, 2009
This is what I'm trying to do: I have a listbox to display a list of costs that the user inputs. I want to use some kind of loop to add those numbers from the listbox sequentially, then display the total in a label.
How do I set up a loop (and what kind of loop is best) to pull the numbers and add them to a total? give an example of what the code might look like. I'm new to VB
View 6 Replies
Jan 20, 2010
I'm making a program similar to a wordpad or whatever, but i'm having issues making the user inputs insert at the cursor position instead of at the end.. I'm running DevStudio 5 btw.
View 4 Replies
Dec 7, 2009
Ok so i made a program where the user enters 3 inputs in a 3 textboxes (First Name, Last Name, Bday) and when the person presses enter a check list is made under the checklistbox with the Lastname. So can any1 tell me if i click on that checklist then everything i entered shows up in a label.
View 11 Replies
Feb 16, 2010
Is it possible for you to loop a block of code until the user provides a valid input? Like, when I click the save button, the program will prompt the user for an integer value, and I would like to validate if the user has inputted a valid value. If the user fails to input a valid value, then the program will re-prompt the same message again until the user inputs a valid value. Eg:
If MsgBox("Add copies to this book?", MsgBoxStyle.YesNo, "Adding Book Copies") = MsgBoxResult.Yes Then
Dim CopyQty As String = InputBox("Amount of copies to generate:", "Add Book Copy")
If IsNumeric(CopyQty) = False or (CopyQty < 1) Then
[code]....
View 12 Replies
Jun 7, 2010
I'm using the Details View control of VWD asp.net 2008
I have a users database table. One of the columns contain the "uniqueidentifier" user's profile ID, created by VWD (from the automatic profiles table).
From my table, I would like to select only the data pertaining to the logged in user.
How do I get the current unique user profileID in general and then how do I use that for my query?
In the configure data source option of the control, I select the check box for "Return Only Unique IDs" and the WHERE option. In this new window I select the Column to the profile userID ... "=" and then assumed I should select Source: "Profile".
Now what should the parameter properties or value be to select only the current logged userID?
OR how can I do this just in C#? There doesn't seem to be any code behind after instering a DB with the VWD controls?
View 1 Replies
Feb 19, 2009
I have a listview with multiple columns that I need to fill out of information gathered from user inputs in various textboxes I use to have a code for Windows Forms Application as below
[code]...
This works fine.However,when I shifted to WPF and tried to reproduce EXACT same code,it tells me Too many arguments to 'Public Sub New()' Alternatively,
Basically I have about 15 data that I want to display in different columns per row in a listview.I need it in such a way I can sort, edit, delete, insert,etc.With my previous methods, I could do those fine, but in wpf im stuffed...
View 2 Replies
Oct 5, 2010
I have a form that has 10 addition execises. The user has the option of using a timer or not. I have the timer part correct, but now I want to be able to check the exercise answer one by one as the user inputs the info.
[Code]...
View 2 Replies
