|
How do you code passing of parameters from a VB form to a crystal report.
Ex : There is a textbox called "name" I need the value of that box (name.text) to be displayed in the crystal report
AMIF
|
|
|
|
|
Hi,
How do we make a listbox to respond directly when the user clicks on the items in the textbox? (such as making a menu appear or displaying info in a label when the items are clicked)
I have used the SelectedIndexChange event but nothing happens when the listbox items are clicked. The SelectedIndexChange event only seems to work when a button is added. It seems that the button's click event gets the listbox's selectedindex change event to start working. The listbox's textchanged event doesnt seem to work also.
Is there any way to make the listbox respond directly to the user's clicks without the use of button controls?
|
|
|
|
|
KaKa` wrote: How do we make a listbox to respond directly when the user clicks on the items
You catch the SelectedIndexChange event. So yes, you are on the right track.
The SelectedIndexChange event is only raised when the user selects a different item in the list. It's raised when you click or arrow through the items in the list. It should be just that simple.
KaKa` wrote: The SelectedIndexChange event only seems to work when a button is added.
When a button is added? Huh? What exactly are you doing here?
Also, the SelectedIndexChange event should not be effected by buttons. There must be something wrong in your code. Perhaps you should post your SelectedIndexChange code.
|
|
|
|
|
Not sure why yours did not work from SelectedIndexChanged but here is a code cut to use and try.
<br />
Private Sub ListBox1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles listStat.SelectedIndexChanged<br />
If listStat.SelectedIndices.Count > 0 Then<br />
<br />
Label1.Text = ListBox1.SelectedItems(0).Text<br />
<br />
End If<br />
If you list box is static you can get the index (integer) and in a Select / Case statement fire off different events. If the list box is populated dynamically you will have to loop through and pull out the index.
Jason
When people make you see red, be thankful your not colour blind.
|
|
|
|
|
Hello,
I want to create a Custom Minimize & Maximize/Restore button in VB.Net. Can anybody tell me that What is the code for Minimize, Maximize/Restore Window.
Thanks In Adv.![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
-- modified at 21:07 Monday 20th February, 2006
|
|
|
|
|
Me.WindowState = FormWindowState.Minimized
Me.WindowState = FormWindowState.Maximized
chatura
|
|
|
|
|
hi again,
can it possible to make Panel control scrollable? How?
Thanks in Adv.
|
|
|
|
|
Yes.
In the designer select the panel on your form, go to its property panel, and set AutoScroll to True.
Afterwards, scrollbars will automatically appear when controls no longer fit inside the panel.
|
|
|
|
|
Is there a way to hide the console window in a console application? Or if not is it possible to open a command window in a Windows application? Any help is greatly appreciated.
|
|
|
|
|
|
coder45 wrote: Is there a way to hide the console window in a console application?
So do you not want to display the console window at all? Ever?
In that case, create a WinForm project without any forms.
coder45 wrote: Or if not, is it possible to open a command window in a Windows application?
You can launch a console window like this. The second argument passes a string of command line arguments.
System.Diagnostics.Process.Start("cmd", "/?")
|
|
|
|
|
Wonder if any of you guys can point me in the right direction? I'm really new to VB.NET, and its probably really simple, but I'm wondering if there is a VB.NET equivalent of the MSAccess &variable trick that I've often used to have Access use a string as the variable??
For example, the current snippet of VB.NET code reads:
Do While intCheckBoxesToCount < 12
strCheckVariable = "CheckBox" & System.Convert.ToString(intCheckBoxesToCount)& ".Checked"
... and then I want to perform some analysis of my string. What I was hoping for was something along the lines of ...
If &strCheckVariable = True Then .....
|
|
|
|
|
Why not keep an array of CheckBox control references and loop through that?
Class Foo : Inherits System.Windows.Forms.Form
<code>Public myCheckBoxes() As CheckBox</code>
'
Private Sub Foo_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
<code> myCheckBoxes = New CheckBox() {CheckBox1, CheckBox2, CheckBox3}</code>
'
' Do something...
'
<code>For Each chkBox As CheckBox In myCheckBoxes
If (chkBox.Checked) Then
' CheckBox is checked!
End If
Next</code>
End Sub
End Class
|
|
|
|
|
Thanks - this works well
|
|
|
|
|
Dear Friends, I need to save some sounds like "a" and "b" sound. Then I want my software to play them together without any break between those two sounds. Do you have any clue about this? For example I can play 2 recorded sounds by this code below. But there is some break between them. Can I prevent that break? Thanks for help.
Private Sub Command2_Click()
Dim Array1(1 To 10) As String
Dim Yol As String
Dim Tur As String
Yol = "C:\Proje\Sounds\"
Tur = ".wav"
Array1(1) = "a"
Array1(2) = "b"
Array1(3) = "c"
For i = 1 To 3
Call Play(Yol, Array1(i), Tur)
Next i
End Sub
Sub Play(Yol As String, Ses As String, Tur As String)
OLE2.SourceDoc = Yol + Ses + Tur
OLE2.Action = 1
OLE2.Action = 7
End Sub
-- modified at 16:27 Monday 20th February, 2006
|
|
|
|
|
hello
i have a combobox with the following data:
KL1
KL10
KL2
KL3
But I want to sort the combobox alphabetically and numeric
so I want to have;
KL1
KL2
KL3
KL10
Any idea how I can do that?
Thebest
|
|
|
|
|
Hi,
Maybe you can try to list as KL01, KL02, KL03 and so on... In this way, it will sort out as KL01, KL02, KL03, KL10.
Chiari
-- modified at 20:08 Monday 20th February, 2006
|
|
|
|
|
I have a project that stores names to a database successfully until of course I hit a name like O'Conner. Then it hits me with a Syntax error (missing operator) in query expression ''Gary O'Connor', 'Dundee United', '18',71, 'Normal')'.
And it only happens with this guys name. So I gather that its the "'" in his O'Conner that messes it up.
How can I fix it? Here is my insert statement.
sCommAdd += "INSERT INTO Goals (Name, ScoredAgainst, Minutes, FixtureID, GoalType) VALUES ('" + P + "', '" + SCA + "', '" + Min + "'," & FID & ", '" + GT + "')"
|
|
|
|
|
You're having this problem because your using string concantentation to build SQL statements. Use parameterized queries instead and you won't have to worry about it at all.
The technique is decsribed in SQL Injection Attacks and Some Tips on How to Prevent Them
[^] by Colin Angus Mackay.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
or you can simply replace "'" with """"
WiL
|
|
|
|
|
Use this function
function NewString(string)
NewString = Replace(string, "'" , "''" )
end function
this should solve your problem...
With Best Regards,
Mayur
-- modified at 23:05 Monday 20th February, 2006
|
|
|
|
|
And I say learn to do it correctly, before you learn a bad habit.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
How cain i convert Stream data Image to Image?
I get from Http a Stream data Image but when i will convert to image, always have trouble to Parameters. Anybody know how can i do this? Thanks..
Vander
|
|
|
|
|
Just load the image from the stream:
MyImage = Image.FromStream(theStream)
---
b { font-weight: normal; }
|
|
|
|
|
Read the input stream into a byte array.
<br />
Dim len As Integer = File1.PostedFile.ContentLength<br />
Dim fileContents() As Byte = New Byte(len) {}<br />
File1.PostedFile.InputStream.Read(fileContents, 0, len)<br />
<br />
<br />
SaveFile(IntFormID, FileName, fileContents)<br />
<br />
<br />
<br />
Public Shared Sub SaveFile(ByVal FormID As Integer, ByVal FileName As String, ByVal File As Byte())<br />
<br />
Dim conn As New SqlConnection(CStr(Current.Session("ConnectionString")))<br />
Dim cmd As New SqlCommand()<br />
cmd.Connection = conn<br />
cmd.CommandType = CommandType.StoredProcedure<br />
cmd.CommandText = "dbo.uspSaveFile"<br />
AddFormIDParameter(cmd, FormID)<br />
<br />
Dim PrmFileImage As New SqlParameter("@File", SqlDbType.Image)<br />
PrmFileImage.Direction = ParameterDirection.Input<br />
cmd.Parameters.Add(PrmFileImage)<br />
PrmFileImage.Value = File<br />
<br />
Dim PrmFileName As New SqlParameter("@FileName", SqlDbType.VarChar, 100)<br />
PrmFileName.Direction = ParameterDirection.Input<br />
cmd.Parameters.Add(PrmFileName)<br />
PrmFileName.Value = FileName<br />
<br />
AddNetIDParameter(cmd)<br />
<br />
conn.Open()<br />
cmd.ExecuteNonQuery()<br />
conn.Close()<br />
<br />
<br />
<br />
<br />
<br />
<br />
End Sub<br />
"People who never make mistakes, never do anything."
My Blog
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
