Populating a drop down list - ASP.NET Discussion Boards

ToddHileHoffer9-Oct-07 7:04

9-Oct-07 7:04

If you are using sql server 2005 then you can use the pivot command. If not, I would use ado.net. Create a dataTable with the proper columns and use a data reader to populate it. I don't think the C# is more efficient, but it sure is easier. Writing complicated stuff is SQL tough to debug and generally more difficult to follow.

How many rows are you going to be pulling back? If you have 1000s of rows you are probably better off using a user defined function in SQL for performance, but if you have 50 or less rows, it won't matter how you do it and the C# will be much easier to maintain / modify / debug if you need to.

I didn't get any requirements for the signature

SQL Query Translation.

Saksida Bojan9-Oct-07 5:37

Saksida Bojan

9-Oct-07 5:37

I am using database MSSQL, i have also installed MySQL throught ODBC driver. I Know these databases sql queryies are a diffrent, but does a certan controll/class/dll exsist to translate query betwen them? If it doesnt it's not a big problem.

Re: SQL Query Translation.

il_masacratore9-Oct-07 21:47

il_masacratore

9-Oct-07 21:47

Queries are not different if you use standard sql in your app...

Visit my blog at http://dotnetforeveryone.blogspot.com/

javascript datetime dynamically (ASP.Net)

veluCovansys9-Oct-07 5:31

veluCovansys

9-Oct-07 5:31

hi this is velu

i need to display the date and time in my web application in ASP.Net with C#,
i created in Server side. But it is a web application, several user use this,so server get the request in every second(performance is low).

i need clientside date and time.

how to create please reply soon

Re: javascript datetime dynamically (ASP.Net)

ToddHileHoffer9-Oct-07 7:05

ToddHileHoffer

9-Oct-07 7:05

just google javascript date time counter. You should find something.

I didn't get any requirements for the signature

Dataset on Immediate window

ss.mmm9-Oct-07 5:30

ss.mmm

9-Oct-07 5:30

Can you suggest me ways to look at the entire dataset or datatable on the immediate window?

Thanks

Re: Dataset on Immediate window

Paddy Boyd9-Oct-07 5:38

Paddy Boyd

9-Oct-07 5:38

If you're using VS 2005, try hovering over the datatable variable and then clicking the little magnifying glass icon when it pops up.

Populating a drop down list

Brendan Vogt9-Oct-07 3:50

Brendan Vogt

9-Oct-07 3:50

Hi,

I have a drop down list in a:

<asp:CreateUserWizardStep ID="CreateUserStep1" runat="server">

<ContentTemplate>

<asp:DropDownList ID="ddlTitles" runat="server" />

I need to populate this drop down list. I am having some issues because normally I would do it like:

private void BindTitles()
{
ddlTitles.DataSource = Title.GetAllTitles();
ddlTitles.DataValueField = "ID";
ddlTitles.DataTextField = "Name";
ddlTitles.DataBind();

// Insert a "None" choice
ddlTitles.Items.Insert(0, new ListItem("None", String.Empty));
}

But because it is in <ContentTemplate> I need to find the control, something like CreateUserStep1.ContentTemplateContainer.FindControl("ddlTitles")... But I do not know how to populate it. In BindTitles() I changed it to create a drop down list control and populated this control the samwe way, but I need to assign this control to ddlTitles. I don't know how to do this.

Please can someone help me??

Thanks

Re: Populating a drop down list

Eduard Keilholz9-Oct-07 4:38

Eduard Keilholz

9-Oct-07 4:38

You're pretty close...

<br />
Control cltrFound = ....FindControl("YourControl");<br />
if (ctrlFound is DropDownList)<br />
{<br />
    DropDownList ddlToBind = (DropDownList)ctrlFound;<br />
    BindTitles(ddlToBind);<br />
}<br />
<br />
private void BindTitles(DropDownList ListToBind)<br />
{<br />
   ListToBind.DataSource = Title.GetAllTitles();<br />
   ListToBind.DataValueField = "ID";<br />
   ListToBind.DataTextField = "Name";<br />
   ListToBind.DataBind();<br />
<br />
   // Insert a "None" choice<br />
   ListToBind.Items.Insert(0, new ListItem("None", String.Empty));<br />
}<br />

That mey help you get even closer Wink | ;)

.: I love it when a plan comes together :.
http://www.zonderpunt.nl

Re: Populating a drop down list

Brendan Vogt9-Oct-07 5:28

Brendan Vogt

9-Oct-07 5:28

Thanks for this, it really helped!!

How do I stop the response object from renaming files?

Al Ortega9-Oct-07 3:33

Al Ortega

9-Oct-07 3:33

I have an file management tool that has just one problem that I can not figure out. The files are stored in an MsSQL 2005 db and can be retrieved with no problem. The problem comes when the response object renames it. Example if the file is name "file 1.doc" then when the IE response sends it to the client it is renamed "file_1.doc" but FF renames it "File" with no "1" or file extension rendering it useless.

Any ideas on what could be causing this and what can be done to stop it?

-Al

Re: How do I stop the response object from renaming files?

Paddy Boyd9-Oct-07 5:24

Paddy Boyd

9-Oct-07 5:24

Are you setting the filename in the response?

Something like:

Response.AppendHeader("content-type", "inline;filename=file.doc")

Re: How do I stop the response object from renaming files?

Al Ortega9-Oct-07 5:52

Al Ortega

9-Oct-07 5:52

no, I have

Response.AddHeader("Content-Disposition", "attachment; filename=" & file.Name)

I tried using inline vice attachment - but there was no difference.

-Al

Gridview DropDownlist

ss.mmm9-Oct-07 3:27

ss.mmm

9-Oct-07 3:27

Can dropdown list be put on gridview bound column? Many places, I read that it has to be converted to template column to put a dropdown. Can you please help with this?

Thanks

Re: Gridview DropDownlist

John Gathogo9-Oct-07 4:20

John Gathogo

9-Oct-07 4:20

The following is sample code:

<asp:TemplateField HeaderText="ColumnName" SortExpression="ColumnName">
<asp:ItemTemplate>
<asp:Label ID="lblColumnName" runat='server' Text='<%# Eval("ColumnName") %>'></asp:Label>
</asp:ItemTemplate>
<asp:EditItemTemplate>
<asp:DropDownList ID="cmbColumnName" runat="server" DataSourceID="SqlDataSource1" DataMember="TableName" DataTextField="ColumnName" DataValueField="ColumnName" SelectedValue='<%# Bind("ColumnName") %>'></asp:DropDownList>
</asp:EditItemTemplate>
</asp:TemplateField>

Re: Gridview DropDownlist

ss.mmm9-Oct-07 4:49

ss.mmm

9-Oct-07 4:49

Thanks for the code. But, can we put dropdown list on Bound Column of GridView in a web form?

Thanks

Re: Gridview DropDownlist

John Gathogo9-Oct-07 6:39

John Gathogo

9-Oct-07 6:39

You may not use <asp:BoundField> with the dropdownlist. When using the templated controls the means to bind is: '<%# Bind("ColumnName") %>'

ASP.NET application performance issue

Mukesh Kumar Gupta9-Oct-07 3:12

Mukesh Kumar Gupta

9-Oct-07 3:12

In my application I have a bulky .aspx page, it has UdatePanels and on every post back through UpdatePanel it performs complex calculations on server as well as renders almost 50 controls again at UI.
I am facing following performance issues with my application
1. Application works fine on all other pages but on above mentioned page it’s very slow and often gives timeout exception.
2. On similar page if there are 3-4 concurrent user then ASP.NET worker process starts using almost 100% of CPU. (considering the RAM on server is 2GB)
3. I am creating and maintaining a session object on this page which fetches values form database and it’s size is around 500 KB, it's compusary for application and cannot be avoided.
I have tried a lot but couldn’t found the performance bottleneck; can anybody please suggest how can I fine tune applications performance for given page?

Re: ASP.NET application performance issue

Saksida Bojan9-Oct-07 4:55

Saksida Bojan

9-Oct-07 4:55

Do you realy need all 50 controls on page, or you coud use as wizzard?

Did you disabled debug mode in Web.Config?

Did you used publish site in Visual Studio?

Did you configure iss? I Think it is in General Tab a combo box, Currently i cant accsess to my computer where i have iss.

Re: ASP.NET application performance issue

Not Active9-Oct-07 4:56

Not Active

9-Oct-07 4:56

Mukesh Kumar Gupta wrote:
complex calculations on server as well as renders almost 50 controls again at UI

Well, I would say this is a clue.

Why do you need to re-render 50 controls? Just update the ones necessary, or reduce the number of controls on the page. I would reconsider the 500KB session object also.

only two letters away from being an asset

How to get list of Virtual Directories in IIS7?

NanaAM9-Oct-07 2:31

NanaAM

9-Oct-07 2:31

Hello,

I am using Microsoft.Web.Administration api s to handle some functionality of IIS7. How do I get Virtual Directories of a particular website( a website not an Application.)?
Please let me know.

Nana

Cant run my aspx pages

matjame9-Oct-07 2:04

matjame

9-Oct-07 2:04

Hi guys.

I have been running my aspx pages perfectly till a few weeks ago.I didnt do any configurations on my pc.Atleast not that I know of.So now I cant run any of my pages coz it tells me the page cannot be found, even when I hit the run or debug button.

Any ideas guys.Please.
Thanx in advance. Cry | :((