prob while deleting row from DataGrid

I have a DataGrid which is binded to a table from DataSet in my application .

m_OleDbDataAdapter = new OleDbDataAdapter();

m_DataSet = new DataSet();

m_OleDbConnection.Open();

m_OleDbDataAdapter.SelectCommand = new OleDbCommand("SELECT * FROM INPUTTABLE",m_OleDbConnection);

m_OleDbDataAdapter.Fill(m_DataSet,"INPUTTABLE");

m_OleDbCommandBuilder = new OleDbCommandBuilder(m_OleDbDataAdapter);

m_dataView.Table =m_DataSet.Tables[0];

m_dataGrid.DataSource =m_DataSet.Tables[0];

m_OleDbConnection.Close();

I have a delete button which delete seleted row from datagrid

private void btnDelete_Click(object sender, System.EventArgs e)

{

int rowno = m_dataGrid.CurrentCell.RowNumber;

m_DataSet.Tables[0].Rows[rowno].Delete();

}

I have another datagrid which shows only deleted row for wich i set the RowStateFilter prop to deleted

m_dataView.Table =m_DataSet.Tables[0];

m_dataView.RowStateFilter =DataViewRowState.Deleted;

dataGrid1.DataSource =m_dataView;

The update code for database is

private void btnUpdate_Click(object sender, System.EventArgs e)

{

try

{

m_OleDbDataAdapter.Update(m_DataSet,m_DataSet.Tables[0].TableName);

m_DataSet.AcceptChanges();

}

catch(Exception ex)

{

MessageBox.Show(ex.Message);

Trace.WriteLine(ex.Message);

}

finally

{

m_OleDbConnection.Close();

}

)

Now the prob is when i click delete button it deletes the rows from datagrid but it doesn;t show deleted row in another datagrid & also the changes doesn't set to database either

any suggestions

Answer this question