Search results for query: *

Hi Everyone, I have an app that opens up 3 forms. 2 forms have a datagrid the other form has book lending details. The datagrid forms are for books in the library and books that have been borrowed. Both datagrid forms will be open as shown in the attachment, how do I refresh the "Borrowed...

Hi Everyone, I wanted to re-configure a DataAdapter and VS 2010 allowed me to change the Select statement in the wizard and all appeared ok until I tried to run the app. The attachment shows the error. After saving the app after many time clicking the Ok button many times I loaded the app...

Hi Everyone, I'm using the book titled "Database Programming with Visual Basic® .NET and ADO.NET: Tips, Tutorials, and Code". I'm going through the chapter that has me do data binding by setting the properties of a DataGrid and TextBoxes. It had me drag a DataAdapter onto the form using the...

Hi Everyone, I'm looking to see if anyone has a sample app or has a link to such an app that uses data binding with a grid control and textboxes and is able to insert, change and delete from a datatable which gets updated to a sql server database. I have done an app that has the grid control...

How do I test an amount entered into a textbox is <= the largest number in a table? Hi Everyone, Can you tell me how to fix my query so I can determine if an amount entered into a textbox is < the largest number in a database table? Here is some sample data: CategoryNumber ----------------...

Hi Everyone, I have a table that has a 2 column primary key. I set up the key where the 2nd column is an identity column. When I ran my VB application I discovered the ID (2nd column) did not increment the correct way. I was hoping it would increment like this: Category ID 50001...

Hi Everyone, I have a button with DialogResult OK set. I'm using the following code to try and do validation: Private Sub ButtonSaveChanges_Validating(ByVal sender As System.Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles ButtonSaveChanges.Validating If...

Hi Everyone, Can you tell me what is the best hand coded way to display data from the database into textboxes? Currently I'm using a data adapter, data set, with a parameter. After I fill the dataset, I load the data into the textboxes using this code as an example...

Hi Everyone, In one of the forms is a Parent / Child situation. The program inserts the parent then allows the children to be inserted or updated. The parent and children are related by an autonumber database table column called CustomerID. After a parent is inserted into the database I...

Hi Everyone, I have seen that there are so many ways to get data from a database onto a form such as a DadatReader, DataSets, DataAdapters, Binding data to the TextBoxes etc. Can you tell me the best way to do this because the more I read the more confused I get on not knowing the best way to...

Hi Everyone, My user wants to have textbox fields that don't have any masks but wants those text fields to reformat any text that is entered as mm/dd if it is a real date entered. They won't be using the year. Could you show me what coding I need to use to do this? Thanks. Truly, Emad

Hi Everyone, Can you help me out of a concurrency violation error? It happens on this statement: objDataAdapterCustomerDetails.UpdateCommand = _ objCommandBuilderParentDetails.GetUpdateCommand It thinks I'm using a key value of 1 when the actual value is...

Hi Everyone, Can you help me fix a query that returns the wrong results? The query does execute but it returns the wrong results. My form has a single text box where the user enters a value. This value may be a customer ID, or it could be a last name or even a phone number. I would like to...

Hi Everyone, Can you look at my code and tell me what I'm doing wrong? I get a "Failed to convert parameter value from a string to a int32" error. I have a form with a "Search" text box and "Search" button that is supposed to load a data grid with data if the search is successful. If the...

Hi Everyone, Can you tell me what event is fired when the user moves the highlight bar in a data grid control? Also this next question is related to the first question. I would like to detect when a user changes a value in one of the many text box controls on my form but don't want to write...

Getting "OleDbCommand.Prepare method requires all parameters to have an explicitly... Hi Everyone, I am using dataset to update/insert the data in the database. Whenever its about to update the dataset, it gives me the following error: "OleDbCommand.Prepare method requires all parameters to...

Hi Everyone, I need help in the syntax to pass parameters to an MS Access query. Here is the code I use. It works in SQL Server but fails with a "No value given for one or more required parameters" error. I'm assuming SQL Server syntax does not work with MS Access even though they are both...

Hi Everyone, I used TOAD to create a new sql server 2008 database and can see it in the navigation tree. Can you tell me what sql commands I need to execute so it can have a user name and password so I can include that into my VB connection string? Also, can I do the same thing inside visual...

Hi Everyone, Should I let a DataAdapter open a connection multiple times? I'm trying to figure out the best way to handle this: My form contains a DataGrid and many TextBox controls and everytime the user moves the highlight bar on the DataGrid I display detail data representing the...

Hi Everyone, Can you tell me where does VS install the compact framework cab files for Windows CE 6.0 ? I would like to copy this to my mini netbook pc because an installed program requires it to be installed. Thanks. Truly, Emad