Can I change sqldataAdapter.Selectcommand dynamically at run time?

I want to change sqldataAdapter.Selectcommand dynamically at run time. I made a Web page that shows records from a table, but I don't now how do refresh it with the new selectcommand. Thanks for your time.
You have to issue a new adapter.Fill() command to get the fresh results with the new command. Always remember the command must be executed again, as the data is not "live," but rather pulled out from the database and displayed. You have to perform a new fill and databind operation to refresh.

Dig Deeper on Win Development Resources

Two methods for remotely refreshing Windows 8 Group Policy settings Alternatives for setting Windows Server 2012 and Windows 8 Group Policy to remotely refresh include Microsoft's GPMC and a PowerShell cmdlet.

More Benefits of Win8 Refresh In my last blog, "What Gets Lost When Using Win8 Refresh," I recounted my adventures after running the "Refresh your PC" facility built into Windows 8 on a machine that refused to let me use the ...

Create Your Own Refresh Image for Windows 8 Windows 8 offers at least one major improvement over previous Windows versions -- namely, the ability to refresh the underlying operating system while keeping personal files intact. That said, if ...

Blade servers: How to decide on Unix or Linux If you’re contemplating Unix or Linux for your blade server, or a migration from one to the other, in this guide you will find everything you need to make up your mind. Useful Unix and Linux command lines also included.

Refresh, Recompose and Rebalance - VMware View: Chapter 10 Mike Laverick explains the VMware concepts of Refresh, Recompose and Rebalance as the three main tasks that may need to be carried out on your linked clones.

How to make computed fields recalculate When Notes/Domino developers say they want to "update the fields" in tha Lotus Notes view, they usually mean that they want to cause computed fields to recalculate. SearchDomino.com development expert Andre Guirard explains the process and offers some bonus words of wisdom on LotusScript programming.

Related Q&A from Daniel Cazzulino

Load a DSL domain model instance file programmatically

Here Daniel Cazzulino explains how to load a DSL (domain specific language) domain model instance file programmatically. This requires the .NET type ... Continue Reading

Top ASP.NET expert advice from Danny Cazzulino

Here we offer a glimpse at 12 of .NET development expert Danny Cazzulino's top ASP.NET questions and answers. Continue Reading

Take care with InitializeComponent

C# developers should NOT be modifying InitializeComponent method in the code-behind (or any of the variable definitions) by hand. Continue Reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our Microsoft .Net Development experts

View all Microsoft .Net Development questions and answers

Can I change sqldataAdapter.Selectcommand dynamically at run time?

Dig Deeper on Win Development Resources

Related Q&A from Daniel Cazzulino

Load a DSL domain model instance file programmatically

Top ASP.NET expert advice from Danny Cazzulino

Take care with InitializeComponent

Have a question for an expert?

Start the conversation

0 comments

Please create a username to comment.

-ADS BY GOOGLE

SearchCloudComputing

The future of the Kubernetes ecosystem isn't all about cloud

Evaluate general and niche cloud service use cases

Compare niche cloud services to the hyperscale offerings

SearchSoftwareQuality

How software prototyping beats requirements gathering

5 vital QA skills for software testers

Is RPA the future of test automation?

TheServerSide.com

Don't ever put a non-Java LTS release into production

Public API strategy considerations for enterprise adoption

Ideas on how to hold a successful code hackathon

SearchCloudApplications

Dig Deeper on Win Development Resources

Related Q&A from Daniel Cazzulino

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.