I am currently in the proccess of making a calculator, i have added all the functions i want, (+, x, / and - plus = obviously), but the problem is, i cannot do something like, "4+5x2", I can do "4+5" but i cant make 1 function mix with the others.
View 2 RepliesI'm trying to create a .dll in VB Express with multiple functions and subs.
For the .dll program, I create a class module with:
Public Class Class1
Public Function ReturnOne(ByRef MyVar As Integer) As Integer
[Code]....
Upon execution, it tells me that it cannot find the entry point in the .dll.
I've attached a picture of the list view control that I am using. I've been fine until now, I want to save the entire line of items in the list view control (item_description, price) and dump it into the MySQL database to allow tracking of reciepts. The following code that I have saves the first column worth of information, but I cant figure out a way to save the second column (the price)
Dim li As ListViewItem
For Each li In ListView1.Items
CurItems = CurItems.ToString + li.Text + ", "
Next
Oh right, and I'm making it comma seperated values so I can pull it up in a readable format again.
I have a process that is a detail/Master issue. I read (into a dataset) my detail record based on several keys. Then I have to read each master record..check some fields/update some fields and then update that master. Detail is not changed. First.. How do I not lock the detail table during my select?
[Code]...
I use a simple master-detail form using Visual basic 2005 express edition and ms sql server 2005 express edition, as well.
The master table is dept (deptno int, dname nvarchar(50)) .
The deail table is emp (empno int, deptno int, ename nvarchar(50)).
The primary key for the dept table is deptno and for the emp table is empno.
There is also a foreign key (deptno on emp table).
I created a new project, connected to a db (called test.mdf) and created a data source consisting the two of the above reffered tables.
I dragged and dropped these tables on the form and i noticed the following:
1)When the form opens... the system queries the database and displays the data on each block on the form.
2)I insert and/or update a record on the master table (dept) and everything goes well...
3)I try to insert and/or update a record on the detail table (emp) and nothing is changed on the detail table - without any error.
4)When i try to insert and/or update a record on the detail table (emp) which violates the primary key constraint or foreign key the system complaints...(as expected).
I have made several posts on here lately regarding master/detail or parent/child data setups but no one has been able to help. It seems like a subject people don't like to tackle BUT I really need help.
I'm having a real hard with the DataView.RowFilter functionality and it is driving me insane.
For the most part, I have the basic master/detail functionality working. When you select a record in the first grid, it shows the correct data in the second grid. When you enter a record in the first grid, you can enter related data in the second grid. I accomplish this by using a dataview and row filter bound to the 2nd grid. When you change the record in the first grid, the rowfilter for the 2nd grid is restated and reapplied.
The problem arises when I overwrite the primary field value in the first grid and the detail records become orphaned. You would think all I have to do is change the ID in the 2nd grid to match the new ID in the 1st grid but this is where I am having problems. I wrote a loop to change the ID of each record currently loaded in the 2nd grid to match the newly changed ID in the first grid. The code is here:
Code:
Dim I As Integer
For I = AuthorizationGroupsDGV.Rows.Count - 2 To 0 Step -1
AuthorizationGroupsDGV.Rows(I).Cells(0).Value = StrEmployeeID
Next
I have used this code before and it works great. It has to step backwards through the grid because when the ID's are changed, they no longer match the RowFilter criteria and they disappear from the grid. They still exist in the dataset. The problem is, while the code "works" the intended effect does not. Some of the records completely disappear from the dataset and do not reload when I restate the row filter against the new ID number.
There are a lot of master/detail databinding examples with detail form on the same window than the master, I can't find any example where detail is in a new window.
View 1 RepliesI was using access but I want to upgrade as access doesn't handle bulk inserts well. I end up with orphan child records at times.
View 32 RepliesI'm redoing a program for my company and my boss wanted me to created the entire thing through functions...
For the task I wanted to know is it possible to have functions within functions?
Sort of like in C where we would have nested structures?
Its a FILE I/O, with robot commands, moves and verifications....
So I would find the line in an excel spreadsheet where it moves, the coordinate, put it into an array.
Take the actual results store them into a two dimensional array...etc, etc....
Another function would eventually compare the results with the moves, and within a tolerance.
I'm trying to use transactionscope to maintain database consistent. But I'm getting error ('Already enlisted'). I'm using transactionscope in multiple functions. I'm trying to do something like this
Private Function RootMethod() As Boolean
Using scope as New Transactionscope
'Connecting & executing query.
[Code].....
What I am trying to do is have a class where the functions of the same name are both instance functions and shared functions.
Public Shared Function Get...(byval xx as xx)
and
Public Function Get...
The Public Function uses a Property xx created in the constructor, whereas the Shared Function has the parameters (byval xx as xx).
I have a dataset containing 2 tables,Customers and Contacts. Just showing the master-detail is not a problem. Problem occurs when I try to search the master table to bring in the detail table. Searching the master table shows only the master record, but not the related detail records. Adding a 'findby' query on the detail table only shows the records.url.. Normally when the master table is filled, the detail record shows in a form.
View 1 RepliesI am integrating two disparate data sources where each value may depend on one or more other derived elements.This app runs as a windows service.Currently all my code is in a single class.I am upgrading to 2010 and wondering if best practices would be to break out my functions into multiple classes - there are over 100 data elements that need to be constructed. The following is an example of a couple derived items:(Is there a better way to do this - when complete I will pass this app off to someone else to support and want to make sure I give them the best beginning.[code]......
View 2 Repliesneed to know exactly how does the API functions Read/Whrite Process works. I'm so confused while working. I know that I have to work using something like sectors. But I don't know how. Can someone give me an example. I dont know hoe to do it. for an example, for you to give me. Create a basic programa with a button and a textbox the button searchs what is in the textbox in a process memory. Search the title of a program for example.
View 2 RepliesThe project requires a form that has textboxes for a students name and the amount of books they have read, and a label where the points they have earned for their reading is displayed. Also a seperate form with About information and yet another seperate form for summary information.
View 1 RepliesI have an asp.net web app. It has a shared class, and I want to have the connection string the same through out the site. My string is in my web config, but I don't want to type this all over the place:
View 3 RepliesSharing similar functions across multiple controls
View 2 RepliesI am very familiar with modules from my time with VB and my other programming, but what is the most commonly used practice and the best way to go about this for a website application with ASP.NET? Say I have multiple pages (in multiple directories; some in the root directory, some in child directories from the root) that will call the same set of functions and subroutines, how do I go about putting this reusable code in a place where the pages and their respective classes can call the functions/subroutines?
View 3 RepliesI have had no experience with the VB .Net framework. I'm quite comfortable with VB. I wish to create a DLL out of some code which performs some calculations. Is it possible to create DLLs which can export functions using VB .Net? (I read somewhere that we can only create 'ActiveX' DLLs and cannot export functions out of it)
This link [URL] does give a method of creating DLLs by replacing the Linker of VB with a new Linker which can add the '/DEF' field while creating the DLL. Is this doable for VB .Net as well?
Also, the DLLs I want o create will be used by VBA codes in Excel Workbooks. Another way I think it could be done is to put the code in a Module inside a workbook and use it as an add-in. I need to create approx. 150 such DLLs, so I'll have to create 150 separate Add-ins. (Thoguh each add-in will only be loaded when it's required.)
is there a way to dynamically create functions at runtime?
View 1 RepliesThe exact error that was thrown was a MissingMethodException,and was caught like
thisExceptions.Domain.GeneralException was caught Message="UpdateVendorFileProcessingWeek, Method not found: 'Int64 DataAccess.Manager.VendorFileHistoryManager.GetVendorFileHistoryID( Int64, System.DateTime, Boolean)'."
Source="Domain"
[code]....
there's a series of shared functions being used;everything compiles and builds ok - it's only during runtime that the error is thrown;the code itself DOES NOT use reflection to find any methods (but obviously the frameworkis doing some reflection)?
I'm wondering how I can go about creating something like a header file to contain some verbose functions I don't want to have to look at after I get them created. Something like in c++ like..
#include "classfunctions.h" to hide all the nasty stuff you don't want anyone to see.
how to implement UI, BL and DAL in a project the way that I see it as a requirement for some projects. The way I am able to do a project now is from a form create an object of a class in which there are properties and functions that do database selects, updates and deletes. Looks to me that doing a project like that is separating the UI from the DAL. In an update button click event I may call Obj. Delete (txtCustID.txt) for example. I don't understand the part of further breaking it down to include a Business layer; in which a vb solution is made up of three solutions.What goes in the BL?Does the BL call the DAL?
View 2 RepliesI am attempting to have my program select a file, create DataTables and then perform some other functions. I want to be able to open another file and re-do the same steps.The problem I am having is that I add columns to my Datatables and when I try and to open another file while one is already open I get a message that a column of xyz is already added how do I properly "clear my datatable" or perhaps that isnt even the correct approach? Here is the code I have that Opens a File
HTML
Private Sub OpenToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OpenToolStripMenuItem.Click
[code]....
This was working at one time but after adding to my project I must have placed something in the wrong place inadvertantly or it has soemthing to do with adding columns,?
I need a simple win api inside c# / vb.net, to read a text out of a message box. I have a function to read a message box title, but i have no idea how to get the content text.The messagebox title function is:
' Function to retrieve the popup window associated with the form, as well as to
' find the child windows of the popup...
Private Declare Auto Function GetWindow Lib "user32.dll" ( _
[code].....
1) Is it possible to access the Excel mathematical functions without actually opening Excel?
I was thinking of through a DLL WinAPI call or maybe a delegate function or smaller program?
2) Does anyone know of a MS link or area that gives instruction on "how to" use every function of every Windows DLL at all?
Or for all those that Microsoft have chosen to document online at least.
I have a VERY basic knowledge of VB. I'm having trouble figuring out how to read multiple xml files when a user selects them from a listbox. Below is what I have so far. Currently this will only read one xml file. When I change "Dim strDir As String = PlayListBox.SelectedItem" to "Dim strDir As String = PlayListBox.SelectedItems" the code doesn't work.[code]...
View 2 Replies read this xml string using VB.net 2010 and store in a table or array. Please help me on how to do this.
<MYMESSAGE XSTAT="YES" XNUMBER=""><MEMBER MEMBERIS="M" LASTNAME="AAA" FIRSTNAME="BBB" MIDDLENAME="CCC" SUFFIX="" BIRTHDAY="10-26-1958"/><EMPLOYER PNN="53453245345" NAME="MY ABC COMPANY"/><DOCUMENTS><DOCUMENT COD="1234" NAME="PROPERLY
FILED">OTHER REMARKS HERE</DOCUMENT></DOCUMENTS></MYMESSAGE>
I have 500 odd csv files that I need to pick up and load into a table in Teradata.How do I combine this 500 files data into one file Or is there a script that will go and fetch data from each file and load it into the table.Here are more details.I have a bunch of hotels and the end of each day all the hotels dump in one file into a common folder.
Like
D:CorpHOTELSACCOUNTSREPORTINGUSA
Here I get files in the following format.
Hotels_Sales_Graph_level_20080529
Hotels_Sales_Graph_level_20080530
Hotels_Sales_Graph_level_20080601
[code].....
Now I need a script to pick all these files data and load it into one file so that I can use this file to insert data into a table using a fast load script i already have.I have a script that will read this file copy it to a new location and archive it.I can use this final file to load my table.But I dont have a script to read all these files and also read the new file that comes in everyday and load it into one csv file.
While converting types, I have found myself using both VB functions and BCL Convert.To* methods.
E.g.)
Cstr() vs. Convert.ToString()
CInt() vs. Convert.ToInt32()
CDbl() vs. Convert.ToInt64()
etc...
Are there any subtle differences that should be noted?