Public Sub cleanTables(ByVal prOKDel As Short)
Dim sqlParams(1) As SqlParameter
Dim sqlProcName As String
[code]....
and finally datatable dt = dbConn.Execute(CommandType.StoredProcedure, sqlProcName, sqlParams)
How can i call sqlserver 2008 user define function in vb.net?
View 1 RepliesI am trying to convert a DLL function call which has the Callback function routine called within the DLL function call.The DLL function call signature is like this:
typedef void *HANDLE;
typedef HANDLE HACQDESC;
DECLARE_HANDLE (HWND);
[code]....
how to convert this DLL call to VB.NET and also how to create the callback function and send it as parameter to this function
call.
I am trying to use PageMethods to call a function from the server side, but I am getting an error that PageMethods is undefined.
Here is what I have put into the html
<asp:ScriptManager ID="ScriptManager1" runat="server"
EnablePageMethods="True">
and here is the function from the code behind.
<System.Web.Services.WebMethod()> _
Public Function LoadChild(ByVal EntityID, ByVal EntityCat, ByVal lnType, ByVal FullExpand, ByVal lnEquip, ByVal lnTemplate) As String
and here is the call to the function using page methods.
PageMethods.LoadChild(lnEntityID, lnEntityCat, GLOBALEQUIPID, FullExpand, 0);
can anyone see why I would keep getting a PageMethods undefined error?
edit - part of the issue may be because the function isnt shared, but when shared is put in, i get this error in about 15 places. - this is refering to the session I am using - here is a snippet of the session being used that is showing an error.
prm4.Value = Session.Item("user_id")
I am getting the word session underlined with the error message below - any suggestions on how to fix this? this could fix the whole issue all together.
Error 305 Cannot refer to an instance member of a class from within a shared method or shared member initializer without an explicit instance of the class.
I don't know why calling another function inside the OnUploadedComplete does not work in ordinary way, It's my code:
ASP.NET code:
<asp:AsyncFileUpload ID="AsyncFileUpload1" runat="server"
OnUploadedComplete ="UploadFile1"
OnClientUploadComplete="uploadComplete" ThrobberID="myThrobber"
onclientuploaderror="uploadError" CompleteBackColor="White" />
VB.NET code:
Protected Sub UploadFile1(ByVal sender As Object, ByVal e As System.EventArgs)
'saveing file on disk, this part works fine, but calling
'myfunction() does not work properly
[code]....
Working in VWD 2010 Express I have an aspx.vb file with the following connection string:
Protected Function getPasswordLength() As Integer
Dim conn As New SqlConnection("Data Source=localhost;database=MyDB;Integrated Security=true")
Dim cmd As SqlCommand = conn.CreateCommand()
[code]....
This works when the code is on the web server / which is collocated with the SQLServer.However, when I want to debug, I have to copy to the server. I would like to be able to "debug in place" on my development machine and only copy files to the production machine periodically. Technically the production machine is not in production at the moment, but that's beside the point.Anyway, I followed the following instruction: [URL] I can now see the remote database, functions, etc. on the other machine (from the VWD running on the development machine). However, I thought I should then be able to execute this same code locally on the development machine using ctrl-F5, but I get the following error:
**Server Error in '/' Application.A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)**
In my VB.net code i have:
cmd.CommandText = "SELECT * FROM [strfg].[dbo].[Myfunc] (@MyParam)"
Dim myparam As New SqlParameter("@MyParam", a)
cmd.Parameters.Add(myparam)
The function (runnig on SQL server) returns a table with four columns, one row.How do I call this function from Visual Basic? cmd.ExecuteScalar() is obviously not correct. In c++ I use a recordset. What is the equivalent in vb? Does anyone have a short example?
Call SQLServer CLR storedprocedure from vb.net client returning a datatable
View 1 RepliesWhat is the preferred method of adding the current date/time into an SQL Server table with INSERT Command and executenonquery? I'm expecting something like ...
cmd.Parameters.Add("@theDate", SqlDbType.VarChar, 20)
cmd.Parameters("@theDate").Value = "getdate()"
Is there a relatively simple way that my VB.NET application can be notified of the fact that a new value has been written to a table in SQL Server Express 2008? Polling is not an option since I'd need to do that every 10 seconds nonstop.
View 1 RepliesI'm trying to undersatnd the syntax of calling a funciton and it seem confusing when I'm using a web service in ASP.net. Maybe this question should be in an ASP forum, but it is a VB question. This simple web service allows you to type in your name and it response with an alert box with you name.
My question is, How can you call a function with 2 arguments when the function is only defined for one. I understand that the second argument is actually a method that handling the respons, but how can you interchange function arguments for methods and how do you know that there are methods for
Here's my call:
<script type="text/javascript">
function HelloWorld()
{
var yourName = $get('txtYourName').value;
[CODE]...
I am working in a project where i have to add employees in a company. I have a form with text fields(for example name,surname,age,...). What i want is to insert this txt values into a database. My project is connected with an sql database. How can i add the values into a data table on button click("submit")?
View 9 RepliesThis is my first client server application using vs2008(vb) + sqlserver 2008. how can i hide my database schema,tables from application users through management studio..?
View 5 RepliesI 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).
How can I call a function from inside another function and suspend the calling function until the called function is finished? I hope I can get some replies because I don't know how to ask the question and make sense:).
Anyway what I am trying to do in steps:
1. The user clicks button1 which triggers the click event.
2. From the click event I call a function
3. I then pop-up a form, that has instructions for the user to read.
4. After the user has read the form he will click the "Done" button and return to the calling function.
The problem is the the calling function continues to execute. I want to stop execution of the calling function until the users clicks the "Done" button on the instruction pop=up. I know I can use a msgbox but the instructions can be lengthly and does not look good in a msgbox.
I have tried the Call method with return in the "Done" button click but I can make that work. I also tried a goto statement but I can get that to work either. In the call statement I said call frmInstruction.show() and it got there but as I said the calling function continued to execute.
ive two custom controls, which are used to draw and edit etc...(like paint but customized....) i want to save their images with a single click....So im using the Getimageofcontrol function to do it....its code is below:::
Public Function GetImageOfControl(ByVal c As Control) As Image
Dim rc As New Rectangle(c.PointToScreen(c.Location), c.Size)
Dim i As Image = New Bitmap(rc.Width, rc.Height)[code].....
and the code to call this function for saving the images is simply.. ...
GetImageOfControl(pboxd).Save("c:78.jpg")
GetImageOfControl2(pboxf).Save("c:lp.jpg")
but the problem is that both the images have the same content....
I have a function where I am performing a lot number of database operations inside a Sub. The operation when called directly like:ExecProcess()
takes about 11 seconds to run.However, if I create a Delegate, and call the sub using BeginInvoke(), the very same process takes over 40 seconds to execute.Here's the threaded code:
Protected del As ProcessDelegate
Protected Delegate Sub ProcessDelegate()
del = New ProcessDelegate(AddressOf SELocal.ExecJob)
Dim cb As New AsyncCallback(AddressOf Me.ExecJobComplete)
del.BeginInvoke(cb, del)
Anyone know what may cause a function to take longer inside a new thread, rather than calling directly?
Some programs implement command parameters, Like my favourite computer game - Crysis - has them and windows media player has them.But how could i implement them in VB.NET..I want to have a component of my program built as a seperate exe - so it can be an Optional component.But of course the seperate exe, on load, needs data passing to it.So i need something like Process.start("Componentname.exe", "/StartDL <Suchandsuchastring>)/StartDL will need to call a function, and the string that it uses will be given to the function to initiate a download?
View 9 RepliesI am attempting to inherit an ASP.NET RegularExpressionValidator and add some functionality to it. I inherited the control and added my custom properties. However, I would also like the client-side functionality to call a different JavaScript function.
In order to do that, I will need to supress what is happening in the AddAttributesToRender method because the name of the function is hard-coded there. Here is what comes up in Reflector for the AddAttributesToRender function in RegularExpressionValidator:
[Code]...
Note: I tried to add the expando property before the parent class does to see if the code would check for its existence and skip it, but that just causes an exception.
I arrive from years with Oracle plsql. Now I'm trying vb.net I created a function that return a char value, so written:
[Code]...
The question: I will create a function get_type(...) in vb.net that calls the tsql function written above... how can I call the tsql function [abc].[GET_PERSON_TYPE] in vb.net function get_type(...) function?
I am trying to call a php function from .net. I tried to a webrequest method but I am not sure how to specify the function to call in the url. A link below shows the method I am trying to call.[URL]..
View 2 RepliesI have created a new Class Library in visual basic and called it 'TestDLL'. I have a TestDLL.vb file where I put in this code
Class TestDLL
Function ReturnHello() As String
Return "Hello"
End Function
End Class
Then I clicked on the build tab and built the solution. I then copied the DLL 'TestDLL.dll' to C:TestDLL.dll
I am trying to use that DLL in a console application. I have tried this code but I get an error: System.EntryPointNotFoundException was unhandled Message=Unable to find an entry point named 'ReturnHello' in DLL 'C:TestDLL.dll'.
Declare Function ReturnHello Lib "C:TestDLL.dll" () As String I have added TestDLL.dll to the references for the console application and got that to work, however my goal is to load and unload different .dll files without restarting the application. I have a lot more code besides this, but I'm just trying to find out what commands I could use for just calling functions from DLL files.
There was something I was reading about assemblies, but all I get that to do is list the classes in my dll file. I will already know all the names and locations of the .dll files, and also the class and functions that they contain, because I will be building all of them. how I can get a simple function return in my console application.
How to declare following function in vb2010?[code]
View 5 RepliesI have in vb a selector
Dim ver =101
Select Case ver
Case 101
upd101()
Case 102
[Code]...
How can I make this select better by calling function in more dynamically in this form: with the prefix "upd" followed by a ver integer.
I have a public function to call default email client.Public Function OpenEmail(ByVal EmailAddress As String, Optional ByVal Subject As String = "", Optional ByVal Body As String = "") As Boolean
[Code]...
i have a java script function which help to calculate the total cost by taking the price * by the quality
<script type="text/javascript">
$("[id*=txtQuality]").live("change", function () {
if (isNaN(parseInt($(this).val()))) {
[code]....
I am using textbox(txtFileType) with event OnFocus=("this.blur();"), so I can't use textchanged event for this textbox, I have written a vb code to calculate my FileNumber using Storeprocedures based on the value of textbox(txtFileType). Can I call this vb code from javascript which can be used in clientside.. please help with an example..
View 2 RepliesIs this possible? Every x minutes I need my app to verify something.
Ex:
verify:
'code to verify
[code].....
I've got a program that has a text box with a list of files that are on any removable media. Suppose you launch the program and there's nothing in your CD-ROM drive. Right now, you'd get nothing, and you'd have to insert a disc and click a "refresh" button, which triggers a function that repopulates the list.
Is there any good way to call this function on the event that the user inserts/removes a CD-ROM from any CD-ROM drive? Also, inserting/removing external disks and flash drives? Without having to constantly poll the drives. Floppy disks aren't important to me.
I wrote a vb program that would prompt the user to enter a number and then enter the exponent value they wanted the number raised to. When they clicked button 3 it did the calculation. everything worked perfectly.
Now I need to change the program. I must create a function in a module and then call that function from button3 click event. I have tried several different ways and even though it seems to "work", it keeps returning an incorrect value![code]...