15,896,153 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 Python 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 Member 11820531 (Top 30 by date)
Member 11820531
31-Aug-16 14:48pm
View
Agreed, but not quite the answer I need :)
Member 11820531
31-Aug-16 9:39am
View
That works if the column is always the same length. I used one column and row as an example. But I need to split by ';' and '=' irrespective of length.
Member 11820531
3-Aug-16 17:46pm
View
EOMONTH is not recognized as a built in function on my DB. I'd have to change my database compatibility level. The solution for my problem was that I didn't make my query more selective in its creation. Thank you for your info! In hindsight, my question didn't fully encapsulate what I was trying to accomplish. So I didn't ask the correct question. Thanks again.
Member 11820531
3-Aug-16 15:09pm
View
That's more of a "after the fact approach". Ideally, I'd like to control re-seeding when my temp table is created and populated. I believe your solution is tied more towards a "permenent" table. Thanks for the info though!
Member 11820531
3-Aug-16 14:52pm
View
Deleted
Check this link out: http://www.codeproject.com/Tips/500811/Simple-Way-To-Use-Pivot-In-SQL-Query. Good luck!
Member 11820531
26-Apr-16 12:20pm
View
I could've swore that I tried that. Thanks for your solution!
Member 11820531
17-Dec-15 16:56pm
View
I should've known that, thank you!
Member 11820531
16-Sep-15 10:02am
View
No the example output was used only to illustrate how I want my results to look. Realistically, I am working with students, groups, and employees. (i.e. The line where I wrote: Please note the above results are not directly related to the SQL listed)
The code I pasted in there is also code that I am actually using. You probably don't understand my question as the information available to you is not enough for you to answer my question.
Thanks for your input.
Member 11820531
12-Aug-15 12:52pm
View
Either way I'll figure it out.
Member 11820531
12-Aug-15 12:52pm
View
I could see why people wouldn't want to help if it was a test, but you would never be able to know. I took the class to challenge myself and get an elective credit. It's an online class where the professor is difficult to get a hold of. I did really well in the beggining the material has gotten a lot more difficult.
Member 11820531
11-Aug-15 10:50am
View
That's the exact issue that I'm going through right now. I take it a test condition would consist of if else statement right? Sorry if my question seems elementary, I'm still learning the ins and outs of C#.
Member 11820531
7-Aug-15 11:35am
View
Sounds like a good idea. Would I then have 2 return statements for each connection string? I've add my current code that I'm using to return my first table.
From what I understand though, your saying: query both tables within the same method correct?
Member 11820531
4-Aug-15 18:40pm
View
The syntax and what each piece of code is doing. Take your example, I read it as: string.Split a new array of datatype Char. Split where there is an empty space. Is that what the code you posted is intended to do?
Member 11820531
31-Jul-15 16:01pm
View
I am not a system admin and cannot create my own linked server. Do you know of another to do this? I've also tried using sp_addlinkedserver code in t-sql.
Member 11820531
30-Jul-15 10:19am
View
I've attempted to use:
operationResult.Message += "Message" + Environment.NewLine; // still did not work
operationResult.Message += "Message" + "\r\n" // also did not work
Member 11820531
28-Jul-15 9:41am
View
Thanks for the feedback! I've tried the above approach but am still receiving the same output. However, when I debugged the page, I didn't see an instance where the code jumped to the FillControls() method. At this point, I think I may have to look for another solution or different route. Thanks again.
Member 11820531
22-Jul-15 11:16am
View
Thanks you, that way approaching this issue has helped!
Member 11820531
20-Jul-15 14:57pm
View
As of right now using the same code in your comment and in my op, the error reads cannot implicitly convert type 'int' to 'System.UI.Webcontrols.CheckBox'
Member 11820531
20-Jul-15 11:04am
View
Please see my response to the other question. (same question as yours)
Member 11820531
20-Jul-15 11:03am
View
I'm unsure because when I've debugged in the past it will highlight the line where the code fails. In this case the entire block of code I've posted is being highlighted. Correction just the first block is being highlighted. The check result code and //Hid progress indicator code is not highlighted.
Member 11820531
9-Jul-15 10:38am
View
Thanks that works for debugging purposes. I know for sure the connection string is working fine and result is being set = to 0. However, I'm still getting the exception thrown and my IsDisabled field is not being updated. Thanks for the code though it helped confirm that some things are acting as I want.
Member 11820531
8-Jul-15 17:19pm
View
That may have work but I found a work around a small time before that. My changes are visible in the revised code in my original post. I'm now focusing on fixing a Format Exception Error. Thanks for your feedback!
Member 11820531
8-Jul-15 16:29pm
View
That would explain why i'm getting an error. Thanks.
Member 11820531
8-Jul-15 12:17pm
View
Do you mind providing a brief snippet of how I could put GetInteger() into a variable, for debugging purposes?
Member 11820531
8-Jul-15 11:58am
View
Your solution worked. Thank you, I appreciate your feedback. I'll also be sure to look into the links you've included.
Member 11820531
8-Jul-15 11:47am
View
The issue is in my last block of code. What I was trying to do was pass the same parameter values that were passed when the method was initially created. The commonsvc class holds the 1st and original method using the same parameters.
Member 11820531
7-Jul-15 18:25pm
View
You were correct, my connection string was being implemented incorrectly. Thank you, I've now fixed my error.
Member 11820531
7-Jul-15 17:49pm
View
@j snooze you are correct they should match, thank you. However, I'm still getting a NullReferenceException Thrown.
Member 11820531
7-Jul-15 17:45pm
View
I have debugged it and received the error posted in the title. If it is a problem with my GetConnectionString function, is there something specific that you would recommend? Thanks for the feedback.
Member 11820531
7-Jul-15 17:37pm
View
Deleted
Yes I believe I can debug the application, that's how I found where the exception is being thrown. As for the ConnectionTypeID, I'm not sure if it's related, but when I select @@Identity I'm essentially trying to pull the ConnectionTypeID.
Show More