I have a datagridview that is filled by a query in the dataabse via the DataSource property.What I want to retrieve some infomation from the record that a user selects in the DataGridView. How do I do that? i've been looking for some time now but I can;t figure it out.
View 6 RepliesI'm trying to assign a number from a row the user selects in a DataGridView to a textbox. On the dgvProducts_CellContentClick event I wish to take whats in column(6) to a textbox.
[Code]...
I hav a web service which pull records from a database and I am hosting these services in IIS which works fine but I am trying to retrieve the record and display the record in a listbox displaying the time field as the text for that record.I have created the following function
public sub get_data()
dim dt as new data.dataTable
dim service as ws webservice.webservice
[code]...
Imports System.Data.SqlClient
Imports System
Imports System.Data
[Code].....
In my form I have a text box (txtJobNo) , a Find button and a dtagridview to display the record for a unique JobNumber. Everything works fine to retrieve data, my problem is the display part in the datagrid view, it replaced the first record. I want to keep all records in place until I am done and then insert all those records in a new table. Please HELP. Please find my code below:
Imports System.Data.SqlClient
Imports System
Imports System.Data
Imports System.Collections
Imports System.Windows.Forms
[Code]...
Im on project about database and I actually im facing 2 major problems.#1I made a form where the user can create a new record.Actually a new product like :
Public Class newgame'Dim cmd As OleDb.OleDbCommand = New OleDb.OleDbCommand("INSERT INTO clients(name,surname,address,phone home,mobile phone,e-mail,memo) VALUES (' " + TextBox1.Text + " ' , ' " + TextBox2.Text + " ',' " + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "','" +
[CODE]...........................
I use vb.net express 2010. I have tried to find a way to add an EULA to my project but have not found it (nor any solutions online).
does express have the ability to add an EULA?also is there a way to get the setup file to move the database into a particular area OR have it make a new database where the user selects?
I am creating the items in a combobox in my code behind. I am setting the display member and the value member. When the user makes a selection from the combo box, I need to get the value of the selected item. I have written some code, but when I step through it, it says that the selectedvalue is Nothing.
Here is the code where I am creating the items in the combo box:
Do While drReader.Read
cboTheater.Items.Add(drReader("TheaterDesc"))
cboTheater.ValueMember = CStr(drReader("TheaterID"))
cboTheater.DisplayMember = CStr(drReader("TheaterDesc"))
Loop
In the selected index change event for the combo box, I am doing the following:
Dim strTheater As String
strTheater = CStr(cboTheater.SelectedValue)
When I step thru the code, strTheater is Nothing
I have a form on which the user selects a file using an openFileDialog. The selected filepath is then processed, which may take 10-20 seconds before the user is presented with the results.I'm finding that the once the user selects the file (clicking the OK button on the openFileDialog), the openFileDialog remains open until all of the processing going on in the background is completed. Once the processing has finished the openFileDialog disappears and the results are shown.The problem is that whilst the openFileDialog remains open on screen, it is not apparent to the user that anything is happening in the background. I do actually have a textbox which updates the user with messages showing the progress. However the openFileDialog hides the messages until it closes, essentially making the progress messages useless.What I'm trying to do is have the openFileDialog close immediately that the user selects a file. Then the processing can continue without the openFileDialog obscuring my form.
View 5 RepliesHow would you be able to Capture the Value of a Cell when the User Selects a Row?
View 7 Repliesi have created a comboBox and want to set it so when a user selects option1 from the drop down list. a Text box populates with text for the user to see.
View 5 RepliesI am not sure what the heck I am doing wrong. I would like if when the user selects no, then the app setting is nothing. By nothing I mean nothing, I am using "Nothing" to test but its not working it returns whatever is in the richtextbox
This is in my formclosing event
Dim msg As String = "Do you want to save your comments?"
MessageBox.Show(msg, "Save", MessageBoxButtons.YesNo, MessageBoxIcon.Question)
If DialogResult = Windows.Forms.DialogResult.Yes Then
[CODE]...
How do I make it so that after the user selects a program it gets executed?Also can I the the OpenFileDialog1 to anything else?
View 13 RepliesIn my datagridview, I want to be able to change the value of comboBox1 depending on what the user selects in comboBox2
I had this working correctly, however if I move onto a new line in my gridview and select a different value in the second row it changes the previous row also. For instance, on Row1, if comboBox1 = A, combox2 = B
Then on Row2, if comBox1 = Y, comboBox2 = Z
However, when I change Row1, Row2 is also changed to reflect what was chosen in Row1. Is there a way I can tailor it to each specific row?
i am trying to design and code a simple help desk program. i would like it to send the details that the user selects and types from the form i have designed (see picture) and also to send the username, computer name, servername and a copy of the windows event log for the previous 15 minutes, to a designated email address in pretend I.T. department.
View 4 RepliesI have a form with a drop down combo box and a list view. The user selects a date from the combo box and then they are to select an item from the list view. I want to ensure that the user has selected a date from the combo box before processing the information from the selection in the list view.
If cboYEARMONTH.SelectedItem = Nothing Then MessageBox.Show("Please Select a Year Month")
I have 2 combo boxes. One is in a form called subcat_selector.vb
on the button Pick Sub Catagory.click event it shows the subcat_selector form. form there, the onload event:
Dim button As DialogResult
[Code].....
I have a combo box and use the SelectedIndexChanged event. I noticed when I assign a value to the combo box that this event fires even though the user does not click on the control. Can you tell me how to test for when the user clicks on it and actually selects a value from it?
View 19 RepliesI am populating text boxes when a user selects a company name from the cbo box. When I make the first selection everything looks good, but when i make another selection the text boxes do not clear and repopulate with the new values. Here is the code in the selected index change event.
[Code]...
I have a field called "payor" where the user selectes either "All, Medicare, Managed care" from a drop down list. I am sending the value of payor to the Fill query once the user selects the one they want.
I have no problem with coding 'Where (payor = @payor) if the user doesn't pick ALL, but what code do I need to include ALL records if the user selects "ALL" in the where statement?
I am working on cinema booking system project in vb.net..I have to book seats in the cinema..I have created a file for seat reservation for every movie..The seating is such that there are 18 seats and in the file have written 0s and 1s indicating reserved and vacant seats respectively..User selects a movie from a combobox and the corresponding file opens..We have to change the color of those seats which are already booked to red.Here is my code but it doesnt work..
Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles movies.SelectedIndexChanged Dim Seat As Button() = New Button() {Form4.Button1, Form4.Button2, Form4.Button3, Form4.Button4, Form4.Button5, Form4.Button6, Form4.Button7, Form4.Button8, Form4.Button9, Form4.Button10, Form4.Button11, Form4.Button12, Form4.Button13, Form4.Button14, Form4.Button15, Form4.Button16, Form4.Button17, Form4.Button18}
[Code]...
I am using a Message box with buttons Yes/No. If the user selects a quantity of Dogs a Messagebox is displayed asking if all the dogs have been vaccinated. If the user says yes I want them to be able to proceed. If the user selects No I want the number in the combo box to delete and go back to zero.My code for the button selected is this:
Dim button As DialogResult If button = Windows.Forms.DialogResult.Yes Then btnCalculate.Focus()
End If
If button = Windows.Forms.DialogResult.No Then
[Code]...
I have now wasted over two days going round & round in circles with the pathetic excuse for a Help System Microsoft now makes us put up with (& nearly blown my monthly broadband data cap doing so).I have lost count of the links that do not exist.The Give Feedback option also does not work (I do not like Microsoft Outlook, & in spite of having set Windows Mail as the default mail that doesn't work either!).Every VB example I have downloaded has failed to operate as it should (if at all), so surprise, surprise nor does my implementation of what they say is how to do it! please give me the "exec summary" version of what I need, ON ONE PAGE which is: Correct way (& syntax) to (in VB code):
1 Open an existing SQL compact 3.5 database THAT IS WHERE I SPECIFY - NOT WHERE the wizards keep saying it is(it against my instructions)!
2 Search to see if a particular record exists in the database (eg WHERE ColumnName. FieldContents = ContentsImLookingFor)?
3 Retrieve the found record into my own record buffer?
3 Add the record if it does not exist?
4 Change the record?
5 Delete the record?
6 Close the database?
The rest I will do MY WAY, a thousand times faster & more efficiently than anything I've seen "documented" so far. Surely that is not a huge ask requiring GBs of "Help" garbage leading nowhere?I've only been programming for 25 years (but not in this environment),
I have a simple web for that has a dropdown list and a button on the form.The dropdown list is bound to a table in my database and holds three values with idents between 1 and 3 (Weekly,Monthly, Please Select).I have set my datasource to pull back item 3 (Please Select) as the first item in the dropdown list to prompt the user to select an option. Items 1 & 2 have data assigned to them and this pulls back the relevent data for these options.
Here is my problem. I need to hide my button when the page loads until the user selects item 1 or 2 and would like the button to be hidden of option 3 is selected. I have tried to complete this in my page load event and the code for the dropdown list but i cannot seem to get this to work.
If IsNumeric(DropDownList1.SelectedValue) = 3 Then
btnAddAgendaTemplate.Visible = False
End If
I'm trying to create a for loop that will display the values (favorite programming languages) a user selects for a listbox.
So far I have this:
Dim selectedLanguages As String = ""
For intLoopIndex As Integer = 0 To languageListBox.Items.Count - 1
[code]....
So far, no matter how many items they select it will display a comma even if only one item is selected, example "C#,"However this is what I need it to do:
1. If the user selects one programming language than it should just printout the selected course with a period right after it. Example: C#.
2. If the user selects two languages it needs to have the text "and" between them followed by a period. Example: VisualBasic.Net and C#.
3. If the user selects three or more languages it needs to seperate them like this for example (again with a period at the end): VisualBasic.Net, C#, and Asp.net.
I'm in the process of adapting a current program that I've created to automate it. **Current State***User selects an excel file and the contents are loaded into a DataGrid User can select which environment to run their query against (stage/prod) Program completes processing and updates datagrid with new values User can export datagrid to excel What I'd like to do is centralize the program on one computer and have it monitor a network folder for creation of a specific file type (*.xls or *.xlsx). If one of these is created in that folder then I want to add that file to a queue for processing. Once done processing I want to send the results as an attachment to an email to the user that created the file. After a file is processed I would like to remove it from that folder as well (into a diff folder of completed items).
[Code]...
I'm using Microsoft Visual Basic 2008 Express Edition. I have a Folder Dialog Browser added in my form and I call it when the user presses a button. The folder path string is stored in a string variable and displayed as text in a text box. (maybe I should use a combo box)
My question is: If the user inputs by hand a non existent path, how do I return an error message, stop the file creation into the invalid path, and return to my main form?
It's probably the most basic of things, but all I can find is how to launch a program, and not with the interactions I desire. Any tips as to the terms to use to search for answers, or links to topics regarding questions similar to mine, would be very appreciated. I have a wealth of info to read through, but I could use your knowledge to save myself time.Here is what I am trying to do:
Use a Button (A) to Launch a Prompt where User Selects Directory Path to an executable Program. The Selection is to be Persistent after the initial selection (saved in a settings file i assume?), and the Selected Path (or just "programname.exe") is to be Displayed in a Text Field (B). Launch Selected and Indicated Program via a Launch Button (C)
I am making a minor basket system which the user selects a number of products from a datagrid and it adds them to a basket using an array list (arrItemID).However on the ViewBasket form I want another datagrid however a query is formed listing the selected products. Though the datagrid seems to be empty (though the query when outputted to a text box is ideal. [code]
View 3 RepliesIs it possible to read the inbox of any email account whether it is yahoo or gmail or hotmail defined by us just as outlook express does, using Visual Basic 2008?
can I extract only subject of a particular email or only its content or only the attachment or any other information regarding that mail?