Gridview compilation Error

Question

0.00/5 (No votes)

See more:

Hi
I have a "Compilation Error" in Gridview control. Below is my code.
gv is gridview control. pls help Me.

Compilation Error

Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: BC30455: Argument not specified for parameter 'index' of 'Public ReadOnly Default Property Item(index As Integer) As System.Web.UI.WebControls.GridViewRow'.

Source Error:
Line 18: 'Dim myGridItem As DataGridItem
Line 19: Dim myGridItem As New GridView
Line 20: For Each myGridItem In gv.Rows.Item
Line 21: If CType(myGridItem.Cells(0).Controls(0), CheckBox).Checked = True Then
Line 22: cmd.Parameters.AddWithValue("@UserName", Me.txtUserName.Text)

Here is code

C#

Try
   Dim cmd As New SqlCommand("usp_UserRight_Insert", conn)
   cmd.CommandType = CommandType.StoredProcedure
   'Dim myGridItem As DataGridItem
   Dim myGridItem As New GridView
     For Each myGridItem In gv.Rows.Item
        If CType(myGridItem.Cells(0).Controls(0), CheckBox).Checked = True Then
           cmd.Parameters.AddWithValue("@MenuName", Me.gv.SelectedRow.Cells(1).Text)
           cmd.Parameters.AddWithValue("@MenuLink", Me.gv.SelectedRow.Cells(2).Text)
           Dim da As New SqlDataAdapter(cmd)
           Dim dt As New DataTable
           da.Fill(dt)
         End If
     Next
Catch ex As Exception
      MsgBox("Error:" & vbCrLf & ex.Message)
Finally
      conn.Close()
End Try

Pls Help me

thanks
Maideen

Posted 21-Oct-12 15:30pm

Maideen Abdul Kader

Updated 6-Jul-19 16:02pm

AshishChaudha

v2

Add a Solution

2 solutions

Solution 2

SQL

For i = 0 To GridView1.Rows.Count - 1
    If DirectCast(GridView1.Rows(i).FindControl("chk"), CheckBox).Checked() Then
        Dim row As GridViewRow = GridView1.Rows(i)
        cmd = New SqlCommand
        cmd.Connection = conn
        cmd.CommandText = "INSERT INTO Z_User_MenuVSGroup(menu_id, menu_name, menu_parent_id, menu_url, group_code) Values(@menuid,@menuname,@menuparentid,@menuurl,@groupcode)"
        cmd.CommandType = CommandType.Text
        conn.Open()
        Try
            cmd.Parameters.AddWithValue("@menuid", row.Cells(1).Text)
            cmd.Parameters.AddWithValue("@menuname", row.Cells(2).Text)
            cmd.Parameters.AddWithValue("@menuparentid", row.Cells(4).Text)
            cmd.Parameters.AddWithValue("@menuurl", row.Cells(5).Text)
            cmd.Parameters.AddWithValue("@groupcode", UCase(Me.cboDesigCode.SelectedValue))

            cmd.ExecuteNonQuery()
        Catch ex As Exception

        Finally
            cmd = Nothing
            conn.Close()

        End Try

    End If
Next

Posted 6-Jul-19 16:03pm

Maideen Abdul Kader

Comments

CHill60 7-Jul-19 9:59am

It took you 7 years to find a solution? :-O

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

manak chand · Accepted Answer · 2012-10-21T19:14:00

Solution 1

If CType(myGridItem.Cells(0).Controls(0), CheckBox).Checked

should be

If CType(myGridItem.rows(0).FindControl("Controlname"), CheckBox).Checked

Posted 21-Oct-12 19:14pm

manak chand

Comments

Member 14188766 6-Jul-19 2:09am

an error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.