Hi,
I want help in displaying record of same challan no. into one textbox.
I have feilds like challan no,sendqty,availableqty,balqty.
if i fill one record of challan no 1, availableqty=1000,sendqty=500,balqty=500.
next time when i am fill record of same challan no then i want availableqty=500 in textbox.
I am using following code:-
str = "select description,balqty,balcartons,yarn_recchno,max(o_id) from quazatoknitting where yarn_recchno='" & UCase(txtyrecchno.Text) & "'group by yarn_recchno,balqty,balcartons,description"
Dim da As SqlDataAdapter = New SqlDataAdapter(str, objconnection)
Dim ds As New DataSet
da.Fill(ds, "quazatoknitting")
If ds.Tables("quazatoknitting").Rows.Count > 0 Then
Dim dv As New DataView
dv = New DataView(ds.Tables("quazatoknitting"))
Dim cm As CurrencyManager
cm = CType(Me.BindingContext(dv), CurrencyManager)
lbltotcartons.DataBindings.Add("text", dv, "balcartons")
lbltotqty.DataBindings.Add("text", dv, "balqty")
txtdesc.DataBindings.Add("text", dv, "description")
txtdesc.ReadOnly = True
txtchallanno.Focus()
lbltotcartons.DataBindings.Clear()
lbltotqty.DataBindings.Clear()
txtdesc.DataBindings.Clear()
End If
Prasad.