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:
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Dec 2, 2010
create function StyleGen(@ID int)
View 4 Replies
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
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