I have two coloumns in a table to store Registered and Closed dates.
I want to calculate the period and to show in labels templated in detailsView.
Period should be like this:
72 Hrs and 58 minutes
a user will choose a period of time (from this date to this date) with a calendar ,, and then i want to get from DB all Invoices that were created within this period ??
each Invoice has a Date saved in Database..
This is the sql select statement i am using:
SelectCommand="SELECT [invoiceid] FROM [invoices] WHERE (([location] = @location) AND ([name] = @name)) AND date BETWEEN '"+ (fromdate.SelectedDate.ToShortDateString()) +"' AND '" + (todate.SelectedDate.ToShortDateString()) + "'">
i am getting this error message:
System.Data.SqlClient.SqlException: Conversion failed when converting date and/or time from character string.
How to display dynamic header for datalist control(Dates are dynamic).Also i want header in each row.I want something like this.Words in bold are headers.Header also in each
row.8/1/2010,8/8/2010,8/15/2010,8/22/2010 are dynamic dates whic change every month based on user selecting date from datecontrol.
HeadCount 8/1/2010 8/8/2010 8/15/2010 8/22/2010
Forecaster HC 447 446 441 432
Agents Scheduled 447 446 441 432
In a formview I need to present a new value calucalted by dividing one field value by another. I need to present the result to one decimal place. The code I am using is the following, however it presents the resulting value rounded up or down to the nearest whole value:
<asp:label id=lblTotal text='<%# Convert.ToInt32(Eval("Value1")) / Convert.ToInt32(Eval("value2")) %>' runat="server"></asp:label>
I did try and insert refernces to {0:N1} but this just threw asp.net errors. Any advise on how I can guarantee that the value calculated is presented to one decimal place?
I'm not sure how to do this, but I did read a lot of post and searched for it.
Protected Function GetTotal(ByVal DonTotalQty As Decimal, ByVal DonValue As Decimal)
Why am I getting this error? I'm trying to do a calculation on my GridView2 and I'm using clientside javascript. I need to add the onkeyup attribute. How do I do this?
Code Behind:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
CType(GridView2.FindControl("TextBox13"), TextBox).Attributes.Add("onkeyup", "calculateSubTotal")
End Sub
I am using a grid form to diplay data... the insert form is completely a separate form. In the insert form a text box called "FormPercentageTextBox" is getting a calculated result using javavascript based on some field ( field1,field2) values (val1, val2).
the problem i have is: when i edit the form and i want to update any value..i want the new calculation result showing on the edited "FormPercentageTextBox" field. I need to have this calculation reflected/
I am trying to arrange the information from a SQL record into a 3 column by 3 row table to fit the form presentation that I want. I have placed on the page 3X3 table and then tried to place a detailsview in the first cell for the first picture called P1dv.
I have place a detailsview in the last cell that would control the paging of information called Controldv. I need to fiqure out how to link P1dv paging to Controldv page action. I am using visual web dev. 2005. I am not updating or editing these are read only views.
example of what i need the form output to look like:
picture1 picture2 picture3
name1 name2 name3
Contact1 contact2 contact3
what i ave coded as of now:
[Code]....
I´m trying to link the gridview to detailsview and I used this page as my inspiration:
http://quickstarts.asp.net/QuickStartv20/aspnet/doc/ctrlref/data/detailsview.aspx
But I´m trying to do that programmatically, not with the sqldatasource. So I wrote the method that binds data to Detailsview and I call it in the page_load. The problem is that I have to click two times on the select button to view the detailsview. The first time I click on the select button nothing happens.
I have a gridview with a Select button. Clicking the Select button for a particular item, I need its full details displayed in DetailsView. how I can bind to DetailsView? Here is what I have so far.
.aspx
<asp:GridView ID="GridView1" runat="server" AllowSorting="True" AllowPaging="True" PageSize="10" OnPageIndexChanging="countryGrid_PageIndexChanging"
CellPadding="4" ForeColor="#333333" Width="400px" Font-Size="9pt" [code].....
I have a gridview in which i have itemtemplates and label controls having data from sql server.
I have two fields say quantity and units and in third field i want their product. I m trying in rowdatabound event like this-
[Code]....
Here my third field is netvalue.
It is throwing error-
Input string in wrong format.
How can i achieve this?
Here is my page:
[Code]....
It basically is 4 questions with each answer assigned a value.
What I would like to do is when the button is clicked the selected values are retrieved and calculated to give a total.
That total is then compared against some common totals and the next value is shown.
So is the total is 8= Very Good, 6= Very Bad, 4= Terrible etc.
The two labels Result and Truth would sho the numerical result and the truth according to the scale.
I am at a loss on how to retrieve the list button clicked value, how to add them up and referance that to the Truth result.
its complicated (to me its "bang head against wall" difficult.
I have kept four column in gridview with dynamically added row...
E.g.
work type      rate    noofworker    amt
Groundwork   10           100       1000
Earthwork   20           100       2000
                                    Total       3000
 OnChange event to fire the calculation...
my query is like this " select product_id, product_price, purchase_amout from purcases"
and on my formview i tried to add a "total purchase"
i tried using <asp:Label ID="total_purchase" runat="server" Text='<%# string.format(cint(eval("product_price")*eval("purchase_amout")),"{ Rp 0:###,###,###,###,###}")%>'>
the total amount show the correct calculation result, but the string format dont work.... so it display 20000 instead of Rp 20,000
btw. "Rp" is the currency symbol in my country... i dont use {0:c} coz the server user US currency
I currently have 3 tables and return an average value for the OverallRating Column on each to get a CombinedOverall, but what if one of the tables does not have data for a particular customer? if I divide by 3 the answer will not be the same, and I could get an answer that is over the max I want (5.0)
[Code]....
It will be possible that the Customer will not have any data in one of the tables.
How do I get around this?
I have 3 dropdownlist for date, month, year. When I select DOB from dropdownlist, the age should be calculated automatically and display in textbox. What can i do?
View 1 RepliesI have a web page in asp.net+vb code+sql database. in an table named course_intake i want to count i tried some and it works correct but i am not able to add more clouse to it
1. if date1 (field) not equal to date2 (field) then att pd as 1 else 2
2. (OY is a field)  if OY Ends is lesser than Jun then Deg Dt as 1 Jul+ OY end year (example if OY is 5 Jun 2012 then deg dt will be 1 Jul 12 else 1 Dec 12)
3. Count from COURSE_INTAKE where OY LIKE 'YO-' WHERE ENTRY_COURSE= ENTRY_COURSEÂ
4. Count from COURSE_INTAKE where OY LIKE 'TAKEN YO-' WHERE ENTRY_COURSE= ENTRY_COURSE
5. Count from COURSE_INTAKE where OY LIKE 'DONE' WHERE ENTRY_COURSE= ENTRY_COURSE
My code is as under
select ENTRY_course,COUNT(*) as Str,convert (varchar, DTsen,6) as [DTSEN],convert (varchar, DTCOM,6) as [DTCOM],
dbo.getBTechBECount(ENTRY_course) as 'BTECH',batch,dbo.getMedCount(ENTRY_course) as 'MED',convert (varchar,
DTCOM+396,6) as [AVL for OY], str-btech AS [STR AVL]
FROM COURSE_INTAKE group by ENTRY_course,DTCOM,dtsen,batch, str-btech ORDER BY dtcom
I am looking at the following article [URL] .... its converting a gridview to excel. On my gridview I have a running total on the footer, and i do know to to change the code or add code to add this to my excel document...
View 1 Repliesi have one grid which have 5 columns 1 for subject,2,3,4 for marks which have textbox to insert obtained marks,and last column have one lable to display total of (2+3+4),now i want total value on textbox event,when user enter any value to any column of textbox i need to display total of all three columns in total column.
View 2 Repliesthis is my gridview  footer calculation script, this script is working good if the aspx page is independent , when i use the same script with my asp.net master page content page that script is not working  this is my scriptÂ
what changes i have to do for apply this script to be work in my master page content page in asp.net
function GrossTotal()
{
$("[id*=GridView1]input[type=text][id*=txtCalc]").keyup(function(e) {
var price = $(this).closest('tr').find("input[type=text][id*=txtCalcPrice]").val();
var quantity = $(e.target).closest('tr').find("input[type=text][id*=txtCalcQuantity]").val();
var total = parseInt(price) * parseInt(quantity);
$(e.target).closest('tr').find("[id*=lblGrossTotal]").text(total);
});
}
I need some pointers to start on this.We are building a time off application where three instances of a calendar control will be displayed ( prev - current and next month) now users can click on various dates accross all three instances and then a count of number of days should be diaplyed in the parent textbox.
To begin with this, i started with adding the dates clicked by the user in Calendar2_SelectionChanged method into a list<> so that i can get the all dates user clicked and then add it to calander's selected dates collection. But this throws an e" object reference not set" error.
Is there anyother way to get all the dates that user click onthe calendar( note the dates doesn't get highlighed so seleteddates doesnt work)does anyone has a good example for this.
I have two tables along with some of its attributes as follows:
ProjDetails: ProjID, StartDate, EndDate
ActDetails: ActID, AStartDate, AEndDate,
What i would like to do is to compare the AStartDate with both StartDate and EndDate which will be done in a DetailsView both insert and edit mode. This is to make sure AStartDate is within both those dates. (Same goes for AEndDate)
At first i though of extracting the StartDate and EndDate from the database and then make the comparison. But i am having problem because both StartDate and EndDate are data type "date" as follows:
Dim strProjDate As String
Using myConn3 As New SqlConnection(connString)
myConn3.Open()
Dim command3 As SqlCommand = myConn3.CreateCommand()
command3.Connection = myConn3
command3.CommandText = "SELECT StartDate FROM ProjDetails WHERE ProjID = @ProjID"
With command3.Parameters
.Add(New SqlParameter("@ProjID", TB_GenerateActID.Text))
End With
strProjDate = command3.ExecuteNonQuery()
TB_ProjStartDate.Text = strProjDate.ToString
End Using
The above code only displays "-7" in the TB_ProjStartDate textbox.
By the way, I am using Web Developer 2008, VB.net.
<asp:datagrid
id="dgCertification"
runat="server"
Width="860px"
GridLines="Horizontal"
CellPadding="2"
AlternatingItemStyle-BackColor="Linen"
[code]...
How do i show the available data based on the dates? Something like the show only FUTURE dates data.
View 4 Replies I am using the following code to select data which appears between 2 dates:
string query = "SELECT (name, date) FROM date where tableinfo
BETWEEN @date1 AND date2";[code]....
Now the above code is working fine. The only problem is that the date in the date column of the gridview is not in the proper format. What can i do in order to change the format of the date in the gridview. If the format of the date is changed in the databse itself I may be able to use the above SQL query.