Manipulating Table Structure?
Mar 3, 2009I have a string array that contains the following:
(Date Type RequestNum)
3/3 xyz 3
3/3 abc 4
[code].....
ADVERTISEMENT
Manipulating Data From An Oracle Temporary Table
Sep 7, 2010I have a VB.Net application that populates an Oracle 11g global temporary table. I can see data in the temporary table by loading it into a grid and everything looks correct.However, when I call an Oracle stored procedure from VB.Net that would manipulate the data in this temporary table, the stored procedure reports that my temporary table is empty.I understood that data in an Oracle global temporary table should be visible to all sessions.
View 1 RepliesHow To Print Out The Table Structure
Aug 7, 2009I have sql 2005 and I need to print out the structure of a table.Is there a function to print this out.
View 3 RepliesFill A Structure With Data From A SQL Table?
Feb 7, 2011Is there an easy way to get data from a table in SQL Express and put it into a Structure? The table has one string column and five bit columns. I'm using VB.net
View 13 RepliesMultiplication Table With Repetition Structure
May 3, 2011Here is the problem: In this question, you create an application that displays a multiplication table similar to the following figure, where x is a number entered by the user and y is the result of multiplying x by the numbers 1 through 9. Multiplication Table
[Code]....
Save DataTable Structure And Data Into A Database Table?
Mar 10, 2010How to Save DataTable Structure And Data Into A Datatbase Table..
View 7 RepliesGet Structure Of User Defined Table Type(UDTT) From SQl 2008?
Sep 25, 2009I have a User defined table type(UDTT) in Sql 2008 I am writing VB Code to send data to Stored procedure that uses it as a parameter I have found that the datatable i build in VB has have columns in same order as udtt when passing it to SQl from VB Currently I have this roughly
In SQL Server
Create type table my_table
Field1 varchar(10)
Field2 varchar(10)
[Code]....
Structure Inside Another Structure Receives Null Reference Error?
Jan 5, 2012Module Module1
Public Structure structure1
Public TRANS() As structure2
End Structure
Public Structure structure2
Public X() As Integer
End Structure
End Module
Class Structure - Large Structure That Has Lots Of Properties ?
Jan 5, 2010I'm new to VB 2008 after having spent a long time with VB6, so I apologize if this is a stupid question. But I'd really like to have this straightened out.
Let's say I have a pretty large structure that has lots of properties.
Code:
Now say that I want an internal database with about 10 instances of this structure total, describing, say, 10 different products that a store sells. When these values are loaded from a database, they remain totally static. (However, they can be different each time a program loads)
Now say that I have a class. Each instance of this class is a type of that BaseProduct structure. Meaning, each instance of the class pertains to one of the 10 types of products that the store sells. However, this class has additional properties that pertain specifically to each instance, which are not static.
Code:
Now, the problem here is... If I have 200 different transactions, each one contains an instance of BaseProduct. BaseProduct is HUGE, and is largely redundant (only 10 types possible), so I think it's a little silly to include a whole copy of it with EVERY transaction. However, the Transaction class really needs information regarding the base product it pertains to. Is there a way to, instead of declaring a New BaseProduct in the Transaction class, to simply make one of the properties of the Transaction class a pointer to a BaseProduct variable?
In VB6, I would accomplish this by making a BaseProduct(10) array, and then giving each Transaction an ID number referring to an entry in that array. But in VB 2008, using class structure, this is impossible. I can't define the BaseProduct(10) array outside of a class in a namespace, and if I define it in the actual application's form, then the class loses modularity since it relies on the application that's using it.
Converting Structure Within Structure To Byte Array For Socket
Aug 29, 2009I am trying to communicate with an external device and i am trying to send a byte array to the external device via sockets but i am always getting a response the message size is too small so i am not sure what i have done wrong. Between the data type there should be no alignment present and all numbers are represented in little endian format. The char array is not null terminated as mentioned in the protocol specifications.
I have to send data based on a struct that embeds 2 other struct. So here's my vb.net code for the struct used to convert to byte array and the sending part.
Public Structure MESSAGETYPE_OIP_Login
Dim Header() As COMMANDHEADER
Dim UserName() As PSTRING
[Code]....
Invalid Structure Size When Marshalling C Structure To .NET
Apr 14, 2012I'm experiencing a problem with the following c-structure:
typedef struct tagTEXTUREPROP
{
DWORD dwSize;
[Code].....
The Marshal.SizeOf obviously calculates a size of 76 and it works with the DLL function, but it leaves me with some bad feelings.
VS 2008 Convert The XML Structure Into A Class Structure?
Apr 25, 2010I'm having a problem that's driving me crazy; I can't understand how to convert the XML structure into a class structure (that I want to use to hydrate a XML document).
The XML document looks like this:
xml
<?xml version="1.0" encoding="utf-8"?>
<artists xmlns:opensearch="http://a9.com/-/spec/opensearch/1.1/" xmlns="http://www.spotify.com/ns/music/1">
[code]....
Arraylist Of Structure Within Array Of Structure?
May 23, 2010I want to make a structure within a structure. Basically it will appear like this:
Structure ID
dim CardType as string
im CardCode as string
[code]......
Assign Array Of Structure To Another Of Same Structure?
Oct 12, 2010In Vb.net I am trying to assign an array of structure to another array of same structure[code]...
View 2 Replies.net - Manipulating .gif Images?
Apr 26, 2011How would I turn single images into animated gifs and vice versa? Is there an existing library for such a thing?
View 1 RepliesManipulating The Picture Box?
Jun 30, 2009I'm trying to design a game using vb.net window application, my game is sokoban, a logic game where the character pushes boxes to the destination.I have already programme my picture to be move by my direction key, I trying to find out if it is possible for picture box to push picture box like when the character(a picture box) move to the box(a picture box too), the box will move also. and also the logic for creating obstacle for the game, as the picture that i have programme can move beyond the page, I'm trying to lock the obstacle in, so when i move the picture, it will be block by the picture box.
View 6 RepliesManipulating Pictureboxes Positions?
Dec 18, 2011i'm creating a game like text twist. that when i press letter a, i need to determine which picturebox contains letter a and display it to different location. that also goes to the proceeding letter a's. for example, i have a jumbled letters "aamba". in my code, it only gets the first letter a and removes it form the screen, it's nowhere to be found. and it won't recognize that i still have other letter a's i'm pretty sure about the location that i set it to be placed.here is my
(it's kind of brute force i think)
ElseIf e.KeyChar = Chr(97) Then
counter1 = 0[code].....
Manipulating Audio Files With .net?
Apr 2, 2012I need to be able to read audio files and manipulate them from within my own program (similar to how Audacity does it). Now, I'm not asking for something with a thousand effects and such, I just need the minimal as far as audio manipulation for .net goes. I really just need to be able to figure out pitches and frequencies being played at what times and the ability to move them all around.
View 1 RepliesManipulating Data From A Database Within VB?
Apr 30, 2010I'm creating a program that displays data from a Access database in DataGridView, and I'm able to "call" the database and display it in datagridview normally, but I need to be able to take the data from 3 separate columns and average them together, within VB.
My table basically displays 3 grades for a student, one column for the student's name and the other 3 columns for 3 separate grades, I need to be able to take the 3 grades from the same row and average them together, then display them in a separate column within DataGridView.
Here is my code so far, but this only displays all the records without the average:
Quote:
Public Class Form1
Sub UpdateGrid(ByVal sqlStr As String)
Dim dt As New DataTable()
[Code]....
Manipulating Data Sheet Next
Jan 10, 2012I am using the Print Document to create the impression in vb.net...Anything I set a certain number of records per page however see the other pages just like the first,some help to handle these records correctly in the leaves?
View 4 RepliesManipulating Excel Files Using VB8
Jul 7, 2011My script is pulling some information (filename, date, &c) from a server that contains only (nearly) identical excel files generated by a separate application whenever it is used. The goal is to find out who is using the tool and how often.
I need help with two things: extracting info from within the excel file, and appending the results to the SAME excel file each time it's run instead of creating a new file each time.
Here is what I have...
CODE:
Manipulating Output From Sql Command Asp.net?
Feb 10, 2011I am building a quiz application which has 5 categories. I am saving details like name, category and score to DB. Table where all data is saved looks like :
Name Category Score
John Windows 10
Tom Mac 5
On the start page i want to disable/enable categories if user has/has not took quiz yet (ie. if John has already completed Windows quiz but hasn't Mac then enable Mac Quiz, disable Windows and show Windows score).Whats the most elegant way of retrieving these values from database and then passing them to variable or boolean? What if search returns NULL (if quiz was not taken by John) and manipulating output from SQL Database? I am using vb.net 2.0 and SQL server 2005 and its an asp.net application.
Manipulating Text In Another Form?
Jun 1, 2010I'm trying to make a program that can handle menu order in restaurant.
In this program, there are Main form (frmOrder), Starter Form (frmStarter), Entree Form (frmEntree), and Dessert Form (frmDessert). Each category (Starter, Entree, and Dessert) contains 4 menus, and each forms other than main form have label for name, price (label), and quantity (textbox).
Main Form have 4 buttons (3 of them opens respective form of Starters, Entrees, Desserts. Last button calculates total), and it has big label that displays all the ordered menu. By default it has current time and date, so any ordered menus are supposed to be displayed on separate line (with quantity, name, and price with dollar sign).
Below is the code I wrote for frmOrders
[Code]....
I tried to see it works, but lblTape.Text (which is the big label that displays ordered menu) do not change. I did saw lblTape.Text got value it supposed to (item quantity & item name & item price) but it doesn't change when I close form and return to Main form. I'm not sure where I got trouble to end up like this...
Manipulating The Registry From A Click Once App?
Mar 16, 2011I have a couple applications that store data in the registry for persistence.It works great when running in Windows XP, but since upgrading to Windows 7 I've noticed that it fails, basically saying that the permissions are inadequate.
If I disable the UAC it seems to work fine, but I don't want to do that.
Dim regKey As RegistryKey
Try
regKey = Registry.LocalMachine.OpenSubKey("SoftwareTagLookup", True)
If regKey Is Nothing Then
[code].....
Manipulating Windows ACL With PowerShell?
Dec 12, 2011I have a file full of last-names separated by commas and then first-names.
Smith,Bob
Chicken,Ronald
Car,Anastasia
Code:
gc permissions.csv|% {$_.split(",")[0]}
I'd like to grab the first character of the first name and then pre-pend it to the string of the last name. The general idea is to find the user ID that's stored in Active Directory, in my company it's the first letter of the first name and then the last name.
Then I'm trying to add these users as read-only on a specific directory.
Sql - Manipulating The Data In Files Itself?
Apr 26, 2010I have developed an application using VB.NET, Visual Studio 2008 and the SQL Server database. Now I want to ignore the database (it has 1 table as customer (name,password,hour,minute)) as I don't want my client to install SQL Server separately or other overheads.I am planning to do the whole using file handling in VB.NET (manipulating the data in files itself, for example change username, password, etc.). As I am new I don't actually know the proper way and of course need assistance.
View 4 RepliesManipulating Cell Values In Datagridview
Jun 2, 2011I have a items in my database named as
product number | product name | dosage | description | price | remaining box(es)
0023 amoxicillin 50mg none 50 50
i am having problem in my buy button. how can i manipulate the value in the remaining box(es). for example, i select the item named amoxicillin, and i entered 5 on my textbox. when i press the buy button the value in remaining box(es) will be 45.
.net - Manipulating Textbox Variables In Calculations?
Jan 2, 2012I have some code where I am trying to use variables in a tabpage. The first tabpage only has one text box for user entry (miles.text) and a button to do a calculation: traveltime = mileage/speed. The value from miles.text is stored into a variable called mileage while the speed used is stored in a variable called speed (me.speedtextbox.text).
Ordinarily, doing val(variable.text) works like a charm and it's not doing it in this case. When the user enters 100 for the mileage, it should be divided by 65 (the number in the database) and, therefore, the answer should be 1.53 hours. In my case, I'm getting "infinity" and whenever I do anything else with the variable, I get "when casting from a number, the value must be a number less than infinity." But it is! It's only 65 and I double-checked that the dataset said that too, which it does. Not sure why I am getting this error.
[Code]...
Forms :: Manipulating Elements From A Webpage?
Nov 20, 2009i am using a webbrowser control on a windows form to display streaming video from cameras at different locations.i can get the image to display on the webrowser but my problem is that there are other links and texts that are displayed on the webpage.
View 2 RepliesManipulating / Resizing / Scaling An Image
May 24, 2010Imagine I have a rectangle say 400px x 300px. All of this is very easy using Sytem.Drawing. DrawImage. But then I want to leave the left hand side as 300px but change the right hand side to 250 px. I can draw the box using 4 DrawLines but I don't know how to squash the image into the new shape. I want the right hand side of the shape to be 250, the left size 300 and the top and bottom 400px.I can't use DrawImage as it expects the left and right sizes to be the same. Is there a way to manipulate the image into the new shape?I've looked at other questions, but they only apply where the left and right hand side is equal.Any thoughts on how to squash an image into a shape which did not have parallel sides?
View 3 Replies