Advertisement

06.14.2008 at 02:52PM PDT, ID: 23485552
[x]
Attachment Details

popluate combobox fill gridview from webservice

Asked by designaire in Windows Forms for .Net, Microsoft Visual Basic.Net, Visual Studio .NET 2005

Create a window application to display sales for a selected store using multitier application. Allow the user to select store name from a drop down list.

Use sales and stores from the pubs database. sales table stor_id, ord_num, ord_date, qty, payterms, and title_id columns. Stores table has stor_id, stor_name, stor_address, city, state and zip columns.

Right the combobox is work. The GridView is displaying the id number I have in the sql statement. How do get it to display the results of the combobox?

Any help would be appreciated

Start Free Trial
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
<WebMethod()> Public Function dat(ByVal services As String) As DataSet
        Dim cn As New SqlConnection
        Dim da As SqlDataAdapter
        Dim strSelect As String
        Dim ds As DataSet
        Dim cnstring As String
        cnstring = "Data Source=.\SQLExpress; Initial Catalog=PUBS; Integrated Security=True;"
 
        cn = New SqlConnection(cnstring)
        cn.Open()
 
        'strSelect = "SELECT DISTINCT stores.stor_name, sales.stor_id FROM (stores INNER JOIN sales ON stores.stor_id = sales.stor_id)"
        strSelect = "SELECT * FROM Stores"
 
        da = New SqlDataAdapter(strSelect, cn)
        ds = New DataSet
        da.Fill(ds, "Stores")
        dat = ds
 
    End Function
 
    <WebMethod()> Public Function data(ByVal selected As String) As DataSet
        Dim cnstring As String
        Dim strSelect As String
        Dim ds As DataSet
        Dim da As SqlDataAdapter
 
        cnstring = "Data Source=.\SQLExpress; Initial Catalog=PUBS; Integrated Security=True;"
 
        strSelect = "SELECT stor_id, ord_num, ord_date, qty, payterms, title_id FROM Sales WHERE stor_id=7067"
 
        Dim cn As New SqlConnection(cnstring)
        cn.Open()
        Dim cmd As New SqlCommand(strSelect, cn)
 
        da = New SqlDataAdapter(strSelect, cn)
        ds = New DataSet
 
        da.Fill(ds, "Sales")
        Return ds
 
    End Function
 
 
 
Public Class Form1
    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Dim combo As New localhost.Service()
        ComboBox1.DataSource = combo.dat.Tables(0)
        ComboBox1.DisplayMember = "stor_name"
        ComboBox1.ValueMember = "stor_id"
 
    End Sub
 
    Public Sub ComboBox1_SelectedIndexChanged(ByVal test As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged
 
        Dim combo1 As New localhost.Service()
        DataGridView1.DataSource = combo1.data
    End Sub
End Class
[+][-]06.15.2008 at 08:51AM PDT, ID: 21788898

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.15.2008 at 11:06AM PDT, ID: 21789204

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.15.2008 at 11:37AM PDT, ID: 21789296

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.16.2008 at 01:17AM PDT, ID: 21791599

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Windows Forms for .Net, Microsoft Visual Basic.Net, Visual Studio .NET 2005
Sign Up Now!
Solution Provided By: PockyMaster
Participating Experts: 1
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628