The following example uses the Sql Command, Sql Data Adapter, and Sql Connection to select records from a database and populate a Data Set with the selected rows. To accomplish this, the method is passed an initialized Data Set, a connection string, and a query string that is a Transact-SQL SELECT statement.
Public Function Select Rows( _ By Val data Set As Data Set, By Val connection String As String, _ By Val query String As String) As Data Set Using connection As New Sql Connection(connection String) Dim adapter As New Sql Data Adapter() adapter.
Command Name will have the name of the command, so tha tyou know which button was clicked.
Thanks for choosing Dev Express for your software development needs.
We are your extended team and are working hard to make certain you have all the resources necessary to build your next great app.
Should you have any questions or wish to provide feedback on our documentation, feel free to email us at [email protected]
Grid View displays the values of a data source in a table where each column represents a field and each row represents a record.
I need to save a textbox comments field, and a dropdownlist status field for each row the save button is clicked on.
(The save is an update to a SQL Server database.) My gridview is working fine, but I can't figure out the save button functionality. "The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years.
I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing.
Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.