Show All Query/Connection Actvity : Login to the PostgresSQL command-line interface psql -U [username] [database_name] Run the following query: SELECT datname,usename,procpid,client_addr,waiting,query_start,current_query FROM pg_stat_activity; Or Using PgAdmin III Open up pgAdmin Connect to your server Select Tools -> Server Status Most Postges Command : 1. How to change PostgreSQL root user password ? $ /usr/local/pgsql/bin/psql … Continue reading
1. Getting All Table in database : USE your_database SELECT name FROM sys.tables 2. Getting All Field in database, if you want getting all field with description can use this : SELECT u.name + ‘.’ + t.name AS [table], td.value AS [table_desc], c.name AS [column], cd.value AS [column_desc] FROM sysobjects t INNER JOIN sysusers u … Continue reading
Create Datagrid, and create ButtonColumn as column: <asp:ButtonColumn HeaderText=”Grouping” Text=”Grouping” CommandName=”Select” Visible=”False”> <ItemStyle HorizontalAlign=”Center” ForeColor=”#C42711″ /> </asp:ButtonColumn> In ASP.NET code (VB): Protected Sub <DataGridName>_ItemCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles <DataGridName>.ItemCommand Dim row As DataRow Dim strTemp As String lblMessage.Visible = False tblStatusDownload.Visible = False GroupingData_Thread() End Sub Sub GroupingData_Thread() ‘method to start … Continue reading
Shared Variables There is another type of shared member we can create. There are times when it is nice to share a value across all instances of a class – when every object of a given type should share the same variable. This is accomplished through the use of shared variables. A shared variable is … Continue reading