15,886,518 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 Sprint89 (Top 19 by date)
Sprint89
3-Nov-14 11:50am
View
What do you mean by 'extract'? are you trying to get at the contents of a text file? Or shell out to a batch file perhaps?
Sprint89
18-Jul-14 4:19am
View
You could do it in dynamic SQL, get the number of records, build a string in a loop that would have that number of records, add a where clause and exec the string. Pretty ugly though
http://www.mssqltips.com/sqlservertip/1160/execute-dynamic-sql-commands-in-sql-server/
Sprint89
17-Jul-14 3:20am
View
What do you want the generated code to do?
Sprint89
3-Jul-14 3:29am
View
"First find days then calculate the months."
There are not a standard number of days in a month, it could be 28, 29, 30 or 31. That is why you need to consider month boundaries
Sprint89
1-Jul-14 3:30am
View
You will need a separate update query for each table, are you trying to use one update for more than one table?
Sprint89
27-Jun-14 6:05am
View
What is the error message?
Sprint89
26-Jun-14 9:25am
View
Try a netstat -a to see if anything else is blocking that port
Sprint89
26-Jun-14 3:26am
View
You don't seem to have included fn_executequerystring(); in the listing above
Sprint89
25-Jun-14 9:57am
View
But that is in your SQL code. If you want to do it that way you need to do the whole transaction, commit/rollback/error-handling in the one SqlCommand. The other way to do it (as in solution2) is to handle the transaction in VB
Sprint89
18-Jun-14 6:10am
View
Do you have a field in either the CRF_Project table or the CustomerList table that is called CreateYear? What happens if you use Create_Year?
Sprint89
17-Jun-14 10:15am
View
I don't think you can ping a port
Sprint89
13-Jun-14 10:14am
View
Are you trying to find, for each EmailID, the contiguous blocks of dates?
I.e. if there had been a record on 6/15/2014 for EmailID 2, your second and third lines in your results would be combined into
StartDate - EndDate EmailID
6/3/2014 - 6/16/2014 2
Sprint89
13-Jun-14 3:23am
View
Is it really being used by another process? If you run Unlocker on it, does it show something hanging on it - a copy process or something?
Sprint89
6-Jun-14 5:22am
View
Does a netstat show anything using that port?
Sprint89
30-May-14 6:27am
View
'Create' as in instantiate the Entry class and call the methods??? Like this:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;
namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
Entry entry = new Entry();
entry.Load();
entry.Save();
}
}
class Entry
{
public string Name { get; set; }
public IEnumerable<string> Emails { get; set; }
public void Save()
{
TextWriter tsw = new StreamWriter(@"C:\Emails.txt");
tsw.WriteLine(Name);
tsw.WriteLine();
foreach (string email in Emails)
{
tsw.WriteLine(email);
}
tsw.Close();
Process.Start(@"C:\Emails.txt");
}
public void Load()
{
TextReader trs = new StreamReader(@"C:\Emails.txt");
Console.WriteLine(trs.ReadToEnd());
trs.Close();
Console.WriteLine("Press any key to exit...");
Console.ReadKey();
}
}
static class Process
{
public static void Start(string path)
{
// Your Process.Start code here
}
}
}
Sprint89
30-May-14 6:00am
View
Are you asking how to call the Save and Load methods?
Sprint89
30-May-14 5:24am
View
if X = 7, why not
20 3 abc123 3
22 4 abc123 4
Sprint89
22-May-14 6:24am
View
I tried that on "Motin AS fahami.menu.ASIM AS SUVASISH" and got "SISH"
Sprint89
7-Mar-14 6:41am
View
Reason for my vote of 2 \n Lots of typos in code samples. Also missing code, doesn't run as is. I spent my time trying to get this to compile and run rather than follow the principles of the article
Show More