I already watch the video in the vb.net express to learn about the data binding. But the problem that i face is when i want to retrieve certain data from the database. the video just show how to fill and update. who ever know the code to retrieve the selected row from the SQL database using vb.net 2005 thanks
retrieve selected data from SQL database using vb.net
Hot Topic
- Information on Threading
- Installing VS.Net 2k5 Final problem
- Presenting a cross tab table in a portrait format
- Loading Crystal Reports Report, How To Stop Prompt Enter Login ID And Password, This Never Happen Before
- How to set TextBox not to accept input until enter pressed and Select Case not working.
- Checkbox in Datagrid
- DataGridView Delete Row Confirmation
- add item in String() in VB .net
- Bug in ChangeType! 2005 Pre-release
- What's the Difference between Visual Basic Express and Visual Basic 2005
Visual Basic
- Protecting Class Library DLL's?
- Why do the ODBC 3.5.1 and MySQL 3.1.8 drivers not work?
- help !!
- Just wondering is it possible to change the default title of MsgBox?
- No Openforms Property in My.Application
- Breakpoints in Visual Basic.Net Code
- mscomm vb6 --> vs2005
- VB Selecting the lowest Integer
- VB.NET On Other Platforms
- exe file
retrieve selected data from SQL database using vb.net
Jeff Siegel
There are a number of ways to do it but a SQL data reader is one way
http://www.developerfusion.co.uk/show/4278/2/
You can use a dataadapter and simply change the SQL statement so that it picks up a single record - a dataset can consist of only one record. And you don't have to bind the dataset to controls.
Again you can probramatically create the tabledatapter, command etc.
A simple web search on VB + SQLdatareader will reveal a large number of articles
Jim198
Fill is what you use to retrieve a row from SQL, using a data grid control.
The easiest thing is to set the data source as a SQL query, Using for example,
Select * From MyTable Where MyField = 'MyCriteria'
If you do not want to use the grid, or data bound controls, then use a SqlDataReader (or an OLE Data Reader if not using SQL Server)