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'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 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 Replies[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">
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 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 want to be able to get the values from a certain column in my gridview and send the data from these columns to a n array in javascript
The array is called yValues[].
The program is a graphing one that takes data from a database and displays it with a graph.
I am fresh to asp.net. I m using vb to write it. Could someone who is professional guide me? I want to input data from textbox to "unknown size" array or arraylist, and bind it to gridview. I have more than 1 data to input. Do i need to use loop to bind?
View 7 RepliesI'd like to make a page that displays information from my database, but in an atypical way. Each record from my data includes an image and some information about the image. I'd like to display an array of images, each with its associated data underneath the image. I'm imagining a table with four columns and in each cell there is an image and underneath the image is information about it (name, size, author).
You can get an idea of what i'm trying to achieve by looking at this webpage:
[URL]
how to implement this with asp.net??
I am looking to use a gridview as an array that does not get loaded with data, instead I would like to use it as a grid which contains textboxes that the user can enter information in to, which I will read.Is this the right control to use? If so, how do I make the grid visible when I am not binding any data to it?
View 5 RepliesI 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?
Repeater 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>
------------------------------------------------------------------------
Whenever I try to export a ListView with formatting or dynamic content in the PreRender event to an Excel file, I lose all of the changes from the PreRender event. Here's the ListView code:
<asp:ListView ID="ListView1" DataSourceID="profileData" runat="server" DataKeyNames="ROW_NUM">
<LayoutTemplate>
<table cellspacing="0">
<thead>
[Code]....
I've done some reading and found that RenderControl possibly ignores anything in PreRender for a control, but I'm thinking there has to be a way to get those PreRender changes in there before extracting the ListView to Excel.
The only workaround I've found so far is to copy and paste all of my preRender code into the Page_Load, and then everything looks fine in Excel. However, then I have to duplicate my code, as I still need it in the preRender event to display it on the screen properly. I don't want to maintain the code twice.
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 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...
I used Autocomplete Without using web Method(ajax call). But I want get data for textbox from database. How I can this?
View 1 RepliesI have a dropdownlist in datalist. I use arraylist to bind the datalist. In arraylist it is "DataNew" Class which has the property of DataTable "dt_city". Now I bind the DataTable to dropdownlist
Line73: <tr>
Line 74: <td style="width: 100px; height: 24px">
Line 75: <asp:DropDownList ID="DropDownList1" runat="server"
Line 76: SelectedValue='<%# DataBinder.Eval(((DataNew)Container.DataItem).dt_city,"city") %>'>
Line 77: </asp:DropDownList></td>
But I got the error of:
Server Error in '/AFIRS' Application.
DataBinding: 'System.Data.DataTable' does not contain a property with the name 'city'.
Description:
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.HttpException: DataBinding: 'System.Data.DataTable' does not contain a property with the name 'city'.
I'm trying to bind an array to a radiobuttonlist following the example from this link: [URL] The main difference is that I am creating my array from a database... the array seems to be populated just fine, I can create a label from any cell of the array, but I just can't make a radio button list from the array.
[Code]....
I get the error on the last line there and can't figure out why. EDIT: fixed the pasted code.
[Code]....
My Default Page
[Code]....
when it goes to databind it gives me error asDropDownList1 do not contain binding with ID
I have a datalist in which i want to do away with -- change to data recieved into an array list.
Goal: This is a working code. Instead of setting the datasource (TABLE) for the DataList -- I want to set the data table to an array list
Dim xUserAccess As New User()
xUserAccess.UserAccess(txtEmployeeID.Text)
If xUserAccess.errorFlag Then
lblErrorMsg.Text = xUserAccess.ErrorMessage
Else
DDLUserAccess.DataSource = xUserAccess.UserData
-- Change to an array list
DDLUserAccess.DataBind()
End if
I need to have a Repeater with the letters of the Alphabet, when the letter is clicked on it returns all the "names" that start with the corresponding letter in a gridview.
I have got a basic repeater below working but when I tried to change it to a LinkButton I seem to have problems with the CommandArgument.
<asp:Repeater runat="server" >
<ItemTemplate>
<%# Container.DataItem %>[code]...
I have seen some close examples of this in C# but I need it in VB and the converter I use says incomplete snytax.
I have an array in my code behind page. say:
int[] Hour = new int[24];
I also have a dropdownlist on my aspx page. say:
<asp:dropdownlist id="ddlHour" runat="server">
I want to bind the value of array to the dropdownlist such that when I dropdown the list, I get to see the values from 0 to 24.