Import Objects Behind The Scenes?
Nov 23, 2010
I have some reports and queries that are going to be stored in 2 databases. One database 'client', will house the client specific queries and reports and the other database, 'all', will contain the application along with default reports and queries with the same names. The issue is that the clients will have their own specific queries/reports that when I install a new database to them it will eliminate their custom reports/queries.
What I want to is to be able to import these objects from 'client' every time the user logs in. This will ensure that I always have the correct information for the client.Here is my current code. (I know it may not be the best method but I am open to improvements.):
Private Function Insert()
Dim Custom
Custom = "some file location"[code]......
View 7 Replies
ADVERTISEMENT
Jun 19, 2011
I was planning on using very similar code to the following to export to excel quickly[url]...
However, the data that I'm exporting is rather large and I find it unnecessary to grab a dataset from the sproc, convert it to a multidimensional array of objects and then export to Excel. There are two main reasons this is unnecessary. 1) It takes time to transfer that data from the dataset to the array. 2) There are then two instances of the data, one in the dataset and one in the array. Therefore, I would rather directly insert the sproc results into the array of objects and bypass the dataset altogether. I can't do this unless I know how many rows I'm getting back from the sproc in order to declare the array's size beforehand. [code]...
View 8 Replies
Oct 13, 2011
I have an Argox Barcode Scanner with a USB port, which inputs data like a keyboard wedge. I've tried scanning barcodes with it with notepad open, and it just dumps the values as plain-text into notepad on a new line every time.
I am creating an application which controls some custom electronics, and displays data on-screen at the same time. This application does not have any user-input on the entire form, except for a button which when clicked, takes the user to a login-form, and then onward to an admin control panel to change the way the program behaves. Everything is going to be set up on a PC which behaves like a kiosk, which means there will be no windows interaction by the user, and he will not be allowed any kind of usage on the machine even if he tries to use his keyboard/mouse all he can, except for reading data presented on-screen as interfaced with our custom electronics, or to use the mouse to press the button which invokes the login screen.
Now in this situation, I need to work in a barcode scanner behind the scenes. What I need to do is a user scans a barcode using the reader, and the scanning of the barcode should trigger some code in the background (which does some checking against a database, and then activates something in our electronics, and so on). After the user scans the barcode using the scanner, there is still supposed to be no user-interaction with the program itself.
how I might accomplish this? I have already thought of using a hidden text-box on the form, but that sounds like a temporary work-around rather than a professional solution. Not to mention if the user were to accidentally click anywhere on-screen with the mouse, or click on the login button, it would take focus away from the hidden text-box, and bringing focus back to it each time programatically is quite a task.
View 1 Replies
May 5, 2009
What happens exactly when you use a regular expression? How do they parse a string so quickly?
View 2 Replies
Mar 25, 2010
Ive looked everywhre for an example they all generally don't work. Im trying to click behind the scenes on "Pandoras Desktop App" Its powered by adobe air (i dont know if that makes much of a difference), i can get the hwnd properly, but after that im lost. ive tried Sendmessaging &H201 but it didnt seem to do anything. Also, for most examples they use notepad with the edit class, how would i get classes on pandoras app? or would i just send the mouseclick directly to the parentHwnd?
View 1 Replies
Dec 5, 2011
make objects from the ToolBox using code instead of changing existing objects invisible then visible later?
View 7 Replies
Jun 23, 2012
I am getting this error, Not sure why it is happening "Error The SqlParameterCollection only accepts non-null SqlParameter type objects, not Int32 objects."I have tried with all sorts of possibilties, now try to enter default data as dummy data,
Using connection As New SqlConnection
connection.ConnectionString = ConfigurationManager.ConnectionStrings("DentalDeviceConnectionString").ConnectionString
connection.Open()[code].....
View 1 Replies
Jan 29, 2011
I have a program like this.
Module Module1
Public Class Mstr
Public Property Prop1 As String
Public Property Prop2 As String[code]....
But it is not working as I expect it to. You can see it from.The DtlsB properties of all three DtlsA objects are having values from last iteration.
View 1 Replies
Jan 6, 2011
I want to let the user input objects to a richtextbox 1 object on each line, and somehow use Random.Next to select pseudorandomly a few objects, the number 'few' inputted in a textbox.
View 9 Replies
Jan 18, 2012
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Using conn As New SqlConnection("Database=Clinic_Management_System;Data Source=.SQLExpress;Integrated Security=True;AttachDBFilename=|DataDirectory|Clinic Management System.mdf")
Dim cmdRecord As SqlCommand
[code]....
View 2 Replies
Feb 7, 2010
I have a user control that inherits the FW ListView and I need to dispose of two objects when the form's disposing of it's objects. Here's what I've concluded already, am I on the right track?
[Code]...
View 3 Replies
May 1, 2009
long story short, I have created a ListView type control, using UserControls for the parent control and the ListViewItems. Most the of the control is written and works fine, right up to the point where I tried to replicate the 'Control.SelectedItems(0).Index' property and the 'SelectedIndexChanged' event.
Each child object knows its index value, and could pass this value via the SelectedIndexChanged event (assuming this is how it works in a normal ListView control -- user clicks on an item, and that item fires an event updating the selected index value in the parent object).
How does the child object raise an event in the parent object? I have a feeling this could be done with Delegates, but I'm still learning about their usage.
View 1 Replies
May 10, 2010
I want to write a program in vb2008 that can import a text file into a Access 2000 database, but using import specifications already in the access database.
View 2 Replies
Aug 9, 2011
getting the following error Unable to cast object of type 'System.Object[]' to type 'OrderService.webdirect_WebLinesRow[]'. On the line
webdirect(web_companyID, web_locationCode, web_customerNumber, web_orderNumber, web_orderReference, web_orderDate, webLinesArray.ToArray(), o_Company, o_LocationCode, o_CustomerNumber, o_OrderNumber, o_OrderStatus, o_OrdDescrip, webRespArray)
I created the webLinesArray.ToArray() array as such
Dim webLinesArray As New ArrayList()
Am I missing an additional cast or something ?
View 1 Replies
Aug 28, 2008
I want to compare two objects to check if all the properites of both the object have same value or not. for this i need to use the reflection to enumarate through all the properties of an object and check the value of the property. To try the code just i have written a Employee Class having Two Properties EmployeeNo and EmployeeName. I am creating an object of the Employee class and need to write a function that can list the values of all the properties in the class.
[Code]...
View 2 Replies
Jul 21, 2009
I am tring to bind a class to a form where the class contains other class variables. For example:
Class Character
Private _name as String
Property Name as String
[code]......
View 5 Replies
Jan 3, 2012
I have a nested class, let's call it class1 and it has class2 inside it; VB.Net eg:[code]
1) How can I define X number of Class2 objects[let's call it: Node(x) array]** with NEW() subroutine called?' this raises error: dim cls2(n) as new class2 end sub.
2) How can I return actual number of Node() array? [code]Outside my class in main project I define cls1 object:[code]Now an array of class2 is created inside cls1.
3) Now,How can I access All of them[node(x) array which is created inside cls1] with all properties and methods available?
I remember I wrote a ProcessManager class with this functionality in .net 2003, nearly 4 years age, I don't have the code now.
View 1 Replies
Jan 24, 2010
I need two seperate lists, which every item is Integer, String, Bitmap - and one which every item is Integer, String String. However I don't know how to do this, or even where to look - I've googled for custom objects and custom object lists. What I'm trying to do is this.Custom Object1 is Integer, String, Bitmap Custom Object2 is Integer, String, String
In one thread I'll be adding items to List1(Of Object1), and processing them, and adding the results to List2(Of Object2), however I need to be able from other threads to look at the list and say only give me the items where Integer = (my thread ID), is this possible? Any help, or even links to information that would be relevant to this request would be helpful?
View 2 Replies
Dec 15, 2009
[Code] I want that once I put something in the BigCollection it stays there, I don't want it to be changeable from outside. I want to be able to clear the SmallCollection but it should not be cleared in the BigCollection. Any Ideas?
View 1 Replies
Feb 6, 2012
Firstly I need somebody to explain a bit of code to me, I'm a massive newbie at programming so I need an in depth explanation.
Private Sub Box_MouseUp(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs)
Dim C As PictureBox = CType(sender, PictureBox)
[code].....
View 2 Replies
Feb 26, 2011
I have to import an csv file to SQL database table which already created (empty and has the same number of named columns). It would be great if you could suggest any tutorials or give some tips.
View 1 Replies
Dec 21, 2009
i have a dll for a device. i want create a dll which will be able to call the device's dll and perform the operations. how can i access all functions of the device in new dll. iwant this in VB
View 2 Replies
Jun 23, 2010
I would like to import a VB.net dll into C++/CLI. I am having trouble referencing my dll. I have tried to find tutorials but with no luck, in particular, I usually find how to import managed libraries directly into native code through COM. I would like to import an existing VB.net dll into my C++/CLI project.
Do I require a header file or a declaration file to import and use my vb.net dll?[code]...
View 1 Replies
Feb 10, 2012
I'm developing an application and I need to know how I can to import a DLL with code and not with "Add reference" because path will be change when I connect to other computer.The library I need to import is ADOX but Maybe it will be used by me with another dlls .
View 4 Replies
Mar 10, 2011
I am trying to import an excel sheet to a sql database. I was able to get it to work using sqlbulkcopy. I am now trying to do it line by line. The code works fine except that only the first row is added to the database. I used a msgbox to ensure that I am iterating through all of the excel values. So I am not sure what is wrong.
Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.OleDb
Imports System.IO
Imports System.Text
[Code]...
View 1 Replies
Jul 13, 2011
I have an app that will load info from a csv into a gridview. Everything works properly except for one column. It is only displaying fields with numeric values. All of the alpha-numeric cells are being left blank. I have looked at the csv and it is properly formatted and the other columns have alpha-numeric as well and are being pulled in properly.
Dim savePath As String = "\Depts"
Dim Conn As System.Data.Odbc.OdbcConnection
Dim dt As New System.Data.DataTable
[code]....
The Item column is the one that is coming in incorrectly.
View 4 Replies
Mar 11, 2009
I made DLL files using VB and placed them in the same directory as .exe. When I edit the source code for .exe and type Dim obj as Object obj = new DLLname.DLLclass everything works fine. The problem comes when I try to use Dim obj as Object obj = CreateObject("DLLname.DLLclass")'error line and an error "Cannot create ActiveX component." is produced. The second code block is more useful to me because I don't want to explicitly specify the name of each DLL file in the code, but rather handle the names as string variables.
So basically I need to import DLL's on the run - how can I do that?
View 2 Replies
May 1, 2010
Hi how can I import other player than winodws media player in vb,let's say winap player.
View 2 Replies
Dec 11, 2009
I mean the imports keyword on the uppermost part of the program.
View 3 Replies
Aug 16, 2011
I dont know how to and ever time i think i do it wont let me import
View 3 Replies
