My application works with the sql database. It always connect to the databse using the same login and password written earlier in the application code.I just have a conncetion string with all that data inside.
I know that it is not the safiest way to do that. How to safely hold this thata inside of an application?
I have a Console app that loops through a queue and processes each record in a datatable. Each process is long and time-consuming (connecting to a remote website, downloading files, reading them and adding them to the database). I'm trying to implement threading for speed's sake but am having cross-threading issues. (The job takes 8 hours or so to run and the cross-threading doesn't start happening until a couple hours into the run.)I'm trying to figure out how to make my code thread safe. I don't update or rely on any non-local variables, and I don't need to return anything. I've tried locking which works but defeats the purpose of the multiple threads. What other things should I be looking for?
[code]...
Lets say we have this code that runs in the constructor:
Dim initVectorBytes As Byte() = System.Text.Encoding.ASCII.GetBytes(initVector)
Dim saltValueBytes As Byte() = System.Text.Encoding.ASCII.GetBytes(saltValue)
Dim passPharse As String = GenerateKeyString(EncryptionKey)
Dim password As Rfc2898DeriveBytes = New Rfc2898DeriveBytes(passPharse, saltValueBytes, passwordIterations)
Dim keyBytes As Byte() = password.GetBytes(CInt(keySize / 8))
mSymmetricKey = New RijndaelManaged()
[Code]...
I am using the Interop User Control Toolkit to create a user control for use in a VBA Forms "like" environment. I created a user control and it worked just fine in the environment. The problem that I have is that I get an activex warning upon form load. I need to get rid of this message. I have tried this link with no luck... Although everything compiled file, it crashed my VBAClnt.
View 1 RepliesThis code was working consistently, but now...This code works on the first pass.Then second pass it just hangs on Code:Dim tcpClient As TcpClient = tcpListener.AcceptTcpClient() for about 2 minutesThen the code will fork for another pass, then fail.....
Code:Imports SystemImports System.TextImports System.Collections.GenericImports System.XmlImports System.Xml.LinqImports System.Net.Sockets
[CODE]....
I have a multi-threaded application with several datasets that are read/written to from a couple threads. I have read that datasets can handle multiple readers and one writer. I have synclocks around all dataset writes and no synchronization around reads. I am experiencing random "Index was outside the bounds of the array." exceptions where a dataset item is in a conditional statement, for example:
[Code]...
is it ever possible to write locking-features(for threading) with the language itself (this question is purely academic, I know no one will ever do it even if its possible (not me))?
A) In Java, is it possible to write thread safety functions with java alone, but without using any of the provided classes/language elements/syntax which offer this feature?
B) In C#, is it possible to write thread safety functions with C# alone, but without using any of the provided classes/language elements/syntax which offer this feature?
C) In Vb, is it possible to write thread safety functions with Vb alone, but without using any of the provided classes/language elements/syntax which offer this feature?
I'm developing a web application that requires the user to log in using forms authentication. inside the webpage you need to download a desktop application that requires to login to the same system too. Is there a way to transfer the current logged credentials from the web application to the windows desktop application without need to login again?. Both applications shares a Login object from an vb.net interface.I tried to save the IP address in the Database but that don't work for me because the website needs to be accessed inside and/or outside of the company and the user cannot login twice in different machines.
View 2 RepliesI was wondering if it was possible to pass data from one vb.net application to another vb.net application? If yes, how is this done?
View 5 RepliesI'm sure this is possible but I've got no clue of what I'm looking for to even start to learn this. Basically I want to create a form that can load data from one software application and feed it to another.
Is it possible to change settings in other forms by another piece of software like if there was a flag = True and I wanted to change it to flag = False or instead of loading Dim processorID As String = String.Empty I can input Dim processorID As String = 1234
we have an old vb6 application (let's call it app-vb6) that basically handles database searches. now i created a new .net application (app-dotnet) that can use the database information to do something else.
what i want to do is to be able to run app-dotnet using information obtained from app-vb6 (which would send something like a command line with a few parameters). but i don't know how to make only one single instance of the app-dotnet to refresh information every time app-vb6 calls it. this link [URL].. seems to have the answer but i could not follow it since it is VC.
I am developing an application for internal use in our company. The purpose of this application is for document imaging. What we are wanting to do is print a barcode label to attach to documents so that when they are scanned in a piece of software such as vfiler will be able to read the barcodes and know how to file them.The main focus is our ERP system which is web based (PHP). We are wanting to modify the code to allow the user to print the barcode label immediately once they enter an order or PO. I have access to the source code for the ERP web pages. I don't know of any way to make a web page print to a printer without displaying the printer select dialog. So, I decided that I wanted to try and create a VB application that would do the printing of the barcodes. This would allow me to bypass the the printer select dialog.
Now for the question. Is there any way to have a web page (PHP) running on the server call a VB app to perform a task? So, if I had a button on the webpage and the user clicked it, that button would somehow send the pertinent information (Order number) to the VB app and the VB app would print the barcode. The VB app will always be running on the machine. The label printers will be Zebra USB label printers on each person's machine.
I am writting a VB .net (3.5) applivcation which references a COM object. I can call methods on the COM object fine provided that they don't require any variables to be passed. I have been told that you can only pass a maximum of one varaible to a COM object, I really don't believe that it true
for example
objsession.connect()
works fine
but
[Code]...
I have created a database with on table that is very similar in setup to ProductCostHistory from the Adventureworks database. Using the adventureworks database as an example, when the procedure is given the parameters of date and productID it will change the EndDate of the currently active cost to the date value and insert a new record with productID as the ProductID and Date as the StartDate, leaving EndDate null for the newly inserted record. I am looking for a way to create a simple form with two textboxes and a button. textbox1 accepts the ProductID parameter and textbox2 accepts the Date value. when the button is pressed, the stored procedure is executed and the table is updated. This seems pretty simple and I am very familiar with tieing stored procedures to a table in a dataset when each prcedure handles only a single simple action (either, SELECT, INSERT, UPDATE, or DELETE but not a single procedure that combines UPDATE and INSERT as the procedure described above does). I've done some reading and played with this on myown but can not find the simplest straightforward way of accomplishing this seemingly simple task.
View 2 RepliesI am developing an VB.NET application that reads data from the serial port and tcp socket, then I'm processing this data and store it in Database server. This application will be started all the time as long as the computer is started. On the server there is installed an apache server with some php scripts representing the "visual interface". From there the users can see the readed data from the VB app. The need is when an event appear in the apache server (such as button pressed), some data to be passed to the running VB app, and eventually trigger an event on it. I've considered some variants like start an timer that reads continuously some tables from the database that the php script writes onto, or read an xml ot text file, but I think that this may slower the communication and it is a source of exceptions or errors.
For example: An user opens a webpage, just to say test.php. On the page there is a button. The user pushes the button. The result of pushing the button has to trigger an event on the VB app and cause sending data trough the serial port or tcp socket. OR - The VB app has a timer that scans for pressing the button on the test.php.
how to use Visual Basic to pass arguments to an application after said application was started. Example, "myapp.exe -d" enables debug mode, I want to be able to start myapp.exe then have a checkbox labeled "Debug mode" in Visual Basic. Upon "Debug Mode" being checked, it passes the argument -d to myapp.exe. Upon it being unchecked, it withdraws that argument from myapp.exe.
View 4 RepliesI've constructed a custom System.Windows.Forms.Form that requires arguments to New. I want to use one of these as the MainForm in a Windows Forms Application. How do I get the Application Framework to pass those arguments as needed?
View 1 RepliesI am a fairly rookie programmer who is trying to learn the basics of n-layered architecture (DAL, BLL, UI). The application I am programming is a single tier, 3-layer application written in VB.NET (.Net 3.5). Layers as follows:
DAL
BLL
UI
COMMON - contains DTO's right now.
I am having trouble determining what to pass between my BLL and UI. My instinct tells me that I should only pass data to the UI, and not the full business object from the BLL. Consider two scenarios:
1) Pass the BO directly from BLL to UI. This exposes BO methods and allows the UI direct access to the BO, which seems bad.
2) Pass only the pertinent data from the BO to the UI. For instance, a customer has a Name and Address. This data is really what we want to show/edit in the UI, so we would only return that data to the UI instead of the full BO. The UI would then call to the BLL to update a specific BO.
I am inclined to use #2, but I don't know the best way to implement it. The way I have it programmed now, if I only return data from the BLL, all references to my BO's will be lost and the GC will claim them. Based on this, I have some questions:
1) Should I keep business objects alive between calls to the BLL? The alternative is to re-create them every time I pass data through the BLL, which seems wrong.
2) What is the best way to keep a BO alive in a single tier architecture (how to hold a reference if we dont pass it to the UI?)
3) How do n-tier applications do this? Do they keep the BO's alive in the BLL and wait for an update from the UI? Doesn't this require a lot of "book keeping" in the BLL to make sure BO's are released when they are no longer needed?
I currently need to build a Automation Add-in for Excel. This add-in will load a recordset from Database to Excel. I would like to have function A() that I input in Cell as a formular. This function A() call a the add-in to load the data from Database to Excel. The data should be a matrix. So that means I would like to set in Excel worksheet a range of data by just calling single function in a cell. (I am sure there should be some way to implement it)As I know if I develop a shared Add-in by VB(or VB.Net) and in the add-in, I can get an Object of Excel.Application. By this Excel.Application object, I can get full control of Excel inside the Add-in. That means if I define a sub that load datamatrix from database and using the Excel.Application object I can populate the data matrix to the Excel.
I have done much research on internet and I now have built a shared Add-in for excel. I should say this add-in works fine without invoke the Excel.Application Object that I have tested. But when I call the Add-in function that invode Excel.Application Object from Excel I got an error as below:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Run-time error '2147467262'(*)
Unable to cast object of type 'System.String' to type Excel.Application
[code]....
I have two tables:
table1
case_no flow result
tc_1 001 pass
tc_1 002 pass
tc_1 003 pass
tc_2 001 pass
tc_2 002 fail
tc_2 003 pass
table2"
case_no result
tc_1 pass
tc_2 fail
Table2 should be updates from table based on the results... If all results is PASS then the table2 should be updated as pass... if any result is FAIL then the entire case_no should be updates a s fail..
Just started VB programming this week and have found a wealth of information about what I'm trying to do. Problem is, some of it is more complete than others.Here's what I'm trying to do:In Form1 (my main form), I want to instantiate a class that contains a couple of properties (speed setpoint and position setpoint). When I click a button, I want to pass this data to Form2 and populate two textboxes on Form2 with the properties of this object. I want to manipulate the property values on Form2 and click an OK button which closes the dialog and returns the manipulated data, updating the property values of the object. Here's the algorithm I'm following:1) On Form1, instantiate the class2) On Form1's "Pass Data" button click event handler, instantiate a Form2 object and invoke the ShowDialog method, passing the object as a parameter.
3) On Form2, overload the ShowDialog method to accept the object as a parameter and modify the method so that it returns the manipulated class data.4) On Form2, in the ShowDialog method, populate the textboxes with the class data that was passed in.Here's where I get stuck. If I press the OK button on Form2 (DialogResult.OK), it returns me to Form1, but what hook do I have in Form1 to receive the manipulated class data that the ShowDialog method is returning?Here's an example of what I'm thinking about:
Code:
Public Class Form1
Dim clsController1 As New MotionController
[code].....
I'm sure it's probably a very elementary question, but every explanation I've found seems to be incomplete.
I've been trying to pass two parameters to my report using code the two parameters are DateTime type, my problem is crystal report viewer is still asking for the first parameter only and it accepts the second one?! in my report i've used two parameters ?firstDate and ?secondDate as dateTime parameters and used them in selctionformula where the date is between the two paramters.[code]...
View 4 RepliesI populate s combobox like this:
Private dbpath As String = My.Settings.SISQL2ConnectionString
Private con As New SqlConnection(dbpath)
[code]....
when I select an item from the combo i need to pass the ProductID to another sub.
I've got this sub
[Code]...
It works on a listview called vendorfilesLV I want to make this sub work on several different listviews. So I'm going to pass the listview in - do I make it BY REF or BY VAL?
[Code]...
I cant seem to find a solution on how to pass parameters to another exe like adding some parameters after path in shortcut, and then launching that shortcut, only I want to do it directly without making shortcuts. So ,how would I pass parameters needed to start another exe (console in my case)?
View 1 RepliesOk im going to make a updater for a current program. And I found this code on this website.
Dim OnlineLocation As String = My.Application.CommandLineArgs(0)
Dim LocalLocation As String = My.Application.CommandLineArgs(1)
My.Computer.Network.DownloadFile(OnlineLocation, LocalLocation)
MessageBox.Show("Update Complete")
But i was wondering, once ive made it. How do u actually pass arguments to it.
I am making a collision detect function, and there are many similar objects which I need to make a collision detect for. I want to have a function where the ARGS is the rectangleshape on the screen. What would the arg type be?
EXAMPLE
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
collisiondetect(item1)
End Sub
[code]....
Further to:- [URL] I now need to pass an array thus:- HTML
[Code]....
Myarray can be redimentioned. Since I need to pass an OBJECT to the thread how do I get the thread to recognise the passed array?
Just ran into an issue with VB.net after years in VB6. I'm attempting to pass a form to a public sub without success.This worked in vb6
vb
Public Sub MySub(frm As Form)
MsgBox (Val(frm.Text1.Text) + Val(frm.Text2.Text))
[code].....
I have a list in detail view that (obviously) lists information. I want to edit an Item if it is double-clicked on. I'm not sure what the best way to do this is. Currently I have this:
Private Sub SoundList_DoubleClick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SoundList.DoubleClick
index = SoundList.Items.Item(SoundList.FocusedItem.Index).Index
[code].....