Almost on a daily basis we run across posts that ask about using a . Oh it might have a slight variation like “How do I load a value from a database into a textbox?” or “How do I read a database into _______ control and then update the database?Nothing much to see here other than how to create the class and use a connection string to tell the connection where to find the database.
So how do we get this stupid name column out of our table “Employees” of the access database and into a control? One is to connect to the database, another thing is to query the database for the info and lastly we put that info into our source control… Connecting to the database is pretty straight forward and really starts out with picking the right connection object from the System. Since Access can be “accessed” through the OLEDB setup we can use the Ole Db Connection class for that. This is nothing but a string that tells the class where to find the database, what driver (or DSN) to use, any username and passwords to login to the database, and any security features we will need to implement for our access.It is also good in that it is directly tied to the dataset itself.So if we modify the dataset, the listbox automatically changes as well.Another beautiful thing about using a Reader to move through data is because they are “forward only”.Since you can only move to the next record at a time and can’t go back, .Just like you can give each option item in HTML select boxes a different value than its actual list item name.The advantage of this method is that it is a quick “dump all the info here” method.Like if we wanted to make sure that each name is properly capitalized we could do that before adding it to the list Box1. The last method here for selecting data is using a command object and fetching what is called a “Reader”.This method is especially common because the command object is very flexible and good not only for select queries, but for updates, inserts and delete queries as well. We will use it again to show you a simple update in a second. But I want to do it using Datagrid View I already bind it to my database.How do I add,edit,delete update my database in datagridview using codes?