I,ve been workin with vb application forms connected with ms access database i used ms access 2003 for my database with connection string
[code]...
was trying seach for a variable in my database. what codes can i use for my search. I'm currently using vb 2010
I am making a bot for a game, i want it to hit F5 every three seconds and at the same time search for a certian image and if it finds that image click it. Then carry on hitting F5 etc...
View 4 RepliesI am making a bot for a game, i want it to hit F5 every three seconds and at the same time search for a certian image and if it finds that image click it
View 1 RepliesIam using this method to seach in xml file but it returns search by first word for example i have a name [url] and i write in seach box word "forum" then it will not return any result but if i write "vb" then it will return the result how to solve this problem code is here
Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click
Dim b As Integer
If TextBox10.Text <> "" And ComboBox1.Text <> "SELECT" Then
Call sorting()
[CODE]..........................
I am trying to write a fairly basic program that uses a database of English words and their German equivalentsto be a sort of quiz. In the database i have three collums, ID, English and German. I want to use a random number to select the word, show the english word and then ask for the german - it is then checked against the database value to see if it has been done correctly.
View 5 RepliesI'm a little brain dead at the moment and was wondering if someone could help me out with some code.I am pretty new to using databases in vb and what I want to do is to match a variable with a value in a database field and when it finds it, it will store the row count into another variable. I know I have to use a counting loop, I'm not sure how to compare the variable to the value in the database.[code]
View 3 Repliesi have information.mdb database. i have bind it to the datagrid view in vb.net. now i want to update the database using a button. for e.g. when user click 'save' button, the text on 'textbox1' will be the data to be insert into the 'textboxvalue' row in my information.mdb database. 'textboxvalue' row is in 'table1' table.
Can i do like this ? this code belong to save button click event.
stitle = Me.TextBox1.Text
Dim con As OleDbConnection = New OleDbConnection
[code].....
how to pass value from database to a variable.
This is my query:
Dim it As String = "Mouse"
Dim itNo As String
SELECT * FROM tblITEquipmentName WHERE equipmentName LIKE '" & it & "%'"
I would like to get the ItEquipmentNo and pass it to variable itNo
i am trying to create a table in a access 2007 database with the name stored in a variable wich the user inputs. For example, if the username entered by someone is "John", i want to create a table in the database also named "John". I have tryed this:
Dim mypath = Application.StartupPath & "\mydb.mdb"
Dim mypassword = ""
Di Cmd As OleDbCommand
[code].....
I am using Forms Based Authentication I have extended the Forms Authentication Tables creating a custom table called Profile_Contact that holds the user's GUID, username, email address, and other information. I have another table called Profile_Account which holds company account information such as Company Name, address info, phone numbers etc. This table has a Key Field called IDProfileAccount.
[Code]...
I have a question about storing formulas on a database and bringing them back in as a string. I want to have the user enter in a width and that number will be passed to intWidth. Lets say a user enters 8 into txtWidth, strRange will = "Less Than 10" and in the database I will have a Width_Range column with "Less Than 10" and a corresponding Equation column to go with it. If I have a formula such as (1800 * 1.8) saved in that database column, the code I have works and does the calculation.
[Code]...
Dim
sqlquary2 = "GET Status from Members
WHERE Username='" & UsernameTextBox.Text &
"';"
[Code]....
I simply wont to read one field in a databasetable into a variable.[code]....
View 6 RepliesThis is probably so simple however my brain has decided it wants a night off. I am trying to write a program that uses SQL queries for various tasks but I need it to allow the user to be able to use which ever name they want for the database name. therefore I need to be able to reference the database as a string variable. For Eg:
[Code]...
I am trying to write the value of 3 variables (Username, Email, Password) to an SQLite Database. I can write text to the database but not a variable. How would I do this?
My Code:
SQCommand.CommandText = "INSERT INTO login_data (username, password, email) VALUES (Username, Password, Email)"
I just started using VS2010. I am very familiar with Visual Basic 6 and was very comfortable with it.I was able to take a variable and assign a database field to iwithout using data binding. I can't seem to figure out how to do thatin VS2010 What I am trying to do is have the use enter a password to gain access to the program. The password is stored in a database so that the user/owner can change this password to suit their preference.
View 1 RepliesI am trying to retrieve a password from an SQLite database. The id of the row the password is in is 1. I want to assignt his password to a variable called actualpass.[code]
View 1 RepliesI am getting the error:"Range variable 'sender' hides a variable in an enclosing block or a range variable previously defined in the query expression."for this
Imports System.Data.SqlClient
Imports System.Linq
Public Class Form1
[code]....
I can select any other item from the table without the error. "sender" has the same properties as "receiver" in the SQL table.
A stored procedure returns data about a user record including a nullable datetime column for their last login date. Which one is the better choice in dealing with the possibility for NULL values when trying to assign a .Net date variable?
Try
_LastLogin = CDate(DT.Rows(0)("LastLogin"))
Catch ex As InvalidCastException
[Code]....
Which is the preferred method of handling possible NULL values from the database? Is there a better way than the three listed?
Edit #2: I have noticed that the TryParse method does not play nice when trying to assign to a Nullable type.
i am trying to write a program which reads a data from the database and perform some calculations. what i am intending to do is when a user selects an item from a listbox and clicks the submit button the program, calls a function to calculate using the value stored in the database and display the result in a textbox.the problem is i cant store the data retrieved from the database into a variable so that the calculations can be done. i am using vb and microsoft sql server.can anyone tell me how do i store the data retrieved by the query into a variable.
View 12 RepliesHow can i declare a simple variable in a form that is the count of the amount of times a field appears in a database.Basically i want to count the amount of times the word "Saloon" appears in a column in my database (access 2007) and then assign that value to a variable.
View 22 RepliesI have a little problem regarding the use of DBNull, NULL etc. in VB.net in combination with SQL Server 2k.
More specifically, I want to do something along the lines of this:If x = 0 Then
x = DBNull.Value where x is declared by Dim x as Object. I would rather use Double, but I can't assign DBNull.Value to this, and using Object works quite well, too. But every time I hit this condition, I get an exception: A first chance exception of type 'System.InvalidCastException' occurred in Microsoft.VisualBasic.dll This is not a major show-stopper, since the database value I write x to in the next step, is NULL by default - most of the time! So I need the ability to write NULL to it. If that was not the case, I would have been able to work around this by catching exceptions, I think - but sadly, this isn't really of use then.
I receive the error -
[Code]...
As you can see below in the code the " & tblName & " will work fine but instead of using the BankName (which the user cannot change because it is in the code) I would like to do the same as I did with the Table name and use a variable that gets its name from an excel spreadsheet rather that an actual name hard coded in a VBA module. I would like the variable field name entered in the Excel Spreadsheet by the user just like the table name is filled in by the user. The problem is getting the ADO SQL string ( cmd.CommandText = "ALTER TABLE " & tblName & " Add Column BankName Char(25)" ) to recognize that the value in the Variable " & fldName & " is the field name to be used.
Sub AddFieldToAccess()
Dim cnn As ADODB.Connection
Dim cmd As ADODB.Command
[code]....
'If I do this I end up with a field named BankName what I need is the name in the variable " & fldName & "
cmd.CommandText = "ALTER TABLE " & tblName & " Add Column BankName Char(25)"
cmd.Execute , , adCmdText
Set cmd = Nothing
[code]....
Public Class Form1
Dim x, c, number(0 To 19) As Integer
Dim s As Integer
[CODE]...
The variables in the brackets [example] do not actually have brackets in them in the original code. These are where the issues are. For both variables, it says, "The type for variable [variable] will not be inferred because it is bound to a field in an enclosing scope. Either change the name of [variable], or use the fully qualified name (for example, 'Me.[variable]' or 'MyBase.[variable]')." Now, I'm not entirely sure if this is a stupid question or not, as I'm used to VB '98 because that's what we use in my programming class at High School. let me know why this won't work.
-Note: The intention of this program is to continually loop the generation of numbers for this list until I tell it to stop. Button1 ends the program, Button2 generates the list one time only, Button3 is supposed to loop the generation of the list, and Button4 is supposed to end the loop, but not the program.
Say that i have the following code that parse about 20k records from the DB.
Code #1
vb.net While reader.Read()
list.Add(If(Integer.TryParse(reader(0).ToString, 0), Integer.Parse(reader(0).ToString), 0))
End While
And then another code which does the very same thing but it seems to be a little cleaner.
Code #2
vb.net While reader.Read()
Dim storeowner As Integer = 0
Integer.TryParse(reader(0).ToString, storeowner)
list.Add(storeowner)
End While
This is what i am confused about; does the compiler creates a new variable automatically when i use the if statement without strictly declared variable? What approach is better in sense of performance?
I am looking for a good resource on variable naming conventions to illustrate variable type and where variables are declared. So I will have public variables, Private variables, private or local variables. I also may want to declare variables with the same name in different class code (i.e. in the code behind different forms). I am assuming good coding would dicatate a prefix for declaration location.
View 4 Repliesi have this error in the line of with xl.active......Object variable or With block variable not set.
Dim xl As Object
xl = CreateObject("Excel.Application")
With xl.ActiveSheet.QueryTables.Add(Connection:= _
"TEXT;C:Documents and SettingsUserDesktop429MEDICA2.TXT", _ Destination:=xl.Range("$A$1"))
[code]....
Now I have the need to get a current value from a bindingsource in a property of a user control.In a previous thread I had tracked down the "Object variable or With block variable not set" to the return in the Get block of a property. At the time I was only using the Set so I just commented out the offending code until I needed it.
[Code]...
The error does not occur during a system compile, only upon saving the container object of the user control. As I said the Set works correctly, only the Get causes the error.I would like to know what I am missing/misunderstanding and am open to other suggestions of handling retrieving the current value of a bindingsource in a user control.
Using Visual Basic 2008 Express. I need to pass a variable to another form. Or else make the variable visible to both forms.
View 4 Replies