Similarly a Dataset has no knowledge of the Data Source where the data coming from. OLEDB.4.0; Data Source=Your mdb filename;" connection = New Ole Db Connection(connetion String) Sql = "select * from tbl Users" Try connection. So the Ole Db Data Adapter manage the communication between these two Objects. Open() oledb Adapter = New Ole Db Data Adapter(Sql, connection) oledb Adapter. NET support meets the different requirements of workflow and the specifications of the various applications.It allows users updating the data base while the end user is up to exit the applications, or click a special button.There are a lot of tutorial on the web about taking data from the SQL database and show it in a Data Gridview.A good tutorial about taking data from SQL databases is also given at
When the end users add a new row to the grid, the Grid View is able to update the database too.
Make sure that make any one filed primary key, generally Roll No is set as PK because of unique identification than other field. Open your visual studio of any version and then go to file new and then click on project.
Then new window will appear and from the left pane select visual c#. To do this, right click on reference select add reference and the click on extension then scroll down and find the My and click on check box and click ok. Go to the file of your form and import namespce as: 6.
and then select the length as well as data type as your requirement and then click on save. Close(); My Sql Connection con = new My Sql Connection("server=localhost;user id=root;database=projectmysql"); con. Open(); My Sql Command cmd = new My Sql Command("UPDATE `projectmysql` SET `name`='" txtname.
You can watch the video for this designing part, you may understand better in video. Open(); My Sql Command cmd = new My Sql Command("DELETE FROM `projectmysql` WHERE rollno ='" txtroll.