when the user clicks on the add button another form launches, which enables the user to add student info such as name, address, course, start date and end date, this information is then written to class when the ok button on that form is clicked, and then displays the data on the initial form in data grid. the user can add multiple entries and they are all displayed on the intial form and a the data grid is populatedwhen any of the rows in the displayed grid is selected, and the update button is clicked then the same form launches as the previous one and but this time its in the update mode and pre populates the form with the inital values.
I'm somewhat of a novice at VB.I have a DataGrid that I am manually populating from a SQL query-based dataset (see code below). Question: How do a capture the value of a specific column of the selected row (mouse click in the row) to use as a variable in other parts of the overall solution?Also, how do I add cell padding around the contents of the data grid cells?
I just want to display data in a DataGridView (from SQL - already made the connection) based on what is selected in a ComboBox (data that is also coming from SQL). The 2 are separete on the form. I am using VB 2010.
This doesn't work for me: objCommand2.CommandText = "SELECT ProductID, Name, Color, Size, ListPrice FROM SalesLT.Product WHERE ProductCategoryID = " & cbCategory.SelectedValue
i m using these code for selecting data grid row [code]but , when no of row more then grid showing rows then grid not show selected row in grid screen, for showing selected row we have to use scroll bar, my problem is how to show selected row in grid automatically
I am using vb 2008, DataBound Controls and typed dataset. My form is having Group Box (initially hidden) and some text box, combobox controls for Data Entry, and the code is
I have set the combo box to select the 1st record in the list however, when the next Statement that is "gBox.Visible=True" is executed, the Combo Box is again set to -1 position. Why is it?
I am trying to make an address book and need help. I am in the middle of making a search function for the program and I've got that working fine. What I would like to do is take the row that is selected from the search results and make that the selected entry for the main form. To explain what I mean I will include pics..
I have written an application which extracts a list of URL's (currently in Internet Explorer cache) from an XML file and displays them in a data grid view. From here i would like to launch Internet Explorer in a hidden mode and capture an image for each of the selected URL's in the data grid view. Is this possbile? If so what is the best way to go about it?
I've been working with a listview. I just need to know how to get the index of the selectedindex otherwise I can't work anything out, if the application doesn't know what is selected... I tried these codes but none tells me the index, I am just lost with it, thought shouldn't be that hard...
Dim index As Integer Dim item As ListViewItem lsvOrderDetails.SelectedItems.IndexOf item = lsvOrderDetails.SelectedItems.Item() index = item.Index
im having a problem regard combobox selected index.the combobox wont change its index when i type a text that is the same with one of the items and pressing tab. when i check its selected index its -1. ill give an example to make it simple..combobox items = AB, AC, AD i entered "AB" by simply typing it not by selecting in the dropdown.its index is -1, how can i make the index the same with the items in the drop down?
What i need it when you select a row, it will add the Note to the richbox. For example when i select that row, it will add "this is just a test " to the richbox. How would i do this ?
And I select one and it works! But when I try to select a different one it comes up with an error on..If ListView2.SelectedItems.Item(0).Text = "None" Then The error..InvalidArgument=Value of '0' is not valid for 'index'. Parameter name: index
I have a problem with importing an excel into a data grid.
Here is my code:
Try Dim _Obj As New ExcelConnection.ExcelConnection _Obj.ImportAttendence("c:Info_pc.xls", DataGrid1) Catch ex As Exception
End Try
In the excel i have numers and text and "Service Pack", "Processor Speed" and "Numar procesoare(Number of processors)" and the values for these are numers. in the data grid when i import the excel those values doesn't appear, i receive the value "null".
I'm trying to create a simple Data Grid that will automatically save changes. So far I have a data grid connected to a MS Access 2007 Database that reads the data. I can create new fields in the Data Grid, but I need to program to save the data automatically to the database on update (or on close).
This is a VB .NET application where we are showing the output of a SQL statement in a Datagrid view. using .NET 2005.We need to get the seperators of the headers on the grid control to be the same colors as the GridColor on the form. See the picture below:We've tried looking through all of the properties of the DataGridView control, and found some interesting things that looked promising such as the DataGridViewAdvancedHeaderStyle, and DataGridViewHeaderBorderStyle, but none of it seems to allow you to change the colors on it.Does anyone know how to do this without remaking the entire thing with a GDI+ control?
I have a program that uses a database for all of its information. The program is just an easier way to understand all of the information.The user uses 1 of 4 search options (FName, LName, MemberID or Startdate). Depending on what they search for depends on which members are displayed in a data grid view.
Upon selecting the desiered member from the data grid view, information about them is then displayed. This information has been split up over 3 tabs called member information, Attendence and payment history.
That all works great. So I now go to the Attendence Tab and wish to update this members attendence by selecting a date from the date time picker, and select the Add attendence button.This also works fine, the attendence is update but the attendence data grid view is not updated automatically.
I have to select the member from the first data grid view to run the code to refresh the members information.So I thought, call the PopulateAttendenceHistory Private sub again and have it update the data grid view... but it still doesnt work.
i'm having a problem with a column in my datagrid. Basically i'm getting the data from a database table and putting it into a datagrid. Then i've added an extra column to add up the 2 prices from the table.
I can do that fine, but the problem is that it only shows the total price to the nearest pound.
This is the bit of code that adds up the 2 columns
i need a help about mouse over event for visual basic 2008 i am using access database file i want to retrieve image or data of cell in datagrid on moving mouse on it in pop up window
Private Sub DataGridView2_CellContentDoubleClick(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView2.CellContentDoubleClick Dim doubleclick As String = "SELECT BibleBookNames.Book, Bible.VerseNum,Bible.Verse1 " & _
I have the below code that i am trying to have two datagrids with a grid splityter in the middle. The split seems to be working fine but the issue i am having is when I populate the datagrid it is growing in height and changing the splitter instead of leaving the height alone and adding scroll bars.
What simple thing am I overlooking? <Grid x:Name="gdHistory" Grid.Column="0" Grid.Row="2" > <Grid.RowDefinitions>
I want to know How to get The last selected Index in the multi select of ListView.For example, when i select Item from index 1 to 10, so I get index 10 as the last selected index.But if i select Item from 10 to 1, so I get index 1 as the last selected index.
how to get the selected index from a listview i know you can do the "ListView.SelectedIndices.Item(0)" but then you still need to know the index of the selected item.