Forms :: User To Be Able To Select Any Number Of Those Checkboxes/rows And Then Return A Value To The Table "stamping" That Users ID?
Jan 8, 2010
I'm working on a project and my boss insists I use a DataGrid for this. The grid holds information for work orders, one of the cols has a check box in it. I need the user to be able to select any number of those checkboxes/rows and then return a value to the table "stamping" that users ID. This is what I have so far to get the grids populated... I'm using 2005 with a 2000 Access Database if that helps. Though this will be changed to SQL Server once we get it working (yay more work)...
[code]...
I removed the code from the second grid to make it easier to read, obviously once I can get one to work the second shouldn't be as much trouble.
This is the check box: dgvNewBiz.Columns(1).HeaderText = "Select"At this point if someone knows how to get it to recognize the click event of the check box and pass that row info to a variable that would be super as I'm sure I could probably figure it out from there.
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?
I have the following code that loads an XML file into a datatable (I went this route because I do not know how to query XML directly). I want to use the Select method to return a row where "age = 72". However, I can't seem to get this to work. Also, if there is a better way to search through a datatable for specifc values that would not require iterating through the whole table to get the results
How to restrict user to select not more than 10 asp.net checkboxes on button click event , if user select more than 10 checkboxes then alert box will pop up that you can not select more than 10 checkboxes
I have an application where event driven events are already detected. Each time an even is detected I increment a counter.I would like to add the following functionality:
1.) I would like to create a time stamp each time an event is detected and store them in some kind of data structure.
2.) I would like to count how many events are being stored (or in essence count how many events have occurred in the past 10 seconds, not once but continuously).
3.) I would then like to discard of any events older than 10 seconds note events are interrupt driven and can occur more frequently than once a second, but updating my count of how many events have occurred in the past 10 seconds can be done as infrequently as say once a second.
I have a vb application sitting on sql 2005 database i want a scenario where the application can check the number of records inserted into a particular table(Users) , if the number of records inserted into that table after 1wk since the last insert is less than 100 records it should pop up a warning alert with the total number of records
I am trying to make a form that can be used to allow users select file(s) from one control and drag them to another. I am stuck. I have done a bunch of research and now have a form that allows the user to select a directory and display the files in a listbox. It works intermittently. The select directory window works when I click the Browse button and it reports that it found a number of files. But they are not in the listbox. When I walk thought the code in DeBug the files are listed.
I would like to know how to filter out system tables and only return user tables .when i run the code it displays lists of system tables with user tables list in combobox.I have just gotten into vb.net and have tried few ways to do this but dont understand well enough.
I'm writing a program for Employees Management and i need to automatically generate a Payroll for each one then calculate some things and save it to another table.
I know how to calculate and save. I just need to get all the ID column of all rows in my Employees table, and select each Employee ID one by one in order to calculate each payroll automatically.
For a project i am working on, i am taking bookings. These bookings are stored in a database alongside a users personal details. The personal details are assigned an ID according to the user who booked it. A user can book more than once with different personal details.
My problem is that i want a user to be able to edit a booking. I want a list of all the names that user booked to be listed in a combo box. This is the part i am having trouble with. i am using an access database and using sql statements to pull out the data. This is what i have tried so far:
SELECT [First Name] FROM PersonalDetails GROUP BY [First Name], UserID HAVING (UserID = ?)
If i execute this query in the query editor, it works and shows the two records currently assigned the input id. However, if i try to output this to, for example, a text box, then it remains blank. I am assuming thisis because there is more than one output, but i'm not sure.
I keep getting an error saying "there is an error in your sql syntax." when i use this sql statement:SELECT * FROM gsm_oceanwide_integrationEDIT:To put this in context heres the code im using this query statement in (VB.net):
Dim con As MySqlConnection = New MySqlConnection("Data Source=" & frmLogin.txtserver.Text & ";Database=stratocast;User ID=" & frmLogin.txtusername.Text & ";Password=" & frmLogin.txtpassword.Text & ";")
i have a problem to retreive whole rows of a datagridview and transfer to my new access database in vb environment anyone can give me advice or examples of how to do it ? for example my datagridview colums have JOB_NO, ERR_DESC , REMARK
now i would to post all row (not selected datagridrow) from this datagridview to my new database .. i search at google using row count may do the job but i still fail on ...
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.
Any method that can effectively get the total number of rows that is StartRows to EndRows in a database table and then get the corresponding data from that row as currently I am having difficulty in retrieving out the correct row of data to the column that I am comparing. It will always get the first row of data regardless of which row I put in the handphone number which I'm comparing to. The codes below is the one which I am currently using now to detect the maxrows in the database and also to retrieve the corresponding information.
MaxRows = ds2.Tables("CustDetail").Rows.Count MaxRows = MaxRows - 1 Dim numbers() As Integer Dim EndAt As Integer inc = 0 [Code] .....
I used a msgbox(n) to see the number of rows in the database but it displays only one where I have two rows in my database. The for loop is the one which will detect the number of maxrows and also retrieve out the corresponding details. But apparently this is not the appropriate way.
I have this application which has one class. I need to return a recordset of data to the calling form. If i use Properties to return, it can only return only a single value at a time. Right now i'm returning a datareader object with one of the properties.Can anyone suggest a better way to return multiple rows of data to the calling method via Class Property?
I want the user only to be able to select rows and not individual cells in a VB.NET DataGridView. Is there a way to make this happen? I don't see an option for the DataGridView object to control this via properties.
I am attempting to fill a form with multiple rows from an access table based off of a parameterized query. My query works fine but I don't want to return one row at a time, I want to return all rows that match my query in multiple text boxes. I know that I can use a datagrid view to accomplish this, but I would prefer the look of a textboxes on a form. I have read through many books and searched the internet forums but think I may just not know what to search for as nothing has worked yet. Can anyone point me in the right direction. So far I have tried setting the text box value to the row().item(), creating a different dataset for each row, and even setting variables for the results of the query to then be passed to the text boxes. Since none of this work, I don't really have any starting code to post. If I could just get a starting point I could work from there, so don't feel the need to code anything for me, just set me in the right direction.
I'm currently working on an application that allows users to select picture files and then categorize them into folders. Now I'm having two issues that are probably simple to fix but I only have a year of experience with vb so I just don't know how to fix them. The first and biggest issue is that once the user has selected and categorized a file, I want the program to select the next file in the folder that the first file was moved from. This way the number of clicks required is minimized. However I have no clue what I would need to do in order to accomplish this. Also, my other problem is that I want to be able to find the indexof a quotation mark but whenever I put it in the parameter it just reads it as a quote.
Im new to .Net and I wondering if you have to re-create a table server control on every postback. I'm having a problem when a user clicks a button which adds a row to the table. It works fine up to about 50 rows being added then the page is extremely slow. [code]
I've got a code using SQLClient that loops though all users in a Users table inside each loop i want to preform another search in the UserOrders table, thus doing a count of all orders.
I get this error
HTML
There is already an open DataReader associated with this Command which must be closed first.
Here is my code
vb.net UserLists.Items.Clear() Dim connection As New SqlClient.SqlConnection(My.Settings.ConnectString) Dim command As New SqlClient.SqlCommand("SELECT * FROM Users ORDER BY PersonName",
is there any way to let user to set the shrtcut ?look like "shortcut key" in properties of the shortcut file i know about keypress and keydown or keyup but how to use them to auto detect the key and set it?example ctrl+h . when it happen one by one i can get keycode or keychar but if they press by user in one time and hold it together i cant read it by kecode or keypress.
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
I have this MySQL Query glitch in my VB.NET program. Here is the query in VB.NET: "SELECT Points FROM user WHERE Username = '" & UsernameText.Text & "';" It will select the points column from the user table from the Username they entered. When I deploy this it will set the value for points to 0 on their account. I'm not even inserting anything in.
I need to code a basic multiplication table in VB. I need a popup input box to ask the user to enter a number, then a label to display the multiplication table for that number from 1 to 9.
