ASP.NET

Re: Drop down list not populating

10-Jul-06 9:35

I have a drop down list (not attached to my datagrid anymore for those of you on the saga with me). I just want to populate this plain old drop-down box. But I can't get it to populate. I could get it to populate when I had it inside a datagrid, so I'm sure it's something easy.

Here is my asp code:

<asp:dropdownlist id=ddPartType style="Z-INDEX: 101; LEFT: 104px; POSITION: absolute; TOP: 48px" tabIndex=1 runat="server" Width="144px" Height="24px" DataSource="<%# GetPartTypes()%>" DataTextField="ptDescription" DataValueField="ptId" EnableViewState="True" AutoPostBack="True"><br />
			</asp:dropdownlist>

All I'm doing is calling GetPartTypes. Okay, here's that code (C#)

public DataSet GetPartTypes()<br />
		{<br />
			ds3 = new DataSet();<br />
			ds3= SqlHelper.ExecuteDataset(this.connectionString, "dbo.GetDescriptions", null);	<br />
			dt3 = ds3.Tables[0];<br />
			ds3.Tables[0].TableName="PartTypes";<br />
			ddPartType.DataSource = ds3;<br />
			ddPartType.DataBind();<br />
			return ds3;<br />
<br />
		}

This calls a stored procedure, GetDescriptions. I know this code works because it executes in Query Analyzer. It's just basically return the descriptions and order by description.

Going through the debugger it's like the code never gets called. So I delibrately called it in PageLoad and got a stack overflow.

BLECH!

Follow up: Okay I can get it to populate if I put the code in the PageLoad. Is this the only way to do it? Or is there something similiar to what I was trying to do?

-- modified at 16:09 Monday 10th July, 2006

Not Active10-Jul-06 11:51

Not Active

10-Jul-06 11:51

Remove DataSource="<%# GetPartTypes()%>"

When you assign the datasource in the page load it is trying to bind to the method you have defined, which again calls DataBind, which again calls this method, which...see where the stack overflow comes in?

Re: Drop down list not populating

postmaster@programmingknowledge.com10-Jul-06 17:47

postmaster@programmingknowledge.com

10-Jul-06 17:47

Find an example at http://www.programmingknowledge.com/dataControl.aspx[^]

Use of query strings

leckey10-Jul-06 5:55

10-Jul-06 5:55

I want to change my session variable to a query string but not finding a lot of info on actually how to program them.

On page 1 of my asp.net application the user enters a part number in a textbox. So I have:

strPartNumberInputReference = txtSearchPart.Text;<br />
Session["ptNum"] = strPartNumberInputReference;

On subsequent pages I call:
partNumber2 = Session["ptNum"].ToString();

So if I want to use a query string do I just change the first page to:

strPartNumberInputReference = txtSearchPart.Text;<br />
strPartNumberInputReference = Request.QueryString["strPartNumberInputReference"]

So 2 questions:
1. Am I writing the above correctly?
2. How do I call in subsuquent pages?

Thanks!

Paddy Boyd10-Jul-06 6:06

Paddy Boyd

10-Jul-06 6:06

No.

<br />
strPartNumberInputReference = txtSearchPart.Text;<br />
<br />
response.Redirect(url & "?strPartNumberInputReference=" & strPartNumberInputReference )<br />

leckey10-Jul-06 6:10

10-Jul-06 6:10

So how do I use it in subsequent pages?
Do I just declare strPartNumberInputReference again or do I use:
strPartNumberInputReference = Request.QueryString["strPartNumberInputReference"];

Thanks for your help!

Paddy Boyd10-Jul-06 6:11

Paddy Boyd

10-Jul-06 6:11

Option 2. Web pages are stateless by default, so you are just passing your parameter, as a string in the url, that is all. It's very different from the way that session works.

leckey10-Jul-06 7:04

10-Jul-06 7:04

Okay, trying to do the response redirect:

Response.Redirect ("...Pages/Add_Weight.aspx" & "?strPartNumberInputReference=" & strPartNumberInputReference );

Getting a compiler error: "Operator '&' cannot be applied to operands of type 'string' and 'string'

What am I doing wrong?

eggsovereasy10-Jul-06 7:21

10-Jul-06 7:21

<br />
Response.Redirect ("...Pages/Add_Weight.aspx"?strPartNumberInputReference=" + strPartNumberInputReference );<br />

eggsovereasy10-Jul-06 7:23

Re: Use of query strings [modified]

10-Jul-06 7:23

& is a bitwise AND

leckey10-Jul-06 7:46

Scrolling Issue in component Art grid

10-Jul-06 7:46

Okay, there are only three quotations in your code. Still getting compiler error. Tried as you wrote and said ; and ) expected. Tried the following:
Response.Redirect ("...Pages/Add_Weight.aspx"?strPartNumberInputReference=" + strPartNumberInputReference" ); and got ) expected.

Am I missing parenthesis or is it the quotes?
THANK YOU!

Okay, got it to work with the following:
Response.Redirect ("Add_Weight.aspx?strPartNumberInputReference=" + strPartNumberInputReference);

Had an extra quotation. Hopefully I won't have any more problems!

-- modified at 14:15 Monday 10th July, 2006

MaheshSharma10-Jul-06 5:40

MaheshSharma

10-Jul-06 5:40

I have a component art grid inside user control. how do i set the vertical and horizontal scrolling if it can exceed the page size. Allowhorizontalscrooling and scroolbar="auto" property not works in that

can any one please help me

thanks
mahesh

need help with server address? used on my webpage

keroed_edmond10-Jul-06 5:29

keroed_edmond

10-Jul-06 5:29

i created an application that streams from a server but my problem is on my server there quiet a few drives for eg drive m,u,f,g,h right and lets say my ip for my server is 123.34.0.1 for arguements sake right

1. i have some audio on the u drive and i want to retrieve it how would i do this???

i tried http://123.34.0.1/recordings/ken.wav................i tried that since the ken.wav is located on u:/recordings/ken.wav

kenny

Re: need help with server address? used on my webpage

eggsovereasy10-Jul-06 7:24

Re: need help with server address? used on my webpage

10-Jul-06 7:24

You have to set up a virtual directory in IIS for u:/recordings/

keroed_edmond10-Jul-06 8:25

keroed_edmond

10-Jul-06 8:25

how would i do this???? canu tell me wat to do or point me to a tutorial as to how to do that

kenny

Re: need help with server address? used on my webpage

eggsovereasy10-Jul-06 8:56