Database - Running SQL Query From Module With A Function Call From The Form?
Jan 28, 2010
I have a form set up where I want to run the function PopulateGrid on it's Form_Load event. I have initialized the DB connection as follows:
Private Sub Main_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
LoadConfigFile()
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & config("DatabasePath") & ";")
cn.Open()
End Sub
Now, I want to run the PopulateGrid function directly after I connect to the database as shown above. I'm confused as to how I'd use a database query in a module when the database is initialized in my main form. Would simple setting the variable cn to public work?
View 1 Replies
ADVERTISEMENT
Aug 21, 2011
I have a problem regarding calling the function in form to the module..i have 2 module which is User Login Module and the other Module is Update the Fields of Student..my problem is the Update Module when i call the function in form i cant call the function that i used..this my code in udpate module and this is my code in form The UpdateExeQuery that i use in module.when i call in the form its error..
View 11 Replies
Jul 20, 2009
Im new in this forum. I just recently upgraded my Visual Studio 2003 to Visual Studio 2008.I have a web project which is working very well in Visual Studio 2003. But when Im trying to run the same project in Visual Studio 2008, Im getting a runtime error message.The error message is about a public function which is defined in a public module. When Im trying to call that function from different web pages of my project, the web pages are not recognising the public functions and asking me to
View 3 Replies
Apr 7, 2012
I am trying to run a query an Access db from VB. The general query which I want to run is
SELECT * FROM Patient WHERE Patient.PatientID = ?
or SELECT * FROM Patient WHERE Patient.PatientLname = ?
I tried using an input box which captured the user input and pass that variable to the query, but that failed. Then I read about writing a function and using that, however, I keep getting an error which says Function not defined, but when stepping through the code, it seems to work. Here is my function: [Code]
View 1 Replies
Mar 2, 2011
I have a function in a module that returns a datatable.I need to call that function asynchronously and get the results in the Main thread (Main Form) in vb.net.
View 2 Replies
Mar 13, 2011
I have to calculate y = a + Bx or y = mx + b in non engineering form. Anyways I have to calculate the y intercept first and am having trouble calling the function from a module. Here is the module and the second window will be the code from my main form
[code]...
View 8 Replies
Jun 20, 2011
i've created a Sub in a Form.
I've created another Sub in a module.
I call the Sub in the module from the form, passing the form into the Sub defined in the module.
Then i add an Handler to an istance of a control (for example mousemove) and i want to give to this handler the execution of the Sub defined in the form.
Example.
Class form1
Sub Form1Sub()
ModuleSub(me)
[Code]....
The problem is that i don't know hot to call the Sub defined in the form, in the Sub handler using the istance of the form passed in the Sub paramenter in the module...
View 7 Replies
Jul 23, 2009
I have a main form (frmPos) and through a module (modTransaction) I open and close several other forms. This works flawlessly. However, when the function on the module is finalized, I want to clear the main (open) form. Therefore, I made a public sub (clearForm) on the main form and when I call this from the main form it works.
View 2 Replies
Jun 22, 2010
I was a vb6 user, done a few projects only with forums Now i am moving to vb.net(vb2010) and i have some trouble.Lets say we have a form(form1), a module(mod1) and a textbox on the form1.
i want to start a Sub (DoWork) in the module but in a new thread.
Dim Thread1 As System.Threading.Thread
Thread1 = New Threading.Thread(AddressOf mod1.DoWork)
Thread1.Start()
The DoWork sub does some stuff and when it's finished i want to change the text of a textbox1 in the main form and start another sub (DoWork2) on the main form under the main thread not the one DoWork is running under.
Plese do not refer me to another post that mighe give me a part answer, try to explain to me what i have to do and why.
View 3 Replies
May 25, 2012
I 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.
View 15 Replies
Aug 16, 2010
how we can declare a connectionstring in a module and call that module
View 1 Replies
Apr 5, 2010
I am using VB2008 In the Form1, i have coded
Public Function getText(ByRef ctlName As String) As String
getText = Mfg.get_TextMatrix(Mfg.Row,Mfg.Col
[Code]...
View 5 Replies
Mar 7, 2012
I have a single form application with two modules. The first module holds all the Sub procedures that provide the filtering functionality for 3 DataGridViews on the form. The second module holds the Predicate of T functions that actually filter the List(Of T) objects that are bound to the DataGridView controls.
I split them into modules since I was starting to have difficulty organising and finding the procedures and functions if I held them all in the form code.In some cases I can happily both Get and Set form control properties from within the modules. In one case I simply can't, I suspect I may yet find some more instances as I test further. The offending line is in one of the Predicate of T functions:
If tWord.Length <= Investigator.NumericUpDown.Value Then Investigator is the Class name of the form.
I suspect my problem might be that the Predicate of T functions (which are collated in a module) are called from the DoWork procedure of a BackgroundWorker that is a component of the form - hence the DoWork procedure is in the form code, but I'm not certain. The same code worked fine when everything was all in the form code. The error reported when adding a watch to the Value property in the module function is "
'Value' is not declared. It may be inaccessible due to its protection level ". I have tried the following to no avail:
1) Setting the NumerciUpDown modifier to Public
2) Adding a Public ReadOnly Property to the form class that simply returns the Value propety of the NumericUpDown
3) Adding Imports Root Namespace.Investigator to the module
I am considering adding a Public Shared variable to hold the curent value of the NumericUpDown and referencing that from the Predicate of T function.I realise, and have read many times, that accessing form control properties from module functions is generally not seen as a smart thing to be doing, but since I am not trying to chnage anything, I simply want to know what the current value is I decided that I wasn't too worried.
View 11 Replies
Aug 31, 2009
Im wanting to pull some data from our Remedy Server every so often. Right now we're having to do it manually; Data > Import External Data or New Database Query. The connection is called AR System ODBC Connection Source. We have to log into the server and then it pulls the info into the sheet. Im needing even if have to setup a conection myself first to just have this conection run every couple or two and update the excel sheet. We're using excel 03, Remedy 7.
View 2 Replies
Apr 27, 2012
I have a VB.Net interface that communicates with an Access 2k3 Database using this module:
Module MOD_ENGINE
'Declare Database connections controls
Dim con As New OleDb.OleDbConnection
Dim dbProvider, dbSource As String
[code]....
I want to call EngineConnect procedure from MOD_ENGINE module into popCboBox module so I can ignate the engine!
View 3 Replies
Aug 11, 2011
I have an application that performs database queries using "Imports System.Data.SqlClient". I want to display an animated GIF on the taskbar which spins while the query is running. However, during a query the application simply hangs and does not update the GUI until the query has finished, at which point the spinning icon is set to invisible anyway. Is there any way to force the GUI to update while the query runs?
View 2 Replies
Apr 1, 2010
i am relatively new to VB and i am working on a Visual Basic Program to build a Student Record Book where all the information is stored to an Access 2007 database. If the user is an administrator they will be able to add a new student, update delete etc. I managed to implement INSERT/DELETE/UPDATE functions and also a search button and they all appear to be working fine.
View 4 Replies
Apr 6, 2011
How to create a delete in used to delete my sql database from different database without decalre one by one in vb applcation
View 1 Replies
Nov 23, 2011
I have defined a function on one form. I need to call that function again on another form. is there any way i can do it without redefining the function again and again?
View 12 Replies
Sep 25, 2011
I have a class inhert ToolStripButton. it builds a new toolstrip button. the button will be added to the toolstrip which is on main form.
I will need call function in the main form. what's the right way to do this?
now, I pass the main form when create the class. but I guess the right way is to raise the event in main form.
but, how about the properties in main form?
if I raise the event, will it run the event first, then go to the next line of the class? or, just raise event, then go to the next line in the class immediately?
View 3 Replies
Jan 25, 2011
How can I call function of the form_Load? I have tried this code but it is not working. [code]
View 13 Replies
Sep 14, 2011
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)**
View 1 Replies
Jun 28, 2009
I 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.
View 4 Replies
May 18, 2010
Just had a small doubt.Say i use something like this
vb Dim ownr as New Form1Dim Dlg as New Form2ownr.Showdlg.showdialog(ownr)
how should i call an public function of form1 in the form2 if form1 is owner of form2, and also if form1 is not the owner of form2 should i use FormName.FunctionName in both the cases.
View 3 Replies
Oct 11, 2009
Is it possible to run a function or to execute a button just after the form was loaded? I mean to execute it just as the form_load subroutine has ended, so the form is already being displayed.
View 2 Replies
Sep 29, 2011
Currently the process is in VBS, however this means there is no real interface.I attempted to get this into HTA, but this doesn't work to well due to known issues - the interface doesn't update with information until the end of the code (functions) are executed.So I thought I would create a VB program to do the work.Ideally, I would have a form load, and once loaded the functions (which map drives accordingly) will display the results on the screen.My code should be pretty sound - it is working - but it seems to be invoking BEFORE the form is displayed.I have tried various subroutines, such as Form1_Load, Form1_Activate, Form1_Shown, but all of these execute the code before the form has loaded and is displayed on the screen.As a test, I have
Private Sub Form1_Shown(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
lbl_Head01.Text = "HELLO WORLD"
[code].....
View 6 Replies
Sep 6, 2005
I need to pass an uint8 array from C++ DLL to VB6 application but I receive always following error: "subscript out of range" if I try to work with the array 'pabyData' in my VB6 procedure. The C procedure is: typedef void (__stdcall *FUNCPTR2SendData) (const uint8_t* pabyData, uint16_t wDataLength); void SendData(const uint8_t* pabyData, uint16_twDataLength) { FUNCPTR2SendData vbFunc; vbFunc = (FUNCPTR2SendData) ptCBFPointers->p2NewDirectDataSMSEvnt; // ptCBFPointers are call back pointers, where is saved the call back address of VB6 functions vbFunc(pabyData, wDataLength); } The VB6 procedure is: Public Sub SendData(ByRef pabyData() As Byte, ByVal wDataLength As Integer
View 2 Replies
Jan 19, 2010
In my .NET porject, I have to run a lot of validation on 4/5 fields. This validation checks if certain fields have errors, for example: the name field is not allowed to have numbers or symbols. If all these checks are passed, I need to execute a SQL query to pull some data out of the database. I could have it with a lot of nested IFs, and run the function at the end once it passes them all, but this will translate into about 12 nested IFs, and it seems a really bulky way to do it. I have also thought about setting a boolean value after every check, and if the value is 1 then don't run the function, else do. But of course this gets overwritten by other checks that pass.
View 2 Replies
Jun 26, 2011
I am having a toolstrip in the mdi form which contains save, update delete and clear buttons. The child form is having save, update, delete and clear as public sub routines , and client form will not have any standard buttons, I will click the respective button in the parent tool window which should call the child forms function.
View 1 Replies
Feb 4, 2012
i just got 1 question how do u create a (in excel ) variable table (database) inside a function which could be called for filling and reading through "for to next" loop module
View 2 Replies
