This update command works in updating my mysql database. Another database I have doesn't have a idnum field. I'm looking for a command to select a row number in the database. For example, update row #5. How would I modify this command?
SQL = "UPDATE " & table_name & " SET " & _
"title='" & TextBox3.Text & _
"' WHERE idnum =" & TextBox2.Text
i am trying to auto select the email value from a 2nd cbobox when the user selects a name from the first cbobox using the first cbobox's index. (the values all line up with each other just fine)This is my current code:
Private Sub cmbAnalyst_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmbAnalyst.SelectedIndexChanged
theAName = cmbAnalyst.Text
[code].....
I have a txtbox(for barcode).. if i input a item number in that txtbox and if that number will match in your database, the other information(shall we say, product type, item ID, etc..) will display in my other txtboxes..
View 5 Repliesi have a website, and a combobox how can i select value number 3?
View 1 Replieshave a table with following fields
Emp_id varchar(50)
Emp_Name varchar(50)
Emp_surname varchar(50)
[code].....
I have an existing database that I want to add a number to that the user inputs. So lets say that in the database there is 4 carrots, and the user on the addinventoryform inputs 3 carrots and pushes a button. Now I want that number to be added to the database number so in the database there would now be seven carrots. I am using an oledb connection and cannot figure this out.
View 1 Repliestrying to calculate the partitions for 8 portions, and putting in select statement for row number,something like,
If Not (dstotal.Tables(0).Rows(0)("totalrecord") = 0) Then
dPartition = CInt(dstotal.Tables(0).Rows(0)("totalrecord")) / 8
End If
[code]....
I have not worked with VB in so long that I might as well be a newb.I know this can be done, and if I remember correctly, it is fairly simple, but for the life of me, I can't remember how.I have a textbox that will be used for entering a number.I have a combobox with a list of precreated options.I need to create the combobox as many times as the number entered in the textbox. Essentially I'm creating a list of items, the number of which is determined by the textbox value, the values of which will be chosen from the comboboxes. This means that the comboboxes all need to be linked as a group with sequential numbering.
View 1 Replieshow would you select a row in a datagridview if the number of rows = 1
View 6 RepliesI have 25 labels (Label1 - Label25). How can i randomly make the background of 1 label blue?I can set a random number in a variable, but I can't find out what to do next. It has to be something like this:[code]
View 1 RepliesI have a table which contains a list of products for a company. They input data about how much stock they have and also the level at which they want to be reminded that they need to order new stock.
[Code]...
I want to list all the true results in a form which the user is then able to navigate through. What would be the best way to go about doing this?
If I have say 5 numbers: 1, 29, 53, 95, 103 What would be the VB.net code for randomly selecting a number of those 5.
i.e) The random number has to be 1, 29, 53, 95, or 103 and has to be randomly generated.
I've tried using the Int(Rnd() * 104), but I do not know how to make it choose only these 5 numbers!
I am a bonehead for even attempting to write script. that's why I do as little of it as possible however I starting to figure out the vb doesn't know what i am thinking. so here is my code and my problem. I made an update form for a data set in my program My Main Data Gridd View is on Form1.vb and the update form is called EditLoad.vb. the data set is called I_FactorDataSet. When I select a loadID number and edit it in the EditLoad.vb form i click save and get an error of InvalidOperationException" "Update requires a valid update comand when passed DataRow collection collection with modified rows"
[Code]...
I have a question about Select Case. My code (psuedocode) is this
[Select Case name
Case number
name=Remove(num, 1, " ") ]
What this needs to do is to remove spaces at the end of a number and lets say that the number would look like this "C12345" but what I want is for the number to look like this "12345". I have it as a hyperlike but for some reason when at the link in the code it had added some spaces at the end of the number and I do not know why. What I want to have happen is when the hyperlink is click that it will go right to that number but it does not. When you click it you have to go to the top of the page (where the http is at) to to the end of the link and back space. Once you have done that it will go to the page that you want.
I am creating an application in Visual Basic '08 with four available checkboxes. Is it possible to limit the number of checkboxes you may select down to 2, and how may I go about doing this?
View 12 RepliesI would like to select a number of rows from a table and out of those I need away of selecting a column from the last row?
View 8 Repliesi need to check whether a demical is 0 through 49.99 or 50 through 99.99 or 100 through 199.99 or greater than 200. i am trying to do this with select case, but i am not sure of the syntax.
View 7 RepliesIm making a text based game that i need to randomly select different numbers of lines from a text file then pass them to a list box.[code]...
First the code needes to identify the 4th element then randomly select lines from lines that contain that element. The code needs to work out how many lines have a matching text to the 4th array then randomly select lines from that total no need for a maximum limit to that number.The same line must only been show the once at a time, but It can then be shown again on a different button click.[code]...
I am making a window based application in vb.net. Now i have work in two sql databases, so i when the window opens it will show two databases..when i select first db then i can work in that particular db only..if select 2nd db then i can work in second db only..how to do that?
View 1 RepliesIs it possible to control the height/number of items shown in a select dropdown box? Or do I need to code a custom widget? Is this possible?
Forgot to mention I'm using the following code:
<asp:DropDownList runat="server" Width="288px" CssClass="Select"></asp:DropDownList>
I'm trying to figure a way to select multiple files from a folder and rename them and also add a sequential number to the end.Example: Take img_001.jpg, img_002.jpg and rename them to picture1.jpg, picture2.jpg and so on. There is a maximum of 50 files in each folder..
View 4 RepliesHi, i want to click a button and it will select the number 2 item in a listbox?I have this but it does not work :/
ListBox2.SelectedItem = 2
EDIT: nvm, i found it
ListBox2.SetSelected(2, True)
I am currently writing a VB .NET application where I am trying to open 1 database, create a select statement and then post the results into another database file using Microsoft Access database 2003.
The code seems to stop executing at the statement cmdJetDB.ExecuteNonQuery()
I am using the following code:
Dim conn1 As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data source=C:Sample.mdb")
Dim conn2 As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data source=C:db2.mdb")
conn1.Open()
conn2.Open()
[Code]...
Question: What is it that I am not doing. I opened both connections, stated my two SQL statements, yet it is still not working. I really need to get this application working. Please Help.........
Create an application that allows the user to select or enter into a combo box the number of days a person will work, and calculates the total amount of pay she will receive over that period of time. Salary is one penny the first day, two pennies the second day, four pennies the third say, and continuing to double each day.
The combo box must list the following items: 30, 180, 365, and 1000. Must be the default drop down box. Use a validating event procedure on the combo box.
The program should go through a loop once for each day, doubling the number of pennies with each iteration of the loop. You will need a running totl of the number of pennies that you add to with each iteration. To calculate the total amount of pay, multiply the total number of pennies by .01 and show the result in currency format.
Public Class Form1
Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged
[CODE]...
how can i return the number of records processed from an sql procedure whether it is a select or update/insert query and how can i receive it in the calling method in vb .net.
View 4 RepliesI am new to VB and trying my hand at the below code. I am trying to determine the number of records for each possible combination. Depending on the outcome of the number of records groups may be combined. I am not able to find the record count for each grouping. Can you please look at the code below and suggest what I am doing wrong?
[Code]...
I have 2 Database in my VB.net application. I am using 1st database for daily operations. I would like to send one of the table records to online database. How Can I do that? First database is MSSQL Online database is MYSQL. I have created connections already using MYSQL .net connector.
View 2 Repliesi want a button to perform a function of checking the last digit number in a field of a table in and add a digit to it and display it in a textbox.
View 1 RepliesI am using Combobox, when i select the value in combobox, the date value should display in datetimepicker where date = combobox id
vb6 code
cmd.CommandText = "select distinct Name from T_Person where personid = '" & txtno & "'"
Set rs = cmd.Execute
[code].....
So how would I use .next (random numbers) to randomly select something from a list of numbers but it can't repeat the number?I could do:
dim num as integer
dim r as new random
num = r.next(1,5)
if num = 1 then
elseif num = 2 then
etc.
That wouldn't work because it would repeat.If I donwload someone's game can I disect it in VS? :0 I tried going to open project, then I went to the folder and clicked open. It brought me inside of the folder so I tried to open the game but there is no form1 there. It says the games name then .exe in the explorer-like thing in the top right?Also, how would I have a value or something in a label and access it from a button.
Example:This is in a label.
Dim number as Integer
number = 0
Then in the button do
Label.number = 0
How would I do something like that? I want to use that a lot as I did in a different language.