I am able to add an existing MDF database to my project and apply it to a form with the appropriate binders and navigators and such and it works fine. I can hard code queries that are very successful. My question is this: Is there a way to add a textbox to the form, where I could enter a valid query that would execute on a button click event? It seems like I should be able to do so with SqlCommand, but I am just stumped.
[Code]...
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 RepliesI have a form with a few text boxes, one of which has it's contents stored to a integer variable.
The value stored will end up being one of a few numbers ranging from 12 to 98, and I need to the same number of new variables as the number in the textbox.
Can I automate the creation of new variables based on the value stored, or do I need to define the max number required and just ignore the rest when using less?
What I'm trying to do is make a list of members in a read only textbox getting the data from two textboxes (first and last name) and a 'save' button. I've made a class named 'Deltaker' (Members in english) to store data and a list 'resultater' (eng: results) using the 'Deltaker' class. I'm trying to get user input from two textboxes 'tbxFornavn' and 'tbxEtternavn' and I use my class' public function 'Navn' to display it in the textbox 'tbxHistory'.
[Code]...
What I'm trying to do is make a list of members in a read only textbox getting the data from two textboxes (first and last name) and a 'save' button.
I've made a class named 'Deltaker' (Members in english) to store data and a list 'resultater' (eng: results) using the 'Deltaker' class.
I'm trying to get user input from two textboxes 'tbxFornavn' and 'tbxEtternavn' and I use my class' public function 'Navn' to display it in the textbox 'tbxHistory'.
I've got a sub procedure to add the input to the list and clear the textboxes and enable another reset button.
So for the save button click event I run the sub procedure and I've written a for next loop to display the results from the list. The first name I enter is all good, but with the second name entry both the first and the second name gets listed as well as the first name that is already there. I thought about using the .clear function to clear the list after each input, but I also want to incorporate laptimes in the list and display the best time in a lable at the bottom of the form. Maybe also sort the list, so I need the data in the list to stay intact.
Public Class Form1
Dim resultater As New List(Of Deltaker)
Private Sub AddDeltaker()
[Code].....
I'am creating a program that will input a number in a textbox for example 5 and display 5 textboxes in form...I have no idea how to do this but here is the code i've done..
textbox1.text = val(textbox1.text)
'i don't know what to do next..
i use visual basic 6 i already try making a button to play sounds. by clicking the button and the sound will out. so that i want to know were could i start, when you input words in textbox the program will speak what you have type in the textbox.
_
The database:
"ID (Primary key)" | "Title"
0 | "title1"
[code].....
OK, before adding values to database, we should check if a row exists with this values :)TO do this, creating a Stored Procedure is a best way to deal with the database fastly.So... The problem now is, at the runtime, Miss OleDB throw this error:Microsoft Jet database engine cannot find the input table or query 'IF
i should say hi experts :D . Help me with this pretty code :)
The database:
"ID (Primary key)" | "Title"
0 | "title1"
[code].....
OK, before adding values to database, we should check if a row exists with this values :)TO do this, creating a Stored Procedure is a best way to deal with the database fastly.So... The problem now is, at the runtime, Miss OleDB throw this error:Microsoft Jet database engine cannot find the input table or query 'IF
When Creating a query using the sear Criteria Builder . I keep getting the error : "The schema returned by the new query differs from the base query" what does that mean and how do i avoid this problem in future
View 2 RepliesI have a problem with the code, I have input the valid username and password in the form textbox to input the strings in php, but it keep displaying the messagebox that says login failed.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
MessageBox.Show("Please enter your username")
ElseIf Textbox2.Text = Nothing Then
MessageBox.Show("Please enter your password")
Else
[CODE]...
I don't really know why it keep displaying the messagebox that says it failed when I have input the valid strings in the first place.
My objective is to, instead of entering in the data manually into the text boxes, I want to read in a textfile. The Calculate button will contain the code to read in the file and assign it to the appropriate textboxes. Save the separate file in the \bin\Debug folder.
The text file just needs to have 3 integers on 3 separate lines.The code I posted works without and errors, but.I am having some trouble integrating the Stream Reader.
[Code]...
how to take a query that returns a single row of data and load that data into textbox controls.I know about ExecuteScalar but it is only good for a single column of data from the query.
View 2 RepliesI am using visual studio 2010 to create a form where you can edit,delete, or insert data from an accessdatabase. When I try to run the form in a web browser I get the error "Query input must contain at least one table or query." I believe that the problem lies with my code/syntax but I am unable to determine the cause of the problem.
<asp:AccessDataSource ID="AccessDataSource1" runat="server"
DataFile="~/App_Data/database.accdb" SelectCommand="SELECT * FROM [database]"
DeleteCommand="DELETE FROM [database] WHERE ([EmployeeID] = @EmployeeID)"
[Code].....
I want to query an access database with variable data defined by the user. The "Search" criteria would be in a textbox. I made a query like
SELECT askID, Question
FROM chita
WHERE (askID LIKE 'Textbox10.text%')
and referring to this query as
Form1.ChitaTableAdapter.searchrec(Form1.ChitaDataSet1.chita)But id does not take the value of the textbox, instead it takes the Textbox10.text as a value. Is it possible to refer to it like this, or should I Linq?
[Code]...
I have a query string that takes the value from a text box and passes it via a query string to a different web page. I need to add a hidden imput (state=MN) but can't get it to work. Everything I have tried hasn't worked.[code]
View 7 Repliesive been learning Vb.net at uni. Ive never used it before and im finding it a little difficult ( supposed to be easy )i usually code in c++ and MFC Problem I have craeted the database and added all the fields to the form.
View 3 RepliesI have a grid view that is shown on the click of a button and takes the input of a text box. This works great, however i would like this gridview to be editable.The code for my button is
GridView2.Visible = True
lblEnterName.Text = ""
If txtLoanName.Text = "" Then
[code]....
I know the datasource needs update,delete queries etc, but not sure how to add these as the datasource is created when the button is pressed.
I currently have a subroutine that generates a file with specific parameters, and it relies on user input in 2 fields. Now I also have a numericupdown control. What I'm looking for is a way that if Numericupdown.Value = 3 then it will generate 6 textboxes and once the parameters are filled out completely it will generate subroutine times(numericupdown.value) and output it to a single file.
View 3 RepliesDoes anyone have a good link to a tutorial that teaches you how to create an input form that adds records to an access databas
View 2 RepliesI have 3 TextBox control, 2 is for keyin data and 1 is for Display data,
[Code]...
What I want is to display combine input data from TextBox1.Text and TextBox2.Text to TextBox3.Text I mean keep any previous data input in same TextBox and saperate it using a comma (,) or (;) for combination I am using (@)
Example: In TextBox1.Text I put 200 and TextBox2.Text 2000... Click button Save and I want it to be display in TextBox3.Text as 200@2000 and again I Enter 500 in TextBox1.Text and 5000 in TextBox2.Text Click save button and I want it be display in TextBox3.Text as 200@2000;500@5000 which is 200@2000 is the first input data... and it continue as many as it can.
how to input data in mysql, different tables with one query?is it possible to do in gridview in vb.net 2008?
View 4 RepliesAm working on a project like a office automation. The problem am displaying the balance amount using lables.But i want to display the numbers like we see in calculators...
One way to do that creating usercontrol which gets input and display the numbers.
I have Access as my back end. Student is the database name and its path is c:Projectstudent.mdb And am having few tables in it. When i click a command button in vb.net a new table must be created in the path mentioned. And it should have the fields I declare. What s the query I need to use ? Is it possible to do like that ?
View 2 RepliesI'm creating a form application using vb. I'm still new to this and I'm teaching myself via the internet so please don't be too mean. I wrote my code using queries that I created in visual studio. I don't quite remember how to create an update query and write the code to update different datagrids. I tried searching the forums, and I can't find anything that fits into the way I wrote my code. I have an update button that I want to use to save all the edited data in the form. Here's my code so far:
Public Class Form1
Private Sub Blsys_systemsBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
Me.Validate()
Me.Blsys_systemsBindingSource.EndEdit()
[code]....
I created 2 forms in Access 2003 (Form1 & Form2) for the purpose of creating a 'smartform' of sorts for my company. In essence they can click on a search feature in the top cell and input an employee ID # which automatically fills in about 10 to 15 fields.
- There is only 1 table attached to the forms.
- The group I created this for is uncomfortable using Access.
What I would like to do with VB.net:
- I thought I would create an internal webpage using VB.net so they wouldn't need to log into Access [the DB would be stored on a separate server.]
- I would need a clean & simple interface that has 2 buttons, one for each form.
-When the form is called up I would need a search feature "EMPLID _________" which would connect to the Access DB table and retrieve the correct information.
-Id also need to have the form printable & have the ability to search again or return to the front page.
i am creating a search system i have one of y search querys working but when i try to do the same on a different part of the project i get this error message and one of my text boxes underlined message is : -
Error1 Argument not specified for parameter 'Param4' of 'Public Overridable Overloads Function GetDataBySearch1(Site As String, Postcode As String, Site1 As String, Param4 As String, Param5 As Object, Param6 As String, Param7 As String, Param8 As String) As WincantonDataSet.SitesDataTable'.C:search_Systemsearch_Systemsitesearch.vb2026Wincanton_System
I am using VS2008, language VB, and MySql.I have a simple database app joust for practice. It has one table that contains ID, Name, Surname and Age fields. The code I am using is:
[code]...
Now I would like to something like this:
[code]...
Value of type'System.Data.EnumerableRowCollection (of char())' cannot be converted to 'string'.What am I doing wrong?
I have two textbox controls and I want to accept input for textbox 1 and textbox 2. However, when user enters text into textbox 1 I would like textbox 2 to mirror the same text as it is typed.
I am sure this is a very simple procedure however it is new to me and I am having trouble finding an answer with search engines. Most result are coming back as text that one can read backwards in a mirror which is not what I am looking for.
creating a mortgage calculator that display continuous information depending on the user input such as monthly payments, remaining balances, and interest paid. I am attempting to use a list box and am currently stuck. [code] Please use code tags when posting your code. Code tags are used like so.
View 1 Replies