Updating database in vb Hot and sexty dating web templates
Java Student Information System Java Contacts Management System Java Inventory Management System Java Hotel Management System C# Inventory Management System C# Student Information System C# Contacts Management System C# Hotel Management System VB.
Fortunately, the Configure Data Source wizard provides an option to have the statements checkbox will only be checkable if the table selected has a primary key and the primary key column (or columns) are included in the list of returned columns.
After checking the Generate statements checkbox, click OK to return to the Configure Select Statement screen, then click Next, and then Finish, to complete the Configure Data Source wizard.
Upon completing the wizard, Visual Studio will add Bound Fields to the Details View for the " Delete Command= "DELETE FROM [Products] WHERE [Product ID] = @Product ID" Insert Command= "INSERT INTO [Products] ([Product Name], [Unit Price], [Discontinued]) VALUES (@Product Name, @Unit Price, @Discontinued)" Select Command= "SELECT [Product ID], [Product Name], [Unit Price], [Discontinued] FROM [Products]" Update Command= "UPDATE [Products] SET [Product Name] = @Product Name, [Unit Price] = @Unit Price, [Discontinued] = @Discontinued WHERE [Product ID] = @Product ID".
Select the Delete Query property, which will bring up a set of ellipses.
Figure 2: Select the Delete Query Property from the Properties Window provide a value for this parameter (leave its Parameter source at None ).