Comments by Member 11698441 (Top 25 by date)

No i tried and its not working.

Yes I used tempdata in controller.

yes i wanna know how to enter data through vector and map

i want output like total time of working hours for a individual employee instance and it should be above 9 hrs if less wanna know how much he is deficit this to be done fr each day

ill say the colums fr u id,card_id, time_out,time_in,transaction_date, update_date,update_user, employeeinstance

502 NULL 2013-12-01 08:00:00.000 2013-12-01 13:00:00.000 2013-12-01 00:00:00.000 NULL NULL 244
514 NULL 2013-12-16 08:00:00.000 2013-12-16 18:00:00.000 2013-12-16 00:00:00.000 NULL NULL 326
516 NULL 2013-12-05 09:00:00.000 2013-12-05 19:00:00.000 2013-12-05 00:00:00.000 NULL NULL 256
517 NULL 2013-12-06 07:00:00.000 2013-12-06 17:00:00.000 2013-12-06 00:00:00.000 NULL NULL 256
520 NULL 2013-12-09 09:00:00.000 2013-12-09 19:00:00.000 2013-12-09 00:00:00.000 NULL NULL 326
521 NULL 2013-12-10 08:30:00.000 2013-12-10 18:00:00.000 2013-12-10 00:00:00.000 NULL NULL 326
525 NULL 2013-12-17 07:50:00.000 2013-12-17 18:07:00.000 2013-12-17 00:00:00.000 NULL NULL 244
526 NULL 2013-12-18 08:18:00.000 2013-12-18 19:07:00.000 2013-12-18 00:00:00.000 NULL NULL 244
527 NULL 2013-12-19 09:00:00.000 2013-12-19 20:00:00.000 2013-12-19 00:00:00.000 NULL NULL 244
529 NULL 2013-12-04 08:00:00.000 2013-12-04 18:00:00.000 2013-12-04 00:00:00.000 NULL NULL 262
530 NULL 2013-12-05 08:30:00.000 2013-12-05 17:30:00.000 2013-12-05 00:00:00.000 NULL NULL 262
532 NULL 2013-11-05 08:00:00.000 2013-11-05 18:00:00.000 2013-11-05 00:00:00.000 NULL NULL 262

ok fine i'll say to u in a detailed manner... there is a list of datas in table with employeeinstance,date, in time and outime i wanna find the total working hours of each employee and also should find the break hours he took and also should check the condition whether he has worked for 9 hrs or not. if he worked less hw much hours he is deficit by this is my situation

there are multiple dates and i have to select for individual date

the problem is like per day there may be multiple entrys and out i wanna group it and add everything per day

no while hardcoding the date its given but how to give fr column in table wer to giv FROM<tablename>

Thanks man i got it :)

protected void GridView2_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Label lblupdateid = (Label)GridView2.Rows[e.RowIndex].FindControl("slnoLabel");
DropDownList DropDown = (DropDownList)GridView2.Rows[e.RowIndex].FindControl("DropDownList1");
DropDownList drp = (DropDownList)sender;
GridViewRow gv = (GridViewRow)drp.NamingContainer;
DropDownList lstuserName = (DropDownList)gv.FindControl("DropDownList1");
Response.Write("Selected Value : " + lstuserName.SelectedValue + " " + "Selected Item : " + lstuserName.SelectedItem.Text);
string query = "update leaveforum set status1='" + lstuserName.SelectedItem.Text + "' where sl_no ='" + lblupdateid.ToString() + "'";
GridView2.EditIndex = -1;
conn.Open();
//SqlCommand cmd = new SqlCommand("SELECT * FROM webdesign", conn);
SqlCommand cmd = new SqlCommand(query, conn);
cmd.ExecuteNonQuery();
conn.Close();
gvbind1();
// GridView2.DataBind();
}

i could get the selected value of dropdown inside this function but fr loading into gridview its not getting the index of the row number inside this function in the same way in inside gridview i could get index but dropdown is not working

yes

ohhhh ok gt it will i be able to use protected void DropDownList1_SelectedIndexChanged(object sender, GridViewUpdateEventArgs e)

yes exactly is it possible?

Dropdown list is inside the gridview i changed it to protected void GridView2_RowUpdating(object sender, GridViewUpdateEventArgs e)

my requirement is like its a leave forum and its entered into db by one user and another user accepts it so a drop down is placed in grid now i want this selected text from dropdown to be posted in the db

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
Label lblupdateid = (Label)GridView2.Rows[e.RowIndex].FindControl("slnoLabel");
DropDownList drp = (DropDownList)sender;
GridViewRow gv = (GridViewRow)drp.NamingContainer;
DropDownList lstuserName = (DropDownList)gv.FindControl("DropDownList1");
Response.Write("Selected Value : " + lstuserName.SelectedValue + " " + "Selected Item : " + lstuserName.SelectedItem.Text);
string query = "update leaveforum set status1=" + lstuserName.SelectedItem.Text where SL_No =" + lblupdateid.Text;
GridView2.EditIndex = -1;
conn.Open();
SqlCommand cmd = new SqlCommand(query, conn);
cmd.ExecuteNonQuery();
conn.Close();
gvbind1();
}
this is drop down table should i give like this but its throwing errror at e.RowIndex and it couldnt seperate as string query = "update leaveforum set status1=" + lstuserName.SelectedItem.Text where SL_No =" + lblupdateid.Text;

Thanks, May i know the function where this C# code to be added?