i have a little problem in my salary table that there is a form having datetimepicker and salary textbox and empCombobox. When emp is selected from combobox then its record display in datetimepicker and salry textbox.know i want that only once a month record should be inserted i mean to retrict through datetimepicker that if month change then allow to enter next month salary.
e.g i entered salary 200 in salary textbox
datetimepicker.value = 7/14/2011
after that this record of emp should be only updated til this month(7) when month(8) starts then next month salary should be inserted.
so plz guide me . i uses Like '%.... %' but its not working
"SELECT * FROM Salary WHERE EmployeeID =" +cmbSelectEmpolyee.SelectedValue + ";";