data is inserting twice in database

Hi,
Please post your code.

Regards,
Lakshmi Naraayanan.S
http://dotnettechrocks.blogspot.in/
http://abaprocker.blogspot.com/

hareeshkumarkr-16190, if this helps please login to Mark As Answer. | Alert Moderator

My code :

If e.CommandName = "vmore" Then
Dim index As Integer = Integer.Parse(e.CommandArgument.ToString())
Dim gr As GridViewRow = GridView1.Rows(index)
'Dim btn1 As MultiView = DirectCast(gr.FindControl("MultiView1"), MultiView)
Dim imgbtnsvm As ImageButton = DirectCast(gr.FindControl("vmore"), ImageButton)

Dim lblslno As Label = DirectCast(gr.FindControl("lblslno"), Label)

Call viewdetails(Integer.Parse(lblslno.Text))

End If

Private Sub viewdetails(ByVal sl As Integer)

con.Open()
Dim cmd As SqlCommand = con.CreateCommand
cmd.CommandText = "Home_userrecordhit_spinsert"
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.AddWithValue("@mtid", sl)
cmd.Parameters.AddWithValue("@useremailid", usrid)

cmd.ExecuteNonQuery()

con.Close()

End Sub

hareeshkumarkr-16190, if this helps please login to Mark As Answer. | Alert Moderator

Hi,
Could you post your code here. or try by debugging it with break points. so that you can trace the things.

Regards,

Awesome Coding !! :)

hareeshkumarkr-16190, if this helps please login to Mark As Answer. | Alert Moderator

HI
@ VASANTH

My code :

If e.CommandName = "vmore" Then
Dim index As Integer = Integer.Parse(e.CommandArgument.ToString())
Dim gr As GridViewRow = GridView1.Rows(index)
'Dim btn1 As MultiView = DirectCast(gr.FindControl("MultiView1"), MultiView)
Dim imgbtnsvm As ImageButton = DirectCast(gr.FindControl("vmore"), ImageButton)

Dim lblslno As Label = DirectCast(gr.FindControl("lblslno"), Label)

Call viewdetails(Integer.Parse(lblslno.Text))

End If

Private Sub viewdetails(ByVal sl As Integer)

con.Open()
Dim cmd As SqlCommand = con.CreateCommand
cmd.CommandText = "Home_userrecordhit_spinsert"
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.AddWithValue("@mtid", sl)
cmd.Parameters.AddWithValue("@useremailid", usrid)

cmd.ExecuteNonQuery()

con.Close()

End Sub

hareeshkumarkr-16190, if this helps please login to Mark As Answer. | Alert Moderator

Hi @Hareeshkumar.Kr@Gmail.Com
Check your action method.
i think your action method was called twice.
Or
please share ur page with us.
Or
Try to recreate your page again.

hareeshkumarkr-16190, if this helps please login to Mark As Answer. | Alert Moderator