Search results for query: *

Hi, I’ve been searching for days and cannot find a solution. I have a RDLC sub report (VS2010) which Works fine in the environment/local mode, also works fine when I deploy to our Development server. However, when I deploy to the Production server, I get the following error. The subreport...

Hi, I need help extracting the month from my date column. The date is returned in this format 2012-07-06. what I would like to do is filter the date based on the month only so return all the data for July etc. This is what I have string value =...

Hi Jason, Thanks for your feedback. But the code above is just sample code and not the actual code i'm using as i never ever hard code paths as like you mentioned it will cause problems when deploying the project. Thank you so much for your help

I have this code now and the logger is fine but using override i 'get cannot override because 'System.Web.UI.Control.Load' is not a function' public static class Logger { public static void Log(string message) { File.AppendAllText("C:\\MyLogFile.txt"...

Thanks Jason, I seem to be having problems with the code in my ui code this line is giving me problems ----base.Load(e); Logger.Error-- Logger is not recognized my code added is below protected void Page_Load(object sender, EventArgs e) { if...

Hi, I'm using asp.net and I have my try catch is in a class in my DAL which returns a datatable to my user control. If my datatable does not get returned and an error is thrown in my try catch, what i need to happen is display the error message inside that particular user control instead...

I have written the sql that brings back the correct data,is it possible for this query to be converted to linq select d.departmentId,round(cast(sum(score)as decimal(10,2))/(SELECT sum(score) FROM table),2) From table t --joins etc GROUP BY departmentId

Hi, I need to get the sum of employees scores for each department using linq. I only need scores from departments that have more than 20 employees but not sure Where to put the Where clause also not sure if the query below is correct var departmentquery = from row in dt.AsEnumerable()...

Found the mistake it should be yyyy instead of YYYY

I tried Convert.ToDateTime(DateTime.Now.ToString("dd/MM/YYYY") + " " + Session[ID].ToString().Substring(0,2) + ":" + Session[ID].ToString().Substring(2,2)); and got The string was not recognized as a valid DateTime. There is an unknown word starting at index 6

Thanks mstrmage1768 I have managed to convert from a date to a string using (HHmm) the problem is converting back as i need the time to be displayed again but using { ID = ((RadTimePicker)cntrl).ID; if (Session[ID] != null) ((RadTimePicker)cntrl).SelectedDate...

Hi, I have a datetime issue At the moment I get a time value as '16/09/2010 06:00:00' but in my database the time value is 600. Is there anyway I can convert the datetime in my application to be passed to the database as 600 which is 6 am or can i take care of the problem at the backend. I'm...

Hi, Using the code below can someone please show me how to cache my query below. var query = from row in dt.AsEnumerable() group row by row["name"] into grp let totalcount = dt.AsEnumerable().Count()...

It's ok guys I manged to work it out I will let you know if i have any other problems with the method i intend to use.

Hi, I have a method that returns a datatable and fills a grid. At the moment I do a round trip the database 3 times to get the same data that the fills the grid to do some calculations to fill some charts. Can someone please tell me how I can avoid going back to the database and reusing...

Thanks for the reply Not sure if is this is the best way but the code below is what I have done and it returns a data set. Before I was adding a data table to my control using uc.DataSource = GetMyDATA().Data; but this does not allow me to add a dataset. How do I pass the dataset to the...

Hi, I’m using the code below to get a datatable. I need to get 2 datatables using this method and I want to end up with one dataset. Can someone please tell me the best way to this. As I’m basically repeating the code below to and changing the stored procedure. Thanks DataTable...

I have sorted the problem by adding values = values.TrimEnd(',');

I used the code below but i get 2,3, but i need 2,3 [code] else if (cntrl.GetType() == typeof(CheckBoxList)) { if (!string.IsNullOrEmpty(((CheckBoxList)cntrl).Text)) { id = ((CheckBoxList)cntrl).ID...

Thanks Jason,