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.
View 1 Replies
ADVERTISEMENT
Dec 7, 2010
I 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 Replies
Jun 2, 2012
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 Replies
Jul 27, 2010
when populating a data grid i keep getting a redundant row in the bottom. is there a way to lock grid rows to the number of rows in the data table?
View 1 Replies
Mar 17, 2012
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
Imports System.Xml
Module Module1
Sub Main()
[Code]....
View 1 Replies
Aug 9, 2010
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
View 7 Replies
Nov 22, 2011
I'm having the datatable with three columns, i need to return the rows in which the third column having the null values.
ie., I need to do like this below mentioned coding,
Dim rows As DataRow() = ds.Tables("Tablename").Select("col3 is null")
Is it possible? if no, anyone tell me the way to get the results.
View 1 Replies
May 9, 2010
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.
View 4 Replies
Apr 12, 2011
how would you select a row in a datagridview if the number of rows = 1
View 6 Replies
Feb 6, 2012
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
View 3 Replies
Sep 17, 2009
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.
View 2 Replies
Oct 12, 2011
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.
[Code]....
View 2 Replies
Nov 2, 2011
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.
View 2 Replies
Apr 22, 2010
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.
View 7 Replies
May 23, 2010
I wanted to let the users to select their desired wallpapers dynamically in the window main form. Is it possible? Funtional spec:
1. Let the users to select their desired wallpapers from any directory.
2. Save the wallpaper in the database.
3. Load the wallpaper in the main form after login sucessful.
View 1 Replies
Mar 30, 2011
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 & ";")
[code]......
View 2 Replies
Jan 18, 2011
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 ...
View 5 Replies
Nov 25, 2009
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 Replies
Aug 23, 2009
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.
View 3 Replies
Jan 28, 2009
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?
View 1 Replies
Jul 1, 2011
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.
View 2 Replies
Jun 7, 2012
I am using PostgreSQL database with VB.net through ODBC what goes OK. Sample code:
[Code]...
View 1 Replies
Feb 27, 2011
visual basic 2008 express
access 2007 db
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.
View 3 Replies
Jul 9, 2009
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.
View 4 Replies
Aug 1, 2011
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]
View 1 Replies
Dec 29, 2010
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",
[CODE]...
View 3 Replies
Feb 12, 2006
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.
View 1 Replies
Oct 28, 2009
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]...
View 14 Replies
Jun 27, 2012
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.
View 5 Replies
Mar 21, 2010
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.
[Code]...
View 5 Replies
