Hi, I am creating a little invoicing application in C# on an access database. Main DB-structure: customers -> * invoice -> * invoicelines I created a typed dataset for it, (with xsd), including all constraints. I have an "invoice" screen, with: First section: Some customer fields, (read-on...more >>

Hi Guys, How can I erase the content o a Data Grid so the next content will be a fresh one, instead of ADDING to the last line in the datagrid...? Thank you -- Bruno Alexandre (Sintra, PORTUGAL) ...more >>

hi, i am facing problem with attaching combobox to a cell of a datagrid. namely to the cell 3rd row 4 column.. then the combobox should display the content of that particular cell... can anyone help me in this regard Thanks Geeta ...more >>

Hello everybody,=20 I have controls two tables in a dataset that are linked with a relation = and all field are bind to control on a form. When I navigate to a row in the parent table for wich there is no child, = the binded text box are empty, as expected. =20 When I put text in the cont...more >>

I've just installed the .NET Framework 1.1 SP1 and suddenly things that used to work are giving me problems. Specifically, I have a grid (not an MS DataGrid but one from a third-party) which is bound to a DataView. One of the columns is boolean and the grid displays checkboxes, as expected. Wh...more >>

Hi, Wonder if Somebody could help me? I`ve been searching all over for a solution but am totally lost. I have a Class called Connection as below: Public Class Connection Private Shared mConnectionsstring As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" Private Shared mLocat...more >>

Windows Form Application, MSAccess Database, VB.NET I am having a very strange problem with the OleDb.OleDbDataAdapter.Fill method.... I have used this method thousands of times with success and have never had any problems, but recently I have a query that will definitely return multiple rows ...more >>

I have set the 'datasource' property of a 'bindingsource' object to a DataView ('dv'). The dv is in turn bound to a dataset table: dv = this.MyDataSet.MyTable.DefaultView; I then set the 'datasource' property of a DataGridView ('DGV') object to the 'bindingsource' object. T...more >>

I have a form with a datagrid and two buttons on it. Upon opening the form, focus goes immediately to the datagrid. How do I set focus onto one of the buttons. I've tried to use "btnSave.Focus()", but to no avail. Please help. Mervin Williams ...more >>

I am using the SortableBindingList<T> class described in the MSDN Custom Data Binding article at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnforms/html/winforms11162004.asp?frame=true This business object is displayed in a listbox using databinding via a BindingSource...more >>

Using VS 2005, I've added a datasource to a DataGridView ('DGV') and this creates the automatic designer code to bind a dataset to the DGV and a data adapter to update the SQL database. The problem is that if I then change the database (e.g. add a field), I need to delete the datasource and...more >>

Hello, The default implementation of the BindingNavigator control saves changes to the datasource when the user navigates to a different record. I want to let the user decide if he wants to save changes when the record has been modified. Is there some event that can be handled before a re...more >>

I've been looking at the code samples for binding data to a DataGridView using the bindingSource property. I do somthing like bindingSource = new BindingSource(); dataGridView.DataSource = bindingSource; Refresh(); private void Refresh() { DataTable t = GetDataTable( mySQLStmt ); ...more >>

i think i FINALLY found the correct group...wooohooo using vb2005 i drag-dropped a table onto a form, and removed a bunch of fields i didnt actually need on the form for dataentry. VB automatically created the add-delete-save buttons on a toolbar. my problem is, before the data is updated ...more >>

I have already posted this on microsoft.public.dotnet.general, but without answer. I have custom collection that is bind to the System.Windows.Forms.DataGrid. My custom collection business object has property Quantity. public event System.ComponentModel.PropertyChangedEventHandler Qu...more >>

Hi, I'm trying to implement deepbinding for my custom business objects. I have written two custom classes: BindableObject which implements ICustomTypeDescriptor BindableCollection which inherits CollectionBase, ITypedList, IListSource Then for test I have created the following obje...more >>

i've been researching concurrency issues with ado .net for the past few days and have found some trouble finding examples that suit my needs. Over and over again the only two options i've found is either save the your changes (DataRowVersion.Current) or don't (DataRowVersion.Original). Well neit...more >>

Hi, Does anyone happen to know how to set the display order of columns in an unbound datagrid? I an using a collection of objects and the public properties are all showing but I'd like to change the column order. Thanks, Bill ...more >>

Hi, The DataGrid appears to show all public properties from the datasource as columns in an unbound datagrid. Is there a way to limit the set shown? I'm doing this not to avoid showing them but to avoid the properties being requested from the objects in the datasource. Thanks, Bill ...more >>

Hi I have a datadapter with the following SQL; SELECT ID, Company, Status, CompanyType FROM Companies WHERE (@Status IS NULL or @Status = Status) When I try to fill like so; Me.CompanyTableAdapter.Fill(Me.MyDataSet.Clients, "Current"), it brings all companies with stat...more >>

Hi I have the following sql for my dataadapter; SELECT ID, Company, Status FROM Companies WHERE Status = @Status I fill the dataadapter as Me.CompanyTableAdapter.Fill(Me.MyDataSet.Companies, "Current") and it works great. The problem is how do I view all Companies and no...more >>

Hi I have created a simple data entry form by dragging a table onto a form and letting vs2005 generate all bindings etc. All works fine. Now I need to be able to view records selectively ie sometimes I need to view/edit only 'Current' accounts and other times I need to view/edit only 'Pros...more >>