(25-06-20, 05:57 PM)Jounior_P كتب : اجعل جملة Select ;hgjhgd :
select * from Items where Quantity <=5

بفرض ان جدول الاصناف اسمه Item والكمية Quantity

(25-06-20, 05:56 PM)Rabeea Qbaha كتب :

كود :

   Public Sub LoadMaterials()
       If _con.con.State = ConnectionState.Closed Then
           _con.con.Open()
       End If

       Dim cmd As New SqlCommand("SELECT MaterialBarCode,category,MaterialName,unit,QuantityAvailable FROM Materials_view where QuantityAvailable <=@QuantityAvailable order by QuantityAvailable", _con.con)
       cmd.Parameters.AddWithValue("@QuantityAvailable", cmb_qun.SelectedItem)

       Ds = New DataSet()
       Dt = New DataTable()

       DataAdapter = New SqlDataAdapter(cmd)
       DataAdapter.Fill(Dt)
       DataAdapter.Fill(Ds, "Materials_view")

       _con.con.Close()

       GV.DataSource = Ds
       GV.DataMember = "Materials_view"
       GV.Refresh()
   End Sub