Click here to Skip to main content

Comments by Mika Wendelius (Top 200 by date)

Mika Wendelius at 8-Aug-14 13:07pm View
   
Glad it helped :)
Mika Wendelius at 2-Aug-14 1:03am View
   
The example in the documentation shows how to swap the first and the last columns. The same way you can define the position of any column.
Mika Wendelius at 1-Aug-14 11:42am View
   
Typically Sql Server is not included in a client setup. Instead it is installed centrally on a database server. However, if your application is designed to use standalone, single user database then it would make sense to include Sql Server in the installation. For example using LocalDB, see http://msdn.microsoft.com/en-us/library/hh272703(v=vs.103).aspx[^]
Mika Wendelius at 1-Aug-14 11:34am View
   
:) Thanks
Mika Wendelius at 1-Aug-14 9:11am View
   
Easier than what? What kind of record you have in mind?
Mika Wendelius at 1-Aug-14 8:57am View
   
As said, you can use SSMS and right click on an existing connection to see the latest SQL
Mika Wendelius at 1-Aug-14 8:45am View
   
The question isn't quite clear. You mean each cell has multiple values? Can you post an example of the data and an example what you would like to achieve.
Mika Wendelius at 24-Jul-14 7:58am View
   
Now I wonder if you're trying to remove the files from application consoleapplication1. If that is the case, then it doesn't make sense if you try to remove the executable you're running...
Mika Wendelius at 24-Jul-14 7:54am View
   
Without proper information, I'm afraid noone can help you to correct the code.
 
What you should do is to describe the whole problem, post all relevant code parts and preferrably explain what you're stuck at.
Mika Wendelius at 22-Jul-14 3:34am View
   
You're welcome :)
Mika Wendelius at 2-Jul-14 4:01am View
   
May be obvious, but what is ubr format? Any references?
Mika Wendelius at 2-Jul-14 3:58am View
   
Sounds like homework, what have you done so far?
Mika Wendelius at 5-Apr-14 4:24am View
   
When using dynamic SQL you have to concatenate the columns from the variables to the statement. For example:
...
SET @From_Value="CAST(" + @VarContainingColName + " AS VARCHAR(50))"
...
Mika Wendelius at 2-Mar-14 10:31am View
   
Reason for my vote of 5 \n Nicely explained!
Mika Wendelius at 28-Jan-14 5:40am View
   
Have you tried running the same insert for example using Slq Server Management Studio. Based on the error it looks like your SQL statement is invalid or one of the values is in wrong format.
Mika Wendelius at 14-Dec-13 14:24pm View
   
You're welcome
Mika Wendelius at 29-Sep-13 11:18am View
   
Glad it helped :)
Mika Wendelius at 29-Sep-13 9:25am View
   
You're welcome :)
Mika Wendelius at 29-Sep-13 9:14am View
   
So if I understood correctly, you worry about 'duplicate' references when the reference is both ways? For example:
studentid preferencestudentid
1 2
1 3
1 4
2 1
2 3
2 4
 
Is this something you want to avoid? If so, you could create a trigger on the table to check if such preference already exists but in opposite way. Also a unique constraint would take care that the sae preference cannot be added twice.
Mika Wendelius at 29-Sep-13 7:55am View
   
What are you stuck in?
Mika Wendelius at 16-Sep-13 8:05am View
   
Thanks Maciej, nice to see you too :)
Mika Wendelius at 16-Sep-13 8:04am View
   
I still didn't quite understand the goal in overall, but perhaps the following link would help you towards building dynamic statements Using Dynamic SQL in Stored Procedures[^]
Mika Wendelius at 16-Sep-13 5:10am View
   
Could you post a small example what kind of variations you're trying to achieve.
Mika Wendelius at 11-Sep-13 12:15pm View
   
Nice answer!
Mika Wendelius at 8-Sep-13 3:44am View
   
Yes, it looks like the article has been deleted but I can still see the content, quite odd... However, did you check the links in solution 2? those mainly seem to work fine.
Mika Wendelius at 7-Sep-13 14:01pm View
   
What was deleted? The article behind the link? Just checked and it seems to open just fine :)
Mika Wendelius at 19-Aug-13 15:05pm View
   
Sorry, I totally misread the title. This applies only to Sql Server.
Mika Wendelius at 22-Jan-13 13:38pm View
   
Have you tried running the statement in SSMS?
Mika Wendelius at 13-Jan-13 10:18am View
   
You're welcome :)
Mika Wendelius at 12-Jan-13 10:57am View
   
You're welcome :)
Mika Wendelius at 12-Jan-13 6:53am View
   
You're welcome :)
Mika Wendelius at 12-Jan-13 6:00am View
   
Where do show the rows? in grid, combobox etc. Also what technology you use ASP.NET, WPF, Forms...
Mika Wendelius at 12-Jan-13 5:49am View
   
There's no direct equivalent for ROWTYPE in Sql Server. One way is to declare a table type variable, see DECLARE[^] or to list the columns and fetch the values into separate variables.
Mika Wendelius at 12-Jan-13 5:46am View
   
IMO those three along with DevExpress are the most used control packages so have a look at them :)
Mika Wendelius at 12-Jan-13 4:19am View
   
You're welcome :)
Mika Wendelius at 12-Jan-13 4:01am View
   
Have you tried debugging the code? When a valid user is entered, do you have 1 row in your data table?
Mika Wendelius at 12-Jan-13 2:55am View
   
Thanks :)
Mika Wendelius at 12-Jan-13 2:54am View
   
Thanks :)
Mika Wendelius at 12-Jan-13 2:53am View
   
Using a temp table is a good option, 5.
Mika Wendelius at 12-Jan-13 2:53am View
   
Fully agree.
Mika Wendelius at 12-Jan-13 2:44am View
   
If I understood correctly, I'd suggest that you put a date field to the table where you record the student login which defines when the user has last logged in and a date field to the question which defines when the question is added.
 
Using these two dates you can select the records which have been added after the last login of the student.
Mika Wendelius at 11-Jan-13 16:26pm View
   
If you mean replacing the null values, I'd personally use COALESCE which is similar in several database products since it's part of the SQL standard.
Mika Wendelius at 11-Jan-13 16:08pm View
   
I'd suggest you post the code you have so far.
Mika Wendelius at 11-Jan-13 16:07pm View
   
Yes, I can see that, but I don't quite understand your comment. Using the data reader has no effect on how parameters should be used or how COALESCE works???
Mika Wendelius at 11-Jan-13 16:04pm View
   
Nice answer!
Mika Wendelius at 11-Jan-13 15:21pm View
   
So do you want to query from those tables in your procedure and return the data or do you want to send the data as parameters and then insert into the tables inside the procedure????
Mika Wendelius at 11-Jan-13 15:16pm View
   
Thanks :)
Mika Wendelius at 11-Jan-13 15:15pm View
   
Can you write a small example of the data and the desired output?
Mika Wendelius at 11-Jan-13 15:11pm View
   
What is the exact problem you're having? Is it something like where to write the code or is it about the logic how correct answers are checked or stored or what?
 
Also, please tag the technologies you use, ASP.Net?
Mika Wendelius at 11-Jan-13 15:08pm View
   
I would say this can be done in multiple ways...
 
To get the first occurrence of a character like -, have a look at IndexOf[^]
Mika Wendelius at 11-Jan-13 15:03pm View
   
Thanks :)
Mika Wendelius at 11-Jan-13 15:00pm View
   
Based on the description, do you really need an inherited control for this? Why not just set the links on each linklabel and then register the same eventhandler for all linklabels. See the updated answer.
Mika Wendelius at 11-Jan-13 14:47pm View
   
Very true.
Mika Wendelius at 11-Jan-13 14:45pm View
   
It's quite hard to answer without knowing anything more about your needs. Few links you could visit:
- Intermediate C++ [^]
- More C++ Idioms[^]
Mika Wendelius at 11-Jan-13 13:59pm View
   
You're welcome :)
Mika Wendelius at 11-Jan-13 13:52pm View
   
Are you sure that the exception is really fired in the int declaration? The following lines are much more potential.
Mika Wendelius at 11-Jan-13 13:22pm View
   
Good answer, 5.
Mika Wendelius at 11-Jan-13 13:21pm View
   
That would work fine in case of the date field, 5+
Mika Wendelius at 11-Jan-13 13:20pm View
   
Thanks :)
Mika Wendelius at 11-Jan-13 13:20pm View
   
Thanks :-D
Mika Wendelius at 11-Jan-13 13:20pm View
   
Thanks Maciej :)
Mika Wendelius at 11-Jan-13 13:19pm View
   
You're welcome :)
Mika Wendelius at 11-Jan-13 13:06pm View
   
If you're using SSIS that way, could you simply try:
string rev = string.Concat(text.Reverse().ToArray());
 
Don't forget to define
 
using System.Linq;
Mika Wendelius at 11-Jan-13 12:51pm View
   
Thanks Marcus :)
Mika Wendelius at 11-Jan-13 11:59am View
   
Can you post the content of the script task.
Mika Wendelius at 11-Jan-13 11:56am View
   
So very true, my 5.
Mika Wendelius at 11-Jan-13 11:42am View
   
Thanks :)
Mika Wendelius at 11-Jan-13 1:38am View
   
Thanks :)
Mika Wendelius at 11-Jan-13 1:38am View
   
You're welcome :)
Mika Wendelius at 11-Jan-13 1:25am View
   
Good link, 5'ed
 
Few other things, first of all congrats to the MVP status! Also Sandeep noted me that Chris has asked us not to modify spam mails in any way, just report them. I think they have a good plan of applying new kind of filter...
Mika Wendelius at 11-Jan-13 1:20am View
   
You're welcome :)
 
One more thing, since you're using multiple statements which logically require a single unit of work, don't forget to use transactions. See MySqlTransaction[^]
Mika Wendelius at 11-Jan-13 0:59am View
   
The question is a bit unclear. Can you edit the question and post the relevant code fragments.
Mika Wendelius at 11-Jan-13 0:50am View
   
So can you simply execute an UPDATE statement inside the if? Something like UPDATE Table2 SET Status = @NewStatus.
 
Note that I have used a parameter in the statement. You should never concatenate values to a Sql statement. This would leave you open to Sql injections, data type conversion problems and so on.
 
Have a look at the modified answer.
Mika Wendelius at 11-Jan-13 0:29am View
   
Thanks Sandeep :)
 
Oh, that's good to know; Will just flag them :)
Mika Wendelius at 10-Jan-13 2:31am View
   
Entity framework is ADO.Net based so it's the same thing. The approach to be used is based on your way to work, do you first create the database and then the code etc.
 
The working style is quite similar. However, EF has lots of more capabilities for example regarding to navigation using foreign keys etc.
 
So basically yes, you're quite correct :)
Mika Wendelius at 10-Jan-13 2:20am View
   
You're welcome
Mika Wendelius at 10-Jan-13 0:56am View
   
This is part of the update statement you posted, so you should modify the DML statements (update and insert) this way for each foreign key column.
 
About parameters, I didn't mean how you set the combo box but how you set the values for the SQL statement. Please refer to the link I posted.
Mika Wendelius at 6-Jan-13 18:07pm View
   
That's true, but if it can be avoided, I think it should :)
Mika Wendelius at 6-Jan-13 14:10pm View
   
Also try using the debugger to see what actually happens. You can also try a bit different string. What happens with:

...
string str = "(a(b(cde)";
...
Mika Wendelius at 6-Jan-13 14:08pm View
   
Instead of writing a new question, use the "Improve question" link to make modifications to your original question: its not working i think there is a logic mistake the question is( Write recursive and non-recursive functions that check parenthesis in a string.)[^]
 
This repost should be deleted.
Mika Wendelius at 6-Jan-13 13:54pm View
   
What's the return value and what would you think it should be?
 
Also have you tried yet creating the recursive version?
Mika Wendelius at 6-Jan-13 13:04pm View
   
Exactly :)
Mika Wendelius at 6-Jan-13 12:54pm View
   
The point wasn't that you set null to the variable but if the fname column in the database contains a null value.
 
Try the following:
 
INSERT INTO StudentName (fname, lname) VALUES (NULL, 'Last name');
 
declare @fname nvarchar(50),@lname nvarchar(50)
 
set @fname = ''
set @lname = 'rst'
 
SELECT *
FROM StudentName sn
WHERE COALESCE(fname , '') LIKE '%' + @fname + '%'
AND COALESCE(lname, '') LIKE '%' + @lname + '%'
 

Why I'm suggesting this is that TextBox never contains a null value, but an empty string when there's no data. However if your SQL statement tries to compare
 
NULL = ''
 
this would be false. Null is never equal to anything.
Mika Wendelius at 6-Jan-13 12:34pm View
   
The idea is that it's used to avoid IS NULL test since this would require you to change the operator.
 
So if a row as a NULL value in lname, the null is replaced with ''. This way the LIKE operator is never comparing to NULL but to an empty string. So this lets you to have null values on the rows but the condition would still be true.
 
COALESCE (, '') results to ''
 
so
 
'' LIKE '%%' is true
 
Hopefully that clarified the idea :)
Mika Wendelius at 6-Jan-13 12:29pm View
   
Thanks Sandeep :)
Mika Wendelius at 6-Jan-13 12:03pm View
   
Nice solution, 5'ed.
Mika Wendelius at 6-Jan-13 11:13am View
   
What is the error message you now get?
Mika Wendelius at 6-Jan-13 11:00am View
   
Good references!
Mika Wendelius at 6-Jan-13 10:59am View
   
That's a useful link!
Mika Wendelius at 6-Jan-13 10:58am View
   
Good point!
Mika Wendelius at 6-Jan-13 10:57am View
   
Good examples!
Mika Wendelius at 6-Jan-13 10:57am View
   
Thank you Espen :D
Mika Wendelius at 6-Jan-13 10:56am View
   
Thanks :)
Mika Wendelius at 4-Jan-13 15:15pm View
   
Unfortunately I haven't tried that service myself. But I would guess that uploading the data is similar to any other database instance once you get the connection working. Basically executing normal commands or using bulk insert if that's preferable.
Mika Wendelius at 4-Jan-13 15:13pm View
   
Thanks :D
Mika Wendelius at 4-Jan-13 15:12pm View
   
Thanks! :D
Mika Wendelius at 4-Jan-13 15:12pm View
   
Thank you :D
Mika Wendelius at 4-Jan-13 15:12pm View
   
Thanks :D
Mika Wendelius at 4-Jan-13 15:12pm View
   
Thank you :)
Mika Wendelius at 4-Jan-13 15:12pm View
   
Thanks Espen :-D
Mika Wendelius at 4-Jan-13 15:11pm View
   
Thanks :)
Mika Wendelius at 4-Jan-13 15:11pm View
   
When a selection is made, get the key value from the combobox and then execute a select like
SELECT ... FROM Model WHERE ManufacturerId = @selectedidvalue
 
For an example about the parameters in the command, see http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlparameter.aspx[^]
Mika Wendelius at 4-Jan-13 15:08pm View
   
In my opinion the best way would be to create the schema beforehand. This way you get all the constraints etc correctly in place.
Mika Wendelius at 4-Jan-13 15:07pm View
   
That's true, thanks :)
Mika Wendelius at 4-Jan-13 15:07pm View
   
Thanks :) Yes, that's a good point.
Mika Wendelius at 4-Jan-13 15:07pm View
   
Thanks :)
Mika Wendelius at 4-Jan-13 15:06pm View
   
Thank you :)
Mika Wendelius at 4-Jan-13 15:06pm View
   
Thanks :)
Mika Wendelius at 4-Jan-13 15:05pm View
   
Thank you :)
Mika Wendelius at 4-Jan-13 15:05pm View
   
Thanks :)
Mika Wendelius at 2-Jan-13 14:25pm View
   
Thanks, Happy New Year to you too :)
Mika Wendelius at 2-Jan-13 3:36am View
   
Good answer, 5.
Mika Wendelius at 2-Jan-13 3:35am View
   
Thanks :)
Mika Wendelius at 31-Dec-12 1:43am View
   
Of course you can, but I suggest getting familiar with surrogates. They make life much more easier in the future :-)
 
The surrogate key doesn't affect how you query or modify the table (except for the key column) so basically everything is done the same way. The main difference is just that the database generates the key, not the program...
Mika Wendelius at 31-Dec-12 1:30am View
   
Nice answer, 5.
Mika Wendelius at 31-Dec-12 1:29am View
   
Thanks :-D
Mika Wendelius at 31-Dec-12 1:28am View
   
By generated I mean a surrogate key[^]. In my opinion the best choice is to use an uniqueidentifier[^] for the column datatype with the default of NEWID.
 
To get the value when inserting a record, you can use the OUTPUT[^] clause.
Mika Wendelius at 30-Dec-12 18:20pm View
   
So basically you have 15 rows in the table if any of the manufacturers has 15 models (nokia, htc or samsung)? If that's true and you hold the data in separate columns instead of separate rows, you'll get problems.
 
What I'm suggesting, eliminates the problem for null values in different columns since you always select rows based in foreign key values.
 
See the updated solution for an example for the data.
Mika Wendelius at 30-Dec-12 13:56pm View
   
Thanks :D
Mika Wendelius at 30-Dec-12 12:58pm View
   
Good answer, 5.
Mika Wendelius at 29-Dec-12 17:25pm View
   
Instead of posting a new question, you can modify the original using the "Improve question" link.
Mika Wendelius at 29-Dec-12 17:12pm View
   
What do you mean by readonly? That only existing file can be selected or something else?
Mika Wendelius at 29-Dec-12 17:07pm View
   
The list you posted isn't XML but just a lost of text. Where is it stored? In a file? Do you need to get the list from file or something else?
Mika Wendelius at 29-Dec-12 16:34pm View
   
No problem at all :)
Mika Wendelius at 29-Dec-12 16:28pm View
   
You're welcome. You can use the "Have a Question or Comment?" button to send a comment directly to a specific solution. This way the person who wrote the solution gets notified, just like with this message :)
Mika Wendelius at 29-Dec-12 16:12pm View
   
Could you explain more, what are you actually trying to do? Do you mean you want to dynamically construct an SQL statement or something else?
Mika Wendelius at 29-Dec-12 15:02pm View
   
Good links, 5.
Mika Wendelius at 29-Dec-12 15:00pm View
   
Thanks :D
Mika Wendelius at 29-Dec-12 11:54am View
   
You're welcome :)
Mika Wendelius at 29-Dec-12 11:42am View
   
Because of site policy, only English posts are accepted.
Mika Wendelius at 29-Dec-12 7:54am View
   
Thank you :D
Mika Wendelius at 29-Dec-12 7:54am View
   
Thanks :)
Mika Wendelius at 29-Dec-12 7:54am View
   
Thank you :)
Mika Wendelius at 29-Dec-12 7:53am View
   
Thanks :D
Mika Wendelius at 29-Dec-12 7:52am View
   
Thanks Espen :D
Mika Wendelius at 29-Dec-12 7:30am View
   
Have a try with the ADO date syntax if that helps...
Mika Wendelius at 29-Dec-12 7:29am View
   
Yes, actually that's quite true. In our region especially with banks and insurance companies.
Mika Wendelius at 29-Dec-12 7:22am View
   
What interface are you using ADO with VB6? if that's true I think both field list and the values should be arrays. Have a look at http://msdn.microsoft.com/en-us/library/windows/desktop/ms677536(v=vs.85).aspx[^]
 
You could also try a different, ADO syntax for the date: #01/01/2011#
Mika Wendelius at 29-Dec-12 6:02am View
   
Thank you :D
Mika Wendelius at 29-Dec-12 6:01am View
   
Also a good link.
Mika Wendelius at 29-Dec-12 6:01am View
   
Good example, my 5
Mika Wendelius at 29-Dec-12 6:00am View
   
Good links, 5
Mika Wendelius at 28-Dec-12 10:59am View
   
Nice! But what if I'm good with Cobol & VB6 or ADA??? Should I pay when I go to a museum or will they pay salary for me :)
Mika Wendelius at 28-Dec-12 10:57am View
   
Nice link!
Mika Wendelius at 28-Dec-12 10:57am View
   
Good answer, 5
Mika Wendelius at 28-Dec-12 10:56am View
   
Very useful!
Mika Wendelius at 28-Dec-12 10:55am View
   
Excellent link!
Mika Wendelius at 28-Dec-12 9:28am View
   
Thanks :D
Mika Wendelius at 28-Dec-12 9:26am View
   
Good example, 5.
Mika Wendelius at 28-Dec-12 9:25am View
   
Thanks Espen :)
Mika Wendelius at 28-Dec-12 5:57am View
   
Yes, functions must be deterministic so using execute or similar is prohibited.
 
Don't know the full case but could you use a procedure with output parameters instead or even replace the function with a single SQL statement (if the calculation of SUM was the only thing the function did)?
Mika Wendelius at 27-Dec-12 18:03pm View
   
Hopefully much, much later :) The enjoy life part sounded really good :thumbsup:
Mika Wendelius at 27-Dec-12 18:00pm View
   
See the updated solution.
Mika Wendelius at 27-Dec-12 17:55pm View
   
And a Happy New Year to you too :-) . Seems that the world didn't come to an end last Friday so we're going to enjoy at least one more... :)
Mika Wendelius at 27-Dec-12 16:30pm View
   
In that case, I think you could do this using UNPIVOT[^]. The idea could be to rotate the columns to rows and then using this result as an inline view you could sum the values. All this could be done in a single query without a cursor.
Mika Wendelius at 24-Dec-12 5:18am View
   
Few things, you don't need to add your email with the text. You'll get notified automatically when someone answers.
 
More importantly, this is not the way Code Project works. People don't do your work for you. For proper questions you'll get answers to direct you to correct direction, but it's considered rude to ask for the full code.
Mika Wendelius at 22-Dec-12 3:54am View
   
Good answer, 5.
Mika Wendelius at 22-Dec-12 3:53am View
   
Thanks :)
Mika Wendelius at 19-Dec-12 12:47pm View
   
Glad it helped :)
Mika Wendelius at 17-Dec-12 14:23pm View
   
Good answer!
Mika Wendelius at 17-Dec-12 14:23pm View
   
Good clarification
Mika Wendelius at 17-Dec-12 14:20pm View
   
Thanks Espen, even though it's seems that it's not what OP is after :)
Mika Wendelius at 17-Dec-12 13:52pm View
   
Could you explain what you actually mean with a foreign table?
Mika Wendelius at 17-Dec-12 3:07am View
   
Thanks :)
Mika Wendelius at 17-Dec-12 0:58am View
   
Thanks :)
Mika Wendelius at 17-Dec-12 0:20am View
   
Good links.
Mika Wendelius at 17-Dec-12 0:19am View
   
Good links :thumbsup:
Mika Wendelius at 17-Dec-12 0:19am View
   
Thanks :)
Mika Wendelius at 13-Dec-12 14:38pm View
   
Thank you! This was a really enlightening answer. Actually I haven't thought about the whole situation much yet so the information that two applications running from same terminal server actually share a session behind the scenes is really promising.
 
Eventually I need to integrate the application to local resources on the client, but based on your answer it seems that this is doable.
 
Thanks again,
 
mika
Mika Wendelius at 12-Dec-12 1:22am View
   
Thanks :)
Mika Wendelius at 12-Dec-12 1:21am View
   
So true :)
Mika Wendelius at 12-Dec-12 0:24am View
   
Really useful links!
Mika Wendelius at 12-Dec-12 0:24am View
   
Thank you :)
Mika Wendelius at 12-Dec-12 0:23am View
   
Thanks, good point.
Mika Wendelius at 12-Dec-12 0:23am View
   
Thank you :)
Mika Wendelius at 12-Dec-12 0:23am View
   
Thanks :)
Mika Wendelius at 12-Dec-12 0:22am View
   
Looks like a really good link. I have to dig it more thoroughly at some point.
Mika Wendelius at 12-Dec-12 0:21am View
   
Quite true.
Mika Wendelius at 12-Dec-12 0:20am View
   
That's a useful link
Mika Wendelius at 12-Dec-12 0:20am View
   
Good answer
Mika Wendelius at 12-Dec-12 0:19am View
   
Good control to remember :)
Mika Wendelius at 12-Dec-12 0:18am View
   
Thank you :)
Mika Wendelius at 12-Dec-12 0:18am View
   
Thanks :)
Mika Wendelius at 12-Dec-12 0:17am View
   
Thanks :)
Mika Wendelius at 12-Dec-12 0:17am View
   
Thanks :-)
Mika Wendelius at 12-Dec-12 0:16am View
   
Thank you :)
Mika Wendelius at 12-Dec-12 0:16am View
   
Thanks :-)
Mika Wendelius at 9-Dec-12 14:50pm View
   
Do you mean if you want to publish it as an article at CodeProject?
Mika Wendelius at 6-Dec-12 12:18pm View
   
You can check which key is pressed based on the information in the event arguments and then set Handled property as needed (depending on the key).
Mika Wendelius at 5-Dec-12 5:05am View
   
I don't quite understand your reply. The database engine is always responsible for creating the plan and executing the query.
Mika Wendelius at 5-Dec-12 1:22am View
   
Yes, the query is always executed on the server. Again, have a look at the plan of the queries and investigate if there are affecting differences.
Mika Wendelius at 5-Dec-12 0:59am View
   
And what tool are you using for printing? Reporting services, plain forms, asp.net page...?
Mika Wendelius at 4-Dec-12 23:23pm View
   
Thanks :)
Mika Wendelius at 4-Dec-12 13:47pm View
   
Thanks :)
Mika Wendelius at 4-Dec-12 13:46pm View
   
Good tutorial, 5.
Mika Wendelius at 4-Dec-12 13:46pm View
   
Thanks :)
Mika Wendelius at 6-Nov-12 5:34am View
   
You're welcome :)
Mika Wendelius at 19-Sep-12 10:50am View
   
You're welcome :)
Mika Wendelius at 14-Sep-12 16:14pm View
   
That's true. Have a nice weekend!
Mika Wendelius at 14-Sep-12 16:05pm View
   
Thanks, that's really messing my brains in late Friday night (local time) :)
 
Now professionally, yes you're right, it would be redundant but since they are disposed in correct order I also think that the finalizer will handle the situation :)

Advertise | Privacy | Mobile
Web03 | 2.8.140821.2 | Last Updated 1 Jan 1900
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid