Torna al Thread

<%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.SQLClient" %> <script language="VB" runat="server"> Sub Page_Load(Source as Object, E as EventArgs) Dim cnn As New SqlConnection(ConfigurationManager.ConnectionStrings("ConnectionString2").ConnectionString) Dim UpdateCommand As SqlCommand = New SqlCommand() UpdateCommand.Connection = cnn sql ="Update tbl_users Set status_id=1 WHERE id_user = 1" UpdateCommand.CommandText = sql Try cnn.Open() UpdateCommand.ExecuteNonQuery() Catch ex As Exception Response.Write(ex.ToString()) Finally cnn.Close() End Try End Sub </script>
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5