Accessing Cursor Data Returned By PL/SQL Function?
Jul 16, 2009I am calling an Oracle function PKGDummy.F_EMPDATA using vb.net.
View 1 Replies
ADVERTISEMENT
Accessing Value Returned From Function?
Feb 22, 2010I'm new to VB.NET and want to parameterise the SQL Connection Strings in my VB.NET App. I've added a function to my Main Form to retrieve the App.config File like:
Imports System.Configuration
Imports System.Configuration.ConfigurationSettings
Public Class MainMenu [code]....
In my other forms when i want to reference the Connection String, i get an error saying getConnStr is not declared?
Private Sub UpdDept_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Try
myconnection = New SqlConnection(getConnStr()) <=============
Dim mycommand As New SqlCommand()
why i get this when i've declared the Function as Public?
Time To Call A Function To Change Data Being Returned From Database?
Jun 28, 2009I have two functions written in VB.NET:
1) The first function (call it GetValues()) returns values in a SQL database as a list via a stored proc. One of the fields is DateTimeSubmitted. All of this data is displayed on my webpage using a repeater control. It works fine.
2) The second function (call it NiceDate()) I created to change the DateTimeSubmitted to a nice date such as "one minute ago" or "yesterday".
My problem is I have no idea which is the best part of the process to do the conversion (at point of data extraction or in pageload etc.) or in fact how to do the conversion.
How To Get Another Function's Returned Value
Apr 4, 2012How to give another function's returned value in LINQ.[code]but in above query I should write code to store the return value of GetObjProperty Value(p) and add obj-p and returnValue combination to the dictionary.The last line below code is wrong. but please suggest me how to correct it. My intention is, I want output collection(say dictionary) of each fruitname and its color(returned by other function call) for all the fruits which the GetFruitColor is not nothing(it can be empty or valid string).[code]In above code last line is wrong. So how to put getFruitColor in k, how to correct it to save the k value and give me output as dictionary of fruit and k value.
View 1 RepliesHow To Use Returned Value From Function
Sep 5, 2010Why this code doesn't work? It returns an unexpected value actually total = 0.
total = Cscore(TextBox1.Text) * CDbl(TextBox2.Text)
When trying this
total = TextBox1.Text * TextBox2.Text
It returns the expected value but I need to pass textbox1.text to the function to get the desirable value
The function is this
Public Function Cscore(ByVal score As Integer) As Double
Select Case score
Case score = 100
Return 5.0
Case score >= 95
[Code] .....
Using Returned Value Of A Function?
Apr 2, 2011I have many functions that perform mathematical calculations.
Here is one for example:
Public Function internaldiamofcasingpipecalculation(ByVal Externaldiameterofcarrierpipe As Double, ByVal insulationthickness As Double) As Double
[Code]....
Handle Nothing Returned From Function?
Mar 18, 2009When the AlertsSettings.xml is not present the Appsettings is assigned to nothing. The variables that follow that definition rely on the existance of that information which will normally be set by the load method. But when there is a problem and either of the variables do not get a value how do I handle that in the code that relies on those values. The Settings class deserializes an xml document and assigned values to properties.
Sub Main()
Dim Appsettings As Settings = Settings.Load("AlertsSettings.xml")
Dim AlertsServer As String
[Code].....
Object Returned By Reference From Function?
Aug 5, 2011This should be a fairly common question, but I haven't found a straightforward answer anywhere.
If I instantiate an object within a function in VB.NET and return it, does it return it be reference or by value. IE - should I be worried about performance if I write something like this:
Public Function ret_obj_func() As big_object
Dim ret_obj As New big_obj(<lots of stuff>)
Return ret_obj
End Function
If I call this function from somewhere else, will it instantiate the object in the ret_obj and then create a deep copy to pass back a copy to the caller, Or will it just pass back a reference?
Passing String Returned From Function?
May 2, 2012I'm trying to establish a connection to my SqlDatabase while getting the connection string from a function. This will eventually lead to dealing with the appconfig file, but for now I'm just getting the basics established.
Imports System.Data.SqlClient
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[code]....
Set Combobox Displaymember To A Returned Value Of A Function?
Jul 2, 2009Combobox with bound rowsource, but I want to change the displaymember to a string returned by a procedure. In Access/VBA I would have a little function to build the string, then simply code the recordsource of the cbo as:
"SELECT ClientIDS, fnGetName([ClientIDS]) AS ClientName FROM tblPerson ORDER BY fnGetName([ClientIDS])".
Pretty straightforward, but I've messed around with this for hours in VS2005/VB to no avail.SELECT ClientIDS, fnGetName
[2005] Is An Obejct Returned By A Function By Ref?
Feb 25, 2009I have a 2 dimensional array of groupboxes that I use to populate a form setup so the first indice is a tab number and the second is the groupbox number.The user can dynamically add tabs to the tabcontrol but I need to add and populate groupboxes to the new tabpage and I can use existing groupbox data in the array for default values.I understand I have to code a deep clone of the source groupbox as it has textboxes in it so I want to add a cloneGBox function that returns a new, populated groupbox when I pass in the x,y indices for the source groupbox in my array.
dim gbx as groupbox = cloneGBox(x,y)
and code cloneGBX as
public function cloneGBox (byval x as integer, byval y as integer) as groupbox
[code].....
Convert Strings Returned From A Function To Numbers
Jul 27, 2010I have the code below. The code returns a string in (IntersectingPoints) for X and Y. I need X and Y values to be in single and stored in an array to deal with later.[code]...
View 11 RepliesLINQ To EF Sum Function Error When No Records Returned
Jun 1, 2012Have seen some solutions for C# but do not know how to solve the issue in VB.NET.
Query:
Dim Query = (From t In myEntities.Bookings
Where(t.Ref = Someid)
Select t.People).Sum()
t.Ref field is an Int and so is t.People.
The SomeId value is the primary key of the related table. This issue is that there will not always be records in the Bookings table with a Ref value of Someid - so the query throws the following error.
I have seen others have got around this problem with catching the error, but from reading up on this and as per the error information it seems there should be a solution (in VB.NET) to cast the query or some of the fields in the query to nullable types?
Error is as follows:
The cast to value type 'Int32' failed because the materialized value is null. Either the result type's generic parameter or the query must use a nullable type.
Asp.net - Declare Return Type Of The Function When There Are Two Possible Returned Types
Jan 25, 2010I have the following statement, I want to turn it into a Public Shared Function :
If isEmployee Then
Dim employeeInstance As New Employee
employeeInstance = GetEmployeeInstanceByUserId(userId)
[Code]....
Public Shared Function GetWorkerInstance(Byval isEmployee as Boolean) As ...(not sure what to write here)...
There two possible return Type. I'm not sure what I should declare for the function return type.
Deep Copy - Is Object Returned By Reference From Function ?
Aug 5, 2011If I instantiate an object within a function in VB.NET and return it, does it return it be reference or by value. IE - should I be worried about performance if I write something like this:
Public Function ret_obj_func() As big_object
Dim ret_obj As New big_obj(<lots of stuff>)
Return ret_obj
End Function
If I call this function from somewhere else, will it instantiate the object in the ret_obj and then create a deep copy to pass back a copy to the caller, Or will it just pass back a reference?
DataGridViewComboBoxCell Not Correctly Displaying Objects Returned By GetValue Function
Jul 14, 2009I have a Class MessageIndex which holds an integer. I have a custom DataGridViewComboBoxCell which has a MessageIndex variable. If the MessageIndex is not set, the cell acts as a normal DataGridViewComboBoxCell; if the MessageIndex is set, then the GetValue and SetValue methods of the DataGridViewComboBoxCell are overridden so as to return the value of the object from its DataSource at the index of the integer stored in the MessageIndex.
As far as I can tell from stepping through the code, that actually works fine. The object returned by the GetValue function is fetched from the DataSource, based on the integer stored in the MessageIndex.
The problem is that when the DataGridView is displayed, all of the cells are blank. The values of the cells can then be set using the ComboBox dropdown, which appears to work fine.
But why are the initial selections not being displayed? As I say, as far as I can tell, the correct information is being retrieved by the GetValue function of the DataGridViewComboBoxCells when the form is initially displayed. It's just not ending up on the screen.
OOP - Declare Two Datatables And Fill Them Both From A Datatable Returned By A Function In Class
Sep 27, 2010When I declare two datatables and fill them both from a datatable returned by a function in class, that when i filter the one it seems to filter the other aswell?
For example:
I declare the datatable and initiate my class:
Dim DatatableOne As New Datatable
Dim DatatableTwo As New Datatable
Dim MyClass As New MyClass
I then call the function that returns a datatable and apply it to datatable1 and 2 Then fill two DataGrids with the table:
DatatableOne = MyClass.GetTable()
DatatableTwo = MyClass.GetTable()
DatatableOne.DefaultView.RowFilter = "Name = 'Tom'"
[CODE]...
For some reason i don't understand but both grids end up with the filtered data?
Accessing The Shared Function?
Mar 1, 2011i have a function that i have in my data access class now i want to access it then declare and assign parameters and then insert data into database?
'1
'the function
Public Shared Function InsertNewRecord(ByVal myStoredProcedure As String) As Boolean
Dim conn As New SqlConnection
[code]....
Accessing A User Defined Function Or Sub?
Sep 10, 2009I'm a new user of VB.Net. I do have doubt on accessing a user defined Function or Sub. In some place of program, I do see the term "Call" when using the Function/Sub. In some other place without "Call". But both works perfectly. May I know the difference between the two.
[Code]...
Accessing Global Function / Values?
Jun 1, 2009m using a public variable called globalquery & a global function retriveToDataGrid() it works perfectly fine under same class /form ..... but when i try to access it from a different form , it gives no error and nothing happens
Public Sub retriveDataToDataGrid()
Try
Dim connStr As String = "Database=shahopticals;" & _
"Data Source=localhost;" & _
[code]....
Communications :: Accessing A Class Function?
Oct 28, 2008I am working on this project and this question seems to be stupid, but I am not really getting the point.I have the following class:
Code:
Public Class ConnectedServer
Public MYPORT As String = "8000"
[code].....
Accessing Control Attributes From Static Function?
Sep 16, 2010Here's what I've got:
<textarea id="TextArea1" rows="6" cols="20" runat="server"></textarea>
and in the code-behind:
partial class _Default : System.Web.UI.Page
[code]....
Accessing Public Shared Function From Another Form
Mar 1, 2011[Code]...
i have a function that i have in my data access class now i want to access it then declare and assign parameters and then insert data into database.
Accessing Function In Alother Class From The Main Form?
Feb 12, 2011I have a new solution with 5 projects inside. a data access layer, database, 2 class libraries, and the main form. These are all components that I had worked on to get to this point of combining into 1 solution. Now what I have run into is I can not the actual functions in the class libraries. I can get to the class level, but that is it. ere is a sample line of code I need to get working. Once I get this one line, the rest will be obvious: Temperature is on the main form. get for options is "Equals, GetHashCode, GetType", etc... Before this I had bult, compiled, and referenced these classes separately, and it worked fine. I know this is going to be an easy answer, I'm just not seeing it for some reason.
View 15 RepliesAsp.net - Accessing Httpcontext In Shared Function Thread Safe?
Jan 5, 2012Im having a problem understanding if accessing httpcontext inside a shared function, without passing in the httpcontext as a parameter is thread safe?
Are the 2 functions in the util class equally thread safe?
Class foo
Sub main()
Dim qs1 = util.getQS(HttpContext.Current)
[Code]....
VS 2008 - How To Write Wrapper DLL For Accessing Function Calls
Jul 27, 2011I have a camera for which the complete source code with header files(.h) and all libraries files(.lib) are given in VC++. Now if I want to access the function calls in the header files and in turn the functions in the library from VB.NET, I am required to write a wrapper DLL for accessing the function calls which I never did till now.
View 1 RepliesData Type Of Returned Set?
Jul 11, 2011I am confused which data type to define for my variable which stores value returned by LINQ Statement.
Currently I am defining it as some data type but its generating error like: ""Unable to cast object of type 'WhereSelectListIterator2""`
[Code]...
Here i want myBase to hold the data which has UIN = 4
Asp.net - Formatting Data Returned Via Datareader?
Jun 6, 2011I am returning a date from my database table:
objSQLDataReader("date")
Which gives me:
31/05/2011 16:00:50
How do I change this to:
31 May 2011
Check That A SqlDataSource Returned Data?
Feb 9, 2010I have a asp.net page that has several SqlDataSources defined that feed data into some graphs. The problem is that the graph product does not handle "no data" very well, and throws an error. I'd like this to handle the situation more gracefully-- so I need to check whether the SqlDataSource returned data or now before rendering the graph (and if not, just post a message saying "No Data" or something).
Is there an easy way to check if the data source returned data, and do this if/then without a bunch of code behind?
Handle The Different Data Types That Could Be Returned?
Sep 7, 2010I tend to use
If Not IsDBNull(dr("data")) Then
myData = dr("data")
End If
to catch nulls. Is there a better way? It seems I use this over and over again? Anyone write a function to check this something like
mydata = IfNotNull("data")
I don't know how to handle the different data types that could be returned.