I am in great problem regarding adding new parameter in parametercollection. the code is below [code]but here a erro given that is "Variable osqlParameters is used before it has been assigned a value, a null reference exception could result at run time"..
View 4 Replies
I got this error when trying to use parameters to my sql statement, but it works fine when not use it. My codes are below:
[Code]...
I am running visual basic 2008 express. When I run the code that I have written it gives me the the following error message
- Incorrect syntax near '?'.
Does anyone know what causes this error. My code is as follows -
Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.OleDb
[Codee].....
I want to add a parameter to my thread call here is the code. I want to call th.Start(True, sender.Text) and Count(ByVal isRunning As Boolean) will then become Private Sub Count(ByVal isRunning As Boolean, Byval strID As String), but I can't do that. So how can I make this thread accept 2 parameters?
Private Sub btnStart1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnStart1.Click
th = New System.Threading.Thread(AddressOf Count)
th.Name = "Button1"
th.Start(True)
[Code] .....
How to add parameters to app.config file while during msi file installation. please look at the attachment.
View 12 RepliesModule Code
Imports System.Data.OleDb
Module modConnections
Public myConn As New OleDbConnection
Public myCmd As New OleDbCommand
Public MyDr As OleDbDataReader
[Code]...
Module Code
Imports System.Data.OleDb
Module modConnections
Public myConn As New OleDbConnection
Public myCmd As New OleDbCommand
Public MyDr As OleDbDataReader
[code]....
I need to be able to add elements to a copy of mylist.testlist without modifying the global mylist object. (Which seems to be happening via the below code.)When I am working on x, which should be a totally separate object, mylist is getting modified as well. How can I fix this? I have worked with lists extensively and never seen this behavior before. I have tested and reproduced the problem in .NET 3.5 and .NET 4.0 on Win 7 Pro 32bit.
Source Code:
Public Class Form1
Public mylist As New test
Sub Main()
[code]....
For example if I have a function call like below
Function callingMe()
Exit Function
And my Function call is like below
SomeObj.callingMe('1','2','3','4','5') // Variable number of arguments
Inside callingMe() function, I want to know arguments passed i.e 1,2,3,4,5 and the Object i.e SomeObj in above case.
I have been working on this all day and still haven't had any luck at getting it to work. I am using the SqlDataReader Object to retrieve data. I am using the code below to send a value to the stored procedure.The problem is that the value is sent enclosed in quotes so I dont get any data back. I have tried using .text.replace("""","")
View 9 RepliesHow do I add an object with parameters to work with MSScriptControl, example:
VBScript.AddObject("GetNPCHP", NPC.GetHP(byval npc_hp as integer), True)
This doesn't compile.
I have an object, called 'PERSON' This person object has a title, firstName & Surname property as well as many other which are at the moment irrelevant. It also has a read only property called Fullname which concatenates the two or three parameters mentioned above depending on an optional parameter 'withTitles' passed over when you call PERSON.FULLNAME
PERSON.FULLNAME(true) <- Will add titles if there are any
PERSON.FULLNAME(false) <- Will give the name without the title
Public ReadOnly Property FullName(Optional ByVal withTitle As Boolean = False) As String
[Code]...
I get an error: PERSON does not contain a property of 'FullName'. If I change this to any other property that does not take a parameter it works as expected. Now I'm guessing that the binding procedure can't handle optional or mandatory parameters for object properties, is this right? Is there a better way to do it? I thought about looping through the collection to add them manually but that kinda defeats the object of DataBinding!
I use the following VB code to execute a scalar function on my sql server:
cmd.CommandText = "[STFRA].[dbo].MyScalarFunc"
cmd.Parameters.Add("@Fastener", SqlDbType.Int)
cmd.Parameters("@Fastener").Value = 4148
[code].....
Here's the code that is causing my problem, I have no idea why though. All necessary services have been imported.
'Creates Prompt File
Sub CreateFile()
Dim createstring As String = ""
[Code].....
I have a class that has a property that I declare like this:
VB.NET
Private _DirectoryList As List(Of FileDirectoryInfo) ''' <summary> ''' Array of directories. ''' </summary> ''' <value>Object</value> ''' <returns>Directory array list</returns> ''' <remarks>N/A</remarks> Public Property Directory As List(Of FileDirectoryInfo) Get Return _DirectoryList End Get Set(ByVal value As List(Of FileDirectoryInfo)) _DirectoryList = value End Set End Property
[Code]...
I have some code that adds items to a List(of Object).
Here's my original code
Dim BeaconStoryList as New List(Of My.StoryType)
Dim BeaconStory as New My.StoryType
Dim NewStories() as New Foriegn.StoryType = GetStories
[Code]....
But as soon as the code assigned "Chicken" to BeaconStory.Title, then BeaconStoryList(0).Title would also change to "Chicken".
With my second version of the code this did not happen.
It's as though it was placing pointers into the elements of the array rather than values. If that is the case, however, then why does my second version of the code work - I'm still passing in the same thing - aren't I?
I am not sure what I'm doing wrong, but I need some guidance from people smarter than me...
View 1 RepliesI know you are going to lough about this , but I guess I deserve it ...I am sure I am doing something wrong , but I can't find it out ...I have created a collection , lets sayMyCollectionI have also created a class , lets call itMyClass
View 2 RepliesI am having issues adding a custom object to an arraylist at runtime.
Details of what Im trying to achieve.
My object is Fixture which represents a light. My light has the following properties:
Name, isMover, HighlightValue, UserNumber, Channels.
Channels is a dynamic arraylist which lists all the different channels of the fixture. A channel could be the lights colour or its intensity. A channel has the following properties:
Type, FeatureGroup, Value, Universe, Address, Slots and Offset.
Slots is the same again, breaking down to another ArrayList with more details.
Code:
Private Sub Patchingtest()
Dim TestFixture As New Fixture_Structure
Dim Intensity As New Channel
[Code].....
I'm trying to add objects from a class I created using data from an excel worksheet to a list using a for loop [code]When I run it I receive "System.NullReferenceException was unhandled by user code Message=Object reference not set to an instance of an object."
View 4 RepliesDim wBrowser As New WebBrowserTabControl1.SelectedTab.Controls.Add(wBrowser)I used the above code to add a WebBrowser to a tab, but I have no idea how to use declarations for it after adding it in code. I'm mainly after the
View 4 RepliesI'm writing a query to select all records that has any part of parameter. I have one table called Employees. Some people have name like this: John David Clark If the parameter is
[Code]....
I should be able to get result back as long as there's a match in the parameters. If I use Function Contains (q.FirstName & " " & q.LastName).Contains(employeeName), I will not get any result back if employeeName is "John Clark" Function Contains looks only for next words from left to right. It doesn't match a single word at a time. So that's why I used this in the Linq to SQL:
[Code]....
I've added reference to Flash object. Then dragged AxMacromediaFlash to form. [renamed Flash1]. Even after setting Flash1.Movie="file.swf".
it doesn't start playing ! I tried, loadMovie,Play,MovieData etc etc.. nothing works. There's no error, no warning, nothing. That Flash object remains plain white. am not using try catch too. I'm on Vista Home Premium 32bit, Flash player 10, Flash ActiveX version 10. Tried re-installing player, activeX. its just not working! : any known issues am ignoring here? and same file works fine if I drag it in IE. and if I check Flash1's state, it shows playing.
I am getting error [07002] the # binded parameters < the # of parameters makers, i checked both parameters were perfect even though i am getting this error here is my code
[Code]...
I have a problem with a generic list, which consists of intances of a class i created. I am just amazed, each time I add a new object to the list, it overwrites the previous entries. Here is a code sample, i just can't beleive it. I am using visual studio 2010:
Dim translations As List(Of TranslatedValue) = New List(Of TranslatedValue)
If Session("ctlTexts") Is Nothing Then
Dim reader As IDataReader = DataAccessFunctions.db.GetDataReader("SELECT [ControlID], [ControlTextEN], [ControlTextDE], [ControlTextBG] FROM [dbo].[tbLanguage]", GetConnectionString)
[code]....
I am having the library in C#.Net. If I am creating the form in C# and adding listeners to the C#.Net library object the event handlers called immediately. IF I am creating the form in VB.net and adding listeners to the C#.Net library object, the handlers are called after some time. Do we have any priority to be set the event handlers
View 1 RepliesIf I am using with WebBrowser how I can add tags to source code of the page in runtime (Make a changes on site).
For example: I have site with this
<html><head>
Test page
</head><body>
this is the text
</body></html>
Now how possible to add elements/tags to text in runtime?
Basically Commands has Parameters and parameters has functions like Add, AddWithValue, and etc. In all tutorials i've seen, i usually noticed that they are using Add instead of AddWithValue.
[Code]...
since it saves my coding time. So which is better to use? Which is safe to use? Does it improves performance?
is there a way to get the GET parameters and POST parameters in just one function or Collection in ASP.NET? Like using $_REQUEST in PHP? I'm using VB.NET.
View 3 RepliesI am trying to create an list or an array of a class.Here is my "Ingredient" class that I am trying to create a list of:[code]In my "recipe" class, I am want to create a list (or array) and I am drawing a big blank on how to do it. Can anyone point me in the right direction?
View 2 Replies
