25+ Hours Comes Down to a Few Different Clicks
Some of you may be aware that I’ve been on a little adventure to teach myself a completely new web programming language and learn a new tool at the same time.
I’ve just about ditched Dreamweaver completely and moved over to Visual Web Developer Express Edition. Along with learning a new software application, I’m also learning ASP.NET, VB and SQL along with everything else.
I’ve been working on a project for a client and one of the search functions stems off a SQL Stored Procedure that greatly expands their current search capabilities on their existing site.
The only problem was that I couldn’t get the form fields to bind to the GridView which is bound to the stored procedure to refresh and show the search results.
I spent hours looking for answer. I’d gotten other simple search forms to work that were just searching off of a single table, but could not figure out this stored procedure based search.
Hours, hours, hours, hours…..
Earlier this week my partner and I were trying to work through the issue and figure out what the problem is. We had found a tutorial example on the web that we were trying to work through and modify for our needs, but were still getting errors.
Finally, we started a brand new page and began entering brute force mode for finding a solution as our deadline is here. I’m working through the settings and I accidentally click on “Control” option for my parameter to come from instead of a “Form” option. Everything worked!
It’s amazing what a single little mouse click on a different option will do. Not VB code required, nothing! It just worked!
Now, I would think that somewhere in all the forum posts and tutorials I’d looked through, somebody would have mentioned to be sure and set the parameter source to “Control” instead of “Form”, but nope. Never saw it.
Hopefully my experience will work for someone else and save you some time. One of my titles at work is “Worst Case Scenario” because it’s my job to put things through the ringer to make sure they work, well this time it was me putting myself through the ringer.
Related Stories
POSTED IN: Business Users, Home User, Internet Explorer, Microsoft Resources, Online Services, Search, Servers, Software, Software Errors, Training, User Experience, Visual Web Developer Express, Web Design
0 opinions for 25+ Hours Comes Down to a Few Different Clicks
No one has left a comment yet. You know what this means, right? You could be first!
Have an opinion? Leave a comment: