15,896,154 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 YourAverageCoder (Top 41 by date)
YourAverageCoder
18-Sep-14 2:11am
View
Will do. Thanks.
YourAverageCoder
18-Sep-14 1:51am
View
Those values are from the database table i try to import to DestinationDatabase. When i enter the same command in SQL Server Studio, the Destination Database accepts it:
INSERT INTO DestinationDatabase.dbo.QvBranch ( BranchPK, BranchCode, BranchName, BranchIsCentral, BranchIsActive, DataState, DataTime, DataUserFK, DataID ) VALUES ( 'F8D4848B-E27C-4351-B8A4-6858A1147059','0000','New Department','0','0',NULL,NULL,NULL,NULL )
YourAverageCoder
17-Sep-14 4:19am
View
You're right.
YourAverageCoder
16-Sep-14 10:29am
View
Deleted
Using UPDATE, is it possible to specify row and column together? Like updating a specific row's specific column instead of updating all rows' specific column?
YourAverageCoder
16-Sep-14 6:26am
View
It helps a lot. Thanks.
YourAverageCoder
16-Sep-14 6:02am
View
That works but i need to know if cursors work inside a dynamic SQL Command.
YourAverageCoder
15-Sep-14 6:35am
View
You did awesome. Much thanks.
YourAverageCoder
15-Sep-14 5:13am
View
Yeah i got confused. Happens a lot.
YourAverageCoder
15-Sep-14 3:37am
View
Value but number would be nice too.
YourAverageCoder
15-Sep-14 3:36am
View
That's too generic. I need more specific stuff. The best select can offer is a specified column while i need specified row too.
YourAverageCoder
13-Sep-14 2:23am
View
I did.
YourAverageCoder
10-Sep-14 7:12am
View
No problem. Thanks for solution.
YourAverageCoder
10-Sep-14 7:01am
View
Deleted
I don't want data though just schema.
YourAverageCoder
10-Sep-14 2:20am
View
Because i will analyze the data for possible corruption.
YourAverageCoder
9-Sep-14 9:25am
View
I was just trying to fix the exception i get. I know you're right that code in itself is meaningless. It's just testing if i can use C# string variable with SQL statement as SqlCommand parameter. That's all.
YourAverageCoder
9-Sep-14 9:12am
View
Google first page tutorials all use Commands with SqlDataReader. It got stuck. You're right.
YourAverageCoder
9-Sep-14 9:09am
View
In SQL Server "USE <databasename> GO" contructs a batch that tells to use the said database name for every default action unless told otherwise. Like i can say "SELECT * FROM tableName" instead of "SELECT * FROM DatabaseName.dbo.tableName"
YourAverageCoder
9-Sep-14 9:06am
View
Nothing. I just want C# code to tell SQL Server to use the database i specify in DatabaseNameString.
YourAverageCoder
8-Sep-14 9:59am
View
For your second point i tried sp_executesql. Here's how i did it:
SET @dynamicSQLCommand = 'SELECT * FROM DestinationDatabase.dbo.@TableName'
EXEC sp_executesql @dynamicSQLCommand, N'@TableName nvarchar(500)', @TableName = @copiedTableName
Yet i still got the syntax error in first row of the code.
YourAverageCoder
6-Sep-14 1:33am
View
Much appreciated.
YourAverageCoder
5-Sep-14 10:03am
View
May i ask where can i find those tools?
YourAverageCoder
19-Aug-14 2:38am
View
It's gonna be moved from some remote server to my local server.
YourAverageCoder
23-Oct-13 2:26am
View
Thanks. I would have rated your answer but i can't since it's posted as a comment.
YourAverageCoder
25-Sep-13 11:01am
View
ValueClass class that has lots of string variables and properties.
YourAverageCoder
25-Sep-13 10:51am
View
No, it says it can't convert from some object to string[].
YourAverageCoder
25-Sep-13 10:39am
View
It's just a random code i made up. Obviously there are differences but i don't get them.
YourAverageCoder
3-Sep-13 5:39am
View
Yes, thanks.
YourAverageCoder
10-Jul-13 6:35am
View
Much appreciated.
YourAverageCoder
10-Jul-13 4:55am
View
a)Actually we are a group(should have specified that, sorry) and the commercial products on our field are rather unsatisfactory
b)I admit i didn't consider that but i assume at least 1 year or so
c)Wouldn't dongles come off rather expensive since you gotta provide 1 dongle for 1 customer each?
These are all important business decisions i will share with my employer thanks. But i still need those pointers in case we decide to pursue this course of action.
YourAverageCoder
19-Feb-13 3:08am
View
Windows x86.
I'm just experimenting to get a better grasp.
YourAverageCoder
18-Feb-13 9:24am
View
So it's possible. Thanks. I thought it wasn't possible because when i googled it, it didn't come up with anything relevant.
YourAverageCoder
15-Feb-13 6:44am
View
I pointed where it occurs. It starts with here : DeviceInfoTable = _SetupDiGetClassDevsUMPTR(&InterfaceClassGuid, NULL, NULL, DIGCF_PRESENT | DIGCF_DEVICEINTERFACE); But why would be good yes.
YourAverageCoder
14-Feb-13 9:51am
View
I tried C++ style class exporting but setupapi.dll functions kept giving me Runtime Check Failure 0 even though i went through all function calls, kept them the same while trying both __cdecl and __stdcall. I just gave up on that. That's why i am asking if it's possible before resoring to classless C type approach.
YourAverageCoder
14-Feb-13 9:42am
View
I updated the question based on your response. I hope it is more clear now.
YourAverageCoder
13-Feb-13 5:43am
View
Weird but it does start with an underscore, from C# example:
<pre lang="c#">
#pragma region DLL imports
//mpusbapi.dll içindeki USB fonksiyonları import ediliyor
[DllImport("MPUSBAPI.dll" , EntryPoint="_MPUSBGetDLLVersion")]
extern "C" DWORD MPUSBGetDLLVersion(void);
[DllImport("MPUSBAPI.dll" , EntryPoint="_MPUSBGetDeviceCount")]
extern "C" DWORD MPUSBGetDeviceCount(PCHAR pVID_PID);
[DllImport("MPUSBAPI.dll" , EntryPoint="_MPUSBOpen")]
extern "C" HANDLE MPUSBOpen(DWORD instance, // Input
PCHAR pVID_PID, // Input
PCHAR pEP, // Input
DWORD dwDir, // Input
DWORD dwReserved);// Input
[DllImport("MPUSBAPI.dll" , EntryPoint="_MPUSBClose")]
extern "C" BOOL MPUSBClose(HANDLE handle); //Input
[DllImport("MPUSBAPI.dll" , EntryPoint="_MPUSBRead")]
extern "C" DWORD MPUSBRead(HANDLE handle, // Input
PVOID pData, // Output
DWORD dwLen, // Input
PDWORD pLength, // Output
DWORD dwMilliseconds);// Input
[DllImport("MPUSBAPI.dll" , EntryPoint="_MPUSBWrite")]
extern "C" DWORD MPUSBWrite(HANDLE handle, // Input
PVOID pData, // Output
DWORD dwLen, // Input
PDWORD pLength, // Output
DWORD dwMilliseconds);// Input
[DllImport("MPUSBAPI.dll" , EntryPoint="_MPUSBReadInt")]
extern "C" DWORD MPUSBReadInt(HANDLE handle, // Input
PVOID pData, // Output
DWORD dwLen, // Input
PDWORD pLength, // Output
DWORD dwMilliseconds);// Input
</pre>
YourAverageCoder
11-Feb-13 4:27am
View
AtaClass.h the abstract interface header i want to include. The compiler gives me "cannot open source code 'AtaClass.h'" error even though they are under the same solution albeit different projects.
YourAverageCoder
7-Feb-13 2:45am
View
I want to turn a USB interaction C++/CLI code (with imports from MPUSAPI.dll, setupapi.dll, user32.dll) to DLL and use its functions.
YourAverageCoder
30-Jan-13 7:24am
View
VS 2010 Version 10.0.30319.1
.NET Framework Version 4.0.30319
In Visual C++ i got ATL, CLR, General, MFC, Test, Win32. I asked this because with Win32, you could choose dll in Application Wizard while CLR got no such option.
YourAverageCoder
30-Jan-13 4:57am
View
Hmm turns out mine is a native one. Any way to turn it to managed one? I don't want to deal with all headers. Thanks.
YourAverageCoder
30-Jan-13 4:50am
View
Targeted Framework is .NETFramework, Version=4.0 if that helps.
YourAverageCoder
30-Jan-13 4:41am
View
I don't know. All default i presume.
Show More