My project consists of a user interface designed in Visual Studio 2010 Express. I have it linked to an Access database. At this time, I have two text boxes that the user will enter a number. I want to be able to write a query that will take the first and second number and pull the information from the database that is equal to or greater than the user entered number
View 6 RepliesHow do you carry out a query from a criteria e.g name entered by the user from a textbox. and then display the query results in a list box..
View 2 RepliesI m trying to filter a sql db with many filter criteria which inert the user in textboxes .. i ve tryed this query
[Code]...
The application must have basic functionality as to: Insert new customers into the database A search function will be needed to find a users criteria entered The more advanced features would include matching certain criteria with another for example if the data in field 1 is the same then it should match this and return the results. so for example if a person has a hobby of 'football' it will return all the people with the same hobby
View 4 Repliesset the selection criteria using combobox, but there is a possibility to select "All Items" option. There are more than 2 combobox selection.
Code:
strSQL = "SELECT nama from GridView"
Dim da As New SqlDataAdapter(strSQL, oconnection)
Dim ds As New DataSet
[code].....
Upon entry into my database, frmLot opens. The form opens in datasheet view. It displays several fields to include one named WorkOrder. The user clicks in the cell named WorkOrder. In the On Click property, I store that variable and name it stWorkOrder. What I need to happen then is to pass this variable to the criteria field of a query named qryWorkOrder and have it run and display results.
View 1 RepliesI have a problem with unicode character, as i create a database in SQL Server 2005. I want to query from a table that criteria fields are contain unicode character i.e NVARCHAR.
e.g: SELECT * FROM tblMyTable WHERE MyField='ភាសាខ្មែរ'. But when i did like this all rows that contain Unicode Character always display. it doesn't fit to my criteria
Can i use the timer when the user tries to log-in and the user entered a wrong password 3 times.i will give the user 5 mins to log-in again with the correct password and if the user enters the wrong pass. 3 times again i will give another 10mins also this is what i want when the user close the program the timer is also their and running that it will give the user the remaining tym on how much tym left 4 him to log-in again.Can i do this in vb.net??i dont know how 2 do this i dont have a clue if it is possible can someone give me a code??
View 9 RepliesI have database with table called "Konzultacije" with field "Vrijeme" (Date/Time). I have datagridview (DGKonzultacije) with columns. Column (1) data format is set to date/time. I want to delete record from "Konzultacije" table depending on selected cell in datagridview but only I can get is error.
This is my code:
Dim iSql As String = "DELETE FROM Konzultacije WHERE Vrijeme = " & DGKonzultacije.CurrentRow.Cells(1).Value
conn.Open()
[CODE]...
If i add apostrophe like this:
Dim iSql As String = "DELETE FROM Konzultacije WHERE Vrijeme = '" & DGKonzultacije.CurrentRow.Cells(1).Value & "'"
error is raised: Data type mismatch in criteria expression.
I want to retrieve query from MS.Access database criteria is between some date range,but I get the following error when execute my reader:Syntax error in date in query expression 'D_ate BETWEEN # @DateFrom # AND # @DateTo #'.
Dim StrSQL As String
StrSQL = "Select * from Pla_Comp Where D_ate BETWEEN # @DateFrom # AND # @DateTo #"
myCommand = New OleDbCommand(strSQL, conn)
[code]....
I am trying to find a way to use a month calendar control as an object data source, such that when end user selects a given date, or a date range (1 week max), it will supply the date range criteria for an access query, and the results will wind up displaying in a data grid view below the month calendar. I am having a really hard time..
how to write the date criteria into the access query for something like this
I want to display a message to the user if certain criteria is not met. Example of this would be - If "B" is equal to or less than "A", I want to display a message to the user.
View 5 RepliesWhy does QueryBuilder modify my query? Is there a workaround? When I enter the query below, QueryBuilder modifies the query to the more complex version below, requiring additional parameters for the FillBy method. Any additional parameters adds an exponential amount of complexity to the modified query.
[Code]...
I am currently trying to develop a chat application which will work on a LAN, however encountering problems with with adding a user through the registration form, always getting the result :: "Datatype mismatch in criteria expression" I've tried checking and cross-checking the datatypes used in both the database(its a .mdb database,, created in Microsoft Access)this is the code i am using:
dim con as new oledbconnection
dim cmd as new oledbcommand
Public Sub UserReg()
[code]....
everything is done,, such as opening the connection and defining teh data reader, etc as you can see from teh code(which was derived from another question but i made edits to suit my use for it)I also have problems with checking wether a user is online. obviously i will be referring to the table to do that using something like
cmd = new oledbdatacommand("SELECT * FROM Users where isOnline = "Yes")
dim sdr as oledbdatareader = cmd.execute reader
whence it will show a list of all the currently "Online users" but i do not how how to quite refer to it?
I need some guidance on the best way to proceed with searching a file content. I have a large file (see attachment) that is in text form, some of these files could be upto 50 times as big, therefore creating a huge file. These files contain information that is produced from another application and therefore I am unable to change the format of the file.
[Code]...
I am trying to perform a task while the word count of a richtextbox is less than a user entered value, but the word count keeps coming out miles out, here is what I have:
Dim count As Integer = 0
RichTextBox1.Text = ""
Do While count < NumericUpDown1.Value
[code]....
I have an EXE that creates objects based on params passed to it.Say I have textboxes named 57 and 21.I want to read the values entered by the end user.
Var1=57.text
Var2=21.text
How do I pull this data from the boxes?
I Create an application that when a user enters a positive integer value in a input box(the default number is 10) when the OK button is clicked, the application should display a message box with the sum of all the integers form 1 through the value entered by the user. If the user enters a negative value, the application should display an error message. I believe I have to use a loop condition but I have no idea what to do.
EX: User enters 10 in the input box once OK button is pressed a message box pops up and says "The sum of the numbers 1 through 10 is 55". Use the following test data to determine if the application is calculating properly
VALUE SUM
5 15
10 55
20 210
100 5050
I have a report that requires the user to enter their ticket number, then they click view, and it generates. Pretty standard. What I would like to do is have the report automatically export to a pdf when they click view. Does anyone know if this is possible and how I would approach the matter?
View 1 RepliesHow 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.
I have a datagridview and, I know I am a bit weird, but when believe it or not, when a user enters a new row I want to insert that row in the database. And even weirder, when a user changes a row in my datagridview I want to update (imagine that) the database.
View 1 RepliesHow do I prevent users from a inserting a duplicate value using SQL Query
datatype is VarChar(50)
e.g. the name field has already been defined as "Josh", I don't want it to be able to add another "Josh"
Ok so I have designed a program to figure out commissions for phone sales at my company. Since the devices we sell and their associated prices change over time, I had to make that data within my program dynamic. I have a form within my program (frmprice) that has 160 textboxes - 80 for the devices and 80 for the associated prices. Now I hard coded the .text members with default values for our current stock of phones and prices.
I also added code so whenever that form with the phones and prices (frmprice) closes it saves any changes that have been made to either the phones or prices and when the form loads it overwrites the default data with any data that the user had entered at last run.
HERE is my logic problem. At the very first run the program is overwriting the default hard coded values with "" because no user data has ever been entered before. So when the form with the prices loads, it passes the user entered data from last run which is null because it has never run before. If I test to see if default value <> the user entered data before it executes the code to pass the user entered values it will always test to be true because the user entered data is null at first run. If I test to see if the default value is = to the user data it will always at first run test to be false because there is no user data yet.
HOWEVER once the user entered data is initialized (anytime after the first run) I need the program to pass the user data from the previous runs back in. Just NOT at the first run. Here is the code i am using: (in the code below the variables ending in "val" are the ones that are of the type string and are saved in the application settings) The frmprice_Load Event:
[Code]....
I created a usercontrol which has a Textbox and a Label. Setting the (boolean) textvalidity property we can toggle the icons on the label to show if the user has entered a valid input.
Sub New()
' This call is required by the Windows Form Designer.
InitializeComponent()
[Code]......
The problem is... when the control is used... the constructor initializes it to true (According to my code) so the icon is already displayed.
I've got a (hopefully) quick question. I've got textboxes attached to a binding source on one of my forms, and when I add, then clear, the data for the next entry to be added a small problem arises. If the user has previously entered something into, for example, Textbox3 and the user does not have the data for Textbox3 the user cannot move to the next field unless something is entered into the box.
[Code]...
Does anyone know of a good way to have a user enter an amount of time (hours and minutes) using winforms controls? At the moment I have two numeric up downs, one for time and one for minutes that I then parse to create a timespan. The only other idea I have is a text box that a user can enter a "00:00" time in, and validate the input. Both of these ways seem a bit bad (in UI terms) though.
View 5 RepliesWhen I run this application the 2% menu item works fine but the 5% does not. It does nothing at all. I'm stuck.
[Code]...
I am trying to show message when user didn't enter any data in datagrid and click on save button it should display message please enter the required fields but I am using this code for this purpose.
For Each cell As DataGridViewCell In DataGridView1.Rows(DataGridView1.RowCount - 1).Cells
If cell.Value Is Nothing OrElse cell.Value.ToString = String.Empty Then
MessageBox.Show("Please Enter the Required Field(s)!", "ITPCHR", MessageBoxButtons.OK, MessageBoxIcon.Stop)
Exit Sub
[Code] .....
When I click on save button without entering data it give me message please enter the required fields but when I enter the data in datagrid it didn't save data and gives same message please enter the required fields.
I'm trying to create an app to launch at start up that will ask you what applications you want launching, or if you want all your favorite app's to start up etc. But before I go any further, I think its crucial to know how to save settings that a user has entered (such as program location and name in this case) so that he/she doesn't have to enter them every time at start up.
So far I have just made this, can anyone tell me how I would get it to save the settings entered?
Code:
Option Explicit On
Module Module1
Dim name As String
[Code]......
I have a question in relation to formatting text fro 24-hour time.
The format I require is always as follows 00:00
How can I make the ":" appear as soon as the second digit is entered as this is required to separate hours from minutes and also how can I force a 0 to appear for any numbers up to and including 9?
Examples being: 00, 01, 02, 03, 04, 05, 06, 07, 08, 09.
These zeros are required but may be forgotten by the user entering them into the textbox?