I'm maintaining a Master Table call "MaterialList" in Datagridview Windows Form now I want to ADD Expandable row option to that Datagridview.
For your information : MaterialList Table is link to MaterialSales Table with Primary Key MaterialCode. By the way if I click any item of MaterialList the Sales Details should appear in that GridView. I'm using Visual Basic 2010 and Database SQLServer.
I am completely Goggled out on this one. We currently have a datalist consisting of rows of data for our company. What I need to do is to add a link into the individual cells of a particular column called candidate profile. The link will be View Notes. When that link is clicked, I would like to have a new row expand right below the existing row to allow the additions of comments in the empty row. When the user comes to the page and there are existing comments for the row of data, have it expanded and give the user the ability to expand, or close the comments as they see fit. I also need to figure out the best way to allow the user to enter in the comments as well.
View 5 Repliesi'm using an ExpandableObjectConverter for an expandable property in my app, but it doesn't work as expected.it seems to work inconsistently, but it's not working reliably.
here's the code:
Public Class timeConverter
Inherits ExpandableObjectConverter
Public Overrides Function CanConvertTo( _
[code].....
IN vb.net, how would i be able to create expandable forms? For example, you have a form , and you click a button, expanding the form to a new size. i currently hav a button that uses a while loop to increment the increasing and decreasing size to make it look animated. any other options?
[Code]...
I decided to play around with NickThissen's Expandable GroupBox control.Expandable GroupBox//When I add a control to my form and debug or build the project, the Text of the GroupBox changes to the default. The Name and anything I put inside of the GroupBox stays the same, however.I also noticed that the control resizes to it's default size when I build and/or debug.
View 4 RepliesI am developing a small application using VS2008, the mdiparent has a expandable panel with Button 1 and Button 2 on it, which opens up child form 1 and child form 2. ( The two child forms are maximized within the mdiparent form)
The problem is, button 1 opens child form 1 and button 2 - child form 2. I cant open the two forms randomly. I have to close the topmost form to access the other forms below it and vice versa.
I have a datagridview populated from a CSV file in vb.net. I have 2 datepickers, 1 button. see the attached images. Image1->before filtering
[Code]...
I have two datagridview's both are databound. First one shows items for sale and the second stores all the items that were sold. I am trying too transfer selected rows from one to the other but no matter what I keep getting told "Rows cannot be programmatically added to the DataGridView's rows collection when the control is data-bound."
View 2 RepliesI have a datagridview extracted from a csv file. It displays duplicate rows. How can I delete those duplicate rows from the datagridview? replies would be precious.
[Code]...
I've made an add button and I want it to add another row to the DGV and fill it with data from a database query.
Me.DataSet.App.Rows.Add() - this does add a new empty rowCode for filling the DGV with a query:Try Me.English_AppTableAdapter.FillBy1(Me.PunchDataSet.English_App) Catch ex As System.Exception
[Code]...
I used MSFlexGrid in VB6, now I've gone from little in VB10 and use Datagridview .... I want to read the contents of a single cell in a particular column and row selected with the mouse...
View 1 RepliesI have a unbound datagridview. I want to find the minimum and maximum value in a column in a datagridview, how can I do this?
I also would like the "address", or row number of these values,
how to use bit fields (Boolean) in datagridview in visual basic 2010 how to know CheckBox checked state checked or not if CheckBox Checked State = Checked?
View 1 RepliesUnable to display data in datagridview : vb 2010 express + mysql server 5 + odbc connector
1. I am able to connect database successfully. I am using arraylist to set data.& also i m
getting till it set to dataview (Object name )
2. Till now i am not added any column name in datagridview property setting .
[add/remove column]'[code...]
i have problem when addnew row at keyup event for datagridview control.i want to add one row when method addRow() called.this my code :
vb.net
Public Class Form2
Dim dt As New DataTable("view")
Private Sub Form2_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
dt.Columns.Add(New DataColumn("Col1"))
[code]....
the problem at dg_KeyUp code, Since more than 1 row created while I want only 1 line only.
I have a datagridview populated from 3 tables....It also has a checkbox column my question is how do I get the Serial Numbers of the SerialNumber column when the user decides to check multiple checkboxes..is it possible to save multiple data simultaneously?? For example, the user decides to requests 10 equipment ...
View 10 RepliesI use DataGridViewComboBoxColumn, for places one ComboBox into my DataGridView.
Now i want to places 7 more ComboBoxen into my DataGridView, so i have 8 ComboBoxen.
The 8 ComboBoxen are filling from a database tabel, that is "Allergeen1".
Is there a code for this?
[Code]...
I looking for idea on how, to do this:
I've a DataTable that a would like to display in the DataGridView
- the first should show all data of the DataTable
- the second should display only a SubSet of the first
I've try building two DataBingSource,
- The first without Filter Expression
- The second with a Filter express like 'Weight < 100'
But when a enter a value in whatever grid that have a weight greater then 100, a row simply vanish from the grid.
[Code]...
In DGV, I have 2 checkbox columns. Column1 and Column 2. Once I checked a checkbox in a column and it happens that there is already a checked checkbox in the other column and they are in the same ROW. It will automatically disable/uncheck the Checked Checkbox.. Meaning only One CheckBox must be allowed to be marked if happens that they are in the same row.
Imports System.Data.SqlClient
Imports System.Text.RegularExpressions
Imports System.IO
[code].....
I have a Windows Forms DataGrid currently filled with text.What I want to do is have a ComboBox appear in a cell when the user enters it.After the user has chosen their item from the ComboBox list I want the ComboBox to be removed leaving just their selection as text in the DataGrid, when they leave the cell.
View 11 RepliesI am having trouble with a comboboxcolumn in a datagridview. I have a MySQL table with "products" which i have managed to populate the combobox with, but i would like it so when a user picks a product from the combo list, the rest of the fields in that row are populated with the product information, price etc.
View 4 RepliesI have a DataGridViewComboBoxColumn in my DataGridView. I want to programatically drop down the list box so that the items arte displayed. With a normal combo box this is done with ComboBox1.DroppedDown = True. The problem is that the DataGridViewComboBoxColumn doesn't have the attribute DroppedDown.
[Code]...
i have this code i want to populate datatable with datagrid. . . .but this is error in column name i dont know why. . . .
Dim dt As New DataTable
Dim rptdoc As ReportDocument
With dt
[code]....
I would like to create a DataGridView that displays records that fill either 18 or 35 columns. I would like to avoid displaying all 35 columns for all records, instead showing the 17 extra columns on a second row for records that need them.How would I go about this? I'm guessing I need to create a new class that inherits from DataGridViewRow and override it's Paint or PaintCells method, but I have no experience with overriding Paint events, so I'm kind of lost after that.
View 8 RepliesI have a datagridview that is filled as follows:
Private Sub cmdExecuteSproc(ByVal SO_Number As String, ByVal Prev_SO_Number As String)
Dim spSteps As New SqlCommand("sproc_shop_order_get_recipe1", cnPMSQL)
spSteps.Parameters.AddWithValue("@int_shop_order", SO_Number)
spSteps.Parameters.AddWithValue("@int_prev_so", Prev_SO_Number)
spSteps.CommandType = CommandType.StoredProcedure
[Code]...
I have searched the forums for an answer to this problem and while I have found simalar issuses, I have not found a solution that works for me. I have created a dataset and populated it. I know that this is true because I can view the information in the dataset in other ways such as using labels or textboxes. However to display the data in a organized and usable way I would like to display the information in a DataGridView control. I DO NOT need to be able to modify or add anything to the datagridview, JUST view the information there. I am not using any wizards to complete this and so I need to be able to complete everything programmaticly. I have written the code involved to the best of my understanding. When I run the application, there are no crashes or errors thrown, I just can't get the datagridview to populate. Below is the code that I am currently using:
[Code]...
I try to select the last row like this:
Dim lastRow As Integer = DGV.RowCount
MsgBox(lastRow)
DGV.Rows(lastRow).Selected = True
The messagebox returns the correct number, but when it comes to select that row it says:Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index
But if I assign it a row, example: DGV.Rows(5).Selected = True
My code works fine but what I'm trying to do is bind the data without it inserting the column names in the mysql table.[code]
View 5 RepliesI am trying to get my datagridview to display more than one row of data.Every time I call the program it only writes the 1st line of data in the datagridview instead of adding it to a new row.I have been looking on the forums for hours but combined with my inexperience I can not understand it. The following code is in a loop and it reads an xml file each time.The goal is to put the xml data from each file into a new row in the table.Public Sub ReadData(ByVal filename As String, ByVal file As String)Try
DS.ReadXml(filename)
DS.Tables.Add("MyTable")
With DS.Tables("MyTable")
[code].....
in visual basic 2010 How to delete a selected row from datagridview and table then skip to next or previous record
View 1 Replies