Input string was not in a correct format.

put a try catch and you'll be fine.

If ck1.Checked = True Then
             dim d as Decimal = 0
             try
                d = Decimal.Parse(row.Cells(2).Text)
             catch ex as exception
               d = 0
             end try
             If d <> 21 Then
                 Session("ierr_code_id") = Decimal.Parse(row.Cells(2).Text)
                 GridView1.EditIndex = currentrow

Hi, you should use all database with prefixed table names like :

      Select             *
      FROM             DB1.DBO.tblUsers tu
      inner join DB2.DBO.Users u on tu.username=u.username

or go through the following link:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=77234

Sorry i put my comments at wrong place.

where do u have the code? If you have it within any event for the grid .. then yiou would need this line to see which row is been processed ..

If e.Row.RowType = DataControlRowType.DataRow Then
If ck1.Checked = True Then
If Decimal.Parse(row.Cells(2).Text) <> 21 Then

oncheckchanged event for checkbox, I have this code.

As others suggested, the problem happened when Decimal.Parse() encountered some text that cannot be translated into decimal.  In that case, you should handler this error by

Dim d as decimal

If Decimal.TryParse(row.Cells(2).Text, d) Then
    'can be parsed successfully
   If d <> 21 Then
          Session("ierr_code_id") = d
          GridView1.EditIndex = currentrow
   Else
          ' handle when d=21
   EndIf
Else
   'Handle when text is not recognized as decimal
EndIf

This is better than catching exception because raising and catching exception required much more overhead.

Edwin,it shows that my d is 0D now with this code above. And with yours it complains that
 If e.Row.RowType = DataControlRowType.DataRow Then  e.row is not a member of system.eventargs.

if it is checkchanged event for the checkbox and not for the gridview, then it will give the error as mentioned above .. so can u pls post the whole code that event so that I can suggest the correction ..

Rejo

thank you all for help

so did you manage to correct it? If yes, can you please post the solution?

Oh my God, I finally did it. Yes, I can post the code. If anybody has any problem converting datagrid to gridview, that is the way works!

In checkchanged event handler

Dim ck1 As CheckBox = CType(sender, CheckBox)
        If ck1.Checked = True Then
            Dim row As GridViewRow = CType(ck1.Parent.Parent, GridViewRow)
            Dim currentrow As Integer = row.RowIndex

            If Decimal.Parse("0" & row.Cells(2).Text) <> 21 Then

                Session("code_id") = Decimal.Parse("0" & row.Cells(2).Text)
                GridView1.SelectedIndex = currentrow
                GridView1.EditIndex = currentrow
                               BindGrid()
            End If
        End If

        Fill_DropDown()
        GridView1.EditIndex = -1
end sub

this two lines are take me long time to figure it out..
 GridView1.SelectedIndex = currentrow
 GridView1.EditIndex = currentrow
before I was doing like this one only and was not working at all.
 GridView1.EditIndex = currentrow
I hope someelse can get benefit from this code too.

It seems you did not solve your first problem "Input string was not in a correct format"

If you enter "one" in row.Cells(2), then you will get the error again.