PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
Course Of The Month
7 days, 8 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
VS 2005 sqldatasource set parameter value to value of another parameter
Posted on 2013-12-09
I'm using a VS2005 webform with a detailsview which only allows inserting a new record. The form is used to log visitor requests. Visitors may visit for only one day or multiple days.
In the instance of multiple days, the requestor enters the arrival and the end dates of the visit (visitDate and visitEndDate are the field names.)
If the visit is only one day, I would like to update the visit date to automatically be the same as the arrival date.
I'm sure there's a way to do it, I just haven't figured it out yet.
I tried this but it doesn't work. I don't get an error, it just doesn't work:
In the instance of multiple days, the requestor enters the arrival and the end dates of the visit (visitDate and visitEndDate are the field names.)
If the visit is only one day, I would like to update the visit date to automatically be the same as the arrival date.
I'm sure there's a way to do it, I just haven't figured it out yet.
I tried this but it doesn't work. I don't get an error, it just doesn't work:
If e.Command.Parameters("@visitEndDate") Is Nothing Then
e.Command.Parameters("@visitEndDate").Value = e.Command.Parameters("@visitDate").Value
End If
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3-
3
6 Comments
You don't need the @, try :
If e.Command.Parameters("visitEndDate") Is Nothing Then
e.Command.Parameters("visitEndDate").Value = e.Command.Parameters("visitDate").Value
End If
I tried it without the "@" and it errors out with this message "A SqlParameter with ParameterName 'visitEndDate' is not contained by the SqlParameter Collection"
The ParameterName is "@visitEndDate" so wouldn't I need the "@?"
The ParameterName is "@visitEndDate" so wouldn't I need the "@?"
What method are you trying to update the parameter in?
Can you post the aspx markup code for the sqldatasource
Can you post the aspx markup code for the sqldatasource
I am using the sqldatasource_inserting method
Here is the code:
Here is the code:
<asp:SqlDataSource ID="vReqSqlDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:App_DBConnectionString %>"
InsertCommand="INSERT INTO dbo.VisitorLog(visitorName1, visitorName2, visitorName3, visitorName4, visitorName5, visitorCompany1, visitorCompany2, visitorCompany3, visitorCompany4, visitorCompany5, foreignVisitor, visitDate, purposeOfVisit, plantNo, nammoContact, nammoPhone, logDate, personalBadge, arrivalTime, requestor, visitEndDate) VALUES (@visitorName1, @visitorName2, @visitorName3, @visitorName4, @visitorName5, @visitorCompany1, @visitorCompany2, @visitorCompany3, @visitorCompany4, @visitorCompany5, @foreignVisitor, @visitDate, @purposeOfVisit, @PlantNo, @nammoContact, @nammoPhone, @logDate, @personalBadge, @arrivalTime, @requestor, @visitEndDate)"
SelectCommand="SELECT dbo.VisitorLog.* FROM dbo.VisitorLog">
<InsertParameters>
<asp:Parameter Name="visitorName1" />
<asp:Parameter Name="visitorName2" />
<asp:Parameter Name="visitorName3" />
<asp:Parameter Name="visitorName4" />
<asp:Parameter Name="visitorName5" />
<asp:Parameter Name="visitorCompany1" />
<asp:Parameter Name="visitorCompany2" />
<asp:Parameter Name="visitorCompany3" />
<asp:Parameter Name="visitorCompany4" />
<asp:Parameter Name="visitorCompany5" />
<asp:Parameter Name="foreignVisitor" />
<asp:Parameter Name="visitDate" />
<asp:Parameter Name="purposeOfVisit" />
<asp:Parameter Name="PlantNo" />
<asp:Parameter Name="nammoContact" />
<asp:Parameter Name="nammoPhone" />
<asp:Parameter Name="logDate" />
<asp:Parameter Name="personalBadge" />
<asp:Parameter Name="arrivalTime" />
<asp:Parameter Name="requestor" />
<asp:Parameter Name="visitEndDate" />
</InsertParameters>
</asp:SqlDataSource>
How are you binding your form field values to the parameters, are you also doing this manually in the sqldatasource_inserting method or declaratively in the form.
Have you tried looking at the value of e.Command.Parameters("@vis
So you would need to do something like :
Have you tried looking at the value of e.Command.Parameters("@vis
So you would need to do something like :
If e.Command.Parameters("@visitEndDate") Is Nothing Or e.Command.Parameters("@visitEndDate").Value = String.Empty Then
e.Command.Parameters("@visitEndDate").Value = e.Command.Parameters("@visitDate").Value
End If
Featured Post
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
In this Article, I will provide a few tips in problem and solution manner.
Opening an ASPX page in Visual studio 2003 is very slow.
To make it fast, please do follow below steps:
Open the Solution/Project.
Right click the ASPX file to b…
ASP.Net to Oracle Connectivity
Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers to develop an ASP.NET client…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you!
In this Micro Tutorial, you'll learn yo…
- Microsoft Applications
- Windows 10
- Windows OS
- Fonts Typography
- Windows 7, Microsoft Word
Suggested Courses
Course of the Month7 days, 8 hours left to enroll
728 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.