Guys,

I get this error: -

Compiler Error Message: CS1513: } expected

Heres my code: -

private void Page_Load(object sender, EventArgs e)
{
    if(!IsPostBack)
    {
          DataGridFill();
    }
}

private void DataGridFill()
{

    DataSet objDataSet = new DataSet();
    objConnection = new OleDbConnection(strConnection);
    objAdapter = new OleDbDataAdapter(Select, objConnection);


    try
    {
        objConnection.Open();
        objAdapter.Fill(objDataSet, "Comments");
        dgComments.DataSource = objDataSet.Tables["Comments"];

    }
    catch(Exception Ex)
    {
        Response.Write(Ex.Message);
        Response.End();
    }
    finally
    {
        dgComments.DataBind();
        objConnection.Close();
    }
}

//public void EditRecord(object sender, DataGridCommandEventArgs e)
//{
// dgComments.EditItemIndex = e.item.ItemIndex;
// DataGridFill();
//}

private void DeleteRecord(Object sender, DataGridCommandEventArgs e)
{
    //Retrieve the value in the table
    int CommentID = Convert.ToInt32(e.Item.Cells[0].Text);
    DataSet objDataSet = new DataSet();
    objConnection = new OleDbConnection(strConnection);

    dgComments.EditItemIndex=-1;

    UpdateDataGrid(CommentID);

    dgComments.DataSource = objDataSet.Tables["Comments"];
    dgComments.DataBind();
}



private void UpdateDataGrid(long CommentID)
{
    objConnection = new OleDbConnection(strConnection);
    objConnection.Open();
    objAdapter = new OleDbDataAdapter(Select, objConnection);
    DataSet objDataSet = new DataSet();
    objAdapter.Fill(objDataSet, "Comments");
    objConnection.Close();

    DataTable tbl = objDataSet.Tables["Comments"];
    tbl.PrimaryKey = new DataColumn[]{tbl.Columns[CommentID];}
    DataRow row = tbl.Rows.Find[CommentID];
    row.Delete();

    OleDbCommandBuilder objBuilder = new OleDbCommandBuilder(objAdapter);
    objConnection.Open();
    objAdapter.Update(objDataSet, "Comments");
    objConnection.Close();
}

Any ideas??

Adz - The World is not enough

__________________
Adz - Learning The J2EE Ways.

Something doesn't look right with this line:

    tbl.PrimaryKey = new DataColumn[]{tbl.Columns[CommentID];}

Not sure what, I work with VB more than C#, but something just strikes me as odd with it.

Peter
------------------------------------------------------
Work smarter, not harder.

Not a C# developer either but move the ';' to the other side of the '}' and try that.

guys,

I have tried another method but it is not deleting my records: -

private void DeleteRecord(Object sender, DataGridCommandEventArgs e)
{
  objConnection = new OleDbConnection(strConnection);
  String strSQL = "DELETE FROM Feedback WHERE CommentID = '?' ";
  OleDbCommand objCommand = new OleDbCommand(strSQL, objConnection);
  objConnection.Open();
  objCommand.Parameters.Add("Comment", OleDbType.VarChar, 32, "Comment");
  int CommentID = Convert.ToInt32(e.Item.Cells[0].Text);
  objCommand.Parameters["Comment"].Value = CommentID.ToString();
  DataGridFill();
  objConnection.Close();

any ideas??

Adz - The World is not enough

I take it back, that will definently not work, right now how to I get this to delete from the data grid??

Adz - The World is not enough

Guys,

I have tried a different method but Igot this error: -

Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index

This is my code: -
private void DeleteRecord(Object sender, DataGridCommandEventArgs e)
{
    objConnection = new OleDbConnection(strConnection);
    string strSQL = "DELETE FROM FeedBack WHERE CommentID = '" + dgComments.DataKeys[e.Item.ItemIndex] + "'";
    OleDbCommand objCommand = new OleDbCommand(strSQL, objConnection);
    objConnection.Open();

      objCommand.ExecuteNonQuery();
      dgComments.EditItemIndex=-1;
      DataGridFill();
      objConnection.Close();

any ideas??



Adz - The World is not enough

This almost looks like the datakeys collection is empty. But that doesn't make any sense. You got me stumped.

Peter
------------------------------------------------------
Work smarter, not harder.

Is the datakeys coming from the dataset or the datagrid? In one of my apps I had to tell the datagrid which one was the datakey like this:

<asp:DataGrid DataKeyField="id" ...

Nice one Stu,

think that that has solved the proble, right the next error I get is the following: -

Data type mismatch in criteria expression.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Data type mismatch in criteria expression.

Source Error:


Line 62: objConnection.Open();
Line 63:
Line 64: (This line is highlighted)objCommand.ExecuteNonQuery();
Line 65: dgComments.EditItemIndex=-1;
Line 66: DataGridFill();

Any ideas




Adz - The World is not enough

The problem is in the SQL Statment. You probably are missing some quotes or something.