I'm building a web app that requires data found on an exterior web site.
The data is found in a tag formatted like this:
<a id="hello" href="/not-important">valueSought</a>
What is the best way to parse the web page and extract the data I need?
i need a way to extract the data from the below in to an array of some sort so i can post only what i need to my page.
the field i need is the var lasttrade and the var lasttrade
how do i go about extracting the data to get what i need... im used to xml feeds but not this...?
[URL]
Doesnt HAVE to be an array, just anything i can use to get the data from the page and post
I have a web page that when the user presses the "Go Back" button, if the formview is not in ReadOnly mode, to ask if they want to exit without saving.
I was thinking of having a pop-up window to ask this question, but I am unsure of how to do this.
What are my options for turning a grid of data in my webpage turn into an excel file.
Is it best for me to return data to the server for the excel file to be made...
I've seen IE open excel files kind of natively - how is that done? Can I hyjack that functionality somehow??
I have a dropdownlist and a button(btnSend).
protected void btnSend_Click(object sender, EventArgs e)
{
InsertIntoTemporary();
LoadAddressdetails();
MassSendOut();
}
What i need to do is as follows;
1) Once i select the item in the dropdownlist, it will extract data from my sql query which is :
string mySQL = "SELECT * FROM examtimetable WHERE subject_name= '" + dd_cat.SelectedValue + "'";
Once seleted,it will display everything in a gridview1.
subject_id subject_name admission_no date venue seat_no
How do I display table database information from two or multiple databases tables where they are linked by one field? For instance, I have an Orders Table and Customer Table, and both are linked by OrderID, and I'd like to display all Orders and the corresponding Customer information.
View 8 RepliesI want to know how do you extract values (after the equals sign "=") from a txt file like this, then put the values into a table residing in a database.
channel num = 0
channel State = Active
Working mode = Active
Startup Key = 123456
DTMF = 0118374683
CallerID = 123456
Call direction = Outgoing call
Call Started = 2009/12/22 12:38:45
Call Ended = 2009/12/22 12:38:58
Call Duration = 00:00:12.5000000
I have got a text file that I need to extract details from.the text file is in the following format:
FirstName SurName (emailaddress)
FirstName SurName (emailaddress)
FirstName SurName (emailaddress)
FirstName SurName (emailaddress)
FirstName SurName (emailaddress) Etc.
Ideally I would like to have the the contents saved to an additional text file in the following format:
FirstName,Surname,EmailAddress
FirstName,Surname,EmailAddress
FirstName,Surname,EmailAddress Etc.
I am trying to extract data dynamically from a site. The site URL is generated, then i want the code to visit the site and take out the data from the description meta tag... can someone help me? I have repeated what im doing with the original search, but now i want to visit each url generated (which will involve visiting a href='http://{0}'>) and use the regex codes ive made. Im also wondering about the order of the code...?
WebClient objWebClient = new WebClient();
string url = "http://www.google.com/search?q=" + TextBox1.Text + "&num=100";
byte[] aRequestHTML;
aRequestHTML = objWebClient.DownloadData(url);
[code]...
Example- %%D1,100,0,0004[data...][0d0a]
[code]....
from the above example i want to extract picture data and need to store in to the sql table.sql table olumname is image and datatype is also image.after that i wanted to display this image column to an aspx page.
I want to extract data from table into a view. MEans i have datatime field with value '12/31/2010 12:00:00 PM' in a table .
I want to change the field format in view to Date like '12/31/2010'.
Iam using oracle 10g.
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(-)..
I have this text in a string:
[Code]....
and I need to extract this:
123;P (A A); 2005
45678;A (H H); 2001
9999;As (D D); 2010
maybe regular expression can make it simpler...?
[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.
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">
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...
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#.
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.
I have a table growth 100000row per day, I'm facing many problems to export data from this table using ASP.net page.
I don't know how to apply this scenario:
Senerio 1:
1- run Asynchronous function to export data from SQL for specified period to CSV file (without locking the table)
2- Refresh page every 5 sec in order to track the status of extracting data
3- compress the file
4- Stop refreshing and showing the download link in order to download the compressed file
or
Senerio 2:
1- run Asynchronous function to export data from SQL for specified period to CSV file (without locking the table)
3- compress the file
4- send the compressed file by Email
I have done the following: Added additional data to the profile table. However, the information is in a string. I am not sure how to extract the information using SQL so that I have the additional data separated. Additionally, I am not too sure how to call this information back into the webpage, once the customer log ins.
View 2 RepliesI have field_1, the data format store in the field is about "Mary, Amy, Billy, Ma" how can i extract the record that the field_1 has Mary.
I can't use the like'%Mary%' because it can extract 'Ma' too.
I would like to extract exactly Mary. or can i split the field_1 by ',' in sql?
I happen to have used datasets and hence data tables in most of data access approaches.
This time arround i want to exctract the integer value and use it in the if statement for testing.
I however face a problem in the fact that though i can select the particular cell in a table i still get a table adapter which is not what i need and is not covertible to int value.
See the code below:
[code]....
How can I extra this particular xFiled value and return and integer value rather than a data table?
I put a dropdownlist in a template field with 4 choices with the values of each to a,b,c,d and when i run the update query i need it to pull from that selected row,and read the value selected in that field. I tried this:
@choice = SelectedRow.Cells[9].Text.ToString() but it didnt work
how can i extract data from a dropdownlist thats inside a template field and use in a update query?
My work is done properly all good with this query
View 1 RepliesRepeater data rendering problem
im using Visual Web Developer Express2005 and language: VB
Example Image of my forum thread that im working:
i encircled in color red the part where i assign the 'content' as you can see above.here EXAMPLE of code in my repeater that populate a <td>(inserting data FROM my database) from my TableField('content')
[Code]....
the part that i encircled in the image above was the data on my tableField named--> 'content'.
The idea was to show not the whole content but to show Only some part of it. example is to show only the 1st 300chars or 100 words.
i tried this code which shows the fist 1-100 chars. [Code]....
Problem is the data i stored in the TableField('content') has other html tagsExample my Tablefield('content') has the following data.
<p class="MsoNormal" style="margin: 0in 0in 0pt"><span style="mso-ansi-language: EN-CA"><span style="font-size: x-small">All hands worked in the preparation..............
When i use the code .tostring.tosubstring(1, 100) it shows: <p class="MsoNormal" style="margin: 0in 0in 0pt"><span style="mso-ansi-language: EN-CA"><span style="font-size: x-small">All hands worked in the preparation..................
instead of starting at: All hands worked in the preparation.......Is there a way that i could extract first the html tags then use the
.string.tosubstring(1, 100) to make it work.I use the code below temporarily to generate the 'content' as showed in the image above. i limit the height of the lable to 100px which does the trick. but i know its not a good method thats why im trying to look for other methods.
<asp:Label runat="server" Height="100PX" Width="615px"><%#DataBinder.Eval(Container.DataItem, "Content")%></asp:Label>
------------------------------------------------------------------------