20,284 Topics
| |
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. | |
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 & "' " & … | |
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 … | |
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 … | |
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. … | |
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... … | |
Hi I am getting this error whenever running the DOT NET Applications. Any one help me to this problem. How can fix it. | |
how to check the master volume is muted or not on windows 7 os. | |
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. | |
have any open source software for create vb program | |
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? | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
how to find list of open port and close open port in vb.net. | |
how to Title Bar Text Animation In VB.NET in diff direction. | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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) … | |
Good morning community, Can someone help me with the IndexOf method to reverse the name: Don Paul to Paul, D | |
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 … | |
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 | |
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 . | |
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 … |
The End.