how to create a comparison statement for a record that I have placed in a column of a SQL Database. In other words, I have a 2- forms, the first form is where the enduser places a few record requirements along with 4-digit number followed by the submission of a registration. After the registraions is submited, I have it coded to where the registration gets saved along with the 4-digit number into the database followed by a second form appearing. Ok, here comes the problem: When the user exits the applaication and then restarts the application again, the first form apears although it is not necessary since the enduser had already registered.
So, how do I or what kind of comparison statement can I create that will let visual basics or the first form know that the registration was completed and force the second form to appear instead or first?I would liked to makes some type of comparison with the 4-digit number thats in located in the SQL database.
Assume a grocery store approached you to write a simple program that calculates total sales of purchases. The program should accept item costs as input, calculate the tax on each item (8%), then display the item cost, total cost, and total after taxes. Item costs will be added to a listbox while the total without the taxes will be displayed in a label, the tax amount in another label, and finally, the total cost (items cost + tax) in a third label. this is the problem I have to program for,
I want to make a program that will sync two folders together with the command in cmd called xcopy, so when i click on a sync logo the folders sync. But i want the user to be able to browse for the locations then set the locations as they sync folders. I already have linked two FolderBrowserDialogs to two textboxes so when i select a folder in the browser the directory shows in the text box. But then how do i put the two directories into the xcopy command? This is what i have done so far...
I am trying to do a very simple demo - load data from an access database and let the user manipulate it with a DataGridView. Here's what I understand so far:1) Create an OleDbDataAdapter by passing it a query and a connection.2) Create a DataSet by calling .Fill() on the DataAdapter with a DataSet object and a name for the retrieved data.3) Attach the DataGridView to the DataSet using the .DataSource property of the DataGridView and the .Tables property of the DataSet.However, I was told there is a much easier way to do it now in vb2008 using TableAdapters.1) Create a DataTableAdapter ( I can't actually find this object -what is it called?)2) Use the Fill method on the DataTableAdapter to connect it to a DataSet3) Now anything the user does in the DataGridView can be saved simply by using TableAdapter.Update.
The program i made is an IP Finder. it uses MS WinSock, so i thought that would be the problem. I have already installed the powerpack and i got another program i made working
I have put a ton of effort into my new project, and I have saved the coding and designer part. I never did publish it, and when I came back to open it later to work on it, I can't seem to get to the screen that allows you to move items, and edit the looks of the project. I have to files that say RSEB.Designer.vb and RSEB.Vb - So how do I open the screen that allows me to edit the damn project?
I have a monster of a problem and don't know where to start. I need to create a simple application that will: have two open file dialog boxeseach file box, one can choose the .txt file to compareonce each box has a file location, click a button that starts. My boss man wants the results saved as :
I've small project to do and now I'm stuck in middle. The program is to read the sequential text file and load it into a array/array of structure.The data information is like this (sample):
ID | Name | Type 1 | Cat | Animal 2 | Dog | Animal
[code]....
This is Just as sample data, my original data is more than this.I've open the DATA.txt file using FileStreamReader:
Dim FileStreamReader As StreamReader = New StreamREader(DATA.txt)
Read all the elements in the list and pass through ReadArrayString.Split the string using:
Where index 0 is the ID, index 1 is the name, and index 2 is the Type Then I load the types in the dropdown combobox menu from the array with out duplication. Like this:
If TypeComboBox.FindString(ReadArrayString(2)) < 0 Then TypeComboBox.Items.Add(ReadArrayString(2)) End If
Now When you click TypeComboBox it will show drop down menu with following list only.
Animal Bird Fish
After this, when Animal type is selected/clicked from combobox dropdown menu then it should only add the Id and Name of Animal type in the ListBox.Pseudocode may looks like this:
If Animal is selected/clicked from TypeComboBox then Add Cat into listbox Add Dog into listbox
[code]....
I've only figure out load items from only one column/array into combobox with out duplication.But can't figure out to compare the value of one column/array with another column/array and load it into listbox. I don't want to hardcode or write matching value inside the code. What I want is use the Array.
i want to create an system that can trigger alert which, the alert box will change to a red color depending on its value.
my problem is, the value that i used to compare is dynamic and based on what user key in in the paramater table while the data that will be display the alert is from the alert table.
lets say the value in the parameter table is been declare as Aand the value that display the alert is been declare as cellvalue.
this is the code that i have been tryingif cellvalue < A then' some code to change the box colorEnd if
but i kept failing. the system cannot read the A value.
I'm a little brain dead at the moment and was wondering if someone could help me out with some code.I am pretty new to using databases in vb and what I want to do is to match a variable with a value in a database field and when it finds it, it will store the row count into another variable. I know I have to use a counting loop, I'm not sure how to compare the variable to the value in the database.[code]
i want to create an system that can trigger alert which, the alert box will change to a red color depending on its value.my problem is, the value that i used to compare is dynamic and based on what user key in in the paramater table while the data that will be display the alert is from the alert table.
lets say the value in the parameter table is been declare as A and the value that display the alert is been declare as cellvalue. this is the code that i have been trying if cellvalue < A then some code to change the box color End if but i kept failing. the system cannot read the A value.
I have a connection string set up and a data reader.I have two textboxes on my form for users to type in. One textbox (txtLogin) is a user name and the other textbox is a password (txtPwd). I'm trying to compare what a user types into those two boxes to a table in a vfp database. The table I'm trying to compare to is open about 99% of the time so I need to be able to read from it in some type of "shared" mode.
My Select statement needs to be something similar to "select * from sites where clogin = txtLogin.text and cpassword = txtPwd.text"I just don't know how to get this to work properly.
i want to compare between the cell value with the value(parameter)in database.
as example, if my cellvalue value is 3 and my paramater(a) in my database is 5 it will be like this if cellvalue<a then (some code)end if
the problem is i don't know the exact data type. the reason i need to use data type is because my data is dynamic.
here is my code:
Code: protected SubGridView1_RowDataBound(ByVal Sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowDataBound con = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;
I have a tblVersion that contains the versions of my application:
VersionID Version
VersionID is a bigint primary key, version is a ntext column that holds the current version... I want to be able to pick the row that has the highest version number, but version could be in this format:
MyApplication 1.0.1
If I try to convert that to a int32 it will throw an exception obviously. I would like to know if some of you have a idea how to solve this issue. I could of course make sure the column will only contain numeric values but this gives a little more flexibility.
I m writing a Auto Sms Sending application which will work in the background. I m using VB2010 and Sql 2008 This application will check SMS table every 5 seconds to check new records if it finds a new record it will sent three sms at an interval of 6 hours.The problem is I don't know How to Extract Value of a 'Time' Column and Compare it with system time.i simply want to Compare value of 'Time' column and system Time if Time Deference >= 6 hours the application will sent SMS
i need to get date from database table and compare it either it today or tomoe..after that need to compare time.I got table where the format is 'datetime' contains like = 4/11/2010 12:00:00AM'....so i need to get the date only...how to do that?...when get the date ...ithen i need to compare a time.
I am looking into WCF specifically in relation to Silverlight. if I am correct in thinking that I can create a WCF Service, and expose a TCP endpoint using a Windows Service that my Silverlight app can use? I have managed to expose this using IIS but it would be good if we could bypass using IIS as some of our customers don't like it.
I am quite new to programming and I want to be able to check whether the user logged on to the system is in a table or not. I am not quite sure how to iterate through a table.
I need to parse a file name and compare to names in a data base. The file name has an underscore "_" as the delimiter. I need everything before the underscore.
I am trying to figure something out. I have an application in which I am adding the ability to consume a feed. I have no problem with the feed itself, but my problem is how can I mark certain items as 'read'? The only thing I can thing of is to read the feed into a database. In this database, I add a column for 'read' which I update when the user has read the article. Then each time I retrieve the feed, I compare the feed to the database and only load new items into the database.
I'm trying to create a simple example of an editable gridview, and for some reason can't seem to get the basics working. Why is this example not displaying the label Bar and a textbox when I click on "edit"?
I'm trying to make to do a widening conversion from a byte to an integer. form has a text box for both Input, and Output, plus a conversion button. [Code] I'm trying to use a catch block, but I'm not certain how it works exactly, and also tried to use an If statement to avert the issue, but that didn't work either. When ever user inputs a number greater than what can be held within the Byte data type the program crashes from the run time error. [Code] and an error message pops up in the compiler saying overflow exception was unhandled.
I am new to vb.net, from VB6. Trying to understand drawing a simple line graph into a picturebox, which was so simple in VB6 ! From code snippets, I can see the basic idea using an bitimage to draw the lines and then showing it in a picturebox. I don't understand how to (simulate) scaling of the bitmap's x/y scales like you could do with VB6's .Scale.