Comments by nrgjack (Top 43 by date)

i've added another part if you want to write less code :P

yep you haven't mentioned.
what would you expect ?

Why downvoting without expleaning the reason guys?
That's not the spirit of codeproject...

the problem is that you need to implement IBranchable in 100 class ??
if it is the case, and you are using entity framework you can modify the entity class generator (file .TT) to add ": IBranchable" to the class that have a member with the same name, but it is a bit more complicated than write 100 row..

your question is unclear.
detail more your question and add your code
otherwise it's impossible for us to help you

well i used AjaxControlToolkit in the past that have an autocomplete that works with ASMX webservice in order to load items, otherwise you can check jquery ui autocomplete : http://api.jqueryui.com/autocomplete/

i never used connection pooling in the web.config. i'm reading http://www.codeproject.com/Articles/17768/ADO-NET-Connection-Pooling-at-a-Glance?display=Print right now ...

case when are used in very small table, the very big table is the one used in the [CTE_In]

about indexes yep there are indexes, infact the query is really fast

usually we look for a month report or a day report so normally we have 24 or 30 rows

i'm checking your answer now, thanks,

let me add the stored in the first post (1 minute ^_^)

i tried running profiler while the webapp was in "confuse" state,
in the profile NOTHING appeared about the web calls (about the process of the app), the same Stored executed in sql management studio runned without problem.

it is like something betwheen the call of the Entity framework stored procedure and (but BEFORE) sql was corrupted or in some way full..

yep i have log4net but as i mentioned, it reports only sql timeout errors...

every application is improvable, but in this case the structure is VERY symple,

GRID (jqplot)
Ajax call
Server controller
sql stored procedure
No session , no application, no cookies, etcc.

no hardware fault,
as i said, once the stored procedure is altered everything go well
and i can't imagine hardware fault every 1th of the month ^_^

it is linear, improves on such small code are difficult

Let me check if could be memory issue, but (i didn't metioned) the application worked with 4 gb ram till 2 month ago, and the we asked an upgrade to 32 gb, but our customer that owns the server give us 8 gb,
anyway the problem persosts (maybe 8gb are not enought too)

thanks for your precious reply :)

please explain the part that is unclear

yep i was thinking about that EF+MVC

BUT

i have no experience in MVC so i can't give u hints in that case

well i think that you shouldn't have any problem.

just in case to be sure, try to use the model and the read-write access all within a model project so in case you find performance issue becomes easier to switch to standard sql calls...

performance, well using linqToEntity you have a very little overread, you can ignore it.
i notice some performance issue with the very first call of the day, that sometimes takes over 20 seconds. note only the very first call of the day, i don't know if it is only my issue or not...

that's apart EF is ok for me.

using ORM in general and EF in particular you save a lot of time developing Entities and DAL

in addictioin you can make views or stored proc if you find performance issue for complex query (also because some query are easier in sql than linq..

did you imported ajaxcontroltoolkit css ?

it's faster because you don't need to create every single entity and logic to retreave / manage the data.
note you must create a db structure with the idea that you are going to use EF, it's a bit harder to make an existent db to work with EF in a second time.

about performances i figure out that the very first call to EF in a period (in my case a day) is sometime very slow (20sec). That apart the other calls are ok.

my five to you.

that's the way to have the posted name "linked" to the max posteddate.

yep it is a good option too,
it is more or less like the not-exists also considering performances isn't it?

personally i think the INSERT WHERE NOT EXISTS is a little more readable

once you have a specific data (in my example idField) you can retrieve with db call every kind of data you need.

you can make a method

privat DataTable GetDataForRepeater(int idField)
{
// your DAL logic
return yourData

}

well i think that the regex can be used server side also in windows forms..

take a look here Adding Regular Expression Validation[^]

amazing :) i knew i wasn't too far from the solution ...

the query works great :D thanks :D

yep i googled before posting, i've found a lot of stored/functions like the one posted in stackoverflow, but i need to put this query in join with other stuffs and so mi question was a little more precise,
the group_concat function could be a valid option but i see that is for mysql db and the reference inside the link to see how the group concat have to be made is broken.

anyway thanks for your help :)

thanks :)

thanks for your help too , i appreciated it a lot, i'll study the link you posted :)

well just to understand, every text on buttons, every label every grid header are translated.
so the translation are more or less always the same for every user, but the new ones that i introduce in every "patch/release"
i tried in test environement and it was very easy to make the change, i used the httpcontext.session and now i use httpcontext.application.

i'll test in theese few days but the solution sounds great till now.

i provide an administration page to clear and restore the translation so i can refresh the translation every time i need, that was a thing that scared me about cache.

anyway thanks a lot

thank you, very interesting topics,
i'm worried about updating cache (rarely).
do you think cache would be a better approach event compared to Application object ? why?
thanks
regards

thanks you, application is a good choiche, it is quite easy to switch from session to application (indeed i was using a propertie that get and set value from/to session now i'll try application, thanks ^_^

thanks,

just a question, if i uses the System.IO.Compression..

and i start to upload compressed files .

when a retrieve a generic file is there a way to understand if the stream has been compressed or not ?

i know that i can compress in that way every file that has been uploaded but it's just in theory..


and the last thing compression rate could be compared to the one of winzip/7zip etcc or it is a lot worse ?

i use localization resources too.

it's quite easy to update , mantain and upgrade to new languages too.

it's true that if you start with this tecnique is lot easier than sobstitute every string-label etcc at the end of the work...

heh thanks ^^ i have an override in my solution for the ToString() that's why it was working for me :p

what do you expect by the compare ?

the list of items with a field grater than 1
or a list of items true or false depending on they are greater than 1 or not?

5 reasons 5 stars ;)

could you post the list of element you need ?

example

root
-child0
--child0child0
--child0child1
-child1
--child1child0
--child1child1

otherwise is impossible to say what is your mistake

that's a good point, unfortunately not all companies and bosses are smart enough to put money on tools and developer's training

thanks againg ;)

thanks

i saw Resharper but is a 30day trial, is there anything free?

i founded some tool but there are more general tools and i don't know how they works...

i'm mantaining application written by other, so i don't know which cose is actually obsolete or not..

see that page :)

http://tablesorter.com/docs/#Demo

the sortable method is wrong, you have to use tablesorter


$(document).ready(function () {
$('.buttonToSort').click(function () {
$("#sortable").tablesorter();
$("#sortable").disableSelection();
})
});

but... why disable selection ?
.disableSelection() is useful for making text elements, or elements that contain text, not text-selectable.
is that your intention ?

you'r using multiple version of the same file
jquery.tablesorter.min.js and jquery.tablesorter.js are the same file ;) the "min" version has no spaces, tab, comments so the js file is the smallest as possible

the same for jquery

try using only
<script type="text/javascript" src="js/jquery-1.7.1.min.js"></script>
<script src="js/Sorter/jquery.tablesorter.min.js" type="text/javascript"></script>

about branching statements (if, else, switch)
if you'r checking many times the same variable is better to use the switch.

about loop statements (for, foreach, while, do while)
i prefer using the foreach loop is safier
while and do while statement must have strong exit condition to avoid infinite loops

than you can mix branching and loop statements as you need :)

you have to get the sortable plugin too, here you can download it : http://tablesorter.com/docs/#Download

then you need to add the link in the head like you did for jquery

then you could have a buttom like :

<asp:Button ID="Button1" runat="server" class="buttonToSort" >
$('.buttonToSort').click(function () {
alert("test click");
$("#sortable").sortable();
$("#sortable").disableSelection();
})