15,991,071 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View .NET questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by Mycroft Holmes (Top 184 by date)
Mycroft Holmes
7-Sep-21 18:23pm
View
And this is why the database design is wrong. Each type that you are likely to want to query/filter/search on should have it's own field. Truly custom fields (ie those you cannot identify) or user defined fields are the only ones you should be allowing in this format. Design your database structure correctly, don't try and take shortcuts they will cost you dearly in the future.
Mycroft Holmes
13-May-21 19:30pm
View
Is it possible to detect the window that had the focus BEFORE he clicked the start button? Oh and then he needs to identify the selected object (textbox) in that window- nasty
Mycroft Holmes
8-Mar-19 17:13pm
View
Thanks - the last hurdle to getting my POC ready except I need to secure the API now [chuckle]
Mycroft Holmes
28-Nov-18 3:45am
View
You used to be able to embed and /or pass credentials into the report or use a specific userid for all reports, we call them functional IDs.
Mycroft Holmes
17-Sep-18 2:53am
View
I have a question - why are you creating code in a language that is no longer supported?
Mycroft Holmes
10-Aug-18 2:27am
View
And yet again I learn something - you have no idea how much crap I have gone through trapping nulls!
Mycroft Holmes
10-Aug-18 2:23am
View
So does the question get bumped if someone posts another answer - I was going to chime in until I saw your comment.
Mycroft Holmes
23-Jul-18 2:16am
View
Do some research into the availability of the Jet engine and find out if you have a 64bit machine.
Mycroft Holmes
7-Jun-18 3:28am
View
And your batch of insert statements do not work in a timely manner! So I have proposed a solution that I know works as we use it regularly to insert many 100 of thousands of rows in a single call to the database.
Mycroft Holmes
6-Jun-18 4:19am
View
Solution too complex, codez not explicit enough - what you expect him to THINK!!!
Mycroft Holmes
4-Jun-18 3:06am
View
You are way too gentle with the lazy sod these days, a request like this used to be an open invitation to be burnt to the ground.
Mycroft Holmes
7-May-18 22:16pm
View
Your joking right, that is a very simple database structure.
Mycroft Holmes
25-Mar-18 3:29am
View
He was joking, this is support site, the volunteers here will help you with your coding problems they will not send you the code.
Mycroft Holmes
18-Mar-18 18:37pm
View
You need something like https://www.google.com.sg/search?q=Crystal+reports+tutorial&rlz=1C1CHBF_enSG709SG709&oq=Crystal+reports+tutorial&aqs=chrome..69i57j0l5.13277j0j8&sourceid=chrome&ie=UTF-8
Mycroft Holmes
14-Mar-18 23:44pm
View
Nick this is a straight up study question, a rather basic one at that. It will almost certainly be covered by you study material. Or you could search for working with arrays and study some of the results.
Mycroft Holmes
30-Oct-17 4:50am
View
You need to identify the attribute that defines a driver as a fax driver. So select one of the drivers that you know is a printer and one that is a fax and inspect the differences. try and identify an attribute that seems generic.
Mycroft Holmes
21-Oct-16 19:14pm
View
Your design is incorrect, your attachment table should only have information on one file per record. There should be 5 records for 5 attachments with the PK of 123
Mycroft Holmes
9-Oct-16 23:50pm
View
EG00009519 is not an attribute name it is data. You need to look into your source and give the first value a name.
Mycroft Holmes
26-Sep-16 8:02am
View
Session
Mycroft Holmes
25-Sep-16 23:10pm
View
I am pretty certain you cannot display a PDF within a report. The report viewer will know how to render an image converted from binary but will not be able to deal with a PDF.
Mycroft Holmes
6-Sep-16 18:40pm
View
Erk same error as the OP, my only excuse, it was typed into the answer not copied from the IDE.
Mycroft Holmes
5-Sep-16 2:18am
View
There is no "one" in your code!
Mycroft Holmes
18-Mar-16 3:43am
View
This is wrong, a server application rarely has a UI. A server should store the images and the client is used for display
Mycroft Holmes
7-Mar-16 2:10am
View
I suspect it will have something to do with utf-8 which does not support unicode characters or possibly the content encoding.
Mycroft Holmes
7-Mar-16 2:06am
View
Well you are not going to get it. Try rentacoder or elance if you want something written.
Mycroft Holmes
25-Jan-16 7:59am
View
Okay you have more problems that you think.
Split that proc into 3
Select - return 1 or all (if driverid = 0 then return all)
Update inserts or updates (if driverid = 0 insert) and returns the changed record
Delete returns the @@ROWCOUNT after delete or the changed record.
Your current proc cannot meet your business requirements.
Mycroft Holmes
19-Jan-16 3:45am
View
It is still a dodgy design and you will still need to split the text into discreet values. I would suggest you supply a hyperlink instead of a checkox. If I had a choice I would change my data structure to have a child table (Interest) with an InterestType and a value.
Mycroft Holmes
19-Jan-16 3:09am
View
He asks about compiler issues and you tell him it is expensive, lost the plot on that one!
Mycroft Holmes
19-Jan-16 3:06am
View
You need to expand on the question, what defines that the record is "registered".
BTW you are wide open to SQL Injection - do a search on "little bobby tables".
Mycroft Holmes
7-Jan-16 2:39am
View
I hope you just C&P that from an existing app hahah
Mycroft Holmes
21-Dec-15 1:26am
View
Your posting your homework, try and do the work and ask specific questions showing that you have attempted to do the work yourself!
Mycroft Holmes
22-Jun-15 23:57pm
View
You also need to make sure the stored procedure has the additional fields and deals with them appropriately.
Mycroft Holmes
22-Jun-15 22:44pm
View
How are you communicating with the database?
Are you using a stored procedure to do the update/insert (CLR_SP seems to indicate this)? If so then check that the stored proc has the required variables for the new fields
Mycroft Holmes
19-May-15 5:04am
View
Have you checked what the count of DtoList is when you start the loop.
Mycroft Holmes
14-May-15 2:36am
View
Do you understand the first query, you want a result with 3 fields (4 if you need to do a join back onto the source table) which are the sum of the values you need to calculate.
Mycroft Holmes
14-May-15 2:21am
View
There is not enough detail to help, are there 2 or 3 or 5 columns. You may want to look at ROW_NUMBER() to get a sequential row ID so you can locate the previous row to do any (obscure) calcs.
Mycroft Holmes
16-Jan-15 19:05pm
View
But you already have all the bits, in your BLL method you call the static DAL method and it returns the string response from ExecuteScalar.
string sResponse = DALNamespace.GetNewCaseNumber(Date, CaseType);
Where DAL is the namespace for your static DAL class
I must be missing something, this is too simple to be the problem.
Mycroft Holmes
15-Jan-15 22:05pm
View
Ok redesign the app may be a bit strong but you need to address the issue where you are creating the database object BEFORE the user has saved the case.
Assuming the case number is an identity field in SQL Server I used to return the @Scope_Identity() after the insert.
These days I return the entire object eg Select * from CaseView where ID = @Scope_Identity()
Because I use a view this gives me the associated fields for the UI (FK description fields etc).
Mycroft Holmes
15-Jan-15 20:37pm
View
What happens if your user cancels the case creation process? You have a crappy record already created in the database.
Mycroft Holmes
16-Dec-14 0:42am
View
Want to test the new spam filter.
Ok so the spam filter will let me make a comment but not post a reply.
Mycroft Holmes
19-Nov-14 3:51am
View
Listen to Sinisa, do NOT ignore this advice it is essential to your continuing sanity!
Mycroft Holmes
15-Nov-14 3:30am
View
Learn not to cross post, Q&A or a forum post NOT both!
Mycroft Holmes
31-Oct-14 2:57am
View
Registry entries are only 1 of many things an installer does and most of them are specific to the installer doing the job, there is no such thing as a generic set of entries that are required for a generic installation.
I don't have a problem not bothering!
Mycroft Holmes
28-Oct-14 18:26pm
View
Sorry I don't use prism and I don't know the capabilities of your control so my help is going to be limited. If I can find the examples I ran across - Telerik dynamic columns radgridview - keywords may help, I will post the link.
Mycroft Holmes
28-Oct-14 6:47am
View
Ah, I use the Telerik control library and it has the SelectedItem property in xaml. You will probably need to use some form of clickevent (node,item,etc)
Mycroft Holmes
28-Oct-14 3:54am
View
If you need guiding then you would be better served by searching for a tutorial rather than a Q&A.
Mycroft Holmes
19-Oct-14 5:19am
View
It would be useful to know what the error is, if the query returns data or is it the binding to the listview?
Mycroft Holmes
19-Oct-14 5:14am
View
Why do you need a cursor?
Mycroft Holmes
19-Oct-14 5:12am
View
The OP may not think so but they look like excellent links!
Mycroft Holmes
16-Oct-14 18:43pm
View
By the great Ghu do NOT use guids unless you have a specific need for a distributed system. Use ints or bigints as identity columns. Try remembering a guid when debugging!
Mycroft Holmes
16-Oct-14 4:49am
View
I wrote this application in the early 90's using Excel as the database, I was selling the dammed rubbish at the time, it is the one I cut my database teeth on when I moved it to SuperBase. Bloody complex and it needs to be correct otherwise it will drive you nuts.
Mycroft Holmes
16-Oct-14 4:46am
View
I would do it anyway, I think they generally just bitch at you, not down vote a valid question. There are a number of other guys who will input valuable opinions.
Mycroft Holmes
16-Oct-14 4:00am
View
Rubbish - EF is not FAST it carries too much overhead. The fastest method IMHO is to use a darareader. Personally I use a datatable.fill and pass the data as a poco opbject.
Mycroft Holmes
16-Oct-14 3:46am
View
Probably better in the database forum but the pedants will get you for cross posting now. This is after all inviting discussion whereas most of us ignore a question with 1 or more answer.
Mycroft Holmes
15-Oct-14 18:23pm
View
Then accept that the filter will be fired EVERY time the user changes any of the 4 values!
Mycroft Holmes
13-Oct-14 5:11am
View
BTW after arguing with Rohan I noticed you are storing the address twice. This is a disaster, store it on the account table ONLY. NEVER, ever store data twice!
Mycroft Holmes
13-Oct-14 5:10am
View
How are you going to get Description to the TBilling table and if you suggest inserting into the TAccount table I'll take your keyboard away from you!
Mycroft Holmes
13-Oct-14 5:06am
View
[Personal opinion] CTE's are not intuitive, they read backwards and I have trouble dealing with them and I can't see any benefit by using a CTE!
Mycroft Holmes
13-Oct-14 5:00am
View
No triggers are not valid for this solution, you have to assume the user is passing in a shed load of variables to be inserted, you don't want to be passing variables to triggers (not sure you CAN).
Actually triggers used for ANYTHING but auditing are a disaster and should be hunted out of the database.
Mycroft Holmes
13-Oct-14 4:55am
View
What database are you using for the local storage (I don't think you know). I would use an XML file, read the article it has example and code.
Mycroft Holmes
25-Sep-14 1:59am
View
Not the brightest request, this is straight research, if you had typed each keyword into google you would have got exactly what you are looking for from MSDN!
Mycroft Holmes
22-Sep-14 4:50am
View
Well next time you might consider telling us you are using MySQL - the above answer is for MSSQL.
Mycroft Holmes
4-Aug-14 1:15am
View
Try naming the datasource "ObjectDataSource1" to the missing name "r_instructores".
Mycroft Holmes
16-Jul-14 1:35am
View
You need to define "it is giving some other data" is it as trivial as rounding errors or different records.
Mycroft Holmes
5-Jun-14 3:12am
View
Some are obsessed by rep point.
Your comment is more than adequate for an answer, especially considering the quality of the database he is working with. Waiting for the OP to confirm an answer is a WOFAM, they are rarely that proactive.
Have no fear the denizens on Q&A will have no compunction in supplying another solution even if yours is the better one.
Mycroft Holmes
5-Jun-14 2:03am
View
Next time when supplying a solution do not add it as a comment, it is difficult to read as there is no formatting, it does not show up as a solution (and others come in to answer it when you have done the job) and you get not rep points for your work.
Mycroft Holmes
30-May-14 3:21am
View
I thought it was a dumb question at first, of course it is defined by the memory you have use, then I started looking for the number and failed to find it in 5 minutes, about the limit of my attention span.
Mycroft Holmes
30-May-14 3:19am
View
That is a discussion by developers on the merits of the 2 frameworks, not the differences.
Mycroft Holmes
30-May-14 3:14am
View
As there are a number of file sources represented by VCE you need to be more specific. Also if you are not going to use software what do you expect to use - magic!
Mycroft Holmes
28-May-14 0:00am
View
There is an explanation at the bottom of the post.
Mycroft Holmes
20-May-14 3:40am
View
In SQL Server you have "Common Table Expressions" CTE which allows you to create a recursive query
Mycroft Holmes
19-May-14 23:59pm
View
Have some Google Foo - there are many examples including a couple on CP.
Use theses keywords in Google - winforms textbox rounded corners
Mycroft Holmes
19-May-14 3:59am
View
Then you need to look at the business requirement and then look at your processing flow to define where you can optomise it. Transactions are not the issue. Identify what makes the insert redundant and work on that.
Mycroft Holmes
19-May-14 3:51am
View
This is a lousy question, go to the Payzippy vendor and study their tutorials, you are asking someone to create a tutorial for you, that is not going to happen.
Mycroft Holmes
19-May-14 3:46am
View
And PatientID not in (select patientid from dialiser)
Mycroft Holmes
19-May-14 3:19am
View
That is not what you want, you need to identify the assignment table in the database and use that in the query not just the last one you assigned. BTW, change the @SepectedPatient to the number (I always use a variable in SQL Proceures that are not supported in Express).
Mycroft Holmes
5-Dec-13 7:36am
View
Of course I'm not using POCO objects, I told you my model implement INotifyPropertyChange, they can't be POCO. POCO object CAN'T tell anyone anything they are DUMB. I told you this in my very first response.
Mycroft Holmes
5-Dec-13 4:18am
View
I don't know EF, we use our own DAL and then populate the Model from a datatable in the WCF. The models are in their own project and implement INotifyPropertyChange.
The client project also references and reuses the same model project (we are doing Silverlight).
Mycroft Holmes
5-Dec-13 3:54am
View
Ah so MySQL does support triggers, I'd assumed so.
Mycroft Holmes
5-Dec-13 3:52am
View
That is not a solution and you are just restating a comment made an hour ago - waste of time.
Mycroft Holmes
25-Nov-13 4:08am
View
Nope - that is your job. Take a look through some of the examples, there are plenty around.
Mycroft Holmes
25-Nov-13 3:22am
View
You mark this question as ASP and are asking a question about a DataGridView - a winforms control. You need to clarify your requirement.
Mycroft Holmes
19-Nov-13 3:12am
View
Take this sort of discussion to the lounge - you will get a better viewing and response.
Mycroft Holmes
10-Nov-13 17:56pm
View
Whatyou have not mentioned is the UI you are using. Windows has a folder for AppData for everyuser on a windows machine and exposes that via the SpecialFolder enumeration, do some research into that area you will find the tools to meet your needs there.
Mycroft Holmes
10-Nov-13 7:25am
View
Usually you should use the AppData folder for the users, some systems will have the installation folder locked out. You can find it using SpecialFolders in the IO namespace
Mycroft Holmes
27-Oct-13 6:07am
View
It would seem reasonable to ask this on the Stimulsoft http://forum.stimulsoft.com/ forum!
Mycroft Holmes
12-Aug-13 23:20pm
View
Are you after information about a database? What database.
Or are you trying to retrieve data stored in the database?
Mycroft Holmes
12-Aug-13 23:18pm
View
Ok so you have thought of an idea, now try and think of the steps you needs to do this, when you run into a problem come back and ask a sensible question.
Mycroft Holmes
2-Aug-13 20:06pm
View
And some idiot down voted you answer!
Good for you getting the answer and even better for posting the solution. Personally I hate linq but ut is just too useful to ignore.
Mycroft Holmes
28-Jul-13 4:47am
View
You need to read the guidelines, asking for code is frowned upon, the goal is for you to learn how to do the work. There are sites such as rentacoder.com where you can get the code written for you.
Mycroft Holmes
23-Jul-13 1:32am
View
Delete and insert is faster than update under certain circumstances so the approach may not be invalid.
Mycroft Holmes
3-Jul-13 3:56am
View
Yuo must be a sock puppet for this ID http://www.codeproject.com/Answers/614920/how-to-export-xml-data-from-sql-to-xml-file-in-asp?cmt=472479#answer1
Mycroft Holmes
3-Jul-13 3:54am
View
Sorry that is your job, I have given you the pointers. Getting the XML data from the database is the same as getting any other type of data except you use ExecuteScalar to get a string variable instead of a dataset
Mycroft Holmes
30-Jun-13 22:28pm
View
First I would confirm that is is the actual export that is causing the timing blowout. Then I would get into Business Objects support forum and try and get an answer from them. This does not sound like a C# problem but a CR issue. The blowout does not surprise me as CR has had another 15 years of garbage development loaded into it and excel is somewhat more complex than in VB6 days so the export would be more convoluted.
Mycroft Holmes
28-May-13 4:11am
View
Why not try expanding on your question, there is not enough info there for anyone to help you. Vani took a guess at ASP, reasonable but you need to give us some more detail on what you are attempting.
Mycroft Holmes
18-Apr-13 2:15am
View
Certainly not, I refuse to help anyone who shouts and uses txt speak. Learn to be polite and use the keyboard! Besides Karthik has given you an excellent link by the looks of it
Mycroft Holmes
18-Apr-13 2:09am
View
Oops and you got shouted at hah hah!
Mycroft Holmes
18-Apr-13 2:06am
View
Looks Ok to me have you checked that your client is sending the information correctly - both must the tester and the employee ids must be sent from the client otherwise you are going to have to test to see if one of them is zero.
Mycroft Holmes
18-Apr-13 2:01am
View
Some sort of hint as to how you communicate with the machine would be useful. You can't just magic the information from there to you.
Mycroft Holmes
4-Apr-13 22:46pm
View
I don't have any MySQL experience so can't refute the indexing issue, 30sec is not unreasonable on a large database. Try changing the where clause.
Mycroft Holmes
4-Apr-13 22:31pm
View
Sorry I assume SQL Server. If you have no access to the database other than query then you are screwed, go back to your manager and make him optimise the query.
I have never used MySQL but after the indexing I would look into the where clause which seems to be converting a date to a string and then applying the filter I think it should be convert the string to a date and filter on the date data type.
Mycroft Holmes
18-Mar-13 7:17am
View
Your question shows such a fundamental lack of knowledge that I cannot answer the question. Get a book and start studying!
Mycroft Holmes
6-Mar-13 22:28pm
View
Wrong site me thinks!
Mycroft Holmes
6-Mar-13 2:43am
View
From whom do you wish to hide the properties.
Mycroft Holmes
5-Mar-13 20:29pm
View
This solution is only valid on a single user database.
Mycroft Holmes
4-Mar-13 4:10am
View
WAT then why are you creating a Parameter and adding it to the command. This MUST generate a sql error.
Mycroft Holmes
4-Mar-13 4:07am
View
Excellent, always good to know the help is appreciated.
Mycroft Holmes
4-Mar-13 3:55am
View
Presumably your parameter name is correctly formatted, your parameter value is a variable and is populated and passed in correctly and presumably you have debugged the code to check the procedure is called correctly and you have tested the procedure in SSMS with the parameter passed in.
Mycroft Holmes
4-Mar-13 0:43am
View
I actually have all these in a bunch of function but dammed if I was going to do the work for him!
Mycroft Holmes
28-Feb-13 1:23am
View
What error are you getting, if it is a security error you will need to take the app out of browser!
Mycroft Holmes
28-Feb-13 1:15am
View
Did you try asking
Google
?
Mycroft Holmes
22-Feb-13 2:34am
View
You will note that you are being ignored. This is because you are asking for the code and using txt speak. Show us what you have created and where and what the error is!
Mycroft Holmes
21-Feb-13 19:14pm
View
Well that was obvious, the variable is a string and you want to do a string function duh! You will need to change the int to a string to be able to use a string function on it (.Contains or LIKE).
Mycroft Holmes
25-Jan-13 2:10am
View
Read the guidelines and ask a question don't make a statement and expect someone to post the solution!
Mycroft Holmes
23-Jan-13 4:14am
View
search the articles, there are chat examples already available.
Mycroft Holmes
14-Jan-13 6:05am
View
Added a link to some info - looks like they support pretty much all platforms.
Mycroft Holmes
11-Jan-13 0:03am
View
Next time edit your post to improve it, multiple posting is irritating.
Mycroft Holmes
9-Jan-13 17:35pm
View
Well I wasn't rude or sarcastic which is my usual style for silly questions :)
Mycroft Holmes
9-Jan-13 2:55am
View
You are asking someone to explain a subject that has books written about it. Do some research, there is plenty of material out there.
Mycroft Holmes
9-Jan-13 2:52am
View
That is your job, if you post the errors you may get some help, asking someone else to do your job is counterproductive!
Mycroft Holmes
8-Jan-13 3:49am
View
Rather than a quick answer you should probably put this into the database discussion area you may get a better response.
Mycroft Holmes
20-Dec-12 3:23am
View
Well done now what are you going to do!
Mycroft Holmes
19-Dec-12 3:54am
View
You can't have even looked at the code, do some work and find out what the code does before rejecting it, you may need to only change 1 parameter from airport to railway for it to work.
Mycroft Holmes
19-Dec-12 3:51am
View
I start to believe you can find anything on the interweb! I was going to go with the sarcastic comment about writing the code to a CD and using the reflection to... but I didn't!
You get 5 from me!
Mycroft Holmes
5-Dec-12 3:09am
View
Listen to Andre, DON'T STORE YOUR DATE AS CHARACTER, this is one of the most basic errors you can make in database design. When you extract the DateTime data from the table is when you format it using the convert.
Mycroft Holmes
29-Nov-12 4:26am
View
You think you will get a different answer because you remove the reference to virus?
Mycroft Holmes
29-Nov-12 2:38am
View
You are not going to get an answer to this basically because it would be like a virus.
Mycroft Holmes
16-Oct-12 3:15am
View
Is there a reason you are reposting the same question repeatedly. Also the title should not be the entire question!
You have not asked a question, what problems are you encountering?
Mycroft Holmes
16-Oct-12 3:11am
View
You have not asked a question, what is the problem you are encountering? This is just a requirement list.
Mycroft Holmes
22-Jun-12 2:07am
View
See Griff's solution it is more detailed. If it fails the TryParseExact with the culture supplied then it is crappy data and you need to deal with it. Mapping the cultureinfo to a supplier is just work.
Mycroft Holmes
8-Jun-12 1:55am
View
codeBegin is right, these are just a set of interview questions. Do the minimum of research and get the answers.
Mycroft Holmes
9-Apr-12 3:49am
View
First create and test your stored procedure. Then in the job definition you can enter the name of the stroed procedure
Mycroft Holmes
19-Mar-12 1:52am
View
Try rentacode or Elance
Mycroft Holmes
6-Mar-12 3:42am
View
All you are doing is reading the file into a byte array, you now need to write it to the database. Try searching for an answer, this has been done many times and there are plenty of resources out there.
Mycroft Holmes
14-Feb-12 22:15pm
View
This must be a homework question. I have seen this asked multiple times this week.
Mycroft Holmes
14-Feb-12 2:50am
View
While I agree with the transaction, recommending a delete/insert scenario for a newbie is very dangerous. He may not be aware of related records that may be left orphaned.
Mycroft Holmes
13-Feb-12 22:14pm
View
Try searching the article for TreeView, your question is not specific enough to be useful.
Mycroft Holmes
13-Feb-12 3:55am
View
learn to use a keyboard, textspeak is not appreciated and should NEVER be used in an answer. We are trying to educate and help developers not devolve them.
Mycroft Holmes
13-Feb-12 3:53am
View
This is like the old support wheeze - try reinstalling the application. Garbage!
Mycroft Holmes
13-Feb-12 3:49am
View
Thats what I said without the links! I hate reposts.
Mycroft Holmes
13-Feb-12 3:14am
View
Don't repost the same question! I hate answering a question that already had an adequate response in it.
Mycroft Holmes
1-Feb-12 22:38pm
View
What is the database you are using?
Mycroft Holmes
11-Jan-12 1:20am
View
Deleted
Why do you people insist on an additional 'Mode' the ID value is more than adequate to tell me the record does not exist and needs inserting.
Mycroft Holmes
11-Jan-12 1:18am
View
Deleted
If you read the original I don't use mode, the mode comes in from a bunch of alternatives that I don't like either. So this is not an alternative.
Mycroft Holmes
30-Nov-11 2:19am
View
And for this you want a Quick Answer - I suggest you post this in the Design forum where it can better be discussed.
Mycroft Holmes
26-Nov-11 19:05pm
View
Deleted
Actually I agree with Rich, what is the point of the tip/trick, possibly to aggregate the link! Mind you I know of no other place to put this information.
Mycroft Holmes
24-Nov-11 17:52pm
View
Sure when you have a specific coding problem post it in Q&A, someone generally will help. The idea that 1 person is going to get involved in your coding issues is just not the way it works.
Mycroft Holmes
23-Nov-11 23:17pm
View
Two things, blogspot is blocked by our net nazi and I have my own work to do.
Mycroft Holmes
17-Nov-11 3:59am
View
You are going to have to try and state your question more clearly, it does not make sense at the moment.
Mycroft Holmes
19-Oct-11 6:51am
View
Sorry I don't have the time nor the inclination to do your work for you
Mycroft Holmes
19-Oct-11 3:07am
View
Yeah but SA your solution is typical MS, technically correct but absolutely useless (I need a smiley here).
Mycroft Holmes
18-Oct-11 3:30am
View
Ahm what are you expecting us to do to help.
Have you tested the query (procedure) in SSMS.
Have you then tried getting the data back in the client, you may be trying to get just too much data or you may have an infinte loop in you query!
Mycroft Holmes
18-Oct-11 3:25am
View
So name the ReportDataSource with the name it is asking for DataSet2_OnlineReports instead of OnlineReports. This is a typical undocumented black hole that gets us all!
Mycroft Holmes
18-Oct-11 2:18am
View
Does intellisense not work on your machine, try .items[index]. Just a guess.
It would also be useful to know what tech you are using, winforms, asp or other.
Mycroft Holmes
26-Sep-11 1:10am
View
Oh it was not intended as a sample, I was astonished at the complexity (never having even thought about it) of the requirements. This will not be an inconsequential project.
Mycroft Holmes
17-Aug-11 5:09am
View
Can you clarify - are you hoping to turn image files into text?
Mycroft Holmes
15-Aug-11 1:59am
View
Deleted
Does your method handle DBNull.Value for all the datatypes.
Mycroft Holmes
9-Aug-11 5:54am
View
You really should let us know whether you are using windows forms or asp or WPF/SL as the methods are very different.
Mycroft Holmes
30-Jul-11 20:41pm
View
Please try and show the correct methods. Using formatted strings to insert dates is not correct and you should promote parameterised queries. Read this article http://www.codeproject.com/KB/database/SqlInjectionAttacks.aspx
Mycroft Holmes
25-Jul-11 19:10pm
View
Deleted
There is a script floating aroun that will search the procs and functions for a substring, this will help locate the offending procs. The code that uses select * is a whole nuther problem.
Mycroft Holmes
25-Jul-11 6:59am
View
Don't be silly - he's asking you for the code!
Mycroft Holmes
25-Jul-11 2:15am
View
Please don't tell me your date data is stored as text values. If so then you URGENTLY need to change to the proper datetime format, if you don't then there is no way to help you.
Mycroft Holmes
25-Jul-11 1:56am
View
Sure you did and it is WRONG, try using dd-MMM-yyyy, the 3 cap Ms will force a text month into the query.
Mycroft Holmes
25-Jul-11 1:40am
View
What database are you using, you should not need formatting in a select statement.
Mycroft Holmes
24-Jul-11 18:57pm
View
I agree with Sharma's request, if you come up with a solution then an article or a tip/trick is justified!
Mycroft Holmes
24-Jul-11 18:54pm
View
So not only do you want the codz but you want it in your style of code. Read the guidelines, asking for the codz is frowned upon. Do a search for 101 Linq examples, it has been immensely useful to me.
Mycroft Holmes
24-Jul-11 6:45am
View
Get a book, find some tutorials and learn. Asking for the codz is the height of trollish behaviour.
Mycroft Holmes
22-Jul-11 20:48pm
View
Besides taking Daves advice and using parameterised queries I would change the field names to eliminate the spaces First Name should be changed to FirstName etc. This is the root cause of one of your problem and should be fixed in the table design.
Mycroft Holmes
10-Jul-11 19:05pm
View
I'd be astonished if there was a converter from foxpro programming to anything. I would expect you to have to rewrite the application from scratch. At least you have the working apop to reverse engineer.
Mycroft Holmes
26-Jun-11 8:04am
View
Question does not make sense, a CVS is a xaml representation of a data source, declare another CVS using the same datasource in the other class.
Mycroft Holmes
30-May-11 21:17pm
View
Deleted
Why not combine string.IsNullOrWhiteSpace instead of using regex
Mycroft Holmes
12-Apr-11 18:12pm
View
Deleted
What makes you think an update and an insert have different objectvies, I just want to write the data to the table, I don't care if there is an existing record or not. Why do you think overloads were invented?
Mycroft Holmes
5-Apr-11 1:16am
View
Deleted
I don't like combining the delete as the delete procs footprint only required the Id. Also a delete proc is often not required, updating a disabled flag is quite common.
Mycroft Holmes
5-Apr-11 1:10am
View
Deleted
I don't have any reason for separating the 2 methods
In the insert part I get the scope_identity() and return it to the client
Now this is a valid reason for 2 procs (the only one)
Created details would be done in the insert part of the proc.
Mycroft Holmes
26-Nov-10 22:50pm
View
Don't know why the OP didn't up vote this - an excellent answer.
Mycroft Holmes
24-Nov-10 3:06am
View
Typical troll posting - 1st post and it is designed to irritate the people who help here.
Be off with you foul TROLL
Mycroft Holmes
25-Oct-10 1:49am
View
What database are you using
Mycroft Holmes
24-Oct-10 20:05pm
View
So someone, the owner/developer of the code, has gone to some trouble and expense to secure their code and you are asking other developers how you can steal their code.
Please cosider yourself thoroughly insulted.
Mycroft Holmes
24-Oct-10 7:00am
View
Your powers of interpretive understanding are impressive, dammed if I could get that from the question!
Mycroft Holmes
27-Sep-10 4:33am
View
What exactly are you expecting, you need to decide on how you intend to handle exceptions.
Mycroft Holmes
8-Sep-10 2:29am
View
Are you looking for somewhere to backup your code? This seems to be a code dump without a question.
This forum is called Q&A, you ask a question and we try and answer it, we seem to be missing a fundamental part of that requirement.
Mycroft Holmes
8-Sep-10 2:27am
View
Are you looking for somewhere to backup your code? This seems to be a code dump without a question.
This forum is called Q&A, you ask a question and we try and answer it, we seem to be missing a fundamental part of that requirement.
Mycroft Holmes
12-Jun-10 4:46am
View
Sorry but I can't resist.
You want to use a graphics language to move a robotic arm from one location to another, I would think a truck would be more useful.
Mycroft Holmes
4-Jun-10 2:13am
View
Reason for my vote of 1
Try rentacoder.com they will be able to supply this service
Show More