I just spent over an hour looking up on the internet how to fill a combobox for each row in a datagridview that is unbound. I am adding the rows manually by code. The columns are already there and one of them is set to a combobox.
how to add two items to the combobox? Each row will have the same items available in the combobox.
I am working with an Unbound DataGridView. I would like to vary the contents of a second combobox based on what is selected in the first. I have code to add the columns and populate the first combobox, but I can't figure out how to do the second one since it can (and usually will) have a different list for each row AND the list must change when the selection in the first is changed.
View 1 RepliesWhat I'm just trying to do is the following:I need to fill a combobox from a dataset, but I have to translate the entries before displaying them. That's why I assume I have to use a loop to add the Items.
View 2 RepliesI am populating a datagridview from a datatable and that is working fine. I wish to add some calculated columns from data in the datatable. At first, I did this by adding these to the table, but that makes it difficult to update the Access database. These lines are commented out.Right now, AWt and DOF are not working. The values are there when I step through (lines 85-87), but the values are not put in the grid. The value of NWt is placed in the grid as it should be.Lines 236 through 254 set up the new unbound columns. 85-87 should populate them.
Public Class LotGrid
Dim LotsTab As New DataTable
Dim PurTab As New DataTable
Dim SalTab As New DataTable
[code]....
I'm populating the datagridview at runtime based on user input. The issue I'm having is that the the combobox is displaying blank. The item I need is in the dropdown (I've added it), but I can't get it selected by default. I've tried the display member but that's not working.
View 1 RepliesI have a datagridview that has 1 combobox column (it will eventually have between 1 and 3 more) but I can't find anything anywhere on how to add rows to this column. I create the columns:
[Code]...
I have an unbound DataGridView that I am trying to fill with data, but am having a problem with the combobox column. I create the columns like this:[code]That works, and I have my columns like I want them, but I don't know how to add a row AND select the appropriate item in the combobox. I am adding items like this:[code]I can't figure out how to set the combobox column. And to top it off, since I changed the column from a text column to a combobox column, the grid is throwing exceptions, although it doesn't tell me what's wrong, it just tells me to handle the dataerror event, and all that I can get from that is e.Context = 3 and I can't find out what that means. Probably a type mis-match, but I can't find the proper way do select from the combobox. The rows add OK, but when I scroll the combobox column into view the first item is selected then the errors get thrown.
View 1 Replies[code]....
Not sure how to do it with an unbound number of players names and combobox's.
How can i bind a comobox selection to a datagridview without writting code...
i Need to select an item from a combox and based on that item refresh the datagrdiview. I did something like that in Access but i don't know how to make it work in visual studio 2008.
once i select the datagridview itme that i want to edit i'd like to be able to update back to the database. I know i need to write code for this but at least i'll have the data refreshed on the datagridview.
Dim file_name As String = "players.txt"
Dim strReadLine As String
Dim sr_readfile As New StreamReader(file_name)
[code].....
I have a datagridview that the columns are bound to a SQL table. I want the collection of a combobox in the datagridview to contain a list from a SQL table.
View 2 RepliesI need to pull from an access database to populate a combobox. Then from there I need to have a second combo box populated depending on the selection in the first box. My thought of an example would be a website that is setup for selecting car make, modle,year...can that be done in VB?
View 1 RepliesI am trying to populate a combobox using the following code.
CODE:
I am trying to populate my combobox from Access, I decided to use a function in a separate module to connect, querry and return the result to my combobox for the sake of diminishing the number of lines, but I can't get it to work in .net.
Here is the module I modified from what I found on the net:
Module DataModule
Dim cnn As Data.OleDb.OleDbConnection = Nothing
Dim DBpath As String = My.Settings.SDBPATH
Dim SQLString As String
Private cnnOpen As Boolean = False
[Code] .....
I remember .eof method for my "While Not" loop but I can't seem to make it work. Basically the table in my DB consist of 2 columns, the first being ID (autonumbers) and the second are the records I want to access via my combobox, there is about 10 rows for now but it is subject to change.
im creating my own control to replace the Date Calender within 2008. I want to return a list of Years into a combobox for the user to select.
Im aware i can manually add these years but ideally i would like to return a list just like the calender control.
when you can't make use of the item value property in an unbound combobox? I get access to it in html, so one would think you could do it in .Net.
View 8 RepliesI have a DataGridView (dgv) on a Windows form (VB.NET) which is bound to a datatable. One of the bound columns is a an ID (Foreign Key) to another datatable. All I want to do is Hide the ID column and populate an unbound column with the Name (ParmName) for the user. I searched the foreign value in the datatable and retrieved the information. I set the Value of the cell in the Datarow. All works well, but does not display. The cell accepts the value...I can even Debug.Print the values to the console. They are there just nothing displaying in DataGridView. Nothing odd about DataGridView. Should be straight forward...
My Code
,
Dim dtParm As DataTable = MyDataSet.tblParameter
Dim dgv As DataGridView = Me.dgvResultNum_DataGrid
[code]....
I want to use a CB where I can define the display/value combinations. The same way a radiogroup works.I have been searching for hours and can't find an answer. This is commonin other languages but apparently in VB it is only done when using a Bound CB.
View 4 RepliesI have a product table with ProductId,ProductName,ProductCode as fields. I've populated a combobox with productnames. Next I have two other tables called Result_Header and Result_Detail. The Result_Header table has ProductId as a foreign key and BatchNo,TestDate etc. The Result_Detail table has ResultId as a foreign key which is the ResultHeaders Primary Key and other fields such as Result,SpecHi etc. What I need is when I select a Product from my combobox my two datagridviews must be populated via the Result_header and Result_detail tables respectively.
View 20 RepliesI'm writing my first Vb application and have come to a grinding halt... I've created a windows form which has got a datagridview (which is populated by a tableadapter and a dataset generated from a SQL stored procedure) with two columns (Product and Qty), I'm populating the Product Column using a Stored Procedure, the user then adds the quantity. Once they've finished filling everything out they'll then hit a save button and I then need to insert both columns (along with a reference number which I'm getting from a text box) into a table on a sql server.
View 1 RepliesThis is some of my code. But how do I populate a datagridview using the datareader.
Dim strSQL As String = "SELECT peopleid,firstnames,surname FROM people;"
Dim cmd As New MySqlCommand(strSQL, con)
'cmd.Parameters.AddWithValue("Parameter1", strName)
Dim reader As MySqlDataReader = cmd.ExecuteReader
and how can I handle null field values.
I am designing a form to Enter new City Name list where i accept following fields
CityName, District, State, Country, Pin.
because a State names and Country names can be retrived from earlier entries, i want to allow user to select desired name from a list in combo box or a list in Auto Complete Custom Source for text box, to do this i have added a Table Adapter to underlying DataSet having Query "SELECT DISTICT STATE FROM CITY ORDER BY STATE".
Now, how do i use this Table Adapter to fill the ComboBox List without binding
And also Custom Source List for TextBox.
First form has 1 listbox and 2 buttons. Second form has 1 datagridview and 1 button. The first form opens the csv and list the location+filename of the CSV file. When the CSV files are listed in the listbox, the user can edit the selected csv file in listbox through edit button, when edit button is pressed, the second form will show as dialog and automatically opens the CSV files in DataGridView. The user will edit some fields and save and the second form will autoclose. Now here's the problem, when i select another CSV file in the listbox and press the edit button, the previous CSV still shows, even other CSV files I select, still the previous CSV file was showing.
[Code]...
I'm working on a project where I've loaded a database into a DGV. I also have an additional unbound checkbox column for the users to select entries with. I have code in place to read the selected rows and save them into a CSV string, which is then saved in the usersettings. All this works fine.
PROBLEM AREA:
I'm trying to reverse this effect so that when the DGV loads, the checkboxes that the user selected previously are checked (and the others left unchecked). I've debugged this extensively, and using watches have confirmed that all the values in the loops are right, and the conditionals are all kicking correctly, but it seems the code I'm using to actually check the boxes doesn't work. I've searched dozens of web pages, msdn white papers, and forums, but no suggestions will check the darned box. Below is some example code.[CODE...]
In debugging, it seems the value for the Cells IS changed, but the checkbox never gets selected. The try/catch was just to pick any error messages (but there are none with this code). What am I doing wrong here?
I am trying to display unbound data in a DataGridView.I set up columns already design-time. I am at a loss for creating code that adds a new row using the column schema that was created in the Designer?Something like this?
dim newrow as DataGridViewRownewrow.cells.item("name").value = "text here"datagridview1.rows.add(newrow)
I get an error saying the 'name' column was not found?
I have a form created which an unbound datagridview that has three columns. "Position", "ID", "Name". The data is being added at runtime into a database upon the forms completion. (I don't want to add unnecessary rows to the database in the event a person clicks Cancel.) What I need to do is on the deletion of a row in the datagridview, search through the rows "Position" for a "HJ" value. If it's not found, change the "Position" value of the first row to be "HJ".
[Code]....
I am trying to transfer the entire contents of an unbound datagridview (excluding the headers) to the next row of a bound datagridview. This is what I have so far but I'm not sure if I'm on the right track or not.
vb.net
Dim rowcount As Integer = dgv1.Rows.Count
dgv2.SelectAll()
[code].....
I have two ComboBoxes
<ComboBox Name="cmbMake" DisplayMemberPath="MakeName" SelectedValuePath="MakeID"/>
<ComboBox Name="cmbModel" DisplayMemberPath="ModelName"/>
I use LINQ-to-Entities to populate the cmbGroup ComboBox
Dim db as myDataEntity
cmbGroup.ItemsSource = db.Makes
How do I populate my second ComboBox (cmbModels) based on the selection of the first ComboBox (cmbMake) using XAML so that whatever I select in the first ComboBox automatically filters the ItemsSource in the second ComboBox?
I have an unbound datagrid control I am using to store inspection information. The program records the information from the user, validates the values, and saves it into a database. It will then show the last inspection data in the datagridview. The user has the option of doublclicking a row and changing values and resaving the row. The number of rows per piece inspected varies, so that is why I used the grid to show the inspection data, however, they want to see a running total of each inspection point at the bottom of the grid so when they add the new values, it will update the running totals. I can see how to add a new column for a running total, but the layout requires the sums to be in the last row of the grid. I can add the row to the grid, but I need to make sure it stays at the bottom of the grid when I add a new row, and if possible freeze the row so it is always visible like excel. The program we are re-writting is excel based so this functionality is critical for the inspector to see the running totals for each inspection point.
View 3 RepliesI have an unbound datagridview with three columns already setup. I load data into a dataset. I bind the dataset to the datagridview. My issue is that new columns for the dataset is added to my datagridview. I would like to place the datainto the predefined columns. I have tried this:
Dim
index As
Integer
[code].....