Sql - Manipulating The Data In Files Itself?
Apr 26, 2010
I 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 Replies
ADVERTISEMENT
Apr 2, 2012
I 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 Replies
Jul 7, 2011
My 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:
View 1 Replies
Apr 30, 2010
I'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]....
View 3 Replies
Jan 10, 2012
I 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 Replies
Apr 14, 2010
The products file contains data such as prices and the product used such as TV. I want to be able to manipulate the data in the product and location file so i can set different products to different location types.
View 5 Replies
Feb 22, 2012
looking for simple code for adding, deleting, editing, and updating data using binding navigator in vb 10. first time using, been using vb6 and code is totally different.
View 1 Replies
Jun 21, 2009
I'm trying to write a vb.net application that works with a 3rd party application called FuzzyTech. Unfortionalty FuzzyTech is quite old so the only way I can interact with it is buy using DDE. FuzzyTech acts as a DDE server. After a bit of research I found a library called NDde which enables me to use DDE. I understand that vb.net does not natively supprt it as it is an old technology.
Now fuzzyTech seems to only respond to the DDE connect and pokes when in debug mode. The only way I can find to get the program in to debug mode is from the menu bar (Debug > Interactive). So I have written an application that runs fuzzyTech, grabs the window and then accesses the menu to put it in to debug mode. My code can then use DDE. I have all of this working ok (although it does feel like a bit of a hack). The problem is I don't want users to be able to see this happening.
I want fuzzyTech to be hidden.After more research I found I could hide the window on startup by using fuzzypProcess.StartInfo.WindowStyle = ProcessWindowStyle.Hidden. However when I do this my code to grab the window and send the menu commands then fails. I think this is because the window title becomes blank when hidden.So I need to know a way of controlling the program after it is hidden or hiding it after it is in debug mode. This is where I am stuck. I'm very new to programming and this has got me completely stumped.
Here is some of the code I am using:
Private fuzzypProcess As Process = New Process()
Private Sub LoadFuzzyTech()
Try
fuzzypProcess.StartInfo.FileName = projectPath & projectTitle & ".ftl"
[code]....
View 2 Replies
Sep 7, 2010
I 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 Replies
Sep 10, 2011
this is not really a code issue, more of an events issue with objects. I want to be able to generate an output as the user inputs into each text box under the "further invoice details" section. For example, if the user inputs a value to amountrequired text box. Then a gross total is auto generated without the need to click a button.
[Code]...
View 1 Replies
Apr 21, 2009
I have an project which was written in VB6 and made use of the Spread3.0 component to display multiple large data from database in spreadsheet. My objective is to convert this project into a VB.NET current version which would not use the third party component but can possibly use a freeware that does similar if not all the functionality.
My question is, are there any freeware that is available in .NET for such spreadsheet-like manipulation of data programatically? I have come across dsoFramer but this only allows the display of the data in an IE frame. I would like to jus embed the content into my existing form.
Also this freeware must be able to handle formula and user-editing as well as multiple cell type such as combobox/checkbox etc.
View 1 Replies
Sep 1, 2010
I have an project which was written in VB6 and made use of the Spread3.0 component todisplay multiple large data from database in spreadsheet. My objective is to convert this project into a VB.NET current version which would not use the third party component but can possibly use a freeware that does similar if not all the functionality
View 1 Replies
Jan 11, 2010
ODP.NET Query - Error manipulating data from Stored Procedure??
View 3 Replies
Apr 26, 2011
How would I turn single images into animated gifs and vice versa? Is there an existing library for such a thing?
View 1 Replies
Jun 30, 2009
I'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 Replies
Dec 18, 2011
i'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].....
View 7 Replies
Feb 10, 2011
I 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.
View 1 Replies
Mar 3, 2009
I have a string array that contains the following:
(Date Type RequestNum)
3/3 xyz 3
3/3 abc 4
[code].....
View 1 Replies
Jun 1, 2010
I'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...
View 11 Replies
Mar 16, 2011
I 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].....
View 1 Replies
Dec 12, 2011
I 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.
View 2 Replies
Jun 2, 2011
I 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.
View 1 Replies
Jan 2, 2012
I 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]...
View 3 Replies
Nov 20, 2009
i 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 Replies
May 24, 2010
Imagine 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
May 1, 2012
I've set up a datasource that binds each table in my access database to the appropriate datagridview... how would I go about submitting changes in the datagridview to the database itself?
ALSO: I would like to have buttons on the form that submit SQL statements to the database and update it. For example, something simple like...when I click the button, it takes the values in the text boxes and forms an SQL statement to create a new record in the appropriate table.... How would I go about submitting SQL via a button?
View 2 Replies
Feb 13, 2012
i mostly use C and assembly, but i thought i would give VB.NET a shot. i used to use VB6 all the time, so wanted to see how different this is. in VB2010, i'm trying to modify the pixels of a Bitmap object and then make it show up in a PictureBox on the form. i get no errors, but this code does not show the new bitmap after it runs.."disp" is the name of the PictureBox on the form.[code]
View 1 Replies
Aug 27, 2011
I have 5 text boxes that I need to perform several operations on as a group, named tb1, tb2, tb3, tb4, tb5.for example, if I want to retrieve the text from each one and process it, I believe I can use the text box or control collection and test each textbox to see if it's name starts with tb, check to see if it has text in it, and then process the text.I think I would use something like for each textbox in..... to test the collection but not yet comfortable with collections and this seems like a good place to start learning how to use them.
View 6 Replies
Apr 12, 2009
Is there anyway of adding a site to the blocked cookies settings list for internet explore using code.
View 2 Replies
Jan 17, 2011
I have the following sub:Private Sub AmIintheListBox1(ByVal datatoenter As String)'Note.- ListboxItemsCount is a variable in the listbox1 change event
[Code]...
I do not know how to do the search of the datatoenter in a listbox with more then one item. If the item is already in the listbox then exit otherwise add it to the listbox.Threaddisplay adds the data to the listbox which I can do when there is no item yet.
View 2 Replies
