ASP.NET

28-Jun-10 9:19

I have a inventory application that pulls data from our database.

So on a page called loggedin.aspx I have two drop down list on the left and a DATALIST (with a pageddatasource) on the right. Now the two boxes on the left let you choose the CITY and the YEAR for the inventory.

Once you select both drop a drop down and click GO it sets the session variables:

protected void btnGo_Click(object sender, ImageClickEventArgs e)
    {
        if (ddlJUR.SelectedIndex != -1)
            Session["JUR"] = ddlJUR.Items[ddlJUR.SelectedIndex].Text;

        if (ddlFY.SelectedIndex != -1)
            Session["FY"] = ddlFY.Items[ddlFY.SelectedIndex].Text;
    }

Now on page load it should be pulling data from the database based on those values. It should also be setting a label stating which values you ahve chosen and also selecting the correct jurisdiction/ fiscal year from the drop down box:

protected object FY;
protected object JUR;

        FY  = Session["FY"];
        JUR = Session["JUR"];

        if (JUR == null)
            lbBreadCrumb.Text = "Please select the jurisdiction from the left.";
        else if (FY == null)
        {
            ListItem iJUR = ddlJUR.Items.FindByText(JUR.ToString());
            if (iJUR != null)
                ddlJUR.SelectedIndex = ddlJUR.Items.IndexOf(iJUR);

            lbBreadCrumb.Text = JUR.ToString() + " > " + "-Please select the Fiscal Year from the left-";
        }
        else
        {
            lbBreadCrumb.Text = JUR.ToString() + " > " + FY.ToString();

            ListItem iJUR = ddlJUR.Items.FindByText(JUR.ToString());
            if (iJUR != null)
                ddlJUR.SelectedIndex = ddlJUR.Items.IndexOf(iJUR);

            ListItem iFY = ddlFY.Items.FindByText(FY.ToString());
            if (iFY != null)
                ddlFY.SelectedIndex = ddlFY.Items.IndexOf(iFY);

            if (!IsPostBack)
            {
                BindData();
            }
        }

It doesn't seem to work though. You have to click the go button twice. Iti s like the session variable doesnt set before the postback happens and the page is loaded??

Ennis Ray Lynch, Jr.28-Jun-10 9:31

28-Jun-10 9:31

Load happens before click. You click code will have to do some work to get the expected results. Ie, your code in page load needs to be in a place where your click can call it too.

Need custom software developed? I do custom programming based primarily on MS tools with an emphasis on C# development and consulting.

A man said to the universe:
"Sir I exist!"
"However," replied the universe,
"The fact has not created in me
A sense of obligation."
--Stephen Crane

Jacob Dixon28-Jun-10 9:33

28-Jun-10 9:33

Ahhh... ok...

Well for what I am tryign to do is Session the best result? I don't know much about ViewState but I'm reading more on it. Is there something else I should be doing?

Jacob Dixon28-Jun-10 9:45

28-Jun-10 9:45

Uhm I thought I knew what you meant but I guess not. Do yuo happen to have an example on a situation like this? I pretty much have to get those session variables on page load so I can query the database and show the data. But then they must also need to be able to change that information from the drop down list

Ennis Ray Lynch, Jr.28-Jun-10 9:55

28-Jun-10 9:55

You can never get the data on page load the first time around if this is the same page where the data is assigned. Try this some combination of the below:

protected void mBtnAssignWhatever_Click(object sender, EventArgs e){
    ...Assign Session Variables
    PopulateForm();
}

protected void PageLoad(...){
    LoadDataFromDatabase();
    if(!IsPostBack){
       //Populate your list boxes here
    }
    PopulateForm();
}

private void PopulateForm(){
    if(AreMySessionVariablesAvaiable()){
        ...
    }
    else{
        ...
    }
}

Jacob Dixon28-Jun-10 10:15

28-Jun-10 10:15

Ok I see where you are going with this.

I may not be able to do what I need. Because I need to load the data from the database BASED on the session variables. ("SELECT * FROM Blah WHERE FY=<session variable=""> AND JUR=<session variable="">").

Your example above loads from the database first. I would think of pulling all the data and then filtering based on the session variables but that is a TON of data to pull.

Can you think of anything other than session variables to use? I was using QueryStrings but didn't really want to go back to that. I might have to though.

Ennis Ray Lynch, Jr.28-Jun-10 10:41

28-Jun-10 10:41

Try the following in your Data load event:

if(SessionDataIsLoaded()){
   LoadData(sessionValue, ...);
}
else{
   LoadData(defaultValue, ...);
   //Or don't even load data, it doesn't really matter
}

Jacob Dixon28-Jun-10 11:00

28-Jun-10 11:00

Are you talking about the datalist Init event? Because I do not even begin to call anything that pulls data without having the session variables first.

Ennis Ray Lynch, Jr.28-Jun-10 11:15

Passing a value from an ASP.Net page to a HTML Page

28-Jun-10 11:15

No.

PDTUM28-Jun-10 6:31

PDTUM

28-Jun-10 6:31

So...I have decided to use PayPal. To my surprise, there is apparently no smooth way to use a PayPal form button on an ASP.net page. OK....so I create a HTML page with the button on it and I insert it into the website. When the user hits Submit from ASP.Net, it enters all the data into the database and then brings up the HTML page with the button....and that works fine. However, I want to post the generated Customer ID number for the customer so that when he returns to the site with proof of purchase from PayPal, I can identify him in the database. What I need to do is have the ID, which was generated by a script on the ASP.Net page, pass that information to the HTML page into a label along side the PayPal button so the customer can write it down and use it with his proof of purchase (invoice) from PayPal. If I was using ASP to ASP, I would simply create a Session value and that would be the end of it. But how do I get the value from the ASP page to the HTML page? Any insight or an example would be greatly appreciated. Thank you, Pat

ps: I may have accidentally posted this into another place on this site. It was not an INTENTIONAL double entry. For those purists that cannot deal with a simple mistake, I apologize in advance and hope that the extra entry doesn't ruin their day.

Re: Passing a value from an ASP.Net page to a HTML Page

Ennis Ray Lynch, Jr.28-Jun-10 7:43

Re: Passing a value from an ASP.Net page to a HTML Page

28-Jun-10 7:43

Why did you create an HTML page instead of an ASP.NET page? ASP.NET now supports multiple form tags in a page (kinda) which will allow you to use ASP.NET to populate your form as you are familiar and then post to the PayPal site.

T M Gray28-Jun-10 7:45

Re: Passing a value from an ASP.Net page to a HTML Page

28-Jun-10 7:45

Did you try a google search for paypal asp.net? While there are 2.3 million results to sort through, several on the first page looked very promising.

PDTUM28-Jun-10 12:19

PDTUM

28-Jun-10 12:19

Thank you, Mr. Gray and Mr. Lynch. I am sure that since the article I read was written, there is some kind of ASP.Net solution. I like ASP.Net and prefer it, but as a developer, the first think I learned is not to swim against the tide. I think PayPal is foolish for not creating a streamlined solution for this issue, however, that's their deal. Mine is to make it work as simply and effectively as possible. I therefore have decided to use a simpler integrated solution that uses both ASP and HTML pages. For others looking in, I use ASP first to get the data into the database, then use it again to show the customer the information I need him to have. Then, I go to HTML to host the PayPal button, which was written for HTML. It looks good (enough) and works perfectly, which is most important, so I am going to stay with it, at least for now. I appreciate the input from both of you. Thank you and best regards, Pat

response.redirect gives -400 error.

vjvjvjvj28-Jun-10 5:48

vjvjvjvj

28-Jun-10 5:48

Hi,

My website shows a sessiontimeout page when some event happens on a page and the the sesssion is expired.

All Page inherits from sessionmanagement class

In the init function of sessionmanagement class, in case the session is expired, it redirects page to sessiontimeout.htm which is in the same folder as response.redirect("sessiontimeout.htm")

For main.aspx it works fine, shows sessiontimeout.htm fine.

main.aspx has ajaxtabcontainer and each tab has iframe.

The pages in the iframe are also inherited from sessionmanagement class.
In case session expires and any event happens in the pages in the iframe, it tries to load sessiontimeout.htm but gives error -400.

I checked the properties in browser. To my surprise, it was trying to load as
<base url="" />/<base root="" folder="" again="" />/sessiontimeout.htm

e.g. if my baseurl is http://myserver/mysite it was trying to load as http://myserver/mysite/mysite/sessiontimeout.htm

I dont know why it was appending the base root folder again.

Why it is giving this strange behaviour from pages in iframe when all the pages are in the same folder?

I guess for this application, this was not happening in visual studio 2008 but now I am using visual studio 2010.

Any suggestions?

Thanks

Vijay

[CrossPost]: response.redirect gives -400 error.

Sandeep Mewara28-Jun-10 6:12

Sandeep Mewara

28-Jun-10 6:12

Please dont post the same question to multiple forums.
Pick one and stick to it.

Other quetion posted here: http://www.codeproject.com/Questions/90278/response-redirect-gives-error-400-error.aspx[^]

Access masterpage control in contentpage codebehind

Hardus Lombaard28-Jun-10 4:55

Hardus Lombaard

28-Jun-10 4:55

I have a masterpage called CaseManagement.Master and a content page called AppointmentSchedule. On my master page I have a textbox called txtPolicyNumber. How do I access this textbox from the content page's codebehind? "this.txtPolicyNumber" and "this.Master.txtPolicyNumber" doesn't work.

Re: Access masterpage control in contentpage codebehind

Brij28-Jun-10 4:59

Brij

28-Jun-10 4:59

you acn access controls of master page like this

TextBox tb = (TextBox)Master.FindControl("txtPolicyNumber");

Cheers!!
Brij
Check my latest Article :A walkthrough to Application State

Re: Access masterpage control in contentpage codebehind

T M Gray28-Jun-10 7:15

Import Dynamic exel to sqlserver

28-Jun-10 7:15

You can expose it as a property. This is more efficient than using FindControl since it won't have to search through the control heirarchy.

public String MyTextBox
{
    get
    {
        return txtPolicyNumber.Text;
    }
    set
    {
        txtPolicyNumber.Text = value;
    }
}

amina8928-Jun-10 4:43

amina89

28-Jun-10 4:43

Hi,
I try to import Excel files to sqlserver problem is that the number and the titles of columns are dynamic.How can i do that?by code.
Thank you

Re: Import Dynamic exel to sqlserver

T M Gray28-Jun-10 7:48

Re: Import Dynamic exel to sqlserver

28-Jun-10 7:48

Do you want a new table each time? You could use a select into SQL statement.

What are you going to do with the data? A bunch of random SQL tables with random columns doesn't sound very useful.

amina8928-Jun-10 22:34

amina89

28-Jun-10 22:34

thank you T M Gray,
I have this problem for almost a month.
I work on an intranet site management reviews of students.
I want to help the manager module to enter student markes .
the problem is that the subjects of a module are dynamic ,I tried a gridview in edit mode but I failed to create the columns dynamically and insert all data at once in the DB.
Now I have an excel file generated by a dynamic sql query containing students of a module but I do not know how import it to the database because the column names and number change .
the table:
reveiw :
id_student________id_subjects______marks
table subject:

id_subject_______name_subject______id_module

the excel file columns:

id_student_____name_student_____name_subject1____name_subject2....

in the name_subjet1 i have de marks of subject1.
I do not know what to do ,is there another solution?
Thanks.

Re: Import Dynamic exel to sqlserver

T M Gray29-Jun-10 10:17