Comments by Harsha24 (Top 37 by date)

("INSERT INTO SalHikes(Empid,Hike,Date) values('"+ EmpId +"','"+ Convert.ToDecimal(dt.Rows[i][j].ToString()) - maxSal +"','"+ dt.Columns[j].ColumnName +"'")...

Getting error at converting process..

where should i use this??

yes..but here i need to do row wise distinct and show that ..how??

ty rk..it works.. now how to do this with hikes..i want to carry hike date and hike salary to a new table and show it in a gridview in .aspx page

it is showing error at comparing i.e., maxSal < dt.Rows[i][j] as invalid arguments

on the process.. will update u as soon as i am done..

my boss will insert the excel using an upload button from the .aspx page.. and now i want to fetch the records from the db as per the id given in the .aspx page

I have created an .aspx page which is used to upload the excel file and submit it into the database..I have written the back end code to do so for the button click..Now the data is saving in sql table..but now how to get the values according to the requirement is where i am struck..

thanks for the reply prabakr.. but the thing is like i don't have a column called salary and all the data is saved as a row to the empid..

To clearly tel u.. it is inserted from a excel sheet..

where the columns will be as empid,dept,desg,Jan-11,Feb-11.Mar-11

and so on it continues.. an I have that of 3 years data.. from that i want to know what is the max salary of an individual employee and know the date and hike salary if any hikes are there to that particular employee..

yup.. i need it from the code behind

sry..i did it in a hurry..it is updated now.. thanks for the info rohan

thanks for the reply.. can we do it using JavaScript.. bcoz i'm working with google spread sheet and i think vba doesn't support der..can u make it in googleapps script

yup even that is ok for me..like opening a page where there is no toolbar

yup.. thanks for the info.. could u pls help me on this..

i was successful in inserting a new row for single record..
But i want to loop it to all the records in the table

its good..what abt using the condition

this is like Task Reminder..
So i need to insert a new row when ReminderDate is reached Today's Date. I am getting this. but it is dng for only one record. i want it to check all d rows in the gridview..

Also important thing is that it should run only once in a day.. so i am writing this as static method in global.asax page. using thread

kk. tel me how it is to be done..

Also let me know where to write this code

i got u.. but where do we need to write dis code..

thanks for the post. could u pls explain in detail

I have a table that has columns as UserID,TaskID,ReminderDate,Task,TaskType,TaskStatus.

Here TaskType is Daily,Weekly,Monthly,Yearly,Today,None.

Now i need to insert a new row in the table as per a condition (when the date in the Reminder Date matches with today's Date).

This should run only once in a day. And the inserted row values should be same(except TaskID, as taskid is set to increment by '1') as the before row but the Reminder Date should be changed(as per the TaskType selected).

i want to insert a new row in the same table itself with new reminder date according to the TaskType.

Thanks for the info. can u replace those with the actual details.(UserID and Session["UserAuthentication"].ToString())

lol.. i'm having practise on diff. concepts.. this is one among them.. @ aspnet_regiis -i

i have no idea how to write the code for this..@ Original Griff

when the form opens for the first time all the data will be displayed.this i have done.
Now i need to fetch the data based on the selection from checked list box1.

Here I am developing an windows application which stores the intime and outtime of an employee using Employee Id. status is used to know whether employeee is IN or OUT.
I have done all this stuff.
Now i need to send an email which carries the details where status is equal to IN. and this process should be done for evrey 30 min.

Also i need to calculate the differene between Outtime and intime that is total working hours.

it's working great.. thanks & cheers Ol

got it..thank you very much.. How to erase the name when the id is erased?????

thank you for the post.. Using the timer is ok. But how about fetching the records from database and send them as an attachment basing on the condition where status = "in".