What is Application State?

Question

hi friends How with the application state, we can store the connection string and how to use it in other WebPages? thanks

Satyapriya Nayak · Answer

Welcome Dibya, Here is your desired code. Application State: - We can declare variables, objects in the application state. If we assign any value in the application state it can be globally accessed in any WebPages of the current application. Program First add a Global Application Class to the current application. Global.asax code Dim strConnString As String = System.Configuration.ConfigurationManager.ConnectionStrings.Item("ConnectionString").ToString() Dim con As New SqlConnection(strConnString) Dim str As String Dim com As SqlCommand Dim ds As DataSet Dim da As SqlDataAdapter Sub Application_Start(ByVal sender As Object, ByVal e As EventArgs) ' Code that runs on application startup Application("sqlconstring") = str Application("sqlcon") = con Application("sqlcom") = com Application("sqldataset") = ds Application("sqldataadapter") = da End Sub Sub Application_End(ByVal sender As Object, ByVal e As EventArgs) ' Code that runs on application shutdown End Sub Sub Application_Error(ByVal sender As Object, ByVal e As EventArgs) ' Code that runs when an unhandled error occurs End Sub Sub Session_Start(ByVal sender As Object, ByVal e As EventArgs) ' Code that runs when a new session is started End Sub Sub Session_End(ByVal sender As Object, ByVal e As EventArgs) ' Code that runs when a session ends. ' Note: The Session_End event is raised only when the sessionstate mode ' is set to InProc in the Web.config file. If session mode is set to StateServer ' or SQLServer, the event is not raised. End Sub Default.aspx code Untitled Page Default.aspx.vb code Imports System.Data Imports System.Data.SqlClient Partial Class _Default Inherits System.Web.UI.Page Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Try Application("sqlcon").open() Application("sqlconstring") = "select * from employee" Application("sqlcom") = New SqlCommand(Application("sqlconstring"), Application("sqlcon")) Application("sqldataadapter") = New SqlDataAdapter(Application("sqlcom")) Application("sqldataset") = New DataSet Application("sqldataadapter").fill(Application("sqldataset"), "employee") GridView1.DataSource = Application("sqldataset") GridView1.DataMember = "employee" GridView1.DataBind() Application("sqlcon").close() Catch ex As Exception Response.Write(ex.Message) End Try End Sub End Class Thanks If this post helps you mark it as answer

What is Application State?

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (1)