I have datagrid with two combobox coloumn where there is relation parent/childIf i select element inside combobox1 i must load combobox2 with relative element, how can i ?But i don't wanna change other rows inside same combobox coloumn
View 1 RepliesI have a DataGridView (called DataGridViewSecurity) in VB.net (Visual Studio 2010) which is bound to a DataTable (called DataTableSecurity) in a DataSet (called DataSetSecurity). I have added a nonbound column (called nSecurityComboBox) that I set based on an integer field (called nSecLevel) in the DataTable. After setting the combobox, it doesn't display anything in the combobox, but when you select the combobox, the 5 values in it's items collection show. Here's the code I'm using to add a record to the DataTable and then to set the combobox:
[Code]....
I have a datagridview with transaction bindingsource I want the datagrid to show the sorted rows only not all the records when i enter a value into a textbox and click button sort.
View 1 RepliesWhat I am trying to do basically is open an access query in a datagrid view and then be able to make changes to the datagrid and then save it back to the database.When I try to save:
Me.BindingSource.EndEdit()
Me.TableAdapter.Update(DataSet)
It says that update is not a member of the tableadapter... Why is that?
now i use acces as datasource to view the agenda in a datagrid and a combo box to select a year or month so i can find the selected month or year in the datagrid .how do i program it so that it searches the selected year or month in a datagrid
View 2 RepliesI have a datagrid who's ItemsSource is a strongly typed IEnumerable object In this datagrid, I have a checkbox column, a price column, a part name column, and a 'total selling for' column. On checking the checkbox I need to update the total selling for column with the value in the price column. This part I have working, however, how can I get the checkbox to remain checked when this happens?
Private Sub UpdateSellFor(sender As System.Object, e As System.Windows.RoutedEventArgs)
Dim _CB As CheckBox = DirectCast(sender, CheckBox)
Dim _ID As Integer = _CB.Tag
Dim _PP = DirectCast(DG_PartsToSelect.CurrentItem, PartTyping).PartPrice
[code]....
I placed a datagrid in my form which l retrive data from my sql. i am using oledb connection. if i run the form i can retrive the data but i am not getting the data in the grid at first ,there is a "+" sign, i have to clik that then it shows the table name and after clicking the table name i can view the data displays in the grid..
View 1 RepliesI have a datagrid which I am using LINQ to fill, I then add some custom columns and fill them in programmatically - if the users clicks on the column header to re-sort, all the data in the added columns disappears. I am obviously missing something very basic here but can't seem to see the forest for the trees. I also have a couple of other questions about how I am doing things:
[Code]...
I am trying to create an xml editor that read and write xml. my code reads the xml with no problem and allows me to create new rows but when I try to "write" it over I get the following error: "Token StartElement in state Epilog would result in an invalid XML document"
here is my xml:
<?xml version="1.0" standalone="yes"?>
<MacroList identifier="test">
[code].....
I decided to rewrite my project. Hit another snag. How do I write the contents from a datagrid to a file and back into the datagrid again later? (Actually, I've done the writing ok - but for the life of me can't get the data back into a blank datagrid.
Here's what I done so far:
Imports System
Imports System.IO
Imports System.Text
[Code]....
how to do cursor moving from one grid it effect to another grid.example Grid A and Grid B have the same number of rows. when I click current row on data grid A, the selected row on data Grid B also follow data grid A..
View 1 RepliesI am printing a files that are shown in datagrid.. But I want to choose a file that I don't want to print by checking the checkbox that I added in datagrid..
I have here the code for printing.. Anyone can edit my code that will print those file that is not checked.
Code:
Try
openMySQL()
Dim sql = "DROP TABLE IF EXISTS dummydisconnectionorder"
[Code].....
I have on my form two datagridviews that correspond to the same table. They are both databound. They have been created automatically through dragging them from the datasources windows.One is datagridview and the other datagridview1. When ever I navigate through a datagrid the corresponding row on the other grid changes as well. I do not want this. Also I want to be able to fill and use each datagrid indepentent from each other. To fill a datagridview on load I use this code
Me.AllServicesTableAdapter.workstation(Me.Database2DataSet.AllServices)This code does not let me choose which datagrid to fill.
I have a search form on that will be pulling search template queries from a table in the underlying (an Access db on a share). The search form has a calendar control for filtering by date range, a listbox containing the names of the search templates, a second listbox which lists the fields in the selected template, and then some controls which show/hide themselves depending on which field is selected so that the user can pick a field and enter it's unique criteria in the appropriate control for filtering. Below these controls is a DataGrid, which will obviously display the results.
The problem is how to dynamically "transform" this DataGrid to display the selected search template. These templates do not represent tables in the underlying; rather they represent preconstructed SQL queries (stored in a table) which are essentially SELECT queries with joins and no WHERE clause (so they are the results of multiple tables joined together by their keys).
To be honest, I'm having trouble even generating the LINQ queries to represent these template dynamically, but that's not as important, since I can manually translate the SQL queries into LINQ. This is definitely not the preferred method, as the whole point of putting these templates in a table, rather than code, was to allow for future additions without rebuilding/redistributing the application interface.
what are the differences between the WPF Datagrid included in the .NET Framework 4.0 versus the Datagrid included in the out-of-band WPF Toolkit? I understand that the toolkit version was released first, and targets the .NET Framework 3.5 SP1.
I needed a WPF datagrid quick and have utilized the toolkit version in my applications. I'm considering moving the application to .NET 4.0 and am wondering what the pros/cons will be in changing out my existing datagrids for the new ones.
I have one data grid which contains a column which contains long string values. When I edit it, the text box which appears is very small. I want to increase the length of text box.
View 2 RepliesI am just trying to put an item into a datagrid from another datagrid.
So I got code like this which takes the right item but puts it into the wrong place. It is suppose to put it into Rows(0).Cells.Item(3) but it puts it into item(2) as it caunts from 0 to 3. If i try to put it into Rows(0).Cells.Item(4) I get an error - indexOutofRange.
DataGridCLI.Rows(0).Cells.Item(3).Value = datagridorder.Rows(0).Cells.Item(2).Value
I have searched alot but can only find info on moving entire rows bound between 2 datagrids, but noting on moving single cells. I have some code below that works ok from DGV to textboxes but not from DGV1 to DGV2.
Dim i As Integer
i = DataGridView1.CurrentRow.Index
Form3.DataGridView1.Item(1, i).Value = DataGridView1.Item(0, i).Value
[code].....
I have converted a VB6 app to .NET using VB 2008 Express Edition, as recommended in the VS 2008. Actually just opened VBP project using this software and followed the wizard's instructions. The app has a form containing the ADODC control and AxMSDataGridLib.AxDataGrid. The DataSource property of the Grid is set to ADODC. (Actual data comes into UI from some DLL.)When I start debugging the converted app I immediately receive following error:Error -2147467259: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.Same error happens when I try to set the ADODC object to the DataGrid.DataSource programmatically (in run time).The VB6 version of same app runs without any problem.
View 4 RepliesI want to ask how to add/insert new row/record and it show at the top in datagridview. i don't want the new add record at the bottom but i want it at the top. I mean,the current is at the top in datagridview. i'm adding the new record is not from inside the datagridview,but from textbox at outside datagridview.
View 5 RepliesI have a combobox with a datagrid, but I'd like the user to be able to type into the combobox like usual; At the minute it's a fixed dropdown. Here is my code:
[Code]....
i want to add button in datagrid.When i insert new row ,i want to add new button and different text in button.i have done but something is wrong
For i As Integer = 0 To 10
DataGridView1.Rows.Add(
New DataGridView())
[Code]....
display me only one text,not change in index of loop
how to add checkboxes into datagrid.
what all references should be made.
I have a data as excel format in Datagrid. I want to format data as combobox in datagrid.
View 5 RepliesI would like to know how to add data to datagrid in vb .net without database similar to MSFlexigrid in VB6 and access the same in the software.
View 1 RepliesI thought I had this figured out but now im stuck again. I need to have a clickable link in a cell in my datagrid that will open a pdf file on my desktop. I made 2 programs. The first used an access database and put in this
[Code]...
Well my datagrid so far has the edit,update,cancel feature and it can get info back from database after entering a number into a textbox.
All i need now is to get it to where I enter a number the data comes up which works and I want a blank row to show up which i can edit and add stuff to.
I saw for adding combox to datagrid still Unwritable.[code]...
field has order number 1. Name of this column is "Name"' Datagrid ComboBox ValueMember field has order number 0. Name of this column is "PubID"
I have a checkbox in a datagrid in my form, the user can only select one checkbox at a time, if more than one is selected the other checkbox will be unselected leaving only one selected. This part works okay, however if I click on another combo box or datagrid on the form it forces the selection to be removed from my checkbox, I can't figure out what is causing this, has anyone had any similiar problems??
View 4 RepliesI have the code below which works fine when checkbox at Cell 2 is Checked ie., the date is inserted in Cell 9. Now, when I unclick Cell 2 I want the Cell 9 to be cleared. Presently, it is not cleared after unchecking.
Code:
Private Sub DgvReturns_CellClick(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DgvReturns.CellClick
If e.ColumnIndex = 2 Then
[Code].....