hello every one again
well this time i am total confuse for this
i have a table tblpay which is having 5 colums
payID
payTransID
payyear
paymonth
totalpay
now i want to show the record based on two columns i.e.:
payyear = 2012
and
payyear = march,april,may,june,july,august,sepetember,october,november,december
and also
wher payyear = 2013
and
paymonth = january,february only
it is as financial year data to be show
currently im using this code to fill DGV:
DataAdapter1 = New OleDbDataAdapter("Select * From " & txttable.Text & " where" _
& "[empID] = '" & lblempID.Text & "' AND" _
& "[pay_year] = '" & txt2011.Text & "' ORDER BY payID", Con)
DataSet1.Clear()
DataAdapter1.Fill(DataSet1, "'" & txttable.Text & "'")
DataAdapter2.Fill(DataSet1, "'" & txttable.Text & "'")
DGVtotalpay.DataSource = DataSet1.Tables(0)
DGVtotalpay.Refresh()
please help me for this i will be very thankfull to you as earlier
please provide me some code which can do this job
thanks in anticipation