Data with where clause and order by clause relational database

  • Thread starter Thread starter muhammadanzar
  • Start date Start date
M

muhammadanzar

Guest
SQL SERVER

Database k1

Table: Customer

pk-CID | C-Name

1 | anzar

2 | Orva

3 | Anzar

4 | Anzar

5 | Jawad

Table 2 Sales

pk-Sid | C-Name | ProductPrice | unitprice

1 | Anzar | Z | 50

2 | Anzar | Z | 90

3 | Orva | Z | 10

4 | jawad | p | 50

5 | Anzar | Z | 20

My Requirement

I want the last unit price of product which is given to anzar

Vb.net Coding problem

Dim adapter As New SqlDataAdapter("SELECT dbo.sales.UnitPrice FROM dbo.sales INNER JOIN dbo.customer ON dbo.sales.CustomerCode = dbo.customer.CustomerCode WHERE dbo.customer.CustomerName =???? ? ORDER BY dbo.sales.Invoice DESC", connection)

Dim table As New DataTable()
adapter.Fill(table)



MUHAMMAD ANZAR E-mail : muhammadanzar@hotmail.com Mobile # :0092-3215096959

Continue reading...
 
Back
Top