| | |
searching by multiple user input and display output in textbox and picture box
Please support our VB.NET advertiser: Intel Parallel Studio Home
Thread Solved |
•
•
Join Date: Sep 2007
Posts: 12
Reputation:
Solved Threads: 0
I am using vb.net 2003 and sql server 2000 as backend. I would like to do searching that will receive several input from user (input from textbox,combobox and radio button) that will retrieve data from sql server and display the output in textboxes and picture box. I can do the same searching and display output in datagrid but i dont know how to display it in textboxes and picturebox. Can anyone help me coz i've been trying to do this all day but still haven't success. With this i include my system interface for better understanding of what im trying to say.Thank you in advance.
Re: searching by multiple user input and display output in textbox and picture box
0
#2 Apr 20th, 2008
have u a searching procedure?? i mean, you can display on datagrid. post it.
Last edited by Jx_Man; Apr 20th, 2008 at 11:02 pm.
Never tried = Never Know
So, Please do something before post your thread.
* PM Asking will be ignored *
So, Please do something before post your thread.
* PM Asking will be ignored *
•
•
Join Date: Sep 2007
Posts: 12
Reputation:
Solved Threads: 0
Re: searching by multiple user input and display output in textbox and picture box
0
#3 Apr 21st, 2008
Im sorry..correction..not same searching but quite similar..this is the code that i used to retrieve input from combobox and display the output in datagrid:
Private Sub btnSearchTool_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearchTool.Click
SqlDataAdapter1.Fill(DsToolInformation1)
Dim datarow As DataRowView
Dim Id As String
Dim x As Integer = 0
Dim location As Integer
Dim result As String = "Fail"
For Each datarow In dv
Id = datarow.Item("Tool_name").ToString()
If (cboToolName.Text = Id) Then
location = x
result = "Success"
x = 0
Exit For
Else
x += 1
End If
Next
If (result = "Success") Then
Me.BindingContext(DsToolInformation1, "Tool").Position += location
btnSearchTool.Text = "&SEARCH"
Else
x = 0
MessageBox.Show("No record found!!!", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Exclamation)
End If
End Sub
And this the output (refer to attachment).
But now i want to do searching that will receive 3 user input and display output in textboxes and picturebox like i've mentioned in previous post..i dont want to display the output using datagrid but I have no idea how to code it.
Private Sub btnSearchTool_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearchTool.Click
SqlDataAdapter1.Fill(DsToolInformation1)
Dim datarow As DataRowView
Dim Id As String
Dim x As Integer = 0
Dim location As Integer
Dim result As String = "Fail"
For Each datarow In dv
Id = datarow.Item("Tool_name").ToString()
If (cboToolName.Text = Id) Then
location = x
result = "Success"
x = 0
Exit For
Else
x += 1
End If
Next
If (result = "Success") Then
Me.BindingContext(DsToolInformation1, "Tool").Position += location
btnSearchTool.Text = "&SEARCH"
Else
x = 0
MessageBox.Show("No record found!!!", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Exclamation)
End If
End Sub
And this the output (refer to attachment).
But now i want to do searching that will receive 3 user input and display output in textboxes and picturebox like i've mentioned in previous post..i dont want to display the output using datagrid but I have no idea how to code it.
•
•
Join Date: Sep 2007
Posts: 12
Reputation:
Solved Threads: 0
Re: searching by multiple user input and display output in textbox and picture box
0
#4 Apr 24th, 2008
Re: searching by multiple user input and display output in textbox and picture box
1
#5 Apr 24th, 2008
Well Great...
Happy coding friend
Happy coding friend
Never tried = Never Know
So, Please do something before post your thread.
* PM Asking will be ignored *
So, Please do something before post your thread.
* PM Asking will be ignored *
![]() |
Other Threads in the VB.NET Forum
- Previous Thread: stopping code executing if cancel button pressed on msgbox
- Next Thread: not displaying the first image from the database
| Thread Tools | Search this Thread |
"crystal .net .net2005 30minutes 2005 2008 access add arithmetic array assignment basic binary bing box button buttons center check code combobox component connectionstring convert cpu crystalreport data database databasesearch datagrid datagridview design dissertation dissertations dissertationthesis dosconsolevb.net dropdownlist editvb.net excel file-dialog firewall folder ftp google hardcopy image images isnumericfuntioncall login math memory mobile ms mssqlbackend mysql navigate net networking opacity output peertopeervideostreaming picturebox1 port print printpreview problemwithinstallation project record reports" reuse save savedialog searchbox serial soap storedprocedure string tcp temp text textbox timer toolbox trim updown useraccounts usercontrol vb vb.net vb.netcode vb.nettoolboxvisualbasic2008sidebar vb2008 vbnet view visual visualbasic visualbasic.net visualstudio web wpf






