Making Sure Figures Match In Tables
Mar 18, 2012
i was just wondering how i would do this task. It seems fairly simple but i dont no how to to do it. In my system i have a table where i have a total figure of the stock. what i am trying to do is when my saler order takes 5 i want it to project this in my overal amount. How would i do this. I am not asking for codes just a method of doing it
View 6 Replies
ADVERTISEMENT
May 5, 2011
I need to count the number of records that match on the GIDs from the 'Directories' table (GID) and the 'ClientSubscriptions' table (DirectoryGID), and also the 'FranchiseGID' from both; as follows:
Dim iSubscriptionCount
SQLCommand = "SELECT COUNT(*) AS Counter FROM Directories.GID, ClientSubscriptons.DirectoryGID FROM Directories, ClientSubscriptons WHERE Directories.GID = ClientSubscriptons.DirectoryGID;"
[CODE]...
I need to determine whether or not to show a menu option based on the above.
Full Code: Default.asp
<!--#include virtual="/System/Startup_Admin.asp"-->
<!--#include virtual="/Admin/FranchiseAdmin/DirectorySetup/i_Directory.asp"-->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-
[CODE]....
View 3 Replies
Feb 22, 2012
I have a field in the database that is XML because it represents a class that is used in C#/VB.Net. Problem is after the initial manipulation most, but not all, of themanipulation is done in SQL Server. This means that the XML field is converted on the fly.As we are getting more fields and more records, this operation is getting slow. I think the slow down is the converting all of those fields to other data types.So to speed it up I was thinking of a couple of ways:Have a set of tables that represent the different pieces of the XML data. I would make these tables read only using a trigger on Insert/Update that would reject any changes. My 'main' table with the XML in it when it updates the XML would turn off the triggers, update the tables with the new values then turn the triggers back on.
The only real reason we use the XML is because it's really easy to convert it to the class in C#/VB.Net. But I'm getting the point where I may end up writing a routine that will take all the bits and pieces and convert it to a class and also a function to go the other way (class -> tables).
View 2 Replies
May 29, 2010
Am trying to match characters or combination of the characters i specify in any order they appears
vb
Regex.IsMatch(teststring "[nuls]")
what i want matched is either any single character, or combination of any of them in any oder. this means that it should not match any character not specified in the pattern.
For example
it should match
n,u,l,s,nu,un,lun, sl etc
not
ny, nx so etc or any other
View 9 Replies
Nov 25, 2011
How can I add a loop to this sequence to make the program give a total of the figures in the domestic and international columns when the word "ALL" is typed into the month textbox,instead of a number. The domestic total should go into the domestic textbox, the international total should go into the international textbox and the total of the domestic and international should go into the companytotal textbox.
'Basic Info:
'Month Domestic International
'1 100,000 150,000
[code]....
View 2 Replies
Nov 25, 2011
How can I add a loop to this sequence to make the program give a total of the figures in the domestic and international columns when the word "ALL" is typed into the month textbox, instead of a number. The domestic total should go into the domestic textbox, the international total should go into the international textbox and the total of the domestic and international should go into the companytotal textbox.
[Code]...
View 1 Replies
Nov 24, 2011
Does anyone know why the domestic figure is showing up in both the domestic and international textbox? And why the totals of the domestic and international figures keep coming out to zero? [Code]
View 4 Replies
Jun 15, 2007
This DEMO will stop itself after a short while,Warning to anyone with photo-epilepsy, it is a bit flickery!!Do you see the peaks as moving clockwise or anti-clockwise from the top?!!ow i am looking to do this without hogging 100% CPU time in a DO LOOP.I would also like to use SetPixel but that is only available with a BITMAP.
View 1 Replies
Jun 4, 2009
Below is my code which is almost complete. The only thing that I need to do is set up an autoupdate feature that keeps an ongoing average of each temperature that I enter in. I have no idea how to do it!
Option Strict On
Imports System.Convert
Imports Microsoft.VisualBasic.ControlChars
Public Class Form1
[code]....
View 1 Replies
May 9, 2012
I'm trying to do something that is turning out to be out of my league at the moment. I need to draw geometric figures. These geometric figures have all the coordinates of their corners. Say I have a trapezoid, and I would want to draw it. The drawing would be done in a picturebox or a panel or a groupbox (some part of the form where only the geometric figure will be).
I saw the method on how to do that Here and that's exactly what I'm trying to achieve, but there it's drawn on a newly created form, and I need it in a picbox, panel or groupbox as I mentioned above. I also need the drawn figure to be at the center of the picbox/panel/groupbox.
The coordinates of the lines should be like (xa.text,ya.text) to (xa.text - xb.text, ya.text + yb.text) if I'm not wrong for the first line of the geometric figure and so on.
View 3 Replies
Nov 22, 2010
I am trying to input a text file of figures into a 2-dimensional array. I want to do this so I will then perform percent changes on the respective columns. The text file contains columns and then numerous rows for each columns each number is separated with a tab. The text file looks something like this.
2.2 5.5
3.7 6.3
9.2 9.1
So I need to be able to input the text file, turn it into an array and then find the total percent change. From 2.2-3.7-9.2
View 8 Replies
Oct 16, 2009
I'm currently trying to write a really simple game on which the player has to pursuit some figures on the screen. Since i'm just writing the prototype version i'm using a Panel wich i redraw 1000 times per second. Now, i want that every level is similar but not the same as past level, so i created a Level Class that contains the game objetcs of Player Class and the Figure Class, wich are the ones that have all the movement subrutines. So, with a Timer, 1000 times per second, i get the input from a joystick, pass it to the player objetc and update the position of the figure object. All this stuff is reported to an internal Panel that every level object has, wich i refresh and then pass it ByVal to the panel that the player actually sees. The problem i have is that after the first level ends, when the second level starts running, i can see the last frame of the fisrt level flashing behind the figures and it makes the game run a bit slower after every level. I tried keeping a copy of the inicial state of exterior panel and use it to clean the one i'm using on the levels but it didn't work...
View 11 Replies
Sep 14, 2009
Here's my situation: I'm tryring to build a very simpe minigame in which the player has to pursuit and catch certain figures on the screen. This figures are currently showed as images on PictureBox wich i pass ByRef to some classes where the movement subrutines are. I have all the graphics in PNG, with transparent background, format and they look fine on the background, but when 2 or more of this figures are over the same place on the screen every PictureBox covers the underlying figure, so all i can see is one figure over the background.I was wondering if theres a way to solve this... Maybe using more powerfull libraries or something like that.
View 4 Replies
Oct 19, 2011
I'm doing a web application in which the user must make a series of figures such as rectangles, text boxes and lines, Is something like like google docs draw
View 2 Replies
Jul 25, 2012
I am using VS2008 and SQLite. I have created a database and several tables and am attempting to populate the tables with data from arrays.
The following code (example) works fine but stops after it inserts 30 to 50 records. I am running the VB code in debug mode and when it stops, I press pause to see where it is. It stops on "SQLcommand.ExecuteNonQuery()" and when I press continue (F5) it will insert another 30 to 50 records.
I do not get an error message. Is this a timeout issue? How do I keep the loop running to the end of the array?
Following is example code.
Dim
SQLconnect As New SQLite.SQLiteConnection()
Dim SQLcommand As SQLiteCommand
CODE:.....................
View 4 Replies
Jul 12, 2011
have a datagridview containing 2 tables left joined, so that:table1 LEFT JOIN table 2 ON table1.id=table2.idI get an error whenever I try to edit my datagridview."invalidOperationException was unhandled by the user codeDynamic SQL generation is not supported against multiple base tables."The error points to this line:
da.FillSchema(dt, SchemaType.Mapped)
da.Update(dt) << This line
'da = dataadapter
[code].....
View 3 Replies
Oct 29, 2010
In my datagridview I was fill in using join tables (table1 = pr_employees, table2 = pr_employee_deduction). My problem now is during save button I want to update records from table2 only.[code]
View 3 Replies
May 10, 2012
We are presently developing an application, let's call it APP1, which uses a SQL Database which have about 800 stored procedures, 600 tables, etc. APP1 was originally created in order to replace another application, APP0, from which we do not have source code but only SQL tables, Stored Procedures, views, etc. Previous programers of APP1 used some DB objects from this same database and added some other objects specific to APP1 because it becomes bigger than APP0. And we do not need APP0 anymore as APP1 does all what we want, and more.
So, now, we are thinking about a way to find out which objects are used by APP1 in order to remove objects which are ONLY used by APP0.What is the best approach to discover all objects used by APP1 without having to open every single class and form?
Once we will have a complete list of these objects, it will be easy to use a program we bought which detects all dependencies for all SQL Objects specified directly from SQL and remove objects which do not return from any dependencies. Any ideas of how I could get this list without having to go through all our program that have many, many, many classes and forms?
Note : I know, in a perfect world, all calls to PSs and tables should be in a DAL but in the case of the application we're presently working on ... this is not our case! Yippy! (sarcastic yippy) ;)
Note 2 : This application is not using any ORM. So all queries are directly using SqlCommand. So any call to any DB objects are in string format.
View 3 Replies
Mar 25, 2009
I have a 5 tables in my database and i want to access all my tables togather at a time.e.g.I have a code for one table i.e. rs.Open "select * from Group_info", con, adOpenDynamic, adLockBatchOptimistic. instead of Group_info table i want to access 5 tables also as Login_table,User_info table,group_name table etc. How i do that
View 11 Replies
May 16, 2012
I'm a huge music person (got my own lil record thing going) but I'm wanting to design a program that would make music in my way. I have a decent amount of background knowlege of Visual Basic and Java I'm just wondering how could I execute this whole project. The Project is making a MPC Sampler. MPC is a drum machine; a machine with buttons that once you press it that it will play a sound from a drum (ex: snare, kick, tom, ect.) . So I would want to make some pads on my program that each have their own sound. Total of 16 pads. Which the design wouldn't be hard to make nor would the functionality of it having the play back sound (in my opinoin it wouldn't be hard atleast). But the thing is I wanna map out these pads to number keys on the number pad or keyboard. I'm not so sure how to do that. But that's all the easy stuff...
Also finding information is making a sound directory. What I mean by this is that I want to make a User Interface that will open up a file directory of sounds and the user can select what "kick" or "snare" sound he may want for the kick or snare pad. I don't know how to do that or even know what to search; neverless I don't know if this whole project idea is a good idea for Visual Basic or another programing language.
Also LATER ON I am wanting to add a record and export function that alows users to..well...record and export their beat or instrumental ha. That doesn't seem too too complex (mainly due to the fact that all it needs to do is record the users key strokes and then show them and play the sounds, but obviously it would get more complex than that.)
Here is an image of one of many MPCs but one with a directory - [URL]
View 5 Replies
Nov 25, 2009
I am working in a point of sale system in Vb express 2008. I want to convert the Amount in Figures to Words like: How to conver the amount of $ 1,550,325.45 to Amount in words as DOLLARS: ONE MILLION, FIVE HUNDRED FIFTY THOUSAND, THREE HUNDRED TWENTY FIVE AND FORTY FIVE CENTS.
View 2 Replies
Nov 25, 2009
I am working in a point of sale system in Vb express 2008.I want to convert the Amount in Figures to Words like:How to conver the amount of $ 1,550,325.45 to Amount in words as DOLLARS: ONE MILLION, FIVE HUNDRED FIFTY THOUSAND, THREE HUNDRED TWENTY FIVE AND FORTY FIVE CENTS.Please advise how to code for that in Vb express.
View 5 Replies
Jun 6, 2011
SQL statements:
SQL = "SHOW TABLES;"
Try
conn.Open()
The remarked area works fine when I'm accessing a specific table. I've successfully inserted the products_model field into the combobox too. The datagridview does show the table names in the db using the SHOW TABLES sql statment, but I'm not understanding how to get this info into the combobox instead.
View 1 Replies
Aug 14, 2009
I am trying to make a database, fill it with tables and then fill the tables. I am having problems connecting to the server and am really not sure why. I have posted this thread in two areas of this site because I was not sure what was the best area to put it in. [code]
View 3 Replies
Mar 15, 2010
I am trying to create the below matrix in my vb.net so during processing I can get the match scores for the alphabets, for example: What is the match for A and N?, I will look into my inbuilt matrix and return -2 Similarly, What is the match for P and L?, I will look into my inbuilt matrix and return -3 how to go about it, I was trying to use nested dictionary like this:
Dim myNestedDictionary As New Dictionary(Of String, Dictionary(Of String, Integer))()
Dim lTempDict As New Dictionary(Of String, Integer)
lTempDict.Add("A", 4)
myNestedDictionary.Add("A", lTempDict)
The other way could be is to read the Matrix from a text based file and then fill the two dimensional array.
View 3 Replies
Mar 2, 2010
I have the following code
TestArray(0) = "<RD><PS:CL><JL:Jump,""(.*?)"">"
TestArray(1) = "<RD><PS:CL><JL:Jump,""(.*?)"">(B)(.*)"
TestArray(2) = "<RD><PS:CL><JL:Jump,""(.*?)"">(C)(.*)"
Do Until xRead.EndOfStream
'do stuff here here with test array(i)
'do stuff here here with test array(i)
'do stuff here here with test array(i)
'do stuff here here with test array(i)
i = i+1
loop
I would like it so that instead of "Do Until xRead.EndOfStream" I would like to read the file line by line until a match is found, then add +1 to i and repeat.
View 4 Replies
Sep 11, 2010
My app retrieves "Place names" and their "Addresses" from a website.
View 2 Replies
Aug 1, 2011
I have :
[Code]...
I think I have explained my problem properly..
View 2 Replies
Dec 13, 2011
I have a RegEx I am using in vb.net and i can get all the matches of the text but i want to get the first match of the text, this is what i am using.
[Code]...
View 1 Replies
Mar 26, 2012
I'm using the following VB.net Code to find phone numbers in HTML and make them "clickable":
Regex.Replace(pDisp.Document.Body.innerHTML, "([0-9+ ]{3,6}[s]{1,1}[0123456789 -/]{4,15})", "<a href=http://DIAL/$1>$1</a>")
There appears an issue if the numbers contain white spaces, for example:
089 12233 455
This will be replaced with:
<a href=http://DIAL/089 12233 455>089 12233 455</a>
Is there a way to get
<a href=http://DIAL/08912233455>089 12233 455</a>
instead?
View 3 Replies