Many 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.
I 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].....
My 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.
I'm attempting to create a function that will get the User Accounts from the registry. I then need to loop through those users and commit specific actions on each one.Here's my function:
VB .NET
ublic Function UserAccounts() As String
Dim userskey As RegistryKey = Registry.LocalMachine.OpenSubKey("SOFTWAREMicrosoftWindows
[code].....
G:DevelopmentDOT NET DevColony_4ImagesBattenhallAve_Plan.bmpand i want to find and return the value after the last '' for example in the string above i would want to return:BattenhallAve_Plan.bmp
View 5 RepliesI am still a newbie with VB. If I return a number the if statement works fine, with opening the new form and updating it as needed. Id the if statement returns a Null from the database it crashes.
[code]...
So, I'm not really sure if I have this setup properly or not. This is my first attempt at utilizing LINQ and I am trying to return data directly from an XML file.Here is my XML structure:
<folder_list>
<folder lbl="_localhost" abs="C:\_localhostapache2triadhtdocs" unc="C:\_localhostapache2triadhtdocs" tag="default" />
<folder lbl="Programming" abs="D:\_prog" unc="D:\_prog" tag="default" />
<folder lbl="Anime" abs="D:Anime" unc="D:Anime" tag="default" />
[Code]...
I'm currently writing a program which uses a Log In Screen. When the program is exited it returns to the Log In Screen before the user can Quit. However the person that logged in before hands details are left within the screen. I have explored using the form load function to clear the text fields and a few other ideas, however to no avail.
Is there a specific event/function I can use to write in some clear text box code for the Log In Screen?
I should be able to pass an array of numbers, calculate average, lowest number, highest number, and standard deviation.the function returns an array containing the results. I dim public data
Public dataArray() As Double
Public DataIndex As Integer = 4
Private Function CalculateData(ByRef dtArray() As Double) As Double()
[code]....
I get an "error Number of indices is less than the number of dimensions of the indexed array" stats()If I add a dimension there like stats(Dataindex) I get an error "Value of type '1-dimensional array of Double' cannot be converted to 1-dimensional array of double".
I have a Business Logic Layer that contains function that return datatables. I'm writing a function that will return just the records that begin with the string passed in. this is what I've come up with so far:
Public Function FetchBusinessAreas(ByVal area As String) As List(Of BusinessArea)
Dim AreasList As New List(Of BusinessArea)
Dim dt As DataTable
[code].....
I need my program to be able to look through an excel workbook and return the data in a particular field.
My work book has multiple sheets relating to different products.
I want to search by the item code of the product then return the list price of the product.
I have googled it but can only find examples of returning specified rows of data not a single field!
I'm trying to create a ntier desktop application using vb.net 2008.I'm trying this [code]...
View 6 RepliesI typed this question once already, hit preview, and somehow never got the preview and lost what I typed. It has been that kind of a day.So here is my quick overview then I am going shopping. I am using OLE DB to select from an excel spreadsheet. It has over 15000 rows and 33 columns. Sometimes even when a cell is not null, it is returning a null value. If I just do a "select * where [termination date] is not null", for example, it will return no rows even though I can see with my own eyes that sometimes termination date is not null.
View 9 RepliesI have column with bit datatype in sql server table(2008).while returing to text box its returning true in text box instead of 1.i tried converting it from true to 1 using txtboolvalue.text=Math.abs(CINT(ReturnList.Item(34)).tostring. But it doesnt convert true to 1
Secondly: im checking for columns in datatable if there are any nulls. its checking for nulls in the sqlserver table but its returning true if there is a null.i just want it to return NULL is there is null i textbox..
CODE:
Then
CODE:
1 when my listbox returns resaults it only brings back 10 how do I set it to return lets say 500
and question 2 is when I click on my links in listbox it's not opening webpage as I would expect it...
This is my code
[Code]...
So 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]
This 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]...
I 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]...
I 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]...
I 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?
i 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]...
I 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 RepliesThanks 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? 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]...
I 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 RepliesI 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.
I 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].....
what 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].....
How 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 RepliesI 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.