I am try to modify this code
_adapter.UpdateCommand = New SqlCommand
With _adapter.UpdateCommand
.Connection = _connection
.CommandType = CommandType.StoredProcedure
.CommandText = "CaseInfo_Update"
[Code]...
way to create and initialize SqlParameters in VB.NET? Using 3 lines per variable seems quite excessive. Unfortunately the constructors for this class are rather ridiculous, so I'm thinking of just writing my own sub for initializing each parameter. This is how I've been doing it.
Dim ID As New SqlParameter("@ID", SqlDbType.Int)
ID.Value = val
query.Parameters.Add(ID)
[Code]....
I'm doing this right now - .Add'ing parameters and then at the bottom I'm looping through them and setting the Source column by just removing the "@" character from the parameter name.
[Code]...
I have the seperate sql commands that will use the same parameters from a database. I can add the parameters to 1 of the commands, but when I add them to the others I get an error.
dim updateCmd as new sqlcommand("USP_TableUpdate", myConn) with {.commandtype = commandtype.storedprocedure}
dim insertCmd as new sqlcommand("USP_TableInsert", myConn) with {.commandtype = commandtype.storedprocedure}
dim deleteCmd as new sqlcomman("USP_TableDelete", myConn) with {.commandtype = commandtype.storedprocedure}
[Code]...
I was looking at a tutorial for SQLParameters and apparently I need to Import something for my code to work.I downloaded Microsoft Patterns and Practices a couple of weeks ago, and have been using that but I can't figure out what I need to Import for the VB.NET code on this website to work:[URL] Of course, I'll me modifying that to what I need it to do but at present I'm just after an understanding of how it works, but I've got no clue what to do about Microsoft.ApplicationBlocks.Data.SQLHelper, where do I find it?
View 5 RepliesI have a table, I add a dataadapter to it and it has all the commands. There are lists of paramters for update,insert and delete. I wonder where does the Visual Studio find the related informatio on the size of the parameter? Since I believe it is reading from a wrong place or I did not set someting correctly. While the corresponding NvarChar column in dataset and database table is having the size of 20, in dataadapter it is all 0!
View 3 Replieswhy the size of all SqlParameters generated by VS2010 are set to 0, while when I look in the dataset all the columns are set to different sizes but when I read it from sqldataadapter they are all set to 0. Isn't it going to make some other issues in future? I mean, I have many sqlparameter with NVarChar types that they are generated by VS2010 and the size is 0!
View 1 RepliesI have this code
Code:
Public Function ExecuteDataReaderSP( _
ByVal storedProcedureName As String, _
ByVal ParamArray arrParam() As SqlParameter) As SqlDataReader[code]....
I try various ways to pass the parameters, every time it return a different error.How is the correct way to pass those parameters?
I connected to the Informix server using RazorSQL, created a stored procedure and tested it, getting the expected answer, so the procedure exists in the database in some form.
I then run the following code:
If ConnectToInformix() Then
Dim cmd As New IfxCommand("dc_routeHasOutstandingQuantity", conn)
cmd.CommandType = CommandType.StoredProcedure
[Code]....
This error does not occur when calling the stored procedure from a live SQL connection.
I want to create an ExpressionTree where a Func(of Vector, Vector, Vector, Vector, Double, Double, Vektor) should be called. So I use
Expression.Call(Forces(0).Function.Method, {Vec1, Vec2, Vec3, Vec4, Double1, Double2})(Vec1-4, Double1-2 are declared as ParameterExpression and Forces(0).Function as Func(of Vector, Vector, Vector, Vector, Double, Double, Vector). But I get an AgrumentException, because Forces(0).Function.Method has seven Arguments. (System.Runtime.CompilerServices.Closure as seventh argument at Index 0).
I have created a small exe that receives some arguments, then creates and start a process (runs ghostscript) to create a png image of a pdf.The whole system works fine except when the exe is called more than once at the same time. My understanding is that i thought it would create a new instance each time it is called, but this doesnt seem to be happening.Is there a way i can 'queue' the requestes to exe so that the previous request completes then the next one begins and so on.[code]
View 2 RepliesHow do I call to a sub using vb.net, I have the following
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
End Sub
[Code].....
I'd like to be able to call a Paint Sub that is framed like what you see immediately below from another sub but haven't been able to figure out how to do it yet. I'm working with option strict on.
Private Sub DisplayGraphics_Paint(ByVal sender As Object, ByVal e As System.Windows.Forms.PaintEventArgs) Handles Me.Paint
End Sub
What would I put inside the parentheses to satisfy the arguments for the above sub DisplayGraphics_Paint().
DisplayGraphics_Paint(?, ?)
Perhaps I should modify the code for the Paint sub to do what I'm trying to do.
I have created a project using VB.Net(VS2008) and created the exe file. I have another project in VBA (Excel 2003). The project basically IC-Testing based. So according to the device type the Excel workbook name varies. For example I have AAAA.xls, BBBB.xls, CCCC.xls. When I open AAAA.xls, I want to call the .exe (which is developed in VB.Net) with the variable "AAAA". i.e when the exe program runs, it knows which Excel is opened or from which Excel the .exe is called. now I am using Shell retval=Shell("d:Monitor.exe",1). Using this the exe is called and running fine. But the Monitor.exe doesn't know which Excel called it, whether it is AAAA.xls, BBBB.xls or CCCC.xls.
View 1 RepliesIs it possible to dynamically load a .NET DLL and create an instance of a class inside it? I will know the name of the class.
View 5 Repliesi have a listview which loads data virtually... ive added search functionality to it using the following linq query i found.
[Code]...
now this code works perfectly when i type on the listview but i instead have a textbox and want that the search happens on keypress in the textbox. so i think i need to call the above function with the presses letter in query... but am not able to give the right arguments.
I currently have two subs in Webbrowser3.DocumentCompleted. The first sub scrolls the web page to a specific point. The second sub takes a screenshot of the webbrowser window.Problem: Screenshot image is recording the top edge of the webbrowser. This means it is not scrolling to the right position before snapping the screenshot.
My guess is that the web page is not fully loaded when DocumentCompleted is called. Or the scroll is not being completed til after the screenshot has been taken. Result: After this is run, I end up with an image of the top edge of the browser. The Webbrowser is scrolled to the right place, but the image is taken before it gets there.
[Code]...
I create a UserControl application
So I put in it (put in UserControl) a Button
how to user this userControl in VB6
I am trying to call this private function, but am missing somthing, anybody point me in the right direction Private Function DL_WebPage(ByVal _URL As String) As String This is what I have tried, but with no success: call DL_webpage But this comes up with an error
View 3 RepliesI have a routine that will connect to a tcp server and then disconnect which works perfect. It checks the connection to another program on another pc which is what I need. But if the computer is not on or the ip address is not valid, it takes a bit for it to time out and continue on.
how to add a timeout of 2 seconds to the following code?
Private Function CheckServer(ByVal IP2 As String, ByVal Port2 As Integer) As Boolean
CheckServer = False
[Code]...
In my Zeal to get with the "Dispose" program, I implement a dispose pattern (still learning the ways and means of THAT) wherever it seems to make sense.I THINK I have the basic idea. However, I notice that, while Drawing.Brushes HAVE a Dispose method, when I call it, some sort of instability is created in Visual Studio itself, and i get the dreaded "Visual Studio has encountered an error and needs to close" splash screen, with no useable error information. SHould I assume that one should just NOT call dispose on Brush objects, or is there something I am missing here: [code]
View 7 RepliesWe know that the DLL function can be called from our mainprogram and return value. I would like to know, when we run DLL function, can we call a sub in our mainprogram (from DLL function) and return a value to DLL fucntion.
View 3 RepliesFirst time posting a question..I am trying to write to a table from a vb form and i am getting this message when executing the insertcommand:
Cannot call methods on char. The following is the code that i am using:
[Code]...
I tried the search (forum / google) before, but unfortunately I found no solution. From VB.NET I have to call a very old c-dll, the methods have signatures like this:[code]In VB I tried the method-declaration with IntPtr, FixedLengthString, Char(), Byte() and so on, but with no success. I now, that char* declarations can be handled with the Stringbuilder, but that seem not to work in this case, as the declaration is a char[256] and no pointer.So how to declare the c-method above to be used in VB.NET?
View 11 Repliesim making a transport agent for exchange and am getting hung up on how to call a method asyncronously. Im doing this based on an msdn article but like usual they didnt provide the part of the code i need to figure out.the article is in C# but i converted it to vb in my project. [URL]I know I need to setup a delegate for the method and then invoke that delegate, but im not 100% on how to implement this.
Imports Microsoft.Exchange.Data.Transport.Routing
Imports Microsoft.Exchange.Data.Transport
Namespace TestTransportAgent
[code]....
I using VB.NET (VS 2008). I want to know if I can call a sub whereby the name of sub is in a varialbe.
For example :
Private Sub Hello()
Msgbox "Hello"
End Sub
[code]....
I know it does not work that way but how can I call a function or sub using a variable and not directly.
I have a bunch of VB.NET programs that have a general purpose logging function to log events, errors, exceptions, etc. It looks like this:
Sub LogMe(Msg as string)
LstLog.items.add(now.tostring & " " & Msg)
End Sub
I wrote a few VB.NET DLLs that contain classes used my my VB.NET programs. In thoses DLL classes, I would like to also trap some events, errors, exceptions, etc. But I want them to be logged using my main LogMe function. Here is some pseudo-code of what I was looking for:
' Main program code
imports MyLib
' Initialize program
[Code]...
I assume I will need to define Delegates to save my LogMe fonction pointer
I know that it's possible to Call a stored procedure from a Windows Application made in VS 2008. But, is it also possible to Create one? If so, isn't it possible for someone to create a SP that will delete all the data in a DB,when executed? Is there a real danger that someone could use an application that communicates with a DB to create such a procedure?
View 7 RepliesCan a BackgroundWorker call additional subs? In my program I am connectiong to an OPC Server. I am doing some AsynReads, which in themselves don't take anytime. But Once I get the AsyncReadComplete returned, I want to do the AsyncRead right away. Basically I need to Loop them. The problem now is that while it is doing this, Everything is unresponsive, because it is just going through the loop. So to perhaps rephrase the question, If the BackgroundWorker initiates a process (in this case AsyncRed) would the returned AsyncReadComplete be apart of the BackgroundWorker or seperate Thread?
View 7 RepliesIn my current project I added a couple of .jpg-images in the project explorer and their build-action to "Resource". My question is: How do I "call" one, according its name and show it in a picturebox?
View 3 Replies