how do i remove selected row permanently from sql database through datagrid?

Question

i am using vb.net 2003.i am doing my project in vb.net windows application. how do i remove selected row permanently from sql database through datagrid in vb.net windows form during runtime. for example values are in datagrid like name age rollno city ramu 22 68 chennai rajesh 23 70 cbe kamal 21 52 salem arun 25 04 trichy here nameagerollnocity are field name.now i want to remove selected row permanently from sql database through datagrid.In this datagridif i select kamal row(kamal2152salem) meansthat kamal row will remove permanently from sql database.how to do these.i want in vb.net windows applicationnot web application.plz help me.

Wim Devos · Answer

Hello I presume you work with a dataset that connects the database and is then shown in the datagridview and you work connectionless. get the index of the selected row in de datagridview delete that row from the dataset DataTable dt = contactenDataSet.Tables[ ]; DataRow row = dt.Rows[ ]; now sync the database with your dataset using a dataAdapter // this is an example for oledb (ms access) // exept for the driver its the same for other db's OleDbConnection conn = new OleDbConnection(); conn.ConnectionString = // make data adapter OleDbDataAdapter dAd = new OleDbDataAdapter(); // define select query dAd.SelectCommand = new OleDbCommand(SELECT * FROM table conn); // make comman commanbuilder OleDbCommandBuilder cmdBuilder = new OleDbCommandBuilder(dAd); // Define SQL commands // insert - update - delete dAd.InsertCommand = cmdBuilder.GetInsertCommand(); dAd.UpdateCommand = cmdBuilder.GetUpdateCommand(); dAd.DeleteCommand = cmdBuilder.GetDeleteCommand(); // database get updated dAd.Update(contactenDataSet ); contactenDataSet.AcceptChanges(); the example is in c# its thoug c# corner :) if you need more comment just let me know kind regards