[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.
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.
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 take data from Sqlserver database , and my prblem is that i want to get old and new values from gridview and base on that i want to change there background colors .. i try gridview rowupdating , editing ,updated Events but when i debug no break point hit and there was no value in ViewSate that i declare ,
View 2 RepliesI 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 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
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 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 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 have a table and 7 column name.
I bind the 7 column name in one dropdownlist.
Now the problem is,how do I extract the data value in a dropdownlist?
For example,
Dropdownlist contain 7 column name
-subject_name
-subject_code
-venue
-time
-seat_no
-admission_no
-subject_id
when I click the subject_name,I want it to appear in a gridview
Example
Math|9.00-10.00|Hall|18|09090J|...
Below is my current codes which I have a problem.
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Data Source= EN\SQLEXPRESS;" + "Initial Catalog=ms;Integrated Security=SSPI");
SqlDataAdapter adapSel;
string mySQL = "SELECT '" + dd_list.SelectedValue+ "' FROM examtimetable ";
adapSel = new SqlDataAdapter(mySQL, conn);
conn.Open();
DataSet dsSel = new DataSet();
adapSel.Fill(dsSel);
GridView1.DataSource = dsSel;
GridView1.DataBind();
conn.Close();
}
Previously I have bind 7 column name in my dropdownlist
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack == false)
{
SqlConnection conn = new SqlConnection("Data Source= EN\SQLEXPRESS;" + "Initial Catalog=ms;Integrated Security=SSPI");
SqlCommand sqlCmd = new SqlCommand("select column_name from information_schema.columns where table_name='examtimetable' and COLUMN_NAME not like '%ID'", conn);
conn.Open();
SqlDataReader ds;
ds = sqlCmd.ExecuteReader();
dd_list.Items.Clear();
dd_list.DataSource = ds;
dd_list.DataTextField = "Column_Name";
dd_list.DataValueField = "Column_Name";
dd_list.DataBind();
dd_list.Items.Insert(0, "Select Option");
ds.Close();
conn.Close();
}
}
My work is done properly all good with this query
View 1 RepliesExample- %%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'm having trouble retrieving the value of a cell in a gridview.
I think it may have something to do with the item template calling a function since I am able to retrieve the values of cells that are not calling a function in the same gridview.
How can i extract the displayed value from this cell?
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
GridViewRow row = GridView1.SelectedRow;
lblTest.Text=row.Cells[7].Text;
}
<ItemTemplate>
<%# GetWednesday(decimal.Parse(Eval("Wed").ToString())).ToString("N2") %>
</ItemTemplate>
i have a grid view which displays only one value and i need to extract that value and display it in a textbox?
View 4 RepliesI 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]...
I 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 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 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...?
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