20,284 Topics

Member Avatar for
Member Avatar for Nebil

I wanted to multiply two values from two different tables. I have a quantity filed stored in one table and a unit/rate field in another. How can i write the sql statement based on a condition and store that multiplied result for further actions.

Member Avatar for G_Waddell
0
230
Member Avatar for Nebil

H guys, I just faced a probelm with my code.It raises an exception.This is the code. conn = oSubPayItemDescription.GetDbConnection() cmd = New OleDbCommand("SELECT [sub_pay_item_quantity].[quantity],[sub_pay_item_unit_rate].[rate] FROM " & "[sub_pay_item_quantity],[sub_pay_item_unit_rate] WHERE [sub_pay_item_quantity].[sub item]=[sub_pay_item_unit_rate].[sub item] AND " & "[sub_pay_item_quantity].[sub item]='" & subItem & "' AND [sub_pay_item_quantity].[bridge type]='" & bridgeType & "' " & …

Member Avatar for G_Waddell
0
207
Member Avatar for fasanay

Hi Guys / Gals - Is there any way to track your AxWindowsMediaPlayer1 when it reaches the end of the Playlist, I am doing a Play / Pause Button but it goes on looping the playlist endlessly, so I was just hoping if I can know it has reached the …

Member Avatar for Gé48
0
681
Member Avatar for joester007

I'm having trouble with this part.My professor wants us to do this, when each button is clicked it 'gathers' the input and calls a sub named Result. I'm guessing we're suppose to use a Sub names Result that will call the other sub procedures. this is what I have so …

Member Avatar for tinstaafl
0
184
Member Avatar for jalmeida

Hi, i need some help if possible. I designed a software on vb 2012 with a local access 2010 database, it runs ok,it add's delete and changes record's. However when i start the software it deletes the added records on the previous session. the software is designed with the dataset's. …

Member Avatar for G_Waddell
0
133
Member Avatar for Yorkiebar14

Hello, I have been using StreamWriters for a long and time and it has always worked but now I seem to be getting an Access Denied error while trying to save to the current users Desktop... Dim savePath As String = "C:\Users\Josh\Desktop\EpiPhone\029.csv" Using sw As New StreamWriter(savePath) '...Rest of code... …

Member Avatar for Jamblaster
0
782
Member Avatar for selvaganapathy

Hi I am getting this error whenever running the DOT NET Applications. Any one help me to this problem. How can fix it.

Member Avatar for Reverend Jim
-1
711
Member Avatar for carlbutler7
Member Avatar for swathi sajja
Member Avatar for xxn5

how to Find emtpy foldder file and zero siz file and del thm. in vb.net how to find list of zero siz file in vb.net and del them.

Member Avatar for G_Waddell
-2
283
Member Avatar for pdmaduranga
Member Avatar for dr.maqbulur.rahman

I used VB6. Now I have shifted to vb10.For data manipulation adodc1.recordset.moveforst etc and adodc1.recordset.fields("xx"), or adodc1.recordset.eof etc were used. Could anybody give me the equivalent navigation process in VB10?

Member Avatar for G_Waddell
0
133
Member Avatar for priyamtheone

I have an MDI application containing an MdiParent form and few MdiChild forms. The MdiParent has a fixed MenuStrip, a fixed ToolStrip and a fixed StatusStrip. The MdiChild forms have one or more ToolStrips and a StatusStrip along with other controls in them. The ToolStrips and the StatusStrip of the …

0
246
Member Avatar for spac

Code the click event of the Play Game button to do the following i. Generate a random integer between 1 and 100 ii. Code a loop that will end when the user guesses the number or 10 guesses have failed to find the number. iii. Use an inputbox function so …

Member Avatar for Jamblaster
0
258
Member Avatar for gayzlein

hi all i want a program that allow me to import excel data into access database using vb.net knowing that the excel data contains duplicates and blanks.my table looks like this: Reference quantity unit_cost turnover once the data is imported, I want to perform calculations to calculate the cumulated turnover …

Member Avatar for gayzlein
0
2K
Member Avatar for Jamblaster

I am having a problem getting this code to work in deleting records from a database. The path to the database is correct and I have another couple of event handlers that work fine using this same datbase so I know that the path to the Db is good. Any …

Member Avatar for Jamblaster
0
176
Member Avatar for Mr.M

Hi Dw I'm trying to detect the harmful files, this is the well known harmful files so now I've tried to scan and delete the files but the problems are: (1)- After the file has been removed (deleted) after a few more minutes it appears again so what I want …

Member Avatar for Mr.M
0
119
Member Avatar for xxn5
Member Avatar for Mr.M
-2
284
Member Avatar for xxn5
Member Avatar for Reverend Jim
-1
496
Member Avatar for Daneil

Dim MoveRight As Boolean Dim MoveRight As Boolean Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick PictureBox1.Image = Image.FromFile("C:\Users\Adrian\Documents\but\Butterfly1.gif") Timer2.Enabled = True Timer1.Enabled = False End Sub Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load PictureBox1.SizeMode = PictureBoxSizeMode.StretchImage End Sub Private Sub …

Member Avatar for EMMAGERALD
0
177
Member Avatar for robert.knighton.79

I'm trying to take input keypress event and move the text it would have typed into a textbox to a different textbox instead. textBox1 has a length limit of 1 so I dont actually have to prevent text going into the box because the textbox is already full I just …

Member Avatar for robert.knighton.79
0
3K
Member Avatar for razree

Hi guys, I'm stucked at (as it seems to me) a very strange problem. I have a listview on my form to which a list of users is populated from mssql db. In the same table but different column I have user_id. I have a textbox and a textbox_keydown control …

Member Avatar for razree
0
1K
Member Avatar for Lakshiya

Hi all. I need your help. Iam using vb.net 2010 and sql server 2008. I have problem when retrieve multiple rows from database to datagridview. All rows have the same identification number(patient registration number).I have problem in loop to show the all rows in datagridview. Pleaase anyone knows that help …

Member Avatar for ccccc
0
1K
Member Avatar for mavtcr

Friends , I am new to VB.NET I know something about VisualBasics 6 Ther we have a DataManager to create new database and tables. In VB.NET Is ther any facility to create new database and tables,If so how to use it?If there is no such facility how can we make …

Member Avatar for Reverend Jim
0
261
Member Avatar for amber.vandenack.5

I need to make a program that will tell me if the user entered a vaild email, phone number, or social security number. This is what I have so far. Sub Main() Dim num As String num = InputBox("Please enter your number!!!", "What was the number you were given?") MsgBox(num) …

Member Avatar for Jamblaster
0
173
Member Avatar for Deegirl

Good morning community, Can someone help me with the IndexOf method to reverse the name: Don Paul to Paul, D

Member Avatar for Deegirl
0
269
Member Avatar for robert.knighton.79

I have a form with 30 textboxes which I want to function as if they are only 1 textbox. # **Why Do this instead of substring the string from a single textbox?** # I have them separated for user friendly appearance purposes. Each box is paired with a checkbox so …

Member Avatar for robert.knighton.79
0
211
Member Avatar for mike.perakis

Dear all, I cant get any result set back, when issuing a simple Select statement through VB.Net and MYSql Data provider, to a Mysql table searching for some Greek string. MYSQL Ver:5.5.32 VB.Net: 2010 Do I need any special encoding for the passed string? Thanx

Member Avatar for G_Waddell
0
292
Member Avatar for xxn5

how to free memory in vb.net when system show low memory. how to relese memory in vb.net from system memory dump in vb.net .

Member Avatar for tinstaafl
-1
2K
Member Avatar for Deegirl

Good morning, Can someone help me code this instruction? Place student names and final mark into two, one- dimensional arrays. One array will be of String (for names), the other will be an array for real numbers (for marks) Use the array to display: Class Average The number of students …

Member Avatar for Begginnerdev
0
166

The End.