Click here to Skip to main content
15,899,026 members
Home / Discussions / C#
   

C#

 
GeneralMessage Removed Pin
14-Aug-10 0:26
yum 201014-Aug-10 0:26 
GeneralRe: sever is not displaying the content that " you have left the chat room".... Pin
OriginalGriff14-Aug-10 2:01
mveOriginalGriff14-Aug-10 2:01 
GeneralRe: sever is not displaying the content that " you have left the chat room".... Pin
yum 201014-Aug-10 7:45
yum 201014-Aug-10 7:45 
GeneralRe: sever is not displaying the content that " you have left the chat room".... Pin
yum 201014-Aug-10 7:49
yum 201014-Aug-10 7:49 
GeneralRe: sever is not displaying the content that " you have left the chat room".... Pin
OriginalGriff14-Aug-10 8:49
mveOriginalGriff14-Aug-10 8:49 
GeneralRe: sever is not displaying the content that " you have left the chat room".... Pin
Luc Pattyn14-Aug-10 9:05
sitebuilderLuc Pattyn14-Aug-10 9:05 
GeneralRe: sever is not displaying the content that " you have left the chat room".... Pin
OriginalGriff14-Aug-10 9:24
mveOriginalGriff14-Aug-10 9:24 
GeneralRe: sever is not displaying the content that " you have left the chat room".... Pin
Luc Pattyn14-Aug-10 9:27
sitebuilderLuc Pattyn14-Aug-10 9:27 
GeneralRe: sever is not displaying the content that " you have left the chat room".... Pin
OriginalGriff14-Aug-10 9:35
mveOriginalGriff14-Aug-10 9:35 
GeneralRe: sever is not displaying the content that " you have left the chat room".... Pin
yum 201015-Aug-10 8:11
yum 201015-Aug-10 8:11 
QuestionGet cell value from GridView Pin
treuveni13-Aug-10 12:45
treuveni13-Aug-10 12:45 
AnswerRe: Get cell value from GridView Pin
PIEBALDconsult13-Aug-10 17:55
mvePIEBALDconsult13-Aug-10 17:55 
GeneralRe: Get cell value from GridView Pin
treuveni13-Aug-10 21:03
treuveni13-Aug-10 21:03 
AnswerRe: Get cell value from GridView Pin
maddahi.m.p14-Aug-10 0:29
maddahi.m.p14-Aug-10 0:29 
QuestionMessage Removed Pin
13-Aug-10 11:53
Tichaona J13-Aug-10 11:53 
AnswerRe: Playing a list of files on after the other. Pin
AspDotNetDev13-Aug-10 12:22
protectorAspDotNetDev13-Aug-10 12:22 
QuestionHow to properly show text for URL link using RichTextBox to output into RTF format? Pin
jboyd11113-Aug-10 10:53
jboyd11113-Aug-10 10:53 
QuestiondataGridView1_CellContentClick Error Index Out of Range Pin
MumbleB13-Aug-10 10:27
MumbleB13-Aug-10 10:27 
Hi Guys. I have been trying to resolve an error I keep getting. I have an app with a number of forms. Most of the forms has a datagridview with edit and delete buttons. Most of them work fine but on two of the most simpler forms it just for some reason doesn't seem to work. Whenever I click on any of the column I get the following error:
Index out of range. must be non-negative and less than the size of the collection. Parameter name : index.

The same code I am using here works on other forms but not on this one.

Below is the code I am using.
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
    int currentRow = int.Parse(e.RowIndex.ToString());
    int rowint = 0;
    dt.Clear();
    try
    {
        conn.Open();
        string taskstring = dataGridView1[0, currentRow].Value.ToString();
        rowint = int.Parse(taskstring);
        if (dataGridView1.Columns[e.ColumnIndex] == deleteButton && currentRow >= 0)
            //if(dataGridView1.Rows[e.RowIndex].Cells = 1)
        {

            string queryDeleteString = "DELETE FROM tblTasks where TaskCode = " + rowint + "";
            OleDbCommand sqlDelete = new OleDbCommand();
            sqlDelete.CommandText = queryDeleteString;
            sqlDelete.Connection = conn;
            sqlDelete.ExecuteNonQuery();
        }
        else if (dataGridView1.Columns[e.ColumnIndex] == editButton && currentRow >= 0)
        {
            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();
        }
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message.ToString());
    }
    finally
    {
        conn.Close();
        getData();

    }
}


Can anybody see anything here that would cause the problem? As mentioned, the same code works on other forms that have much more columns and data on it. Only two fo the forms don't seem to work with this code. Confused | :confused:
Excellence is doing ordinary things extraordinarily well.

AnswerRe: dataGridView1_CellContentClick Error Index Out of Range Pin
OriginalGriff13-Aug-10 10:39
mveOriginalGriff13-Aug-10 10:39 
GeneralRe: dataGridView1_CellContentClick Error Index Out of Range Pin
MumbleB13-Aug-10 11:02
MumbleB13-Aug-10 11:02 
GeneralRe: dataGridView1_CellContentClick Error Index Out of Range Pin
MumbleB13-Aug-10 11:18
MumbleB13-Aug-10 11:18 
GeneralRe: dataGridView1_CellContentClick Error Index Out of Range Pin
OriginalGriff13-Aug-10 22:59
mveOriginalGriff13-Aug-10 22:59 
GeneralRe: dataGridView1_CellContentClick Error Index Out of Range Pin
MumbleB14-Aug-10 3:41
MumbleB14-Aug-10 3:41 
AnswerRe: dataGridView1_CellContentClick Error Index Out of Range Pin
Luc Pattyn13-Aug-10 14:00
sitebuilderLuc Pattyn13-Aug-10 14:00 
GeneralRe: dataGridView1_CellContentClick Error Index Out of Range Pin
MumbleB13-Aug-10 21:50
MumbleB13-Aug-10 21:50 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.