It's possible to achieve that using Linq To Dataset[^]. Assuming that you did Load[^] data into DataTable object via using SqlReader[^]: var result = dt.AsEnumerable() .GroupBy(a=>a.Field("ID")) .Select(g=>new { Id = g.Key, Count = g.Count() }) .ToList(); Returns a list of Id's with the number of occurences. For further information, please see: Programming Guide (LINQ to DataSet)[^] Queries in LINQ to DataSet[^] Querying DataSets (LINQ to DataSet)[^] LINQ to DataSet Examples[^]

I am not sure what you are trying to do, but shouldn't your if condition be reversed? i.e. it "HasData" if complexQuery > 0 and it's "Blank" if complextQuery == 0. Try this: if (complexQuery != 0) // <-- reverse the condition here { var newQuery = "HasData"; entity.Attributes.Add("new_testcomplexquery", newQuery); } else { var newQueryToo = "Blank"; entity.Attributes.Add("new_testcomplexquery", newQueryToo); } You have just been Sharapova'd.

Thanks for your reply jkirkerk it was very helpful

That really is like asking "how long is a piece of string?" :-D Only you will know if you can actually achieve this timeline. Some observations from my own experiences though Step 1 - if you get "awkward" stakeholders this step could well take longer than 4 days (actual time spent or elapsed!) Step 2 - seems a little long as you appear to already have an idea of the tables required - if you're including all of the admin hoops to jump through with DBA's or other control mechanisms I would make it clear in the estimate Step 14 - seems a bit light, but some of the builds do seem a bit long. Step 15 - see my earlier comments about stakeholders! I've never run UAT in less than 3 days (and even that was a struggle) If this timeline is going out to the stakeholders double everything and make it clear whether or not this is a "working days elapsed" timeline or a "working hours spent" Under promise and over deliver ;)

How many people will use the front-end, and are they located in the same office? Will all your users be working on computers within a single LAN, or are they working from locations that are geographically distributed? How much control do you have over your users' deployment environment? A Microsoft Access front-end is almost certain to be the simplest and fastest solution to implement, but it comes with some limitations that are important to consider. I generally prefer ASP.NET because then the UI is accessible to anyone with a web browser. This makes the application easier to distribute and update - but it is likely to be more difficult and more time-consuming to implement.

macca24 wrote: Anyone know if this can be achieved? Quite simple really. In your button click code, pass the textbox value to a stored procedure. In that stored procedure, update all the records. Then refresh the grid. There are only 10 types of people in the world, those who understand binary and those who don't.

You can use the SSRS Report Viewer control and create SSRS Reports. You can also do Crystal Reports. I believe those are probably the 2 most common report engines used with ASP.Net. There are only 10 types of people in the world, those who understand binary and those who don't.

Put an onchange event on each textbox that calls a JS function. In the function, check if all 3 textboxes have numbers in them. If so, add them and put the result into the 4th textbox. There are only 10 types of people in the world, those who understand binary and those who don't.

macca24 wrote: Anyone any ideas on best way to do this? In the button click, call a stored procedure that does the calculation and updates the data and then refresh your grid. There are only 10 types of people in the world, those who understand binary and those who don't.

You could also use SSIS or even create a job to do the work and schedule it in SQL. There are only 10 types of people in the world, those who understand binary and those who don't.

Then as I suggested - do the query.

Try by splitting the decimal value in 2 strings and passing with concatenation, don't forget to add "." in between. If DBMS is SQL Server 2005, it will work...the problem is due to different ways .NET and SQL Server 2005 stores the decimal value. HTH Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks.

Check out http://itextsharp.sourceforge.net/[^] Vasudevan Deepak Kumar Personal Homepage Tech Gossips A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

Sure it can be a mess... but in case you want to retrieve the username of whoever is using your app in the other side, I believe a simple My.User.Name in the codebehind may work. Kazz "Users are there to click on things, not think. Let the archs do the damn thinking."

first check txt1 means the textbox having Date Value. if txt1.text="" then in query pass null keyword for that Date Field. i.e. here abc is the table with 2 columns frmdt(Date)& name(Text) insert into abc values(null,'"& txt2.text &"')

Do you control the web-server? Could the site be being cached by a content acceleration server? If you re-name the folder on the website and can still hit the website then there is something wrong :). I would double check IIS to make sure it's pointing at the right location. If it is, then create a test HTML page in the root and try to access if from the site. If you can see it you know the website is working. Then update that file and see if you can see the updates. If you can then I agree, it must be something you're doing with the release of the new code. Thanks, Adrian

yes, they are correct.

clear the internet temprory fiels and cookies.