All fields from my class objects are added to the columns collection of DataGridViews, when the forms or custom controls that contain them are viewed within the VS 2005 designer. I haven't been able to figure out how to stop the designer from auto-adding all of the fields found within the bindingsource object.
View 6 RepliesFor a WinForms VB.Net application, I use the Bindingsource's filtering capacity to filter data, which is seen in a DataGridview. The BindingSource is from a DataSet, created using the Designer, and the data comes from a Access DB, using JetEngine and .Net 3.5. So basically:
Datagridview.Datasource = xxBindingSource
xxBindingsource.Filter = "[extended filter string with multiple columns]"
This filtering works fine, however, now I included some extra columns in the DataGridView, which I'd like to filter on, too. Of course, when I feed the manually added columns to the Filter of the BindingSource, this doesn't work out.I've done some research, and was not able to find any way to use the BindingSource's filtering syntax on the DataGridview. I'd like to use this syntax though, as I designed quite a nice UserControl and class around it, to provide smooth, fast and simple filtering capabilities.
I have an object (ClassGPS) containing a DataTable that is exposed through the property "Satellites". My form has a bindingsource that, upon load, associates itself to a new ClassGPS object. The table has 5 columns, two of which ("PRN" and "dB") I want to chart using the new 4.0 chart tool. So the chart object's DataSource = ClassGPSBindingSource, and the DataMember = Satellites. That is all set in the designer.In ClassGPS.New(), the table is pre-loaded with 4 rows. This object is created before the form loads. When the form loads and the bindingsource is set to the created GPS object, the chart correctly updates and displays the four pre-loaded entries.On this form, I have a button that adds more entries. Tracing from the Click event, pushing the button does add the entries properly to the underlying table, and if I create a ListCHanged handler on the data source, the events are all correctly firing, but the Chart does not update to reflect the changes.
So to test, I added a Datagridview object. Just like the chart, I set its datasource to ClassGPSBindingSource, and the DataMember to Satellites. And here's where it gets weird. In the designer, the newly added DataGridView control has 4 columns in it labeled RowVersion, Row, IsNew, and IsEdit. I didn't create these columns, it does it itself. If I try to change the bindings on these columns to reflect the actual datatable names (PRN and dB) two things can happen:
1) If I hit Play (F5) to debug the program, the DataGridView looks and acts correctly inside the program and is correctly bound and updating fine as I add new data. In the designer underneath however, the changed columns have disappeared and are replaced with the original four it is creating for no apparent reason. When the debug session terminates, the columns - which just finished functioning fine in the debug session - are now gone.
2) If I hit Build, the designer destroys my columns immediately and recreates those it defaulted to.In either case, something very fishy is going on... in that the Chart, with the exact same binding settings as the datagridview, does not work but the datagridview works just fine (unless Build is hit prior to Run).Has anyone run across this? Can you reproduce it? I have bound a chart to a datatable before and it worked just fine, but it didn't have to update except when the form it was on was closed and later re-loaded.
If you have a form with two datagridviews that were dragged on to the form from a datasource that have a parent/child relationship with foreign key constraints. Is there any difference between using the binding navigator Delete button or adding a button to the form and in the Click event put "somebindingsource. RemoveCurrent". Basically what I'm trying to find out is if clicking the navigator Delete button causes "Removecurrent" or does it do something else or something additional.
View 2 RepliesI have a DataGridView and have the AutoGenerateColumns property set to false, but the when I build my project the columns are Auto Generated.
I can see the property set to false in the Designer.vb code for the Form.
I've had this problem before and I'm not sure how to fix it.
I am entering data in a dataGridView, I have a column named with 6 characters.The first 3 characters are always "HHH"When I enter in this cell, Is there any way to put automatically these 3 characters and start to write in the fourth one?
View 2 RepliesI'm having problems with bindingsource. I have a proc used to update a datagridview from a bindingsource. When I run the debugger, the datatable appears to be populated rowcount is 2206 and 7 columns. When the bindingsource.datasource is set, everything looks good. The filter appears to be ok, however, when the datagridview is set to the bindingsource, it's not working. I have it in a try/catch block and an error isn't being raised. When I reference the columns to size them, an error is raised. Below is the snippet of
[Code]...
I have a program where i let the user dynamically add DataGridViews to the interface, those are also added to a list for easy management. All of the DataGridViews have their own datasources. I am using a Databinding source to get different DataGridViewTextBoxColumns to add.
The problem is the following: When the user adds the first table the following code runs:
dataGridList(dataGridList.Count -1).Clear()
dataGridList(dataGridList.Count -1).Add(NameDataGridViewTextBoxColumn)
No problem there and the right data is displayed, but when the user adds the second table i get an exception thrown:
"Provided column already belongs to the datagrid view"
I think this is strange since i access different DataGridView's right?
The point of all of this is to be able to view different columns in all the DataGridViews depending on the users choices.
I am adding two unbound calculated columns to datagridview. The columns show up but does not have the calculated data.
Private Sub Top10ToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) _
Handles Top10ToolStripMenuItem.Click
[Code]......
The user picks x amount of scenarios from the combobox, and x amount of columns appear in the datagridview. If the user changes the number of columns from x amount to y amount, the columns should be added/removed respectively but currently when y amount is chosen x amount of columns are in the datagridview.
I'm not sure how to do this, I've tried using an IF statement under the .SelectedIndexChanged event but the code adds columns until it reaches as high as it can go, then pulls an error saying too many columns.
I have a DatagridView with 12 columns. I would like to insert 3 Columns AFTER it has been filled with data from the table.The first New column should contain the total of Col1, Col2, Col3.The second new column should contain the total of the (old) Col4, Col5 , Col6...
View 2 RepliesI have a datagridview that is bound to a datatable. When the form is displayed, the column headers have no sort glyphs and the columns will not sort.
I don't see a property on the form that controls column sorting - at least not one that's obvious. This is an area of the code that another developer wrote originally, so maybe there's something going on that I'm not aware of.
I'm trying to allow users to resize columns of my datagridview, but it's not working. I have this line:
DataGridView1.AllowUserToResizeColumns = True
I want users to be able to resize columns the same way they would if in excel.
With .net 05 and datagridview
Error: Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: index
I am just looping through a datagridview cells of some columns, my datagridview is having 134 rows and 09 columns, but my code stopping at row 124 stating above error.
My code is here:
Public Sub IScoLP(ByVal dGRid As DataGridView)
'SHUNTING
Dim w As String = "SHUNTING"
Dim T_wTYPE As Object
Dim T_ALp As Object
[Code] .....
I have an unbound datagridview with a whole bunch of columns.I need to sort based on 4 columns, the first three are simple strings, the fouth is a date string (which in itself presents a problem, since it wants to sort lexically but I need them in date order).
View 3 RepliesI have a datagridview that I'm populating from a SProc. The data coms back fine and is presenting in the DGV without any trouble, but I don't like the order the data is being returned in.A long solution might be to modify the SProc to return the data in a different order, but I prefer to handle this on the UI for simplicity. Also, I know the user can re-order but that presents a specific poblem in the way the columns are structured.Is there a way to programmatically change the order at runtime?Here's the ode I have on the UI. If you need to see the adapter class also, please let me know and I'll present it, too.
Code:
Private Sub UpcomingInspections()
AddHandler mAdapter.ErrorOccured, AddressOf HandleDataError
[code]....
I have a bindingsource that is connected to a table where tho fields determine uniqueness. During a refresh I would like to return to the row that the user was on when he clicked the refresh button. BindingSource.find only supports one column in so far as i have been able to infer. So how doi do it. Altering the table is out of the question. Besides searching on multiple fields is a common event. Like for example first and lastname or perhaps company and journal number.
View 15 RepliesI am using the following code to alter an table imported from an Excel spreadsheet
Dim SQL As String = "ALTER TABLE receipts ADD payee integer, account integer, category integer, reconciled boolean"
Dim dataread As New OleDb.OleDbCommand()
dataread.Connection = Connection1
[code]....
Both ExecuteNonQuery() actions yields the exception message {"Syntax error in field definition."}The error message does not happen with the first if the boolean column is not there (I tried Tes/No as a definition - but that also failed.The second query to modify the ID column from autonumber to integer I assume fails because it is a Primary KeyHas?
in my VB.Net application I've created a Dataset that call an existing MS SQL Server stored procedure but after the wizard close no columns where added... how can I add all the columns returned by the stored procedure without adding them manually (off course the stored procedure might change in the future) in which case manually will not work.
View 1 RepliesI set the width for my ListView columns in the designer, in run time they always shrink back. I have no idea why, could anyone shed some light on this for me - possibly a solution to keeping them exactly the way I set them in designer ?
View 2 RepliesJust moved from VB.NET to C#.In VB to connect and Event Handler to a Sub we use the Handles clause.From what it seems, this do not exist in C#. After creating a simple application with a button I realize that Window Forms Designer automatically created an EventHandler to my button1_Click function (after I double clicked it), in Form1.Designer.cs with this code:
this.button1.Click += new System.EventHandler(this.button1_Click);
But, in VB, the WinForms Designer create the Handles clause in my class, in the function header. So, C# create the default EventHandler in designer file, while VB creates in main class where control resides.
I am a student working on a project for my company. I work using Microsoft Visual Studio 2005. Language is vb.net. I also work using windows application.
I have a form(EmailContacts.vb) which contains a datagridview and a button(btnAdd) to add the data to a textbox of another form. My datagridview consist of 3 columns; CustName, Email and Selection. Selection column being the column with all the checkboxes. Everything is working fine and i can display data from the database on the datagridview properly.
The problem is how do i add a 'Select All' feature such that when the user clicked once on the 'Select All' checkbox, all the checkboxes in the 'Selection' column are selected?
These are my codes for the form:-
[Code]....
I see the DataGridView control has a property "AllowUserToAddRows" that I can turn on or off but what if I want the ability to be context dependent. i.e. I want an event that will fire when the user attempts to add a row in which I can cancel if certain conditions aren't met but I can't find an appropriate event.
View 1 RepliesI have a combobox and a group of textboxes on a windows form. I'm using a binding source to bind a dataset from an access database to these controls. To add a new row, I'm adding a row to the dataset. This adds to the database fine, but on the screen, it adds the new entry to my form, but it also overwrites the textboxes of what ever item was currently selected with the values of the new row I just added. If I quit and re-enter the program everything is correct.[code]...
View 5 RepliesI'm using VB.net 2005. I have working programs that I populate DataGridViews with something like the following:
[Code]...
If using a datagridview to update a database and the datagridview is bound to a bindingsource which has its datasource as the table to be updated: where dshould you place the tableadapter.update(mydatarow)
View 5 RepliesI am very interested to see the answer as I would like to know the significant differences (if any) of generally using one more than the other. In a few days, I will be starting my Java programming class to familiarize myself with the language.I do know that Java uses objects.My question/discussion is not necessarily related to .NET (although in a way, it is); my question is more about what is a better practice and why.Is it more proper to declare buttons and such through runtime rather than designer? Is it just more work typing everything? Or does build and run much faster?
View 9 RepliesThe company has a Visual Studio 2010 Ultimate project that is written in Visual Basic. The project has several strings in the resources file (Resources.resx). One of those strings (VersionSuffix) contains "" when we are distributing a normal version of our product and "BETA" when we are distributing a beta version of our product. Most of the time we distribute a normal version of our product. Therefore, most of the time the resource string VersionSuffix contains "".
Recently, we attempted to distribute a beta version of our product. Therefore, we changed resource string VersionSuffix from "" to "BETA". However, it quickly became apparent that the resource string VersionSuffix was being used as the default value for several control properties in the form designer. For example, if I draw a rich textbox on a form then file FORMNAME.Designer.vb will contain the following.
Me.RichTextBox1.Location = New System.Drawing.Point(286, 306)
Me.RichTextBox1.Name = "RichTextBox1"
Me.RichTextBox1.Size = New System.Drawing.Size(134, 33)
Me.RichTextBox1.TabIndex = 32
Me.RichTextBox1.Text = Global.PROJECTNAME.My.Resources.Resources.VersionSuffix
We are unable to find anything anywhere that indicates that this resource string should be used as the default value for control properties. Therefore, we have no idea why this resource string is being used for this purpose. We would like to change the control property assignments in the designer from Me.RichTextBox1.Text = Global.PROJECTNAME.My.Resources.Resources.VersionSuffix
Me.RichTextBox1.Text = "" However, we don't know why these strange assignments are being made. Therefore, as soon as someone adds another control the problem will most likely return. Does anyone know why this is happening and how to prevent it from happening again?
my program has been finished a year ago and then I didn't use it. but today I need to use it for some reason. I find it cannot be update when pressing the save button on BindingNavigator bar, here is the message
System.InvalidOperationException
When passing the modified data to DataRow collection，The update need a valid UpdateCommand.
[code].....
i have created my own custom propertythe property is of type collection ,it displays a form which allow the user to add a list of images and strings,it stores the data in a collection ,my problem is , i have noticed that after adding items to the collection at design time , there is no code generated in the .Designer file of the form and there for when i close the for / save it and reload it , all the items that i added to my custom property are gone.my question , what did i miss here ? how do i make my custom property generate code at the .designer file for the items i have added to my property?
View 1 Replies