C# OleDB Delete Command

Question

I am currently creating an window application connected with a Microsoft Access database to perform CRUD operation for the business related to education

One of the workflow is to search the keyword and perform CRUD operation in the DataGrid View At first , I am trying to display the datagrid view of the record ( such as students , time to take course, what course...e.t.c.) with respect to the receipt number

The application logic is to get the receipt number in the datagrid View and perform delete operation

So my question is

How to get the value of the receipt number column in the selected row of the datagrid view?
There are OleCommands and OleDataAdapter to perform the CRUD operation. Which method shall I use ?

The following is the code for the delete operation

        public void delete_course_transaction(string receipt_no)
    {
        OleDbDataAdapter oledbAdapter = new OleDbDataAdapter();
        try
        {

            using (OleDbConnection connection = new OleDbConnection(connectionDBString))
            {
                string sql = "delete from COURSE_TAKE where COURSE_TAKE.RECEIPT_NO = '" + receipt_no + "'";
                connection.Open();
                oledbAdapter.DeleteCommand = connection.CreateCommand();
                oledbAdapter.DeleteCommand.CommandText = sql;
                int rows = oledbAdapter.DeleteCommand.ExecuteNonQuery();
                if (rows > 0)
                {
                    MessageBox.Show("Delete Course transaction Success!");
                }
            }
        }
        catch (Exception e)
        {
            MessageBox.Show(e.Message);
        }
    }

Sirwan Afifi · Accepted Answer · 2012-12-01 06:14:39Z

2

If I understand correctly :

for your first question you can use this code :

txtName.Text = dataGridView1[0, dataGridView1.CurrentRow.Index].Value.ToString();

and your second question : refer here :http://forums.asp.net/t/706106.aspx/1

answered Dec 1, 2012 at 6:14

Sirwan Afifi

10.8k14 gold badges67 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Jeff Bootsholz Over a year ago

how about returning the name of column in the datagridview when a particular cell is selected

Sirwan Afifi Over a year ago

@LoWaiLun use this code : txtName.Text = dataGridView1.Columns[e.ColumnIndex].HeaderText;

Sirwan Afifi Over a year ago

@LoWaiLun in dataGridView1_CellClick event.

Collectives™ on Stack Overflow

C# OleDB Delete Command

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related