test.aspx.vb Imports System.Data.SqlClient ————————————- Dim connString As String connString = ConfigurationManager.ConnectionStrings(“MyConnectionString1″).ToString Dim conn As New SqlConnection(connString) web.config <connectionstrings> <add name=”MyConnectionString1″ connectionString=”Data Source=MY-SQL-SRV;Initial Catalog=Northwind; Persist Security Info=True; User ID=my_user;Password=my_pwd” providerName=”System.Data.SqlClient” /> </connectionstrings>
Home » Posts tagged "Visual Studio" (Page 3)
Archive for the 'Visual Studio' Tag
Close thickbox (popup) refresh parent page
Test.aspx <html xmlns=”http://www.w3.org/1999/xhtml”> <head runat=”server”> </head> <body> <form id=”form1″ runat=”server”> < %= Me.UpdMsg %> </form> </body> </html> Test.aspx.vb Protected UpdMsg As String Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)Handles Me.Load If Page.IsPostBack Then UpdMsg = “<a href=’#’ onClick=’parent.location.reload(1)’>Close!</a>” End If End Sub
Record Update Confirmation Message
DataSource connection string <asp:sqldatasource ID=”MySQLDS” runat=”server” ConnectionString=”< %$ ConnectionStrings:MyConnString %>” UpdateCommand=”UPDATE [MyTablel] SET [DATE_SUBMITTED] = @DATE_SUBMITTED WHERE [RID] = @RID” OnUpdated=”UpdateMessage” > </asp:sqldatasource> VB code in a head section of the page <head> <script runat=”server”> Sub UpdateMessage(ByVal source As Object, ByVal e As SqlDataSourceStatusEventArgs) If e.AffectedRows > 0 Then ‘ Perform any additional processing, ‘ […]