I have a base form and I am trying to get the DataSource of the ActiveControl if the control is a datagridview.What I have so far is:
Dim curControl As Control = Me.ActiveControl
Dim ControlType As String = curControl.GetType.ToString()
If ControlType = "System.Windows.Forms.DataGridView" Then
[code].....
I have a datagridview bound to a datatable setting its datasource property to the datatable. I would like to have a child form that contains a list of columns associated with the datatable that contains a checkbox that will allow the user to hide and show the columns ( I do not know the best control to use here) (I assume this is the easy part as All i need to do is loop through each of the datatable's columns to get the column name)
now I would like save these visible columns on some event like form_closing so that the next time the user opens the form up it will remember the settings
My application must display some data in Datagridview (status of COM ports communication) and i Used .mdb databases before for faster search and Datagridview update. How i understand Datagridview is importing data from DataTable and data in DataTable is imported from .mdb file, so i decided to make shortcut - stop to using .mdb file (data must be erased every time application start and it is useless make .mdb file and erase it every time, becouse it is increasing even when drop is used) and using only DataTable..
I want to row in Datagridview change it color to red when it's Collumn(6).text countains %error% string..
When Error in COM port is starting, i can fast find row in DataTable for that port and write information that Error accured for that port and DataGridview automatically updates:
Dim RRow as () DataRow
RRow = ds.Select("Port = 'COM3')
RRow(0).Item(6) = "Error Opening COM3"
I'm trying to setup a form to search for data within an existing DataTable.
FilterColumnsComboBox.DataSource = WOTable.Columns?
FilterColumnsComboBox.DisplayMember = ???
FilterColumnsComboBox.ValueMember = ???
[Code]....
I could hard-code in the column names ("WO_Number",WO_CustID","CustLastName", etc...), but would prefer to pick this up dynamically (partly because I want to reuse this code later).
Let's say that I have a DataGridView(myDGV) which I populate as follows:
'...
Dim strSQL as String = "SELECT col1,col2,col3 FROM myTable"
'....
myda.Fill(myDtb)
myDGV.DataSource = myDtb.
'The above code fills the DGV with data from the underlying query
'of the DataTable.
'Supposing that I want to add an unbound Column to the end of the DGV which appears together with the data returned by the query, is it possibe?
Dim GridDTB as Datatable[code]...
It is updating only on the table "DT3", which is last create table in the array.
I am migrating my code from vb.net 1.1 framework to vb.net 3.5In my windows application, the base window has some buttons and events are written for the same.I have shortcuts defined for these buttons also, for example: ctrl+d, DEL (keyboard) etc.Now i open a property Grid form on top of my base window for a selected object.Even when the focus is on this property grid, i am noticing that my base window events are firing on pressing those shortcuts.
example:I select some text in my property grid and hit delete button from keyboard. The delete event that i have written for the selected object gets fired and the text is not deleting.I fail to understand why is it happening. It wasnt behaving like this in .net 1.1.In .net 1.1 it would delete the text and only when the focus is back on the base window, hitting Delete would call the event.How do i control such a behavior? Is there some property that i need to set for property grid in .net 3.5 to prevent base window events from firing till the time focus is on property grid form?
I am sorry to keep bothering you about this damn DataGridView control ... As you might have noticed I am having a hard time with the DataGridView control ... My latest problem has to do with updating the data base file (Access) through a DataGridView control .
Up to now I have managed to successfully edit an entry in the DataGridView control and moreover to successfully update the data base file itself .
The above form and its code work fine . The problem starts when I am trying to run the code of the Update button from another form .
You see , I have another form , through which I change the contents of some of the cells in the DataGridView control (back in Form1) . What I want next is to simply update the data base file itself , just like I was doing with the button in the first form , after I manually changed the cell in the DataGridView control .Thus , on the second form I have a button with this code :
Form1.Button1_Click(Nothing, Nothing) (of course the Click event is declared public)I have also tried :
Form1.Button1.PerformClick()
but still nothing ...Although Form2 successfully changes the cells back in Form1 , the data base file itself does not get updated ...If I manually press the Update button in Form1 I once again successfully update the data base file , but I want to do the whole thing by calling the Update button from Form2 .
I have a base form and I inherit other forms from it. However, if i go back and change say the size of the base form, I don't see those changes take effect in my inherited forms. Does anyone know why that is? Is there a solution to this issue?So as far as design is goes, what exactly gets inherited by other forms?
View 9 RepliesI have a DataSet(dssongs) with a DataTable(dtsongs) on a form(songsForm).
I am adding rows to the dataTable using the following
Dim dr As DataRow = songsForm.dtSongs.NewRow
dr.Item("colSongFile") = file
dr.Item("colSongTitle") = ""
[Code]....
How do I refer to a DataTable on another form?
When I do this
Public Class cInherits : Inherits Panel
I get this: Base class 'System.Windows.Forms.Panel' specified for class 'MenuButton' cannot be different from the base class 'System.Windows.Forms.UserControl' of one of its other partial types.
How do I inherit?
using vb.net/asp.net 2008question: i found this c# code snippet and wondering how do you do this in vb.net?DataTable dataTable = gridview.DataSource as DataTable;
View 1 RepliesI have a datasource attached to an Access DB. I have a problem if I remove a datatable from my datasource(which contains lots of datatables). I have to manually remove the reference to that datatable from the designer file for each form that uses the dataset.
View 6 RepliesI am using code similar to this to populate a combobox with items from a database. The display works fine, but when I try to get the combobox.SelectedValue it is returning a DataRowView, where I need an integer. Obviously this is becuase I haven't casted the value to an integer, but the function, CInt(cboPosition.SelectedValue) is throwing an InvalidCastException. Is there any way that I can get the ValueMember's type to be an Integer?
Dim cn As New SqlConnection(CreditDisputesLogConn)
Dim cmd As New SqlCommand("CustomersLookup", cn)
Dim da As New SqlDataAdapter(cmd)
[Code]....
How can I get an item value from a Combobox using a datatable as it's datasource? Here's my code for constructing the combobox. This code works, that's why I'm not showing it all, but I want you to know how I'm creating the combobox.
Try
query = "SELECT category_id, name FROM categories ORDER BY name ASC;"
dbCommand = New MySqlCommand(query, dbConnection)
[Code]....
I want to display what is the item you physically see in the combobox that you select.
I am using VB.net.
I have a gridview with a datatable datasource.
What is the best option to update the datatable when i delete a row in the gridview and then show the gridview without that row?
Can you tell me how to syncronise the a DataSource when inserting a new row into a DataTable? [code]The user enters values in the Textboxes and clicks a save button.At that point I get a concurrency violation when using .Update to get the new row into the database.Can you tell me if I need to add any more code to synchronise everything?
View 2 Repliesi need to query the datatable & set the outcome as datagridview controls datasource
vb.net
Private Sub Txt_Search_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Txt_Search.TextChanged
'routine objective:- Filter datatable & set the datagridview datasource
[code]....
I have binded a datatable to a combobox, using DataSource, DisplayMember and ValueMember properties. Now I try to set the combobox to a preset value using comboBox.SelectedValue = value. Nothing happens however.
[Code]...
I want to know how to perform row delete to datatable which is a datasource to the grid.
In details: I have a datagridview (dg) and its datasource is set to dtItem. User will select some rows in dg and press 'delete' button.
dg.DataSource = dtItem;
I will perform a loop and delete the records. Here is the code eg:
foreach (DataGridViewRow drw in dg.Rows)
{
if (drw.Selected)
[Code]....
The problem is it didn't delete correctly. If user selects row index 0 and 1 in dg and delete it, it will delete the first one correctly and then finished cuz no more row is selected in next gridviewrow.
I tried google and didn't find what I want. may be because i don't know the correct keywords I should use to search.
I have several problems with rows in a DataGridView. Background information: The DataGridView (DataGridViewCalib) is in one TabPage of a TabControl, some columns of the DataGridView are automatically DataGridViewCheckBoxColumn as the DataSource have some colums which are Boolean. This is a Windows Form written in VB.Net with Visual Studio 2008. The user loads an input data file.
The problems:
1) At first arrival in the TabPage, ShowDataGridViewCalib (code below) is called. All rows are then shown in the DataGridView, despite the code saying that some rows should not be visible. Breakpoints in the code show that the code do arrive at the Rows.Visible = False events. Despite all rows beeing shown a Watch in the debugger shows that:
[code]...
There are two alternative ways of handling the rows in the code. The first attempt (commented away here) is probably the "nicest".
So my final goal is to take some columns from one form's datagridview (in form3) and place them into a seperate form's datagridview (form4). I started off by just trying to put all of the rows in there one-by-one. Later I will be moe picky about which rows I want. Below is the code I am using. The problem is that I am ending up with an empty form, but no errors.[code]
View 2 RepliesMy program has two forms which get data from the same data source. After binding controls to tables and fields on both forms, I noticed each form has it's own apparently duplicate DataSet. Is it standard practice for each form to have its own DataSet even though they use the same ConnectionString and connect to the same database at the same time?
View 1 RepliesI have a tab (created in the form developer) that contains about a dozen controls. I need to be able to clone this tab w/all controls. I have no problem creating the forms. However, the controls don't copy. This is true whether I create the new tab with a string:
TabPages.Add(MO.Name)Or with a tab object assigned to the base form:
Dim NewTab As New TabPage
NewTab = MyBaseTabPage
TabPages.Add(NewTab)
In either case, my first tab has everything it should have the other tabs have, the other tabs have only the tab name.Basically, I want to be able to clone my base tab into n number of tabs.
I have a form called BaseReportForm that handles drawing some stuff to in a panel to create a template for a bunch of reports. The drawing all takes place in the Panel's Paint event and this form will always be inherited. In the inherited forms, I draw the specific details of the report in the inherited form's Panel Paint event. So I am drawing to the same panel from the base form and from the inherited form. It all works fine, but when I try to open the design view for the inherited forms, I get the following error..
Quote:
The event Paint is read-only and cannot be changed.
I'm not sure I am handling my paint events correctly. Is there a different way I should be handling the drawing of these reports?
When I try to change the datasource of my DataGridView, I am loosing the order of the columns and their type(checkboxes,comboboxes) that i specified on designtime! It's like changing the datasource is generating again the datagridview, why ? and How can I change the datasource without losing these information ? on form load i do something like
Private Sub frmGrid_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim Path as string
[Code].....
I have created a Datagridview by dropping in from the Datasource. After I changed one column to be a Checkboxcolumn but it does not represent the values. In the table (smallint) I have 0s and -1s but it doesnt matter what I enter as True and False Value in the column it just shows that the box is checked.
View 5 RepliesI have a DataGridView and in it a CheckBoxColumn, when I click a cell of that column the check box gets checked.I do it like this:
dgvMessages.CurrentRow.DataBoundItem("have_read") = 1
but the change does not get committed to the DataSource (or at least not immediately), so when I search through it I get wrong results.
I can't call AcceptChanges as that will refresh the grid and cause unwanted side effects... What can I do about this? Is there such a thing as an 'AutoCommit' property on a DataGridView?
my question is, is there a way to filter records in the dataset and use that records to fill in the datagridview? for example, a datatable (with 3 columns: ID, StudentName, Gender) is filled with list of students. i have two datagrids in the form namely DatagridView1 and Datagridview2. DatagridView1 is where the the list of student where Gender is equal to M and DatagridView2 is where the the list of student where Gender is equal to F.in my current solution, i am using a loop.
[code]...
is there a way without using a loop?
I simply cannot understand or see when a DGV's DataSource (a DataTable in my case) get's updated when a new row has been added to the DGV by the user. I have looked at row counts in the DataTable at every possible event and cannot "get" the correct number of rows (which I ultimately need to "get" the GetChanges(DataRowState.Added) of the DataTable.So, here's what I've done.1. The DGV is populated on the FormLoad event. It includes a ComboBoxColumn which has it's own datasource. All fine.Now, let's say initially there is 1 single row in the DGV. There is also and "empty" row at the bottom of the DGV, all cell values are empty.if the user Clicks the ComboBoxCol and chooses an item, then this actually creates a NEW friggin' row, RIGHT?!No. Not exactly. At least NOT in the DataTable (The DGV's datasource).I attempted to "check". Looked at the editingComboBox_SelectionChangeCommitted event:
Private Sub editingComboBox_SelectionChangeCommitted(ByVal sender As Object, ByVal e As System.EventArgs) _
Handles editingComboBox.SelectionChangeCommitted
Dim rct As Integer = ImprovementsEntity.improvementTable.Rows.Count
[code]....
