DataSource Controls :: How To Extract First 3 Digits From A DropDownMenu
Apr 21, 2010
I have a web form where there are couple of DDL's; DDL1 and DDL2 respectively. I want the DDL2 to be populated based on what option is selected in DDL1. Also I just want to extract the first three digits of the value selected in DDL1 and use it in the WHERE clause of the SQL query used to generate DDL2.
My prob is that I am not able to extract the first three digits out of DDL1 to be compared to another field from the DB in the WHERE clause of the SQL query for DDL2.
Here is my code for DDL2
[Code]....
View 15 Replies
Similar Messages:
Mar 18, 2010
I need to extract numerical digits from a string using sql in a select statement
"Customer is eligible for Balance Billing with $10 credit on the next bill. Fixed monthly Balance Billing amount is $141.38. Offer is valid till the end of March 31, 2010."
I need ot extract 141.38 from teh above text.The length of the decimal can vary
View 5 Replies
Feb 23, 2010
I currently have a numeric field as numeric(5,2) which has 2 digits after the decimal. Now I need to be able to display 4 digits after the decimal. But if I change the field to (7,4) then it places 2 zeros after the last numbers. For example: 1.32 changes to 1.3200.
But some records will have exactly 4 numbers after the decimal such as : 2.4375.
My issue is I don't want all the data to have 4 numbers after the decimal. I don't think there is another data type that will allow this.
View 3 Replies
Apr 9, 2010
i have a data column which contains data in the folowing format :
12345-ABC-1234
1234-AB-123
123-A-12
how can i retrive columns based on the characters between the hyphens
e.g. only those columns which contain AB between hyphens(-)..
View 2 Replies
Apr 15, 2010
i hve a data column containing data in this format...
1234-ab-1234
123-xy-123
12-ab-12
123-xy-123
1234-a-1234
12-s-1234
1234-xy-1234
how can i extract data between hyphens (ab, xy, a, s).. i need to extract distinct data only...
View 4 Replies
Jun 11, 2010
I am looking for a fast way (either by script or Query statements) that would enable me uniquely extract some tables from my database schema.
The tables I wish to extract have some unique columns like x and y coordinate columns and i want to extract only the tables that have these coulmns in them.
My database schema is very large with 100s of tables that i cant just go through the tables one by one.
View 4 Replies
Feb 24, 2010
how can i split the frist word in sql if the field contain ',' otherwise, only show the data value.
if the field is 'A,B,C'
I would like to select A as a result.
View 3 Replies
Mar 25, 2011
've created a simple gridView which lists all products based on category within a dropDownMenu (select * where CatID = dropDownMenu).This works just fine, but is there a simple way to add 'Show All' in the dropDownMenu -
View 5 Replies
Jan 6, 2011
I have a gridview column named "Job Number" and the number is in this format: 01-04-11-3215, 01-04-11-3216 and so on...
Since the first few characters represent the date I need to sort on the last 4 digits.
View 2 Replies
Jun 29, 2010
*I used one dropdownMenu and Textbox. The datas including Two columns(one for dropdownmenu and another one for textbox) are stored in the database.If i click on any data in dropdownmenu,then the corresponding data should be displayed on the textbox..
View 1 Replies
Mar 17, 2011
I've put together the following code which generates a dropdownmenu list (values from a database) in a repeater control, then adds a final item. I can make it selected, but I'd like it to appear at the top, rather than the bottom as it does now.
[Code]....
View 2 Replies
Oct 10, 2013
when i upload a file with extension zip by fileupload countrol...i want to extract the file and save in to server mappath (root)
View 1 Replies
Nov 22, 2010
[URL]
As seen in the pic above, i wanted to extract out the selected data at the price and mulitply it with the quantity.
How to i "take out" the value at the price when that row is selected then multiply it with the input quantity to calculate the total price
I'm using VB btw.
View 3 Replies
May 7, 2015
I have a scanned pdf document which contains an image and some lines of text after the image what i need to do is to take the image part and convert it in jpeg without the text part,how can i do that in an application in .net,first of all is that possible that from scanned document containg text and image i can only extract image and then convert it into jpeg
View 1 Replies
May 7, 2015
I am using this article [URL] .....
My question is on how to unzip file without the file upload, since there's no fieupload, the file will manually code behind.
For example:
file.zip, then it will be unzip in the folder files.
The file.zip is fixed in code behind.
View 1 Replies
Sep 20, 2013
Code to extract from starting word to the ending word in pdf.
for example in the below part of pdf file i wan to extract para from Jana-gana to jaya jaya jaya jaya he...
(1) The composition consisting of the words and music of the first stanza ofthe late poet Rabindra Nath Tagore’s song known as “Jana Gana Mana” isthe National Anthem of India.
It reads as follows: -Jana-gana-mana-adhinayaka jaya heBharata-bhagya-vidhataPanjaba-Sindhu-Gujarata-MarathaDravida-Utkala-BangaVindhya-Himachala-Yamuna-Gangauchchala-jaladhi-tarangaTava Subha name jage, tave subha asisa mage,gahe tava jaya-gatha.Jana-gana-mangala-dayaka jaya heBharata-bhagya-vidhata.Jaya he, Jaya he, Jaya he,jaya jaya jaya jaya he.
The above is the full version of the Anthem and its playing time isapproximately 52 seconds.
View 1 Replies
Feb 17, 2010
I am tring to extract a value from a monitored device that outputs values in an XML format:
<?xml version="1.0" ?>
- <server host="ePDU" address="192.168.168.123" address-backup="192.168.123.123"
name="Monitored ePDU" version="1.11" mac-address="00-19-85-F0-4E-A2" company="Eaton"
company-url="http://www.epdu.com/" buzzer="0" tempunit="C">
View 2 Replies
Nov 25, 2010
previously i did a post similar to the prob i'm having now, the link is here
http://forums.asp.net/p/1625701/4178673.aspx#4178673
For now, my problem is i do not noe how to extract out the insert value from the gridview's textbox.
So now how do i extract out the selected data from the column price and quantity and multiply them?
A preview of my cart is here
http://i239.photobucket.com/albums/ff47/klxian/cart.jpg
And i'm using VB btw, i do not know C#.
View 3 Replies
Aug 16, 2010
i used the following line of code in the row editing event to extract values from the gridview.
x = GridView1.Rows(e.NewEditIndex).Cells(1).Text
However i am getting the old values from the cell!
I need to extract the new values which i enter during updating.
View 4 Replies
Jun 16, 2013
I want to read a pdf file which contains empid and code for 100 nos.. in front end I'll give specific empid..then the corresponding code has to be displayed in the textbox by reading pdf.. I know this can be done by itesxtsharp.dll and regex..
View 1 Replies
Sep 17, 2013
How to extract word from the text file
example, in the below text file i wan to extract - Total Charges
Previous Balance (see back for details)
$196.82 Credits
$4.97 Taxes, Governmental Surcharges & Fees $5.85 Total Current Charges $196.36 ALP-Account
Total Charges Due by August 16, 2013 $196.36
View 1 Replies
Feb 3, 2010
How to I use DataFormatString to display last 4 digits (xxxxx1234)?
<asp:BoundField ReadOnly="True" DataField="SSN" >
<ItemStyle Wrap="False" />
</asp:BoundField>
View 1 Replies
Feb 15, 2011
I have a TextBox in a FormView that I want to make sure that the user enters exactly 9 digits. The FormView is inside an Update Panel so I want to be able to validate without a Postback. I cannot figure out which validation control can do that and how. I already have a FilteredTextBoxExtender that forces all digits.
View 3 Replies
Jul 23, 2010
my code:
[Code]....
I have a stored encryption: "dkljas84u238jidasjidoia"When I get in this instance decryption "11111111111111111"show how the combobox "****************** 1111 "Something like: SELECT RIGHT ('11111111111111111 ', 4)
View 5 Replies
Jan 4, 2011
I have a textbox where the user must not be able to enter more than two digits after a decimal.How do I do this without using javascript?
View 3 Replies
