C#

Kwagga wrote:

I have also re-writtent the currentRow as this which seems to work:
int currentRow = e.RowIndex;

Kwagga wrote:

The error seems to come in here:
string taskstring = dataGridView1[0, currentRow].Value.ToString();

private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
    int currentRow = e.RowIndex;
    int rowint = 0;
    dt.Clear();

    try
    {
        conn.Open();

        string taskstring = dataGridView1[0, currentRow].Value.ToString(); //This is where the error is.

Kwagga wrote:

string taskstring = dataGridView1[0, currentRow].Value.ToString(); /

Luc Pattyn wrote:

make sure your development tools (Visual Studio or other) ALWAYS show line numbers in editor windows.

OriginalGriff wrote:

How are you doing today?

OriginalGriff wrote:

You don't need to do this

Luc Pattyn wrote:

a major chess tournament is about to start.

Luc Pattyn wrote:

I can't find the hidden message I'm sure you must have hidden in there

Luc Pattyn wrote:

those few characters on each line are the most useful data in there

private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
    int currentRow = e.RowIndex;
    int rowint = 0;
    try
    {
        string taskstring = dataGridView1[0, currentRow].Value.ToString();
        rowint = int.Parse(taskstring);
        if (dataGridView1.Columns[e.ColumnIndex] == deleteButton && currentRow >= 0)
        {
            if (conn.State == ConnectionState.Open)
            {
                conn.Close();
            }
            else
            {
                conn.Open();
                OleDbCommand sqlDelete = new OleDbCommand("DELETE FROM tblTasks where TaskCode = @rowint", conn);
                OleDbParameter param = new OleDbParameter();
                param.ParameterName = "@rowint";
                param.Value = rowint;
                sqlDelete.Parameters.Add(param);
                sqlDelete.ExecuteNonQuery();
                getData();
            }
        }
        if (dataGridView1.Columns[e.ColumnIndex] == editButton && currentRow >= 0)
        {
            if (conn.State == ConnectionState.Open)
            {
                conn.Close();
            }
            else
            {
                conn.Open();
                string updatestring = "Select TaskCode, TaskName, TaskDescription FROM tblTasks WHERE TaskCode = " + rowint + "";
                string taskname = dataGridView1[dataGridView1.Columns["TaskName"].Index, currentRow].Value.ToString();
                string description = dataGridView1[dataGridView1.Columns["TaskDescription"].Index, currentRow].Value.ToString();
                OleDbDataAdapter da = new OleDbDataAdapter(updatestring, conn);
                OleDbCommandBuilder cmdb = new OleDbCommandBuilder(da);
                da.Update(dt);
                string update = "UPDATE tblTasks SET TaskName = '" + taskname + "', TaskDescription = '" + description + "' WHERE TaskCode = " + rowint + "";
                da.UpdateCommand = conn.CreateCommand();
                da.UpdateCommand.CommandText = update;
                da.UpdateCommand.ExecuteNonQuery();
                getData();
            }
        }
        else
        {
            return;
        }

    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message.ToString());
    }
    finally
    {
        conn.Close();
    }
}

OleDbCommand sqlDelete = new OleDbCommand("DELETE FROM tblTasks where TaskCode = @rowint", conn);
OleDbParameter param = new OleDbParameter();
param.ParameterName = "@rowint";
param.Value = rowint;
sqlDelete.Parameters.Add(param);

OleDbCommand sqlDelete = new OleDbCommand("DELETE FROM tblTasks where TaskCode = @rowint", conn);
sqlDelete.Parameters.AddWithValue("@rowint", rowint);

UPDATE mytable SET field1=@F1,field2=@F2 WHERE field3=@F3

cmd.AddWithValue("@F1", "111");
cmd.AddWithValue("@F2", "222");
...

ListBox lb = new ListBox();
lb.Items.Add("Hello");
lb.Items.Add("Goodbye");
string s = lb.Items[1] as string;

OriginalGriff wrote:

It'll be a pipe and carpet slippers next