Refreshing the Data Grid for Different Parameters

Question:
I am using Visual Basic 6 and have a data grid referencing the Data environment command with a parameter. The grid won’t refresh to allow for different parameters. The following code is for changing the parameter:

    DataEnv.Scheme "%eme%"

This code fires off the query with another parameter and updates the resultant recordset, but the grid does not update accordingly.

Answer:
You didn’t mention which data grid you are using, which would affect exactly how it’s done. I chose the Microsoft DataGrid Control 6.0 for this example. The following code allows your application to display the results of a DataEnvironment Data Command through the grid. When the user clicks a button of the Visual Basic application, the code re-executes the Command with an input parameter and displays the results in the grid. After re-executing the Command, I reset the DataSource and DataMember properties to ensure that the DataGrid points to the correct source of data. In addition, I call the Refresh method of the control to ensure that the most recent data is displayed. This code works, but there are other possible ways to accomplish the same thing.

Private Sub Command1_Click()    If DataEnvironment1.rsCommand1.State <> 0 Then        DataEnvironment1.rsCommand1.Close    End If        DataEnvironment1.Command1 Text1.Text    Set DataGrid1.DataSource = DataEnvironment1    DataGrid1.DataMember = "Command1"    DataGrid1.RefreshEnd Sub
Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

The Latest

microsoft careers

Top Careers at Microsoft

Microsoft has gained its position as one of the top companies in the world, and Microsoft careers are flourishing. This multinational company is efficiently developing popular software and computers with other consumer electronics. It is a dream come true for so many people to acquire a high paid, high-prestige job

your company's audio

4 Areas of Your Company Where Your Audio Really Matters

Your company probably relies on audio more than you realize. Whether you’re creating a spoken text message to a colleague or giving a speech, you want your audio to shine. Otherwise, you could cause avoidable friction points and potentially hurt your brand reputation. For example, let’s say you create a

chrome os developer mode

How to Turn on Chrome OS Developer Mode

Google’s Chrome OS is a popular operating system that is widely used on Chromebooks and other devices. While it is designed to be simple and user-friendly, there are times when users may want to access additional features and functionality. One way to do this is by turning on Chrome OS