|
|
Okay I have a form, where when you type in the textbox it shows up automatically in a live web browser view, and when you type in the textbox the little clicky sound comes up. I need a code that will stop the sound. Please and Thank-You!!
|
|
|
|
|
What clicky sound? The TextBox doesn't make any noise when you type.
It's possible that the browser is making a clicking noise every time you set its Document property. There is no code to turn that off.
|
|
|
|
|
Well then it's the browser sound probably... but I was making a browser, and I had to press enter on the search box. It made a sound, but then I added a code, and the sound stopped. I tried the stoping sound with this and it didn't work. So their should be a code. I think. Thanks.
|
|
|
|
|
thebiostyle wrote: but then I added a code, and the sound stopped.
You're going to have to show that code. I get the feeling that you don't understand what it does and think that it'll apply to the brwoser as well.
|
|
|
|
|
If e.KeyChar = Chr(13) Then
e.Handled = True
End If
|
|
|
|
|
That's not going to work for any control other than the TextBox.
|
|
|
|
|
thebiostyle wrote: and when you type in the textbox the little clicky sound comes up. I need a code that will stop the sound.
You don't use code the way one would use aspirin - it hurts here, gimme a patch. You might want to start by researching whether the sound is coming from your application, or from something else.
I bet it's coming from the operating system. Are we talking about the standard Windows-sounds?
I are Troll 
|
|
|
|
|
Hi,
I have created two columns in my database, "Name", "Payment1", "Payment2".
While creating the columns, I checked "Null" option, because of which it shows "Null" entries under my column "Payment1" if I am not filling anything.
But I want to fill "0" (Zero) in those empty fields of "Payment1" column, so that I can update it later on.
Also I have to add entries of column "Payment1" & "Payment2" Values, so that I can get a total payment.
Anyone can help me on this?
Thanks
R.S.
|
|
|
|
|
Change the existing columns to not null, and set the 'Default value' to 0
When you add the new columns ensure you set the default value and not null for them as well.
If you have knowledge, let others light their candles at it.
Margaret Fuller (1810 - 1850)
www.JacksonSoft.co.uk
|
|
|
|
|
CREATE TABLE Table1
(
Name varchar(50),
Payment1 int NOT NULL DEFAULT (0),
Payment2 int NOT NULL DEFAULT (0)
)
|
|
|
|
|
I have to add entries of column "Payment1" & "Payment2" Values, so that I can get a total payment and write the sum in another column "Total Pay".
How to Add these two columns using UPDATE? Is there any other way to update theese two columns and write the sum in another column "Total Pay" ?
|
|
|
|
|
ALTER TABLE Table1 ADD TotalPayment int;
UPDATE Table1 SET TotalPayment = Payment1 + Payment2;
Although, this is a bad practice since it violates principles of normalization 
|
|
|
|
|
Hi,
I am adding two columns in "payments" table in database. Column A & B. These two are added and updated in Column "Total Payment". The code I wrote is below, its not updating the sum of A & B in column "Total Payment":
cmd = New SqlCommand("Select * FROM payments", con)
If con.State = ConnectionState.Closed Then con.Open()
myDA = New SqlDataAdapter(cmd)
Dim myDataFinalPaySet As New DataSet()
myDA.Fill(myDataFinalPaySet, "payments")
Dim TotalPaymentValue As Double
Dim TaxablePayment As Double
For Each dr As DataRow In myDataFinalPaySet.Tables(0).Rows
Dim ValA As Double = dr("A")
Dim ValB As Double = dr("B")
TotalPaymentValue = ValA + ValB
If con.State = ConnectionState.Closed Then con.Open()
cmd = New SqlCommand("UPDATE payments SET [Total Payment]= '" & TotalPaymentValue & "'", con)
cmd.ExecuteNonQuery()
cmd = New SqlCommand("Select * FROM payments", con)
myDA = New SqlDataAdapter(cmd)
myDA.Fill(myDataFinalPaySet, "payments")
DataGridPayment.Update()
con.Close()
Next
Can Someone help me onthis?
|
|
|
|
|
Use IsNull on the second column when adding.
Payment1 + Isnull(Payment2,0)
This belongs in the general database forum.
|
|
|
|
|
I have to add entries of column "Payment1" & "Payment2" Values, so that I can get a total payment and write the sum in another column "Total Pay".
How to Add these two columns using UPDATE command? Is there any other way to add these two columns and write their sum in another column "Total Pay" ?
|
|
|
|
|
You need to read BOL and get some idea what you are doing. This is a very basic problem that is exampled throughout the doco.
Update TableName Set TotalPay = Payment1 + IsNull(Payment2,0)
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi,
I have an array, x = {10,20,30,"",""). I want the length of this array with non-empty fields, i.e. 3 instead of 5. How to get this in VB?
thanks
|
|
|
|
|
Guess you would have to loop through the array keeping a count of non-empty elements.
|
|
|
|
|
You can write a query in LINQ to filter the array;
Sub Main()
Dim myItems As Object() = {10, 20, 30, "", ""}
Dim myNonEmptyItems = _
From n In myItems _
Where (n.GetType().ToString() <> "System.String") _
Select n
For Each item In myNonEmptyItems
Console.WriteLine("Item: " & item.ToString())
Next
Console.ReadKey()
End SubEnjoy 
I are Troll
|
|
|
|
|
I would like to create a small app to synchronize/backup various groups of files or folders between a flashdrive, home pc and work pc.
Any comments to ensure good speed and reliability regarding the following would be appreciated:
1) To determine which files have changed,
<pre>
Dim di As New DirectoryInfo(Path)
Dim files As FileSystemInfo() = di.GetFiles
Dim fi As FileInfo
'Loop through files and see when last modified, and add to a datatable
For Each fi In files
dr = dtFiles.NewRow
dr.Item(0) = diNext.Name
dr.Item(1) = dr.Item(0) = diNext.LastWriteTime
dtFiles.Rows.Add(dr)
Next
</pre>
Is this OK, or would it be better to check CRC of the files to find the ones that have changed?
I was thinking more along the lines of determining which is the NEWEST file, and then making the sync Bi-Directional though
2) Once I have found the files that are newer, then use:
<pre>System.IO.File.Copy("Sourcefile", "DestinationFile")</pre>
To verify file copied correctly, maybe just put above in a Try... Catch...
Or should I check CRC or something to see if copied correctly?
3) If anyone has done something similar, are there any pitfalls or things I should watch out for?
Tks.
|
|
|
|
|
2). You can use File.Copy the copy the files over, wrapped in a Try/Catch block. You don't have to check the file contents yourself since the O/S takes care of that for you. Since File.Copy is a blocking call, any errors encountered will throw an exception you can catch.
3) Yeah, but I didn't write my own system to do this. I used the MS Sync Framework[^].
|
|
|
|
|
Hi,
I have been searching google for the answer but can't seem to get anywhere.
I have a small program that asks the user for a registration key, they type in the key lets say its "password" the term "password" is then checked on a .txt file in the debug folder and if it is correct they can then install the program on to the hardrive.
This worked brillinat on vb.net however it doesn't work on cd-rw disc.
I WOULD LIKE TO KEEP SOME SECURITY ON THIS PROGRAM that is why i am planing on using CD-RW
i was oringally having the .txt file so that the contents of that .txt file was deleted. is there anyway that the whole file could be dleted or would that still upset the cd-rw???
there must be away round this!?
Dan
|
|
|
|
|
Surely you're overlooking the gigantic flaw that your clients all have rewritable cd-rom drives, what do you do if a client purchases your program and his cd-rom drive does not support writing to cd's?
|
|
|
|
|
I have a checker on form load to see if the disc is in a cd-rom drive if it is, it displays a message saying you cannot install the prgram and then closes the program
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
