We just refreshed our COA course based on the Newton exam. With 14 labs, this course goes over the different OpenStack services that are part of the certification: Dashboard, Identity Service, Image Service, Networking, Compute, Object Storage, Block Storage, and Orchestration.
Solved
use combo box to read data in SQL Server 2005 db
Posted on 2007-11-14
I could really use a lot of help on how to code a combo box in Microsoft Visual Studio if I am connected to SQL Server 2005 db.
I'm not even sure where to begin. I'm connected to the db and I can move previous and next and all of the fields on the form change the way I would expect. But I want to be able to select a FileNo from the combo box and have it fill the form with the correct data.
I have tried creating the following view in SQLServer 2005 but it won't even compile...
SELECT FileNo, SSN, FirstName, MiddleName, LastName, Dependants
FROM dbo.tblClientInfo
WHERE (FileNo = @FileNo)
If I take off the Where clause (just to get something to work) I can save it. So I tired using the followng code in the SelectedIndexChanged property of my cboFileNo combo box. It complies but when I select a file number from the dropdown menu I get the errors
Relax or turn off constraints in your DataSets.
Clear datasets before loading them from view state.
Code in the SelectedIndexChanged property:
Private Sub LoadByFileNo(ByVal sender As System.Object, ByVal e As System.EventArgs)
Me.VuLkUpFileNoTableAdapte
End Sub
I don't even know if I'm on the right track. I have viewed many "how to" videos on VB.net but none of them have an example using a dropdown menu the way I want.
I could really use some detailed help. A link to detailed instructions on how to create a combo box would also work.
Thanks in advance!
I'm not even sure where to begin. I'm connected to the db and I can move previous and next and all of the fields on the form change the way I would expect. But I want to be able to select a FileNo from the combo box and have it fill the form with the correct data.
I have tried creating the following view in SQLServer 2005 but it won't even compile...
SELECT FileNo, SSN, FirstName, MiddleName, LastName, Dependants
FROM dbo.tblClientInfo
WHERE (FileNo = @FileNo)
If I take off the Where clause (just to get something to work) I can save it. So I tired using the followng code in the SelectedIndexChanged property of my cboFileNo combo box. It complies but when I select a file number from the dropdown menu I get the errors
Relax or turn off constraints in your DataSets.
Clear datasets before loading them from view state.
Code in the SelectedIndexChanged property:
Private Sub LoadByFileNo(ByVal sender As System.Object, ByVal e As System.EventArgs)
Me.VuLkUpFileNoTableAdapte
End Sub
I don't even know if I'm on the right track. I have viewed many "how to" videos on VB.net but none of them have an example using a dropdown menu the way I want.
I could really use some detailed help. A link to detailed instructions on how to create a combo box would also work.
Thanks in advance!
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
2
4 Comments
I have done this with a databound combo box. You should be able to go into the properties of the combobox and configure it as a databound control and query for the values to load.
In the design mode of your form you should see it when the combo box is selected. It will let you create the query you desire in the control specification.
Regarding your view, views don't take parameters. That's only doable in stored procedures. If you know the values you want to restrict on, you can enter them in a where clause. At runtime if you want to filter, you have to put a where on the end of your view.
For example: SELECT A, B, C FROM vwMyView WHERE A = 1234
In the design mode of your form you should see it when the combo box is selected. It will let you create the query you desire in the control specification.
Regarding your view, views don't take parameters. That's only doable in stored procedures. If you know the values you want to restrict on, you can enter them in a where clause. At runtime if you want to filter, you have to put a where on the end of your view.
For example: SELECT A, B, C FROM vwMyView WHERE A = 1234
Thank you for responding.
I went to the properties window of the combo box and tried creating the following query because it used the @parameter in an example and it says qry not view.
SELECT FileNo, SSN, FirstName, MiddleName, LastName, Dependants
FROM dbo.tblClientInfo
WHERE (FileNo = @cboFileNo)
However I get the same messages.
If parameters are only doable in a stored procedure could you help me with the code I'd need in a stored procedure? And how I would use it with my combo box?
Thanks!
I went to the properties window of the combo box and tried creating the following query because it used the @parameter in an example and it says qry not view.
SELECT FileNo, SSN, FirstName, MiddleName, LastName, Dependants
FROM dbo.tblClientInfo
WHERE (FileNo = @cboFileNo)
However I get the same messages.
If parameters are only doable in a stored procedure could you help me with the code I'd need in a stored procedure? And how I would use it with my combo box?
Thanks!
Bryan,
I changed the datasource of the combo box to my table and the selected value to my view and everything seems to be fine. That just shows how new I am to all this. I thought I would need a class and procedures and I didn't know how to link it all. I was trying to do to much.
Thanks for your input.
I changed the datasource of the combo box to my table and the selected value to my view and everything seems to be fine. That just shows how new I am to all this. I thought I would need a class and procedures and I didn't know how to link it all. I was trying to do to much.
Thanks for your input.
I am trying to do this now but even after reading above I can't get it to work. I want to fill a combobox with a paramaterized sql query. The paramater will be chosen by a different combobox. I've created a query using the combobox and tried a stored procedure... problem is, I dont understand how I set the paramater to the selected value.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
by Mark Wills
Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server... So if you are the accidental DBA, or, simp…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB.
To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
How to fix incompatible JVM issue while installing Eclipse
While installing Eclipse in windows, got one error like above and unable to proceed with the installation.
This video describes how to successfully install Eclipse.
How to solve incompa…
Suggested Courses
Course of the Month7 days, 21 hours left to enroll
715 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.