emaduddeen

Hi Everyone, Can you reply with a tutorial and maybe a sample project that can be downloaded that shows how to update a database such as MS Access from DataAdapter commands in which changes are made in a DataGridView? For example, the DataAdapter contains 2 tables called FirstTable and the …

Hi Everyone. Can you show me what the most effecient way to load data from a data adapter in textboxes would be? I heard that binding data to the textboxes is a better way but this is how I have been doing it so far: [CODE] ' Compose the SELECT …

Hi Everyone, In my form there is a "Validating" event on a textbox. This form also has a "Cancel" button. Is there a way to not execute the "Validating" event when the user clicks on the "Cancel" button? Please show me code to do this. Thanks. Truly, Emad

Hi Everyone, I'm doing a point of sale application and would like to add code to my "Save" button that will insert data into the database. The form will first lookup a customer and set up data for an invoice header. The customer will be able to select products and …

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: [CODE] CategoryNumber ---------------- 10 20 30 40 50 [/CODE] If the user enters 35 …

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 …

Hi Everyone, I have a form with multiple tabs that allows the user to insert data into a customer table. The ID is an Identity column. After a row is inserted into the database I would like to retrieve the ID number for that row that was just inserted into …

Hi Everyone, Can you help me out of a concurrency violation error? It happens on this statement: [CODE] objDataAdapterCustomerDetails.UpdateCommand = _ objCommandBuilderParentDetails.GetUpdateCommand [/CODE] It thinks I'm using a key value of 1 when the actual value is really 1218. I'm using a command builder and I'm also new to doing …

Hi Everyone, I'm using MS Access as the database and using a command builder. .GetInsertCommand get the correct insert command text but .GetUpdateCommand gets the wrong command text. It even returns a primary key value of 1 which is not the actual value it should be. In order to get …

Hi Everyone, Can you look at this code because I am sure I'm missing something. I am trying to reset a Dataset. I have a form that has 1 text box and has 2 queries that locate the data. One is by customer ID and the other is by customer …

Greetings Everyone, In the TableAdapter configuration wizard I am using this query: [CODE] SELECT AttendanceID, StudentID, ClassId, DateOfClass, Absent FROM Attendance WHERE (DateOfClass BETWEEN #5/1/2010# AND #5/30/2010#) [/CODE] Can you tell me the correct syntax to change the #5/1/2010# AND #5/30/2010# so the WHERE clause uses dteStartDate AND dteStartDate which …

Greetings Everyone, We have many forms in an Attendance application I am writing for a local school. The first form is called formBrowseAttendance and the other form is called formBrowseStudents. In formBrowseAttendance is a textbox called editBoxStudentID. Inside the double click event of a grid in the formBrowseStudents I am …

Greetings Everyone, Can you tell me how to take a query that returns a single row of data and load that data into textbox controls. I know about ExecuteScalar but it is only good for a single column of data from the query. Thanks. Truly, Emad

Greetings Everyone, I have several forms in my project and I have set the IsMdiContainer property to True on my main form. This project also is not using a menu system. Instead I'm using a 3rd party ribbon control with buttons that call the other forms in the project. Can …

Hi Everyone, There are so many controls, properties, etc in VB 2008 .NET it's mind boggling. I'm amazed at how much this product can do. Does anyone know of a VB 2008 .NET book that describes in simple language and shows sample code for all of those controls, properties, etc? …

Hi Everyone, I never did custom events and would like to make a sub procedure execute via a custom event from another form that does not have the custom event defined. For example I would like to raise the event from my ok button in one form and have the …

Hi Everyone, Can you tell me how to change this code so the value in my DatePicker control will update to the database in this update statement? [CODE] strAttendanceUpdateStatement = _ "UPDATE Attendance " & _ "SET DateOfClass = " & DatePickerDateOfClass.Value & ", " & _ "Absent = " …

Hi Everyone, I would like to know how to make a DataView global to a particular form. The DataView is currently created and returned from a function within a public class residing in another .vb module. All help will be appreciated. Thanks. Truly, Emad Here's what the code in the …

Hi Everyone, Can you tell me how do I set up create Insert, Update and Delete commands for your a DataAdapter? I'm using a DataGridView to allow the user to view, change and delete data rows and would like to be able to save any changes made in the grid …