Can I change sqldataAdapter.Selectcommand dynamically at run time?

Daniel Cazzulino, Clarius Consulting

Published: 20 Aug 2003

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.

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

SearchCloudComputing

6 long-term plans to add to cloud cost optimization strategies

Short-term cost management tools are one way to improve cost efficiencies in the cloud, but to stay on track, you also need ...

IaaS vs. PaaS options on AWS, Azure and Google Cloud Platform

Looking to shift your workloads to the cloud? Understand and compare the IaaS and PaaS options on AWS, Azure and Google Cloud ...

SearchSoftwareQuality

How to tame ever-changing requirements in software development

When one sprint ends, another begins -- but not before you receive a heaping new pile of requirements. Here's how to deal with ...

Web and mobile testing faceoff: Sauce Labs vs. BrowserStack

Two automated testing platforms enter; only one tool leaves. IT consultant Tom Nolle examines how Sauce Labs and BrowserStack ...

UX guidelines for people-friendly software

Nail these UX design concepts for easier transitions from requirements to application design to code.

TheServerSide.com

Is Java slow? Compared to C++, it's faster than you think

If you find that Java is slower than other languages, such as C++, here's how to better compare the two and the major differences...

Java video games, like Minecraft, keep the language popular

The next generation of Java developers can learn the ins and outs of the language through an unlikely source: video games such as...

Pivotal, Microsoft team up to deliver Azure Spring Cloud

Azure Spring Cloud, jointly developed by Microsoft and Pivotal, lets Spring developers bring apps to the cloud without concern ...

Can I change sqldataAdapter.Selectcommand dynamically at run time?

Dig Deeper on Win Development Resources

Cloud computing causes confusion about services dependencies

Top 3 concerns when migrating to Windows 7

Create Windows 7 apps to win cash, trips to PDC

Microsoft leaving IE out of Windows 7 in Europe

Create Windows 7 apps to win cash, trips to PDC

SharePoint hot? 'Clouds' rolling in? - Ballmer speaks at partner event

Oslo SOA strategy fleshed out more at TechEd Developer

Visual Studio 2005 tools, improvements on tap for VSLive!

Cloud computing causes confusion about services dependencies

Top 3 concerns when migrating to Windows 7

Microsoft leaving IE out of Windows 7 in Europe

Jumping into Visual Studio as an Industry Partner

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

Top 5 cloud architect interview questions and answers

6 long-term plans to add to cloud cost optimization strategies

IaaS vs. PaaS options on AWS, Azure and Google Cloud Platform

SearchSoftwareQuality

How to tame ever-changing requirements in software development

Web and mobile testing faceoff: Sauce Labs vs. BrowserStack

UX guidelines for people-friendly software

TheServerSide.com

Is Java slow? Compared to C++, it's faster than you think

Java video games, like Minecraft, keep the language popular

Pivotal, Microsoft team up to deliver Azure Spring Cloud

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.