ADO.NET: Return Multiple Values Instead Of Only The First In An ExecuteScalar()-like Fashion
Nov 18, 2009currently, I use this code:
[Code]...
ADVERTISEMENT
Asp.net - EF4 Insert In VB And Return ID Of Inserted Row Like ExecuteScalar() Does
Mar 15, 2012show me how to do an insert with EF4 VB and also how to return the ID of the inserted row?This is what I have got for edit and it works.. I have seen some very confusing ways of doing selects and edits and have found that i'm most comfortable keeping it written nice like this so that I can go back and understand what I have done.
[Code]...
I want to insert a new order with an order_id and value for ExportedToOW and get the order_id back which is auto generated by the DB..
Sqlcommand.ExecuteScalar Return Dbnull?
Apr 17, 2009i tried this sqlcommand select max(food) from foods and i tried this dim x as double=cdbl(cmd.executescalar)and it throws the the exception {System.Invalid CastException}because the food table is empty and the max(food) is null how can i fix that because i want to take the value and add one to it so do i need to catch the error or try another conversion option?
View 2 RepliesPass Multiple Values And Return Multiple Values?
Jun 10, 2011When I click on button1, employee_id and P values need to be transferred from button1_click to Cal_Category13() and go through all the calculation. After the calculation, udtnew.X and udtnew.MTD values need to be transferred back to button1_Click
I've no problem to return multiple values Cal_Category13().MTD and Cal_Category13().X from Cal_Category13() to button1_Click but i've no idea how to transfer employee_id and p values from button1_click to Cal_Category13().
Program Code
Public Structure PCB
Public Employee_ID As String
Public MTD As Decimal
[Code]......
ExecuteScalar Isn't Returning The Return Value Of A Stored Proceedure?
Jun 4, 2010I have an sp that deletes a bunch of rows and returns the number of rows deleted...
ALTER PROCEDURE [dbo].[DeleteChangeLog]
@ChangeEntityType bigint,
@StartDate datetime,[code]......
Return Multiple Values From A Function?
Mar 30, 2011Is it possible to make a function that returns both a datatable AND a list(of custom class) at the same?In my GUI layer, the main form (the application is MDI) calls this function and it has to fill the datagrid on one of its child forms and it also has to fill lot of other child forms with various information that is calculated from my custom class properties.Both the datatable and the class properties are created from the same external database and that's why I don't want to have two separate functions.
View 3 RepliesReturn Multiple Values From A Query .net?
Apr 10, 2012how to store or return multiple queries result values into multiple variables.. I'm using a query that return 4 columns but how to.. individual store those results into 4 separate variables.. here is my code
Private Sub FrmAlumnos_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
txtCurrentUser.Text = Login.txtUser.Text
Dim strsql As String
[code]....
Return Multiple Values From Function?
Mar 15, 2011I have created a function that takes a Car Registation as its argument and I want it to return 3 values (Make, Model, Price and of course True).The code itself works fine (it returning each Individual value but can't find a way to get ALL of them from 1 function) However I need to actually return all 3 values, and I cannot see how to do this with a simple function.
View 8 RepliesXML - Return Multiple Values And Align Into Column Format
Feb 11, 2011I am new to working with XML and have a question. I can recover any one value from an XML file but how do I recover 2 values from the same file and align them into a column format.
This is what I have been doing so far:
Dim doc As New System.Xml.XmlDocument
doc.Load("C:a_xmltestingDev_Clean.xml")
Dim list = doc.GetElementsByTagName("product") 'this returns the product ok
Dim list2 = doc.GetElementsByTagName("product_code") 'this returns the product code ok
I can pass either list into this and recover the values but not both
For Each item As System.Xml.XmlElement In list2
Debug.WriteLine(item.InnerText)
Next
Can I pass 2 GetElementsByTagName into a list?
Use Linq ToDictionary To Return A Dictionary With Multiple Values In The Dictionary Items?
Jan 25, 2010I want to group items from a linq query under a header, so that for each header I have a list of objects that match the header title. I assumed the solution would be to use ToDictionary to convert the objects, but this allows only one object per "group" (or dictionary key). I assumed I could create the dictionary of type (String, List Of()), but I can't figure out how to write it. As an example I have written a simplified version below.
[Code]...
Search For Multiple Values In Array Then Return Array Line?
Sep 8, 2010Row1
;W910 RF3500AA ;Increase volume by 40 db ;(c) summer ;(p) horse +1000000 F5 000000 5555 44 555555 904938291 8676859 00
Row2
;W910 RF350011 ;Increase backlight by 50% ;(c) winter ;(p) vistar +1000000 F5 000000 5555 44 555555 904938291 8676859 00
Row3
;W910 RF350022 ;Increase backlight by 100% ;(c) spring ;(p) spaceman +1000000 F5 000000 5555 44 555555 904938291 8676859 00
Row4 (Duplicate of Row3)
;W910 RF350022 ;Increase backlight by 100% ;(c) spring ;(p) spaceman +1000000 F5 000000 5555 44 555555 904938291 8676859 00
if label1 = RF350022
label2 = Increase
label3 = spring
label4 = 100%
only if it contains all of these words it should return the first instance (row3) then end or null the rest (row4).how can i get row 3 to show in message box now it has been found?
VS 2008 Return Multiple Table Rows To Multiple Text Boxes
Feb 27, 2011visual basic 2008 express
access 2007 db
I am attempting to fill a form with multiple rows from an access table based off of a parameterized query. My query works fine but I don't want to return one row at a time, I want to return all rows that match my query in multiple text boxes. I know that I can use a datagrid view to accomplish this, but I would prefer the look of a textboxes on a form. I have read through many books and searched the internet forums but think I may just not know what to search for as nothing has worked yet. Can anyone point me in the right direction. So far I have tried setting the text box value to the row().item(), creating a different dataset for each row, and even setting variables for the results of the query to then be passed to the text boxes. Since none of this work, I don't really have any starting code to post. If I could just get a starting point I could work from there, so don't feel the need to code anything for me, just set me in the right direction.
.NET Terminating Threads In An Orderly Fashion
Jul 26, 2009Currently, I have a RingBuffer which is run by a producer and a consumer thread.In looking for a method of terminating them orderly, I thought I'd use a flag to indicate when the producer had finished and then check that flag in my consumer along with the number of ring buffer slots that need to be written. If the producer has finished and the ring buffer has no slots that need to be written the consumer can terminate.However, if I artificially lengthen the time the producer takes by inserting a sleep, the consumer does not terminate. I believe this is a consequence of the semaphores being used.Here is the code I'm working with. Notice that the program will "hang" after all slots have been written. The producer terminates, but the consumer "hangs".[code]
View 1 RepliesWrite Xml Documents In A Linear Fashion Is To Use The XmlTextReader?
Mar 20, 2006OverviewThe fastest way to read or write Xml documents in a linear fashion is to use the XmlTextReader and XmlTextWriter classes in the System.Xml namespace. If read- or write-only forward-only access is too limiting, however, the System.Xml.XmlDocument class provides the ability to easily modify existing documents (adding, removing, or modifying elements and / or attributes) and leverages the powerful search capabilities of XPath.
Getting StartedThe XmlDocument can load Xml from a string in memory, from a URL, or from a file path. There are two methods that enable this functionality: Load and LoadXml. To load a document from either a URL or file path, use the Load method. Following is an example of using the LoadXml method to load an Xml document from memory. (NOTE: we will be working with this particular document throughout this article)
[Code]...
Exclude Multiple Values In Sum Depending On Values In 2 Columns In SSRS 2005?
Apr 21, 2009I have simple columns and their respective sums. However, I exclude 1 particular value from each sum, like so [code]...
Now I need to exclude another value ("Awaiting Progression") from a second column called "PROGRESSION".
Since I already exclude value based on 1 column called CATEGORY, how do I change my =Sum(Code.ExcludeOthers(Fields!CATEGORY.Value,Fields!ACTION_PLAN_NEW.Value)) to exclude a value from the PROGRESSION column if it's = ("Awaiting Progression") ?
i.e. How do I exclude multiple values, depending on values in 2 columns in SSRS 2005?
Which Of The VB Controls Is Best Suited To Show Images In A Strip Like Fashion From An Image Array
May 24, 2009Which of the VB controls is best suited to show images in a strip like fashion from an Image Array?I have an Image Array. I would like to display the images in the array to the end-user in a control.The control should should apear like a scrollabel list. I guess something like silverlight does.When the user sees and selects an image he/she wants to view, it is selected by clicking on the thumbnail and appears in a picturebox.
View 1 RepliesHow To Get 2 Return Values In One Function
Mar 26, 2012i want to get two output values in one Function is't possible ?i am just using String data type and split the values.but have any other easy way to get two output values actually i want to checking a folder how many jpg files are Horizontal and vertical [code]finally i split the values with "|" character.have any other options to get two values as separate in one functions.i have no moew idea about Dictionary,
View 2 RepliesNPV In Excel And VB Return Different Values?
Nov 30, 2010If a use the NPV() function in Excel (2010) with a discount rate of 5% and 10 cells that each contain 505,000 the resulting NPV function call "=NPV(5%,C2:C11)" returns the value of 3,899,496.
If I use the Financial.NPV() method in the Microsoft.VisualBasic namespace (in my C# application) and pass in a discount rate of 5% (as a double) and an array of 10 doubles with a value of 505,000 each, the VB function returns the much lower value of 100,999.99 (plus a few more decimals).
QueryString Does Not Return All Values
Nov 12, 2010When I do a
Request.Querystring("key1")
Request.Querystring("key2")
The system doesn't seem to parse the second ?/value out but treats it as if key1 was all one string, e.g. [URL] ...as if it completely ignores or doesn't parse out the second (or other if more) key/value pairs.
Return The Greater Of 3 Values
Dec 14, 2009Need to return the greater of 3 values. Each value is based on user input and system calculations. Requirement = the greater of (Req1, Req2, Req3) Have tried a number of "If" "Else" and Ifs within Ifs "<" and ">" combinations without consistant results. This may seem simple to some but I am relatively new to VB. My search on MSDN was not fruitful.
View 11 RepliesReturn Two Values From The Same Function?
Feb 3, 2010[size="5"]How can I return two values from the same function?? I need to return an arraylist and an integer...the arraylist is already returning now i need to add the integer
View 3 RepliesObjects - Display Some Test Extra Textboxes In A Dimmed / Transparent Type Of Fashion
Feb 9, 2010I have a form that displays data. What I would like to have is a button that when pressed will display some test extran textboxes in a dimmed/transparent type of fashion. I can get that using another form, but would like to do it without the second form.
View 1 RepliesAssign SQL Return Values To Array?
Apr 7, 2010Assign SQL return values to Array
View 2 RepliesHow To Return Values To Owner Forum
Aug 28, 2010ok here is the thing, in my application there is 2 forms, in the main one (not an MDI)it has some textboxes and a picture box, the other small form contains only a ser enters his search criteria in the textboxes in the main formand presses a button to show the results,t opens the second form and displays the results inthe listview(results are names of pictures).
View 2 RepliesIf Statements - Program Look At 2 Different Values Then Return A Value
Feb 18, 2012What I need to do is to have my program look at 2 different values then return a value.
Here's an example:
If my tube material = SA-214 and the tube gauge = 20 then my tube wall thickness = .032. The thing is I have 5 different types of tube material and 12 different tube gauges so based on which tube material is selected and which tube gauge is selected the tube wall thickness will vary. So if I select a TM of SA214 and a TG of 14 then my tube wall will be .076.
Return Values Calling By Private Sub()?
Nov 25, 2009I have following codes in my Project
[Code]...
Now I am calling Get_Values(). But I am not getting the values in variable G1,G2 & G3.
Return Values Of Stored Procedure?
Jun 11, 2011the stored procedure is within a transaction. I want to get the inserted values after calling the stored procedure. My problem is, I don't know if that is possible because the transaction is not yet commited.
View 1 RepliesReturn Values To The Calling Form?
Nov 24, 2009I have a form which calls other form to achieve some functionality. How can I pass values obtained on other form to the calling form?
View 10 RepliesSearch Text Box And Return Values Between X And Y
Apr 7, 2012i am having a few problems with something i need to create. it firsts needs to get source code of a url i specify, after which i need to click a few buttons so it gets different parts (extract) of the data that i need from the source code and display it in a different text box if possile. (while leaving the original sorce code intact)
[Code]...
Unable To Use RegEx To Return Values
Oct 14, 2009I am trying to get '[NewsLink1234]' from the textbox. I think the Regex code is correct. I need the results to show:
[NewsLink1234]
[NewsLink12333444]
[NewsLink12]
Depending on which ones are in the textbox as the numbers will be ids.
Here is the code:
Partial Class Hertscricket___Test_admin_Default
Inherits System.Web.UI.Page
Public StringVariable As String = ""
Public strValue As String = ""
[Code] .....