Comments by Reiss - CodeProject

Reiss 30-Jan-15 7:17am View

The OP has two different fields that they want to check against Cust_Name and CustID so your IN methodology won't work

Reiss 20-Dec-13 4:10am View

I am assuming that the reg object is not set, which means that it hasn't found the key at the path you have specified.

Reiss 2-May-12 7:07am View

You appear to be affectively spoofing a primary key - any reason why a standard PK won't solve your issue?

Reiss 19-Jan-12 11:30am View

Why not store the exe on file system and hold a reference to its location in the database?

Reiss 17-Jan-12 6:36am View

You can't add a second element directly to an xml docuemnt, it would need to be nested inside a single root element - I have modified my example to show you how this can be done

Reiss 17-Jan-12 4:50am View

This works for ints - the OP mentioned numbers although code shows he is trying to do it with ints, so may need to use the Double.TryParse method

Reiss 10-Jan-12 3:53am View

What platform are you using wpf, asp.net, winform etc?

Reiss 4-Jan-12 3:17am View

Do you need to account for multiple instances of either C or M, e.g. CdddMCssMMC

Reiss 23-Dec-11 5:18am View

+5 for links

Reiss 22-Dec-11 8:38am View

What is your target app written in, what automation framework are you using? - Use the Improve question widget to add some details to what you are trying to achieve.

Reiss 14-Dec-11 4:15am View

Just wondered why you are using vars when you know explicitly what type you are getting?

Reiss 7-Dec-11 3:26am View

The only thing I can suggest is that you update your question (using the improve question widget) to post the code for the method GetInsertDealSheetCommand() as that must be causing the issue

Reiss 6-Dec-11 4:50am View

Are you getting any error messages - if so update the question to add the details.

Reiss 2-Dec-11 4:02am View

What are the values in the cells before you try and parse/convert them?

Reiss 2-Dec-11 4:01am View

Deleted

What are the values in the cells before you try and parse/convert them?

Reiss 30-Nov-11 10:26am View

Are you sure your top level control c is what you think it is, when using master pages, user controls etc the control collections get messy.

Also the formatting on your else if blocks is really nasty - put the if on the same line as the else

Reiss 29-Nov-11 10:52am View

Deleted

I am with GG on this, for any site that involves transactions (not just finacial ones), testing on live is really really dangerous - you would have to reverse out, or stub out the endpoints - which kind of makes the testing obsolete

Reiss 29-Nov-11 10:50am View

Deleted

my 5 - cleanest solution

Reiss 29-Nov-11 10:49am View

Deleted

Reason for my vote of 3
works, just not elegant

Reiss 29-Nov-11 10:47am View

Deleted

Reason for my vote of 1
totally unscalable

Reiss 29-Nov-11 3:54am View

Deleted

Good article btw, now voted

Reiss 28-Nov-11 6:49am View

What are you struggling with? Getting a list of file names or the data binding or something else?

Reiss 28-Nov-11 5:37am View

Deleted

Eduard Lu wrote:The best way to design your own application is to use the N-tier architecture - a very sweeping statement. In client - server apps this is often true, but the architecture used is dependant on what you are trying to achieve.

Reiss 28-Nov-11 5:32am View

Deleted

Your title is misleading - your tip only illustrates how to read and write to the registry - which your app may not have privileges to do in any case

Reiss 24-Nov-11 3:17am View

Repost of a repost http://www.codeproject.com/Questions/287815/ramdomly-selecting-questions-from-database

Reiss 23-Nov-11 5:06am View

I would suggest it is because you are not calling your binddata() sub on the post back event

Reiss 23-Nov-11 4:10am View

Please don't repost your questions.

Reiss 23-Nov-11 3:40am View

The question wasn't about converting a string to an int but requiring that only numeric characters and a possible initial + sign be entered in the field, so there is no possible out-of-range exception that can be thrown by using a regex to validate the field. The method signature for int.TryParse also requires an out parameter of type int too, so it is
<pre lang="c#">
int t = 0;
bool valid = int.TryParse(myTextBox.value, out t);
</pre>

whilst this would satisfy the rules required by the OP it would also falsely pass a negative value.

UK phone numbers couldn't be stored as an int as they start with a zero, which would be trimmed off automatically, and internationally they are too big to be stored as an int anyway e.g. +441234123456

Reiss 22-Nov-11 5:25am View

Deleted

~~Have you checked that the query is working when run directly against the database via management studio? (Use the improve question widget if you need to amend the question to add extra info)~~ [edit]Missed that bit

Reiss 21-Nov-11 5:59am View

What is the code in the receiving application? Use the Improve question widget to edit your question to add this detail.

Reiss 21-Nov-11 4:29am View

Given that you have got the code that retrieves the data captured by the ECG, then surely your question is how can I write a web application - all you are doing is putting a different UI on a business tier.

Reiss 21-Nov-11 3:56am View

In future please don't repost your question - if you first doesn't have enough detail, use the improve question widget to edit the question and add more details.

Reiss 18-Nov-11 9:02am View

What have you tried and what is the issue you are facing?

Reiss 18-Nov-11 4:47am View

True, but why make two calls to the database when you can do it in one - to me the title suggests that this is what the user is doing

Reiss 17-Nov-11 9:16am View

That takes me back - statistical mechanics was the pet subject of one of my lecturers at uni

Reiss 17-Nov-11 7:24am View

We don't do homework - it is set for a reason, there is also a reasonable chance that your tutor is a member of this site too!

Reiss 17-Nov-11 3:27am View

could answer and links +5

Reiss 16-Nov-11 14:06pm View

that's the only bit I understood

Reiss 16-Nov-11 11:31am View

I'm sorry but I don't have a clue what you are asking - please use the improve question to explain your issue.

Reiss 16-Nov-11 9:57am View

Thanks missed that bit - always fun guessing what environment the user is working in ;)

Reiss 16-Nov-11 8:26am View

People aren't going to do your work for you - if you get stuck on a particular issue which you can't fix, then posting what you are doing and how it is not working (citing relevant formatted code and error messages) will mean that your question will more likely be looked at and help forthcoming - also don't mark your question as urgent - it is not urgent for the people who help out.

Reiss 16-Nov-11 5:57am View

This is really for the OP - but as it not a solution I have tagged it to yours. Just to give you some idea how big a task it is, I created a fully functional DAG in a win form application and it took about a month in total

Reiss 16-Nov-11 5:35am View

Are you after a directed acyclic graph?

Reiss 16-Nov-11 5:31am View

Please don't repost your questions - use the improve question widget to alter your original one

Reiss 16-Nov-11 5:14am View

In SQL 2008 didn't they change it that if the account you are using doesn't have permission to the sproc you now get the can't find error rather than the oiriginal you don't have permission error - or am I am getting mixed up with something else?

Reiss 16-Nov-11 5:03am View

use the Improve Question widget to provide more details about what you are asking as it is not clear. Also don't reuqest urgent responses - it is rude and you are much less likely to get help.

Reiss 15-Nov-11 10:53am View

Deleted

In my opinion when ever I find that the solution to a problem is a dynamic enum I know I have got my design wrong -
<blockquote class="FQ"><div class="FQA">MSDN says:</div>
Robust Programming

Assigning additional values new versions of enums, or changing the values of the enum members in a new version, can cause problems for dependant source code. It is often the case that enum values are used in switch statements, and if additional elements have been added to the enum type, the test for default values can return true unexpectedly.

If other developers will be using your code, it is important to provide guidelines on how their code should react if new elements are added to any enum types.
</blockquote>
From enums[^]

Dynamic enums pretty much fall down against these precepts.

Reiss 15-Nov-11 7:12am View

Deleted

+5 Pretty much the approach I use when working with tabs

Reiss 11-Nov-11 8:18am View

Make sure you have a full back up of your project before you do the migration - just in case you have a client who can't move to the newer framework and you need to support it.

Reiss 11-Nov-11 8:17am View

have my 5

Reiss 11-Nov-11 6:07am View

Deleted

Reason for my vote of 5
The HashSet is a much under used class

Reiss 11-Nov-11 6:03am View

[edit] formatted as code - removed urgency

Reiss 11-Nov-11 5:00am View

Did you miss the bit about searching the internet before posting a question

<quote>
A few simple rules when posting your question.

Have you searched or Googled for a solution?
...

Reiss 8-Nov-11 1:57am View

Sorry it is AddRange for a List

Reiss 3-Nov-11 4:47am View

My comment was not that what you have written for storing the file doesn't work (hence the OT - Off Topic), rather that it doesn't scale.

If person A uploads a file called MyFile.txt and then person B then uploads a a file also called MyFile.txt, the first file on the server will be over-written and you will have two database records pointing to the same physical file.

Depending on your actual requirements you should implement some logic that ensures the filenames on the server are unique or that a second record isn't created

Reiss 31-Oct-11 9:56am View

The same in reverse
Cursor currentCursor = _parent.Cursor

Reiss 28-Oct-11 4:05am View

This isn't a question - please use improve question widget to update your post with the relevant details.

Reiss 28-Oct-11 3:30am View

Can you rephrase your question (using the improve question widget), giving more information about what you are trying to achieve please

Reiss 27-Oct-11 3:37am View

Please don't repost your question, if you have changes you want to make to your original one use the Improve question widget provided

Reiss 25-Oct-11 9:47am View

In your code you have a While True loop - may I suggest that you alter it so that you define a meaningful boolean variable instead, so you code becomes

Private Sub ReadSocket()
Dim loopForever as Boolean = True

While loopForever
'Do stuff
End While
End Sub

I find this more readable and more obvious when you come back to look at the code at a later date

Reiss 25-Oct-11 9:36am View

my 5, just what I was going to post

Reiss 24-Oct-11 6:57am View

+5 - Expresso is very handy

Reiss 24-Oct-11 6:54am View

Deleted

MSDN link http://msdn.microsoft.com/en-us/library/ms188037.aspx

Reiss 21-Oct-11 3:26am View

I was certain I had done it like that in the past - must be going mad

Reiss 20-Oct-11 6:18am View

What is your question?

Reiss 19-Oct-11 11:41am View

Not going to happen, people will help you with problems you are having, not write your application for you.

Reiss 19-Oct-11 11:39am View

Struct's can implement interfaces too

Reiss 19-Oct-11 11:00am View

Deleted

Looks like you have got a browser refresh issue, as solution posted twice

Reiss 19-Oct-11 9:24am View

Without your code, it is impossible to diagnose the problem, use the Improve Question widget to paste your code into the original question (only the relevant sections please, rather than a code dump)

Reiss 19-Oct-11 7:07am View

+5, I did think about going down the extension route, but I can't think of a scenario whereby I need to check if any function key has been pressed.

Reiss 19-Oct-11 6:29am View

There are 24 Function keys available

Reiss 19-Oct-11 6:07am View

Good catch

Reiss 19-Oct-11 3:27am View

What is this mystical google that you speak of ;)

Reiss 17-Oct-11 6:08am View

You haven't provided the error message, which may help others help you

Reiss 14-Oct-11 10:33am View

Please don't code dump - I don't think many people are going spend the time to wade through all that

Reiss 13-Oct-11 10:33am View

Is 'notepad' a flat file?

Reiss 13-Oct-11 10:26am View

Just to clarify
1) You have production data in a database (Database_Prod) in table Customer
2) You have archived data in a database (Database_Archive) in table Customer

Reiss 13-Oct-11 10:00am View

+5 Correct anwser as this is the only way to do it - by using regex's it is possible to verify that the email address is valid, but not that it exists

Reiss 12-Oct-11 6:24am View

I am trying to ascertain whether the querystring entity should be a single string or not as the syntax supplied is incorrect

Reiss 12-Oct-11 6:22am View

Your supplied code won't compile as is because the value you have tried to assign to querystring is not valid c# syntax

Reiss 12-Oct-11 6:07am View

string queryString = {"id": "1234", "name": "ABC XYZ", "given_name": "ABC", "family_name": "XYZ", "link": "http://profiles.google.com/123456", "gender": "male", "locale": "en-GB"};

Reiss 12-Oct-11 4:27am View

Don't repost your questions

Reiss 11-Oct-11 7:34am View

OT : In a command window cd \ will return you to the root folder

Reiss 7-Oct-11 3:51am View

Deleted

have my 5 - your tip works and is explained well - that's all that should matter

Reiss 7-Oct-11 3:51am View

Deleted

IMO down voting should be used when something it wrong or can be done better, not just because it is common knowledge - how does stuff that is common knowledge get onto the interweb in the first place, if people don't write tips and articles in the first place?

Reiss 7-Oct-11 3:47am View

Deleted

+4 - you are missing the extra one, as no reason given for each item on the check list, otherwise very good cheat sheet

Reiss 7-Oct-11 3:44am View

Deleted

Reason for my vote of 5
Good explanation of the differences

Reiss 6-Oct-11 11:02am View

+5 but, do you expect the OP to come up with a data model as sensible as this

Reiss 6-Oct-11 7:09am View

I think you meant SqlConnection class to communicate, as you run the commands against the connection.

Reiss 5-Oct-11 11:11am View

What have you tried?

Reiss 5-Oct-11 9:31am View

Deleted

Reason for my 5 - CTE will be more efficient

Reiss 5-Oct-11 9:30am View

Deleted

Probably needs to be tagged as .Net 4 as it is using Lazy

Reiss 5-Oct-11 6:43am View

I appreciate that English may not be your main language, but I have no idea what you are asking.

Reiss 4-Oct-11 9:50am View

added pre tags for code

Reiss 3-Oct-11 6:58am View

What is the error message you are getting?

Reiss 3-Oct-11 3:51am View

without seeing your code, no one is going to be able to help you

Reiss 3-Oct-11 3:43am View

Good link

Reiss 3-Oct-11 3:43am View

Good short answer

Reiss 30-Sep-11 3:44am View

Are they abstract classes?

Reiss 28-Sep-11 5:31am View

I was going to suggest what happens when just the select is executed, but I believe that this will resolve the issue

Reiss 23-Sep-11 8:25am View

Can you edit you original question using the Improve Question widget please

Reiss 23-Sep-11 8:24am View

Not sure why you have been down voted so much - this is pretty much what needs to be done - have +4 from me as just a bit light on the details

Reiss 22-Sep-11 10:35am View

Deleted

Why bother to understand anything - you can always post your ~~problem~~ requirements in QA and wait for someone else to do it for you ;)

Joking aside good tip +5

Reiss 22-Sep-11 10:03am View

have my +5 to counter the 'tard

Reiss 21-Sep-11 3:30am View

Deleted

Hi Doc, regardless of which constructor you call in your implementing code, the final constructor always gets called, so DoStuff() is always executed

Reiss 21-Sep-11 3:02am View

Deleted

Hi Robert, in this scenario you are correct, but sometimes you may still need overloaded constructors and so using defaults like you have may not always work, or you have to duplicate the default value in multiple places which introduces human error if you have to change the default value.

Reiss 20-Sep-11 8:01am View

You have tagged your question as both MS-SQL and MySQL, which one is it as thiscould impact the answer

Reiss 20-Sep-11 4:02am View

Apart from the fact that a quick google would have lead to the answer this is a genuine question - most software used in corporations is paid for and requires a license key of some sort, however nearly all corps use some sort of silent deployment tool to deliver the software - indeed it is pretty much the only way to deliver software to a large number of users in disparate locations

Reiss 16-Sep-11 8:20am View

Can you only post the relevant sections of code - people arn't going to trawl through your code dump attempting to guess which part is causing you the issue and can you clarify whay you mean by my checkbox is not working

Reiss 16-Sep-11 8:15am View

What are the values stored in lstFiles.Items(c).ToString() and c.ToString()

Reiss 14-Sep-11 8:57am View

+5 - good link

Reiss 14-Sep-11 5:41am View

This sounds like homework - we don't do your homework for you, it also appears that you haven't tried to do anything yourself - people are happy to help out with problems, not write your code for you

Reiss 14-Sep-11 5:24am View

Deleted

+5 - I use this all the time.

Reiss 13-Sep-11 8:48am View

I can see a few issues, but I really need the 3 table schemas as I suspect that most of the performance issues are going to be around the indexes you (don't) have - also when you run it with the execution plan option turned on where is the main bottle neck?

Reiss 13-Sep-11 7:23am View

Deleted

If you are using int.tryParse to validate the value you may want to consider renaming your tip, as not all numerics are int's

Reiss 12-Sep-11 6:27am View

Deleted

Edit: Fixed the link

Reiss 9-Sep-11 2:44am View

We need more details in order to help - can you detail the exception (if any) you are getting, along with the relevant code section

Reiss 8-Sep-11 10:55am View

Deleted

+5 - Your time period lib is a seminal piece of work I would recomend to anyone

Reiss 8-Sep-11 10:49am View

+5 good links - looks like google is broken (again)

Reiss 8-Sep-11 10:28am View

I think you need to look at your whole design - what are you going to do with the import if one record fails due to data typing issue

Reiss 8-Sep-11 7:01am View

Also don't use all caps in your messages (see responses below) - it is considered shouting and therefore rude.

Reiss 8-Sep-11 6:58am View

Removed your "it is urgent" remark - your problem is not urgent to the people here giving their free time to help

Reiss 8-Sep-11 3:55am View

I appreciate that English may not be you primary language, but do try asking politely for help

Reiss 6-Sep-11 10:34am View

What part isn't working?

Reiss 6-Sep-11 8:59am View

Please don't use all caps - it is considered shouting.

Reiss 6-Sep-11 8:40am View

I have edited your message - it may be urgent to you, but not to the people helping out here - indeed people are generally less inclined to help if you state it is urgent.

Reiss 6-Sep-11 5:57am View

Have 5 - btw, do you have this stock answer saved anywhere - you can almost guarantee that you will need at once a week ;)

Reiss 6-Sep-11 5:54am View

I can't stress this enough, but make sure your that all indexes and stored procedures are properly maintained otherwise your db perfromance will suffer.

As a minimum always recompile your sp's if you change any of the indexes/statistics for pre SQL 2008

Reiss 6-Sep-11 3:25am View

Deleted

Have 4 - good tip, but see my alternative for why I don't think it's a 5.

Reiss 5-Sep-11 7:57am View

Shouldn't you be placing this type of information in to the dts configuration file?

Reiss 5-Sep-11 3:49am View

Is there a reason why you can't write a sql agent job to do this?

Reiss 2-Sep-11 8:59am View

You haven't asked a question - use the Improve Question widget to do so.

Reiss 2-Sep-11 5:55am View

Deleted

Good spot - thanks for sharing

Reiss 2-Sep-11 3:13am View

Deleted

Very true, but if you are shipping non-release code then you have bigger issues to worry about ;-)

Reiss 1-Sep-11 7:33am View

Deleted

My vote of 5
A very simple and elegant idea

Reiss 31-Aug-11 11:10am View

Agreed that the database should handle this - if this is the requirement then the userID column should have a unique constraint on it in the database, that way you can just try and insert the record and handle the error if it exists - this has the advantage of getting past any race conditions

Reiss 31-Aug-11 10:10am View

How are the images stored in the database?

Reiss 31-Aug-11 7:32am View

Absolute nonsense solution, the syntax of the try is correct - see
http://msdn.microsoft.com/en-us/library/fk6t46tz%28v=VS.100%29.aspx

Reiss 18-Aug-11 9:57am View

true, just another way to do it that's all.

Reiss 18-Aug-11 9:10am View

+5 - nice and simple

Reiss 18-Aug-11 9:02am View

+5 - I think google must be some sort of secret society as only a select few have heard about it.

Reiss 18-Aug-11 5:56am View

Again - What is your question?

Reiss 18-Aug-11 5:55am View

What is your question?

Reiss 18-Aug-11 4:50am View

even pseudocode should go in a code block

Reiss 18-Aug-11 4:44am View

Deleted

This approach would require you to have permissions to read the registry - not wrong, but required - http://msdn.microsoft.com/en-us/library/system.security.permissions.registrypermission.aspx

Reiss 18-Aug-11 3:14am View

Very important tip - I shouldn't be surprised anymore, but I see this nearly everytime I work for a new customer.

Reiss 17-Aug-11 7:05am View

Good explanation.

Reiss 17-Aug-11 6:54am View

If you are going to do that, I would rather it went in a finally block - less chance of missing it during a refactoring exercise.

Reiss 17-Aug-11 5:13am View

Deleted

Whilst this is a useful tip in itself, isn't there a greater risk that you can accidentally ship the wrong code (I understand that there is a risk regardless of how you chose to comment/uncomment code)

Reiss 17-Aug-11 5:06am View

What version of asp.net are you using - this will dictate the optimum solution, as you should be using role membership

Reiss 15-Aug-11 10:36am View

yet another re-worded post asking the same question...

Reiss 15-Aug-11 7:11am View

You missed the large link to the codeplex download page?
http://newsletter.codeplex.com/SourceControl/list/changesets

Reiss 15-Aug-11 7:02am View

Also, you should provide a pump into your custom messagebox class to instruct it to close - a timer is bad design flaw - what happens if the data isn't saved (e.g. an exception is thrown somewhere), the user thinks the data has been saved but hasn't

Reiss 12-Aug-11 3:26am View

title doesn't reflect your problem

Reiss 9-Aug-11 7:49am View

nice link +5

Reiss 8-Aug-11 7:39am View

Are you using the full unc path for the server path, e.g. \\servername\c$\folder

Reiss 5-Aug-11 7:50am View

Does the video play if you down load it manually?

Reiss 3-Aug-11 15:10pm View

There isn't enough detail, is an sql error being thrown during the second insert? The table schema's and the sp's you are running would help us help you.

Reiss 2-Aug-11 5:28am View

Most complete answer out of the group

Reiss 1-Aug-11 11:07am View

I think this is what the OP is after, if so then this is correct

Reiss 1-Aug-11 11:05am View

When I had to do my doctoral thesis, part of the viva was explaining why you selected that topic - you will probably have to defend your choice of topic, so you need to think long and hard about it.

Reiss 29-Jul-11 6:19am View

good link - have 5

Reiss 29-Jul-11 6:17am View

Asking people to think for themselves for a minute - in this industry - are you quiet mad? ;)

Reiss 28-Jul-11 4:14am View

I agree that you have more flexability in your approach, as you can make it non-inclusive if you wish.

This article (http://stackoverflow.com/questions/921282/compare-performance-difference-of-t-sql-between-and-operator) suggests that the execution plan is the same (I haven't tested this), so performance shouldn't be an issue either way

Reiss 28-Jul-11 3:33am View

Better solution than mine - completely forgot about DATEDIFF

Reiss 27-Jul-11 11:42am View

I like that suggestion - maybe create a directory with the date as the name and then add files using a pure GUID.

Reiss 27-Jul-11 4:32am View

Good link - leading people to find their own solution and therefore increasing their understanding is better than just spoon feeding them the answer.

Reiss 27-Jul-11 4:30am View

Orginally you had some syntactical errors, but essentially was correct

Reiss 26-Jul-11 10:33am View

Why don't you want to use stored procedures - this is the job they were designed for - it's a bit like saying I want to build a house and I don't want to use cement.

Reiss 22-Jul-11 16:16pm View

What bit are you struggling with - the voice control or creating the web browser?

Reiss 22-Jul-11 16:07pm View

Best resource I have come across

Reiss 22-Jul-11 9:50am View

I would argue that there are a lot of coding issues with the code as provided, but that won't solve your problem.

Just to get you started

change this
if (DatePicker.SelectedDate.ToShortDateString() == "1/1/0001")
to this
if (DatePicker.SelectedDate.Equals(DateTime.MinValue))

change this
else if(ddlEmployeeID.SelectedValue==".:Select Employee:.")
to something index based

move this
const string status = "a";
outside your foreach loop

etc

Reiss 21-Jul-11 8:52am View

take 5

Reiss 21-Jul-11 5:55am View

EricCiz - if you are using Forms authentication, then can't you just store the username entered in the form for later use?

Reiss 21-Jul-11 5:25am View

You can type faster than me ;)

Reiss 20-Jul-11 6:55am View

but I wanted to be the next Warren Buffett...

Reiss 20-Jul-11 4:19am View

Goolge - my god if only I had known about this before!

Reiss 19-Jul-11 15:41pm View

This is not a solution - questions like this should be tagged as comments as above by RaisKazi and digital man

Reiss 19-Jul-11 4:29am View

It's not wise to put your e-mail address on a public forum, unless you like spam.

Reiss 18-Jul-11 8:40am View

You may want to add some logic to check there is only one instance of the underscore character

Reiss 18-Jul-11 8:25am View

and your question is?

Reiss 16-Jul-11 6:48am View

And we have no idea either, not unless you can add some details - what is the Message, where is coming from, how it is received etc

Reiss 15-Jul-11 10:55am View

Have you started the Timer - this is different to just enabling it?
If yes, have you stepped through the trTick_Tick method?

Reiss 15-Jul-11 9:07am View

SQL injection will be a threat if you allow direct text sql execution against your database

Reiss 15-Jul-11 9:03am View

On top of this I would suggest that you read this article http://www.akadia.com/services/sqlsrv_table_auditing.html on creating triggers to audit changes made to the data.

Reiss 15-Jul-11 4:02am View

can you treat your html pages as xhtml and use the same solution you use for xml files (I assume some sort of XPATH)

Reiss 14-Jul-11 11:43am View

This will stop the form from closing in all cases and the CloseReason will only tell you UserClosing and not give any details about the whether it was invoked via the ALT-F4 key stroke combination.

Reiss 14-Jul-11 6:41am View

A datagrid with 300,000 rows (I don't know how many columns) - even if paged for display on the screen, you would need to fetch it all for the download - this is going to take a very long time.

Reiss 14-Jul-11 5:54am View

What do you want to do with the data once it has been exported - is it going to be fed into another system or viwed by a user?

Reiss 14-Jul-11 5:43am View

Tagging you question will help get it answered

Reiss 14-Jul-11 5:37am View

Please note that not everyone will understand the Indian numbering system. 3lakh is three hundred thousand.

What version of excel are you exporting to, as older versions can only contain 65,536 rows.

Reiss 13-Jul-11 10:49am View

Should the user be able to type into the command prompt, or should only system generated commands be allowed?

Reiss 13-Jul-11 5:19am View

This is a sql question and not a VB.NET one (The error is being thrown by the database) - you might have more success if you re-tag it.

Reiss 13-Jul-11 5:14am View

You may want to write it as an extension method and put in your framework library.

Reiss 13-Jul-11 3:31am View

just beat me to it ;-)

Reiss 12-Jul-11 16:15pm View

If you are going to publish code on a public forum, make sure you alter url's, connection strings etc.

Reiss 12-Jul-11 10:54am View

Deleted

I have had to use this before, as the installer had been deleted and so I couldn't uninstall the service ready for the next release.

Reiss 12-Jul-11 6:11am View

I think what you are after is

timer_fired_event method
{
try
{
open_log_file
call_method_with_other_logic()
}
catch
{
}
finally
{
close_log_file
}

private void call_method_with_other_logic()
{
//this may or may not write to open log file
// this may or may not throw an exception
// you may want to catch some exceptions here and handle them if appropriate or let them bubble up the call stack
}

Reiss 11-Jul-11 11:01am View

Glad you got it working, also kudos for working it out yourself ;-)

Reiss 8-Jul-11 11:09am View

I would definitely recommend a full re-write as just "porting" the code would probably miss out on many of the new features/paradigms that are about now (regardless of langauge) - indeed there are probably hacks (sorry workarounds) in the original code to handle stuff like this.

Comments by Reiss (Top 200 by date)