How do I sumbit the selected dates value as paramters in submit button for a stored procedure?

Posted on 2011-10-26
Last Modified: 2012-08-14
I am having the user enter two dates (start date and end date) and then submit these values to the stored procedure. The submission is done through the submit on click event. The values are passed as a parameter in the report view page and populated using grid view.

    Protected Sub btnSumbit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSumbit.Click
        txtStartDate.Text = ("StartDate").ToString
        txtEndDate.Text = ("EndDate").ToString

    End Sub

Question by:patelankitm
    1 Comment
    LVL 12

    Accepted Solution

    I'm confused on your question.  Your code show assigning values to the textboxes on the submit,not reading the value.
      How are you passing the values to the separate page that has the report view and grid view? (QueryString, Cross-post, Session, etc.)  Or is this your question?  Each of these methods have their pros and cons.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now