[metador]

hello all,

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 + ";";

[FlashM]

each salary record should have information about when it was inserted... then before update-ing it, check the date value... if it's in the same month => don't allow to update it...

Why are you even updating same salary record... you really should have new salary record for each employee each month... You need to keep track of employee salaries...

best regards

[metador]

Thanks for help.I got first point.
actually employee salaries are not fixed for each month.So manually enter each month.
And kindly give me one more help that when i change date from datetimepicker suppose select last month any date then how that month salary should display in salary textbox means after calling this event

private void dateTimePicker1_ValueChanged_1(object sender, EventArgs e)

FlashM, on 13 July 2011 - 06:47 AM, said:

each salary record should have information about when it was inserted... then before update-ing it, check the date value... if it's in the same month => don't allow to update it...

Why are you even updating same salary record... you really should have new salary record for each employee each month... You need to keep track of employee salaries...

best regards