SQL Server 2000 / ADO.Net / VB.Net / DataGrid I am a newbie to ADO.net and disconnected data. Even though I have done a lot of reading I have not been able to get the following questions answered. I don't understand how a disconnected dataset is supposed to get the id field value assigned. ...more >>

Hi, I have a datafield containing Y or N. I would like to databind to the checkbox, and tell it that Y denotes the checked state and N denotes the unchecked state. In fact, I would like to be able to do something like this to arbitrary values which should denote the checked and uncheck state...more >>

I am using simple databinding on a small form with only about 10 controls. My problem is that the _second_ time I open the form and edit a value, I am no longer able to tab or click out of the control that I just changed the value in. Here's what I mean: 1. Open the app 2. Open the Details f...more >>

I have a stored procedure that returns data to be shown in a grid. When I run the stored procedure from SQL query analyzer for a months worth of data, I get the response in less than 1 second. However.. when I do this to a grid.. it takes more than a minute. any ideas? Some code is below. ...more >>

Hello, I am new to vb.net and having a problem. I am using windows forms, class libraries to connect to the oracle database. My table contains a boolean field which is stored as varchar2. I am retrieving the values from the database and displaying them in a datagrid using oracledataadap...more >>

I have a data connection to an access database, and inside the access database there is a query of which the text is: SELECT Name FROM Items WHERE Name LIKE '*Crystal' ORDER BY Name; When I run this query in Access it works fine, and I get back a list of all entries in the Items table which ...more >>

Hi, I have tow problems when I am writing a win-form program. The First is: On a form, I place two textboxes, two buttons and a dataGrid. Then I bind them to a dataView like this: ... dataView = dataSet.Tables[0].DefaultView; dataGrid.DataSource = dataView; textBox1.DataBindings.Ad...more >>

I there a way to execute a SqlCommnad asynchronous? Or to open an dataset asynchronous? Like in ADO using adAsyncFetch. Thank you ... ...more >>

Hello group... I've created a class derived from CollectionBase that implements the following interfaces: IBindingList ITypedList IListSource And for my collection items I've created a class that implements the IEditableObject interface. Everything works fine, I can bind my collect...more >>

Hi, Given a textbox bound to a datasource, is there a way of pushing the value from the textbox on, say, a KeyPress event? There doesn't seem to be much documentation for data binding in general, and I'm sure I'm missing something simple. I've tried using EndCurrentEdit, but there's somethi...more >>

I've built a query form that will populate a datatable by generating a SELECT statement that pulls data from a database table according to selections made in a series of listboxes on the query form. Two of the listboxes contain items that are in many to many relationships, so the IDs of those ...more >>

Is there a control in VB .NET that has the functionality as the Combo box in Access? I'm interested especially in multiple columns property. Thanks in advance ... ...more >>

This is rarely answered by anyone who here this questions, because i think most the people did't know the answer about this question. If anybody who are willing to help a group of students help us email rajeev_gt@rediffmail.com...more >>

Hi, I created a user control that binds to a dataset. I noticed that the changes from the dataset are available in the user control right away. This is all good. The problem I ran into is that the changes I type into the text boxes positioned on the user control are not reflected in th...more >>

Hi, In my user control has two checkbox. each checkbox is binding with a property in myObject. Ex: class MyObject { private bool m_bCheck1; private bool m_bCheck2; public bool Check1 { get{ return m_bCheck1;} se...more >>

I can't seem to navigate a custom collection effectively. If I navigate to a child Collection, then the collection show up blank (Seems reflection isn't able to get the Member info). If I bind to that child directly, the DataGrid populates fine. I've tried applying a Style manually, but it onl...more >>

I have a WinForm datagrid that receives data from a DataSet. One of the colums is anm INT-column from the database, and I would like to format these INTs before binding them to the control. I format the grid by applying a style to it, and I have seen in the doc that there on the object Data...more >>

Why textboxes don't go blank when I click addnew. I have a FullWord form displaying KeywordSets in textboxes and a checkbox, a grid in synch with the textboxes, and two child grids tied by relationships to KeywordSets. One is Keywords and the other is SearchPhrase. I have several proble...more >>

Hi, I have a very simple webform which I would like to use to record peoples input. In am able to create a SQLDataConnection & SQLDataAdapter to connecti to the SQL database. I am then able to set the parameter in the SelectCommand so I retrieve the data which I want. After I do that I c...more >>

Hi Everybody, I find the problem that is the CheckBox Problem?? If I dont use the CheckBox press the AddCommand is work? But when I use the Check Box it will come out the error : column 'code' does not allow nulls... Someone can help me solver this problem......... Many Thanks This i...more >>

I have a simple form that I am trying to use to set application level persmision When I click the update Function I get a system error I cannot explain the code is as follows Dim datarw As DataRowView datarw = dv1(recindex) datarw.BeginEdit() datarw(1) = ...more >>

Hi, Dear gurus, I want to bind my collection to a datagrid. The field names in my object show up in a weird order, and I just wonder how I could reorder those columns . I find some code like the following , but I don't want to do it that way because it won't work if I have large number of ...more >>

Hi all, I have a question on implementing IListSource.GetList If I implement it on my binding component, does winform databinding expect to get same IList reference always after the initial databind? Basically does it at some later time call GetList again and expects same reference or same...more >>

Hello My arraylist have 10 objects. How can i update my datagrid when I add an object to the arrarlist with databinding ? Thanks...more >>

Hi, New to this game. I am trying to create a basic application but have come up against a stumbling block with regards to the above and using a combo box. I have got a list of employees in a user_name field. These are displayed correctly in a combo box, what I want the application to do...more >>

Hi, I have a problem with some databound usercontrols I'm working on.. The controls are mainly groups of textboxes used for displaying and editing chunks of related data that will appear on multiple forms. Each control consists of labels and textboxes.. Each textbox has a public property ...more >>

Hi Everybody, I find the problem that is the CheckBox Problem?? If I dont use the CheckBox press the AddCommand is work? But when I use the Check Box it will come out the error : column 'code' does not allow nulls... Someone can help me solver this problem......... Many Thanks This i...more >>

Hello all. I have the following problem and i couldn't find a solution. I made a control which contains 2 radio buttons. I that control i have a property (bool). That property tells me which one of those radios are checked. I have a form where i have my control. After i modify some fields i...more >>

Ok, I'm new at this and learning as I go, but under extreme pressure from work.. So many bugs and little tricky obsticals have got me very far behind, and this is the latest.. I made a simple databinding form, but not using the wizard, because it doesn't use the SQL driver. I'm keeping it s...more >>

Hi, I have a DataSet with a set of parent & child table, a relation is defined. I then create a dataview and bound it to a single datagrid. DataView dv = new DataView(ds.Table["parent"]); dataGrid.SetDataBinding(dv,""); Everything works as expected, I can click on the "+" to see the child...more >>

Hi, all. The most irritating thing about .net with datagrid is sorting feature. With vb6, I've used flexgrid or 3rd party component(spread) with sorting feature. But, with datagrid, if I click header and sort it, the actual data bound is not sorted so the data is messed up! The data I see is d...more >>

Hi, How do I set a filter for a datetime column? I want to get only the rows within a month like this: dv.RowFilter = "CreateDate >= '9/1/2004' AND CreateDate <= '9/31/2004'"; I got this error "Cannot perform '<=' operation on System.DateTime and System.String." instead. Any sugges...more >>

Does anyone have an example of a custom bindingcontext? I want to have the databound controls update the data with each keypress rather than wait for focus to be lost. It seems that a custom bindingcontext might be the solution. John ...more >>

Hi.... Column 'code' does not allow nulls I have a WinForm, When I press the Add Buttom after... I get the above error message...??? The about 'code' is Primary Key and the Data Type is nvarchar.....Please help me how to solver this problem. Many Thanks Here is my Add Buttom program...more >>

I have one Tabcontrol with two tabpages. In each tabpage there's a textbox with it text property binded to a dataset The problem is that the textbox of tabpage 2 is empty till I click on this tab. If I check IsBinding property it is set to False on the second tab and true on the first. Some...more >>

Hi, sorry for cross-posting from the adonet-group. It fits in both I guess. --- I have a real serious problem I can't figure out myself. Here's the pretty plain scenario: I have a DataSet with one table. I created a DataView on that table. I have a Listbox bound to the DataView to sel...more >>

I have some code like the following: foreach (System.Data.DataTable dt in dataSet.Tables) { dataAdapter.Update(dt); } This updates the various datatables in my dataset fine, however, any output parameters don't appear to be updated. For example, if I am in the debugger, and step ...more >>

Urgent Urgent.... I want write a SQL Command for insert data into SQL DataTable...? Ex.... Write SQL Command for insert data from TextBox1, TextBox2 into SQL DataTable1 and then second SQL Command insert data from TextBox3, TextBox4 into SQL DataTable2 ...more >>

Hi, sorry for cross-posting this one from the adonet-group. --- I'm pretty new to Winforms & DataBinding and I'm currently running into a lot of issues. Sorry if this has been explained before. I have a DataSet containing a table 'Member' that holds a lot of columns with info about mem...more >>

Is there an event that must fire if you set the value of an control in code? For example, I have a combobox that is bound to a dataset. If I check/uncheck the combobox, everything is fine during the save. However, when I create a new Row in the dataset, the default value for the checkbox is DB...more >>

I have a dataset that has 5 DataTables in it. I also have a 'working' dataset that is a copy of one of the datatables in the main dataset. I want to be able to call the DataSet.Merge() method, passing the working dataset, and it merge with the appropriate DataTable in the main dataset. Is this...more >>

I have build a form....in the form all is TextBox, Now I have 2 SQLDataAdapter (2 SQL DataTable "cus" & "cust"), When I push down the Updata Buttom, It only updata the "cus" DataTable, the another one "cust" DataTable no response....??? Here is my Updata Segment: --------------------------...more >>