protected void gvTimeSheet_DataBound(object sender, EventArgs e) { DataTable dt = new DataTable(); int intUserID = TypeConvert.IsNullInt32(ddlUsers.SelectedValue, 0); DateTime fromDate = Convert.ToDateTime(UCFromDate.selectedDate); DateTime toDate = Convert.ToDateTime(UCToDate.selectedDate); string strQuery = "EXEC SPRptUserTimeSheet_AP @User=" + intUserID + ",@dateFrom='" + fromDate + "',@dateTo='" + toDate + "'"; dt = DataHelper.ExecuteQuery(strQuery); dt.Columns.Add("Booked Hrs"); dt.Columns.Add("Time Zone"); foreach (DataRow row in dt.Rows) { string userName = row[0].ToString(); string bookedHr = row[6].ToString(); string timezone = row[7].ToString(); if (userName == string.Empty) { row[0] = ddlUsers.SelectedItem.Text; } if (bookedHr == string.Empty) { row["Booked Hrs"] = 0.0; } if (bookedHr != string.Empty) { row["Booked Hrs"] = objCommon.fnGetEffortInHrMinFormat(Convert.ToInt32(bookedHr)); } if (timezone == "0") { row["Time Zone"] = "Offshore"; } if (timezone == "1") { row["Time Zone"] = "Onsite"; } } ViewState["dtExport"] = dt; } } What I have tried: protected void gvTimeSheet_DataBound(object sender, EventArgs e) { DataTable dt = new DataTable(); int intUserID = TypeConvert.IsNullInt32(ddlUsers.SelectedValue, 0); DateTime fromDate = Convert.ToDateTime(UCFromDate.selectedDate); DateTime toDate = Convert.ToDateTime(UCToDate.selectedDate); string strQuery = "EXEC SPRptUserTimeSheet_AP @User=" + intUserID + ",@dateFrom='" + fromDate + "',@dateTo='" + toDate + "'"; dt = DataHelper.ExecuteQuery(strQuery); dt.Columns.Add("Booked Hrs"); dt.Columns.Add("Time Zone"); foreach (DataRow row in dt.Rows) { string userName = row[0].ToString(); string bookedHr = row[6].ToString(); string timezone = row[7].ToString(); if (userName == string.Empty) { row[0] = ddlUsers.SelectedItem.Text; } if (bookedHr == string.Empty) { row["Booked Hrs"] = 0.0; } if (bookedHr != string.Empty) { row["Booked Hrs"] = objCommon.fnGetEffortInHrMinFormat(Convert.ToInt32(bookedHr)); } if (timezone == "0") { row["Time Zone"] = "Offshore"; } if (timezone == "1") { row["Time Zone"] = "Onsite"; } } ViewState["dtExport"] = dt; } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)