Click here to Skip to main content
15,877,246 members

Comments by tanugarg (Top 32 by date)

tanugarg 5-Dec-14 1:25am View    
token no
1
2
3
4
5
.
.
.
.
200
this is automatic generated no in dec 2014
i want to generate a token no from sr.no 1 in jan 2015
tanugarg 12-Aug-14 5:05am View    
myconn.Open()
b = "DH"
da2 = New SqlDataAdapter("Select token_no from billentry where status = '" + b + "' and billdate=convert(datetime,'" & DateTimePicker2.Text & "',103)", myconn)
dt2 = New DataTable()
da2.Fill(dt2)
ComboBox1.DataSource = dt2
ComboBox1.DisplayMember = "token_no"
ComboBox1.ValueMember = "token_no"
If ComboBox1.SelectedIndex = -1 Then
MessageBox.Show("No Bill For Passing!")
End If

myconn.Close()
tanugarg 30-Jul-14 2:57am View    
table is same not diffrent
tanugarg 30-Jul-14 2:51am View    
i have two columns mode_pay and status_mode, mode_pay is having values and status_mode is null so i want to retrieve data from both columns like Select token_no from billentry where mode_pay= 'cash' and status_mode= 'null'
tanugarg 4-Jul-14 3:27am View    
how to count rows please explain by code