Returning Just Time (in Military) From DB In ASP.NET
Mar 3, 2011I'm saving military time into the database. Then I need to pull this data back out of the database. To get just the time without the date I can do this:
[Code]....
ADVERTISEMENT
Asp.net - Format A Varchar In A Gridview In Military Time To Standard Time
Apr 19, 2012There is a varchar column in the database table in this format of military time 1230 or 1750 or 1320 and that field get populated into a gridview in asp. I need to convert that string to standard time. I have tried the DateFormatString and nothing seems to work.
the asp is
<asp:BoundColumn DataField="ScanTime" SortExpression="ScanTime" ReadOnly="True"
HeaderText="Scan Time" DataFormatString="{0:hh}:{0:mm} {tt}">
<ItemStyle Width="80px"></ItemStyle>
</asp:BoundColumn>
that DateFormatString causes Input string was not in a correct format. error.
I have tried combinations of hh:mm and things like that but since its a varchar I think its failing
Convert The Time Of Day Into A String That Contains A Military Formatted Date?
Apr 21, 2010This seems so simple, but I can't get the answer. I need to get the current time in an hh:mm:ss or sss military format. By military format, I mean that if it is past noon, the hour is the PM time plus 12 (1 PM is 13, 5 PM is 17). I found this bit of code:
[Code]...
It returns the hour in AM/PM format. That is, if it is 4 PM, it returns 04 rather than 16). I can't find documentation on the hh:mm:ss mask. In fact I can't find a simple discussion on how to make the time of day property return time in various formats. After 3 hours of futzing around,
Returning A Real World Time Value?
Nov 2, 2009I am having a problem trying to get a real time back from this code.
Code:
Public Sub Time()
Dim StartTime As TimeSpan = TimeSpan.Parse(txtStart.Text)
Dim EndTime As TimeSpan = TimeSpan.Parse(txtEnd.Text)
[Code]....
I am using a start time of 09:25 and an end time of 10:15 to test this with. I would like it to return 50, as 50 real world minutes went by. I am getting -1331385.
This is mostly someone else's code from a different forum. I have never used a TimeSpan method before and they keep telling me it works "like what I asked for".
Reading Military Times - Error Message Box
Feb 27, 2011I am trying to get both text box to read the military times. If either time is invalid the "enter valid, the "enter valid input" message box should display. In my validMilTime I tested both hours and minutes. I am not sure if I wrote the code for minutes correctly in the validMilTime to test minutes. I test it and it goes directly to "enter valid input". I want it to read "both times are valid" if I put 1200 and 1400 in both txtStart and txtEnd textbox.
Here is my code so far:
Option Strict On
Option Explicit On
Public Class frmMiltime
Private Sub btnEdit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnEdit.Click
If ValidMilTime(txtStart) And ValidMilTime(txtEnd) Then
[Code] .....
Asp.net - Returning In Oracle INSERT Is Not Returning Proper Value?
Mar 15, 2012I have an ASP.NET web application (VB.NET) using an Oracle database. On an insert, I need to get the identity of the inserted row back. I am trying to use RETURNING, but I keep getting a value of 1 returned.
Dim strInsert As String = "INSERT INTO L.TRANSACTIONS (LOCATION_KEY, TRANS_CREATOR, TRANS_EMAIL, TRANS_PHONE) VALUES (:location_key, :trans_creator, :trans_email, :trans_phone) RETURNING TRANS_ID INTO :ukey"
[Code].....
Returning A Function Vs. Returning Variable Name?
Dec 12, 2011My brain may just be fried since it's the end of the semester, but my teacher kicked this back to fix and resubmit...she said that I am "returning the name of your function rather than your variable name".
Here is my code for all 3 forms.
code:
These are forms to calculate the cost of getting a cell phone package.
C# - Convert A Date And Time To UTC Time Based On The Time Zone Of The User?
Sep 6, 2009I have an ASP.NET application with a SQL Server back end. I am storing all my dates in UTC format and doing the appropriate conversions to the local time zone of the browser viewing it. One of the pages asks for a start date and end date (no times).
I am taking the start date and setting the time to 00:00:00 hours (midnight) and I'm taking the End time and adding a time of 23:59:59, so that the date range covers the whole day. Now what I'm trying to do is do a SQL query to do a search for records in this date range. The problem is, the data in SQL is in UTC time and the user is typing their dates and times in their local date and times. My quickest solution was to convert the date and time to UTC, then search the records. However, by doing this, I am to believe ASP.NET converts the given time and date to UTC based on the server time zone. How can I convert a date and time to UTC time based on the time zone of the user?
VBA UDF Returning #VALUE
Nov 13, 2010So I have a pretty simple UDF written in visual basic for use in excel. It calculates your approx. taxes. Lets say I use it as such: =Taxes(I23-I18,I24-I20,"Married")
If I type this in it works great. Now if I save the sheet and restart excel the cell now says #VALUE! If I select the formula and hit enter once again it recalculates it fine. What am I doing wrong? Application.Volatile shouldn't be needed but I was trying ideas. [Code]
.net - Calling A Sub And Returning A Value?
Mar 15, 2012This might seem like an insanely easy question, but I cant seem to find an answer anywhere to it. I'd like to think that I am decent at VB but while I was learning javascript the other day I found something that seemed awesome and now I cant figure out how to do it in VB.in javascript it looks like this
var someValue = getThatValue()Its both calling and setting the value from the getThatValue() sub. what is the VB equivalent?
[Code]...
Asp.net - DaylightSavingTime Returning Different Value?
Nov 2, 2010I have a piece of code that checks a time and then adds hours based on the daylight savings time value.
Dim CommentDateTime as Date = "11/2/2010 8:21:42 PM"
If CommentDateTime.IsDaylightSavingTime Then
'do something
Else
'do something else
End If
The problem that I'm having is that IsDaylightSavingTime behaves differently on the production server than it does on the development.On the development server the case is TRUE, but on the production it is false.
Both servers are running the same OS and are both running .NET 3.5
[Code]...
Asp.net - GetConstructor Returning Nothing
Oct 10, 2011I have two different GetConstructors(), one is returning what it should be returning the other however is returning nothing. ItemName is BSRPTReportPerformanceSubcontractorRating
The first one which is returning what it properly should is:
[Code]...
C# - Returning XML From A Web Service?
Mar 20, 2012I have an XML file that sits on the hard drive of a Server running my Web Service. I need to access that file from another application.
This is my method on my Web Service
Public Function getXMLFile()
Dim xmlDocument As System.Xml.XmlDocument
xmlDocument = New System.Xml.XmlDocument()
[Code]....
This is caused when I try to return the xmlDocument object
From the information I gathered, it's like SOAP wants to wrap my XML in more XML and stops me from doing that.
How do I go about getting the XML File from my Web Service if I can't return XML?
Combobox Isn;t Returning A Value?
Nov 23, 2010i am new to VB programming, actually this is my first time with VB any ways here is my situation that is driving me mad
[Code]...
Msgbox Returning A Value?
Jun 22, 2010I am creating a message box in VB8 for an error. I created the message box and everything works. The message box returns a value of 0 which is the default one. Where does it return 0 to. Or do you have to tell it where to return it.
View 2 RepliesReturning A DataTable In WCF And .NET
Apr 25, 2011Thanks William, that was the ticket. Had to assign the name property on both ends [DataTable.TableName].
On a side note here: There appears to be some school of thought (no offense Marc) that the following statement is always true:
"Everything in the world can and should be made into an object."
It is, simply, not always true. There are cases where you cannot cram your 'object' into any cookie-cutter or class no matter how you try to customize it. For me to objectize this beast, I'd have to create roughly 4,000 objects. I don't have time to do that, and yet this project must run as a service. Frankly I think the developers at MickeySoft need to get out more into the real world, and see for themselves that although theory is great it does not represent true-life challenges. I am all for working with objects for the obvious benefits, but there is a reality that universals do not exist. In my trade, even 'most of the time' rarely happens.
Before they push out a new technology set, and cease support of an old one, they need to make sure that the new technology has the same capabilities the old one had.
For the record: The people who believe the above statement to be true are also the same people who would refuse to take the project I'm currently working on.
Just the same -- thank you both for your time, efforts and opinions!
I'm trying to create a WCF function that will return a table to my console testing app. I am a total noob. The data is 2-dimensional and looks like this:
23 Letter
42 Another Letter
43 Document
[Code].....
...Of course, it won't work. I just need to get the WCF to pass a basic table to my console application. The execute SQL seems to work just fine, I just can't get the data back to my application.
Returning A Function Value
Dec 14, 2009returning a function value? I have a simple function that returns an integer. This function works fine when executed in SQL Developer but, when called from my apps, it always returns 2 regardless of anything. I have checked it over and over again, I cant seems to find where I am going wrong.
[Code]...
Returning A Value From A Form?
Jun 15, 2010I want to return a value (vbCancel or vbOK) from a form which is shown as a dialog from the calling form.So, I overloaded the showdialog method to return the value.Trouble is, a value of zero is returned as soon as the form is shown.Now, if I can make it behave more like the showDialog method where execution doesn't continue until the form is hidden everything would be fine.
View 3 RepliesReturning A Value From DataSet?
May 8, 2012I have a combo box that is "linked" to dataset.
I have a Label that I want to return the value from 'Description' Column from 'Base' Table.
This is determine when user has chose a value from the combo box which is linked to the 'Base' Table from 'Material' Column.
Returning In LINQ To XML?
May 23, 2011I am working with a method using LINQ to XML to return a string.This is the XML
<data name="lnkViewResultResource1.Text" xml:space="preserve">
<value>View results</value>
</data>
[code].....
Returning No Value From A Function?
Apr 20, 2009what changes I need to make to the code so that when no value for intPosition is found the textbox txtRoomNumber remains blank? At the moment a value is being entered into the textbox when no value for intPosition is found.
Code:
Private Sub btnFindRoom_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnFindRoom.Click
Dim strRoomType As String
Dim intRoomNumber As Integer
[code].....
Returning Plain Old XML With WCF?
Nov 15, 2011How can this be so difficult and why? Returning simple XML with no Name Spaces and an XML decaration. Creating the XML using XML Writer is easily done and if I output it to a file then great. How on earth can you return the contents via WCF. Using an XML Element is no good as you loose the XML declaration and using a string is no good as the output is wrapped up in a <string> element. Can't return an XML Document as it can't be serialised.I know that there are many posts on this site, but none answer the question. I am using VB.NET (boy I wish I had the time to learn C#) and I cannot get the Data Contract to work either even using IXmlSerializer. An example of the output I need to send back via WCF
View 4 RepliesReturning The Max Value From Sqlite DB?
Feb 22, 2012I have a SQLite database and I am tyring to query the max value in the RecordID field. This query works when I run it in SQLite but I can not get the VB to return the value, what have I done wrong?
Dim getMaxRecID As String = "SELECT MAX(RecordID) FROM String"
Using cmd1 As New SQLiteCommand(getMaxRecID, pConn)
cmd1.CommandType = CommandType.Text
Dim IDresults As Integer
[code]....
The connection is correctly opening the db, and shows it as open as well. No error, just IDresults returns 0 everytime.
Returning The MAX(ID) Value To Image?
Jul 2, 2011i am uploading images to my database but saving them on the file system based on the user. But I want the name of the file to be saved to be that of my primary key column, SightId. Mt table is called Sight with columns Sightid, userid, and titleThis is want I need: The sightid value of the just added record to also be image file name. Examle, I add a record with Sightid = 3 userid=4 title=yes the image and to the file system with the upload needs to be 3.jpg. I have this code but it draws a 0:
[Code]...
SqlCeResultSet Only Returning One Row
Nov 29, 2010I am working on a Mobile 6 Classic phone application for the first time and am having problems with the SqlCeResultSet.[code]...
View 2 RepliesVS 2008 Returning Only ONE Value?
Apr 29, 2010Many times, I query my database for get only one value (one unique row).
I allways use this
Dim ConexaoBD As OleDbConnection
Dim DsDados As DataSet
Dim Dt As DataTable
[Code]...
I think this code in unnecessary for get only one value, and I believe thats a easy way to do it.
Why Is String Returning A Char
Jun 27, 2012I have built a DataTable from my database. Then I am looping through the rows and trying to access a string, however the value is being returned as each character in the string.
For Each theseRows In DisplayForm.MainTab.Rows
If theseRows.Item("Last_Name") = userLast And theseRows.Item("First_Name") = userFirst Then
[Code]....
The Trap_Code values are two or three letter strings, the returned value is each letter once at a time. The loop seems to cycle through the individual characters of the string as an array rather than display the entire value, which is what I was hoping for.
.net - Function Returning Different Datatype?
Feb 15, 2011Just come across the following snippet:
Public Function Checked() As Boolean
Return applyChange 'this is a string!
End Function
Whats going on here? How can a function with return type Boolean actually return a string? I'm assuming theres some implicit conversion going on here, which I'd rather not have.
.net - Recursive Function Not Returning?
Nov 28, 2011I am hopeing someone can help me here with a recursive function I have that is not returning either true or false as I would have espected it to. The function loops through a Active Directory group for its members and then calls itself if it encounters any groups within the membership in order to gets its members as well. I am trying to return either true or false based on if any errors were encountered but not haveing any luck at all. It appears to just hang and never return back to the primary calling sub that starts the recursive function. Below is my code I am using:
[Code]...
Asp.net - Datediff Not Returning Expected Value?
Jun 21, 2012this code always return '0' i don't know why
Dim cur_month = DatePart(DateInterval.Month, Now).ToString()
Dim cur_date As String = "01/" + cur_month + "/" + (DatePart(DateInterval.Year, Now).ToString)
[Code]....
cnb_mnth is ComboBox for Month
txt_year is Text Box For Entering Year