salve ragazzi avrei un piccolo problema:
se faccio un refresh page mi inserisce nuovamnte il record :master:codice:If Page.IsPostBack Then Dim newdate As New Class1 Dim dataoggi = (newdate.datetrans(Today.ToShortDateString)) Dim strSQL As String strSQL = "insert into rapportini (utente,idcliente,tipo,ore,data) values ('" & Membership.GetUser.ToString & "'," & DropDownList1.SelectedValue & ",'" & TextBox2.Text.ToString & "'," & CInt(TextBox3.Text) & "," & dataoggi & " )" 'Response.Write(strSQL) Dim conn As New SqlConnection(ConfigurationManager.ConnectionStrings("IntranetConnectionString").ConnectionString) Dim Command As New SqlCommand(strSQL, conn) conn.Open() Command.ExecuteNonQuery() ' conn.Open() Label1.Text = "Record inserito perfettamnete" GridView1.DataSourceID = "SqlDataSource2" SqlDataSource2.SelectCommand = "select * from rapportini where utente='" & Membership.GetUser.ToString & "' and data=" & dataoggi & " order by id" GridView1.DataBind() End If
grazie

Rispondi quotando