VS 2008 Indent Dropdownlist Text Based On Ddl Value

Aug 12, 2010

I found a good article online and am able to read data from an excel file. The excel file I created has two columns which I am populating column A as the dropdownlist text value and column B is the dropdownlist value Here is my code:

page.aspx
HTML Code:
<form id="form1" runat="server">
<div>
<asp:DropDownList ID="ddlFund" runat="server" />
</div>
</form>
page.aspx.vb

Code:

Imports System.Data
Imports System.Data.OleDb
Partial Class read_excel
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim myDataSet As New DataSet()
Dim sXLSfile As String = Server.MapPath("/xls/class-list.xls")
Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & sXLSfile & ";" & _
"Extended Properties=""Excel 8.0;"""
''You must use the $ after the object you reference in the spreadsheet
Dim myData As New OleDbDataAdapter("SELECT * FROM [Fund Project List$]", strConn)
myData.TableMappings.Add("Table", "ExcelFile")
myData.Fill(myDataSet)
ddlFund.DataSource = myDataSet.Tables(0).DefaultView
ddlFund.DataTextField = "group"
ddlFund.DataValueField = "groupval"
ddlFund.DataBind()
End Sub
End Class

the excel file looks something like so (<blank> means no data in cell):

Row 1: group | groupval
Row 2: ITEMS | <blank>
Row 3: Blankets | Blankets
Row 4: Beds | Beds
Row 5: STAFF | <blank>
Row 6: John Doe | John Doe

Currently my dropdown gets populated and it's text listing shows up but I want all the items that do not have a value that is blank to be indented. Anyone know if this can be done? How about if I bold just the text that has a blank value?

View 5 Replies


Similar Messages:

Crystal Reports :: How To Indent Text Within A Formula

Sep 3, 2010

I'm doing a report that includes blocks of text. The block of text that is inserted into the report is determined using a formula.

I want to indent the first line (similar to writing a letter) of the text. Can anyone let me know how to program this into the formula. I'm looking for something similar to the Bold (<b>), underline (<u>), or hard return (<BR>) codes that are used with HTML format.

View 8 Replies

Forms Data Controls :: How To Indent Text In Table Cell

Nov 26, 2010

Using Web Dev 2010 Express. .NET 3.50

I have an aspx page with a div containing an asp:Table with 1 row, 1 cell. From the codebehind, I read a user supplied text file and add rows/cells (vb). I would like my output to have indented text in certain rows. Example follows:

[code]....

how to do this?

View 2 Replies

Web Forms :: Programmatically Select Item In DropDownList Based On Text Value

May 7, 2010

Here's what I want to accomplish: I have two .aspx pages, the first page with a ddl to select a vendor (SelectVendor.aspx), and one to add a vendor (NewVendor.aspx), if it's not in the first one. If a user adds a new vendor on the NewVendor.aspx page I want the page to automatically redirect back to SelectVendor.aspx and have the ddl automatically select the new vendor that was just added. Here's where I'm at so far: If a vendor is not listed in the ddl on SelectVendor.aspx, a user can click a button to navigate to a page to add a new vendor (NewVendor.aspx). On NewVendor.aspx the user types the name of the new vendor in a textbox and clicks an insert button to add the new vendor, then the page is automatically redirected back to SelectVendor.aspx with the new vendor name added to the QueryString. For example, let's say a user adds a vendor name "Best Vendor": The page is redirected back to SelectVendor.aspx as "SelectVendor.aspx ?vendor=Best Vendor"Now all I need from here is to have the ddl programmatically select the new vendor by the text value in the QueryString.

Here is the code that I'm having trouble with from my Page_Load routine for SelectVendor.aspx:

[Code]....

View 7 Replies

Web Forms :: Bind Dropdownlist Text Value To Dataset, But Populate The Value Based On Number Of Items

Mar 7, 2011

I need to bind my dropdownlist to my dataset that is returning application specific text values. But for purposes on that page, i need to assign the value to each one starting at 0 to the number of items returned from my dataset..

Example, if my dataset only returns 1 item, the value of that item needs to be 0

[Code]....

If my dataset returns 4 items, the value of those items needs to be 0 thru 3

[Code]....

Is it possible to assign values like that to a dropdownlist from the code behind?

View 6 Replies

Web Forms :: Populate DropDownList Based On RadioButtons And Populate GridView Based On DropDownList

Oct 5, 2012

there is a radio button, a dropdownlist. radiobuttons are OY, OTY,VDA ( in my database there are fields named OY.OTY,VDA) if i select OY in my radio button the data should be displayed from field OY in dropdownlist and if i select OTY in my radio button the data should be displayed from OTY field in dropdownlist is it possible. there is a sqldatasource for dropdownlist .

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:MS16ConnectionString %>"
SelectCommand="SELECT DISTINCT OY FROM COURSE_INTAKE">
</asp:SqlDataSource>

THE SELECTED DROPDOWNLIST DATA IS REQUIRDE TO BE DISPLYED IN A GRIDVIEW.

View 1 Replies

VS 2008 - Restricting Access To Web Pages (on Intranet Site) Based On Role Based Authorization

Jul 12, 2011

I have a simple intranet site. It has a role based authorization in the web.config file.

Any user's in a specific role called as "Apr-Sales-Writers" will be authorized to use those pages. If not, they will not be authorized. So far so good. Works fine. But we added additional functionality where a new active directory group (means new role) has to be added and user's belonging to this new AD group should be given access to only specific .aspx pages on the intranet site. I am using a web.sitemap and it looks like this.

If the user's belong to say AD group "Apr-Sales-Writers", they should access only default.aspx and salesData.aspx pages. User's belonging to new AD group (which I did not include in the web.config file below), should have access to other .aspx pages.

[CODE]<?xml version="1.0" encoding="utf-8" ?>
<siteMap xmlns="http://schemas.microsoft.com/AspNet/SiteMap-File-1.0" >
<siteMapNode url="default.aspx" title="Home" description="Home">
<siteMapNode title="sales Data" description="sales Data">
<siteMapNode url="salesData.aspx" title="sales Data" description="sales Data" />

[Code] ....

View 7 Replies

Data Controls :: Populate City DropDownList Based On District DropDownList Selection

Sep 2, 2012

i have 2 DDL in my page that when users select item from ddldistric1 item in ddlcity1 will change these are my code

 protected void DDLcity1_SelectedIndexChanged(object sender, EventArgs e)
{
BindDistrictC();
}
private void BindDistrictC()

[code]...

View 1 Replies

C# - Disable Or Enable 2nd Dropdownlist In Aspx Based On Selected Choice Of The 1st Dropdownlist Box

Apr 15, 2010

I am having a problem with disabling DropDownList based on the chice of 1st DropDownList, there is no post back occuring, and it is a template based web app here is the current code:

<script type="text/javascript">
$(function() { var dropDownList1 = $('#<%= ddlUserType.ClientID %>');
var dropDownList2 = $('#<%= ddlMember.ClientID %>'); dropDownList1.change(function(e) {
if ( jQuery("#ddlUserType").val() != "ETOC") dropDownList2.removeAttr('disabled'); e.preventDefault();
else
dropDownList2.removeAttr('enabled'); e.preventDefault(); }
} );
</script>

what is happening now is page is blank and if I remove the above code everything shows, where I am going wrong. here is the plain and final javascript code which worked:

<script language="javascript">
function CheckDropDownState(lstbox)
{
if (lstbox.selectedIndex == 3) { document.forms[0].ddlMember.disabled = 1; }
else { document.forms[0].ddlMember.disabled = 0; }
}
</script>

and thew .aspx code: <asp:dropdownlist id="ddlUserType" runat="server" onclick="CheckDropDownState(this);"></asp:dropdownlist>

View 2 Replies

Disabling Dropdownlist Inside A Gridview Based On Value Selected On Another Dropdownlist?

Jan 11, 2011

what i m trying is i hav two dropdownlists inside the gridview... namely say ddonsiteoffsite and ddhours... now what i want is if the selectedtext of ddonsiteoffsite is "onsite" the ddhours should b disabled... i tried the code snippet but ... its not disabling the ddhours... can someone help me please..

<asp:TemplateColumn HeaderText=" OnSite/OffSite" >
<ItemTemplate>
<asp:DropDownList ID="ddOnsiteOffside" runat="server" onchange="ToggleOnOff(this)">
[code].....

View 2 Replies

C# - Populating Dropdownlist Using MVC2 Based On Another Dropdownlist (Cascading)

Sep 18, 2010

I am making an application that deals with vehicles. I need two DropDownLists:

Makes: All Vehicle Makes
Models: Models that belong to the selected value of the Make DropDownList

How is this done in MVC2? My Idea: Do I use an ajax call when my first list is selected and then pull back the Models to bind to the Model DDL? How would model binding come into play that way? UPDATE I posted what I ended up doing as an answer. It is super simple and works great. You can use a get too if you feel so inclined, but you have to specify that you want to like so... return Json(citiesList, JsonRequestBehavior.AllowGet);

View 4 Replies

Change Text Of Text Objects Based On Formula Result In Crystal Report

Sep 3, 2010

I want to change text of text object in crystal report (.rpt file). The datasource for the report is a datatable which consists of a column named sale, if it is '0' then I want to display the text of text object as 'sale' and if it is '1' then I want to display the text of text object as 'lease'. how to add formula and based upon the result of formula I have to change the text of text object being displayed.

View 1 Replies

VS 2008 Dropdownlist Selection Disables / Enables Another Dropdownlist

Aug 1, 2013

I have a dropdownlist on my page with dates such as 1/1/2013, 2/1/2013, etc.

Then there is a second ddl.

If the date in ddl #1 is before 1/10/2013 I want to enable ddl #2.
If the date in ddl #1 is on or after 1/10/2013 I want to either disable ddl #2 or hide it (whichever's easier).

Disabling ddl #2 based on the selected date is a new requirement so I am enhancing the existing code. Obviously I want to do this without a postback, but I don't know what is the best way. I am trying to understand what an AsyncPostBackTrigger is because this is the existing code:

Code:
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<asp:dropdownlist id="EffectiveDateDropDown" runat="server"></asp:dropdownlist>
</ContentTemplate>
<Triggers>
<asp:AsyncPostBackTrigger ControlID="QuoteType"
EventName="SelectedIndexChanged" />
</Triggers>
</asp:UpdatePanel>

It wants to do something when the selected index is changed? This exists in the code-behind, but I set a breakpoint and never hit it:

Code:
protected void QuoteType_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
}
catch (Exception err)
{
this.PublishError(err);
}
}

View 2 Replies

DropDownList / Based Off What Is Selected As The Dropdownlist?

Oct 6, 2010

I am trying to make a simple dropdownlist.Based off what is selected as the dropdownlist, I want it to open a new webpage.

For example:

Here is the dropdownlist - If they select team1, I want it to open up webpage /team1.aspx If it's team2, team2.aspx and so on.

<form id="form1" runat="server">

View 2 Replies

Visual Studio :: Intellisense And Indent Switching Off In VWD 2010?

Jul 7, 2010

I wonder if any of you guys could help me. When writing code occasionally I hit return to start a new line and the line is started from the far left instead of the same indentation as the line above like I would expect and when typing there is no intellisense, its happened a few times now

View 1 Replies

VS 2008 - Reading Contents Of A Text File Into Text Box On Form

Jul 13, 2011

I'm trying to read the contents of a text file into a text box on my form. When I run the following code, nothing happens.

VB.NET Code:
Protected Sub lbLogs_SelectedIndexChanged(ByVal sender As Object,
ByVal e As EventArgs) Handles lbLogs.SelectedIndexChanged       
For Each li As ListItem In lbLogs.Items           
If li.Selected Then                Using sw As New StreamReader(li.Value)                   
txtLog.Text = sw.ReadToEnd                     sw.Close()                End Using            End If        Next    End Sub

I populate the ListBox with ListItems and each ListItem's Value property holds the full path to the file. But, I removed all of that and just put txtLog.Text = "test" inside of the "is selected" block.

View 6 Replies

JavaScript - Dynamically Creating A TreeViewin HTML With Indent Lines?

Mar 10, 2010

i'm quite new to HTML, and am trying to create a professional looking TreeView.

I can not use the in built TreeView in ASP.NET as i need to point the target of the selection to another frame (I have tried, and this doesn't seem possible).

My TreeView is built up as follows:

[code]....

I have the collapsing of the folders working, but would like to know how to format this TreeView so it has dotted lines down to the child nodes (as most TreeViews tend to have).

How would i go about this?

View 1 Replies

VS 2008 - Server Text Field To Text Box

Apr 11, 2014

I have an old database that still contains depreciated Text fields. I need to pull from these fields and display the results. You would think this should be easy... First my select statement caused a problem:

Code:
SELECT DISTINCT ..., CustomerInstructions, ... FROM Orders
where CustomerInstructions is a Text field.

The error I get: "The text data type cannot be selected as DISTINCT because it is not comparable." A quick search shows I can cast the text field as a varchar(max).

Code:
SELECT DISTINCT ..., CAST(CustomerInstructions AS VARCHAR(MAX)), ... FROM Orders

Now I get an error while trying to load the instructions into a text box: "Specified argument was out of the range of valid values. Parameter name: index"

Not sure what the problem is here. I have text and a text box. What's with the "out of range" crap?

View 2 Replies

VS 2008 Creating Role Based Authorization?

Feb 9, 2011

I have seen articles on Role Based Authorization in MS-Sql server-Asp.net but i did not find any article in MySql-ASP.net/vb.net, i am acheived this concept using session user name i am enabling certain parts of website to group A and certain parts of site to Group B but when i have more groups i cannot use this method.

Myrequirement is:

In Web applications, typically there exist certain parts of the site that only certain folks, or groups of persons can access. For example, imagine Web site used to administer the content on a company's public Internet Web site, where the public Web site lists products sold by the company. From the administrative site, all company employees might be able to make minor changes to the products' descriptions, quantity, and other such non-essential information. However, perhaps only a subset of trusted employees might be able to change the products' prices. And even a smaller subset of employees would be able to add new products or delete existing products from the database I would be delighted if any one provide the solution

View 9 Replies

VS 2008 - Dynamic Changes To Treeview Based On Sitemap

Dec 19, 2011

I have a web app with treeview based on a fairly simple sitemap. The only catch is that I want to be able to remove nodes based on a user's role. We are NOT using the asp.net security so I can't take advantage of the built-in function.When I put code in the master page load event (or anywhere else it seems), there seems to be nothing in the treeview object yet, so I can't make changes to it.

View 7 Replies

Proper Way To Populate Dropdownlist Based Off Another Value?

Dec 21, 2010

I'm running into a minor issue with some ASP.Net code I'm working on. For simplicity sake lets say I have two dropdownlists, one that is full of various items and another that is full of other items, but based off the selected item of the first dropdownlist. I currently set variables into hidden inputs to check to see if the item in the first dropdownlist has changed and if it has to change the second dropdownlist, but I'm also having to check to make sure that if something else causes a postback to NOT repopulate the second dropdownlist as to not lose what is currently selected by the user. This check also allows me to make sure that when I navigate away from the page, the correct values are selected and not something replaced by a postback repopulation.

I'm new to ASP.Net/HTML/CSS/Javascript and the like. I know while what I have works, it isn't even close to being the correct way to do things. correct my ways and figure out the BEST way to solve this current problem. Some good ASP.Net tutorial websites would be nice too as I need to keep improving my skills with it.

View 2 Replies

How To Redirect Based On Selection Of DropDownList

Jul 26, 2010

I have a TextBox1 and a Search button in my application with this following code:
protected void Button1_Click(object sender, EventArgs e) {
Response.Redirect("~\searchpage.aspx?PatientNRIC=" + TextBox1.Text); }

Which means, if the user type ONLY IC NO:S1234567D, then when click it will show the patient detailview. So I now I'm doing almost the same thing but now I have a TextBox2 and a DropDownList1. Inside DropDownList1, I have "Name", "IC No", "Test_Date". So for an example, I type "S1234567D" in the textbox1, and I choose "IC No" in DropDownList1 it should redirect me to a page of the S1234567D's patient detailview. How could I do my code?

View 2 Replies

Web Forms :: Add Own Value In Functions Based On Dropdownlist?

Dec 2, 2010

create function StyleGen(@ID int)

View 4 Replies

VS 2008 - Role Based Authorization For ASPX Pages

Aug 2, 2011

I am having a very simple intranet site. I took the sample for my project from [URL] ....

I have integrated windows authentication with Role based authorization. There are only 3 .aspx pages and I have a tree view control on the master page. depending on the choices that the user's make on the tree view control the .aspx pages gets displayed.

There are only 2 active directory groups. Sales and Marketing. My network id is not in Sales AD group.So obviously it prompts me to put userid and password and it throws not authorized error when i try to access PortfolioData.aspx page. So far so good.

But I am a member of AD group MARKETING. I should be able open the page Schedules.aspx (please see the config file below). But I still get the Error message 401.2.: Unauthorized: Logon failed due to server configuration.

Code:

<!--
<authorization>
<allow roles="domainADGROUP_SALES"/>
<deny users="*"/>
</authorization>

[Code] .....

View 2 Replies

VS 2008 - Role Based Security Not Working In Application

Jul 12, 2011

I have an asp.net application. This is a role based authorization. Basically, if the user's are in a specific AD group, it should allow them to look at the webpage. Otherwise it should error out saying "not authorized".

In the web.config file, I have the following lines of code. I made sure I am in the Apr-Sales-Writers AD group.

Code:
<authorization>
<allow roles="Apr-Sales-Writers"/>
<deny users="*"/>
</authorization>

Issue: when I go to default.aspx page, it prompts for a userid and password and even though I put correct password and userid, it says "not authorized error".

Code:
Access is denied.
Description: An error occurred while accessing the resources required to serve this request. The server may not be configured for access to the requested URL.

Error message 401.2.: Unauthorized: Logon failed due to server configuration. Verify that you have permission to view this directory or page based on the credentials you supplied and the authentication methods enabled on the Web server. Contact the Web server's administrator for additional assistance.

In the IIS project (on IIS server), I configured it to be a "Integrated windows authentication".

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved