|
I am using Sql SErver 2000 Database and I begin to work with Visual c++ Net 2005;
How to to write SqlCommand::Connection to connect to SQl server 2000 in Visual c++ net 2005
I learn my self
|
|
|
|
|
I see you have lots of Database development questions. Lucky for you there are a massive number of Database Articles here on CodeProject. Use the Navigation mechanisms on the site to find the Database Articles and look through them. I am sure the information you seek is in there.
|
|
|
|
|
In addition to led mike's reply, I think it's important to consult the documentation for the
platforms/systems/etc. that you're wanting to develop for.
For example, to connect to SQL Server, you'll probably want to use the SQL Native Client.
Connection string info can be found here: Using Connection String Keywords with SQL Native Client[^]
Mark
"Go that way, really fast. If something gets in your way, turn."
|
|
|
|
|
String^ strConnection;
String^ strString;
SqlConnection^ cprl = gcnew SqlConnection();
cprl->ConnectionString = "Persist Security Info=False;Integrated Security=SSPI;database=payroll05;server=SEM1;Trusted_Connection=Yes;" ;
cprl->Open();
|
|
|
|
|
Does that work? 
Mark
"Go that way, really fast. If something gets in your way, turn."
|
|
|
|
|
|
I am using Visual C++ NET 2005.
I want to know how to execute a query with parameters in my program
I learn my self
|
|
|
|
|
String^ strConnection;
String^ strString;
SqlConnection^ cprl = gcnew SqlConnection();
cprl->ConnectionString = "Persist Security Info=False;Integrated Security=SSPI;database=payroll05;server=SEM1;Trusted_Connection=Yes;" ;
// connectionString="Persist Security Info=False;Integrated Security=SSPI;database=Northwind;server=(local);"
// providerName="System.Data.SqlClient"
cprl->Open();
SqlCommand^ Cmd = gcnew SqlCommand();
Cmd->CommandText = "insert into barimpot(taux,minr,maxr)values(@taux ,@minr ,@maxr)";
SqlParameter^ para = gcnew SqlParameter();
para->SqlDbType = SqlDbType::Int;
para->ParameterName = "@taux";
para->Value = this->taux->Text::get();
Cmd->Parameters->Add(para);
SqlParameter^ param = gcnew SqlParameter();
param->SqlDbType = SqlDbType::Decimal;
param->ParameterName = "@minr";
param->Value = this->borneinf->Text::get();
Cmd->Parameters->Add(param);
SqlParameter^ parai = gcnew SqlParameter();
parai->SqlDbType = SqlDbType::Int;
parai->ParameterName = "@maxr";
parai->Value = this->bornesup->Text::get();
Cmd->Parameters->Add(parai);
Cmd->CommandType = CommandType::Text;
Cmd->Connection = cprl;
// ::MessageBox::Show("okkk2");
Cmd->ExecuteNonQuery() ;
|
|
|
|
|
Hi,
What does MVPs mean.
VIBIN
"Fool's run away,where angle's fear to tread"
|
|
|
|
|
|
...and in sports, it's a Most Valuable Player.
I wonder if that's the same for Code Project MVPs?
Or is it Most Valuable Person, Professional,...
"Go that way, really fast. If something gets in your way, turn."
|
|
|
|
|
hi,
how can i construct an Image ( to be passed to a Graphics object later ) from a memory a buffer ?
lets say a loaded GIF file in a char * buffer
Thanks in advance
A.Barakat
|
|
|
|
|
A.Barakat wrote: lets say a loaded GIF file in a char * buffer
Don't do that. Load it into an Image type.
|
|
|
|
|
If you choose to ignore led mike's advice...
I think you could store in a MemoryStream and use Image.FromStream() to create the object later.
I'm not sure why though
Mark
"Go that way, really fast. If something gets in your way, turn."
|
|
|
|
|
Hello,
I have an MFC application that i would like to mix with Managed C++.
I changed the compiler settings and everything compiles fine.
For the moment I did not write any managed code but I have the message as follows at execution:
"An unhandled exception of type 'System.TypeLoadException' occurred in ApplicationName.exe
Additional information: Could not load type _TREEITEM from assembly ApplicationName, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null."
This message occurs before execution of the function that returns a pointer.
I have put a breakpoint in it but it is never called.
I think it is unmanaged pointer problem because I have modified the function to return a reference to CWnd and everything was Ok.
below is the code snipped, Could please help me because I am 100% newbee with C++/CLI
Declaration
private:
CWnd* m_pView;
CWnd* CreateTreeView();
Definition
BnBPaneView::BnBPaneView():m_pView(NULL){}
int BnBPaneView::OnCreate(LPCREATESTRUCT lpCreateStruct)
{
if (CWnd::OnCreate(lpCreateStruct) == -1)
return -1;
m_pView = CreateTreeView();
etc..
.
.
.
}
|
|
|
|
|
i don't see anything involving managed code at all here so I'm not sure how the problem could
be with unmanaged pointers.
BnBPaneView is an unmanaged class, right (derived from an MFCclass)?
Mark
"Go that way, really fast. If something gets in your way, turn."
|
|
|
|
|
Yes it is unmanaged, derived from CWnd:
class BnBPaneView : public CWnd
Actually all what I have done is to change the compiler settings recommended in the MSDN:
Use managed extensions = yes
Enable minimum Rebuild = no
basic runtime checks = default
And before changing those settings, the application was working fine.
|
|
|
|
|
|
Does that mean that those who want to mix their applications must specify #pragma unmanaged before all their functions that are implemented with native code?
It is a hudge work to pass through thousands of functions.
While reading some articles on the subject, I understood that thanks to JIW ( just it works), there is nothing to do except changing the compiler settings.
And regarding MFC applications, following directives
#using <mscorlib.dll>
#using <system.windows.forms.dll>
using namespace System;
using namespace System::Windows::Forms;
are to be added in the stdafx.h file.
|
|
|
|
|
Arris7 wrote: While reading some articles on the subject, I understood that thanks to JIW ( just it works), there is nothing to do except changing the compiler settings.
That's correct.
Arris7 wrote: Does that mean that those who want to mix their applications must specify #pragma unmanaged before all their functions that are implemented with native code?
No. You can, but it's not necessary. If you decide to use #pragma unmanaged/unmanaged, they
effect code from that point on, until another is encountered, or the end of file is reached.
That means they only need to be at the top of a source file (under the #includes), not around
every function. This worked well for me going from a large MFC code base to adding managed
code. That also means you can mix native/CLR compilation in the same source file.
Arris7 wrote: And regarding MFC applications, following directives
#using
#using
using namespace System;
using namespace System::Windows::Forms;
are to be added in the stdafx.h file.
I suppose you could put those in the precompiled header. I'm not sure what most people do.
I personally include just the ones I need on a per-.cpp/.h file basis, especially with namespaces.
Did the TreeView struct stuff work out ok?
Mark
"Go that way, really fast. If something gets in your way, turn."
|
|
|
|
|
Mark,
Thank you so much for those great details, I have added #pragma unmanaged on the top of all my classes under #include. Now it compiles and execute very fine.
I just noticed that compilation and buid process has slow down.
This time I agree it is JIW;)
|
|
|
|
|
You're welcome! I hope I could help.
The only real slowdown I've noticed is when starting mixed-mode apps in the debugger
Cheers!
Mark
"Go that way, really fast. If something gets in your way, turn."
|
|
|
|
|
Why does te following C++ code flag error?
# include <iostream.h>
const int i=10;
void main()
{
const int i = 20;
cout << i << endl << ::i;
cout << &i;
}
The error flagged is "Illegal structure operation in main"
Compiler use : Borland C++ 4.5
How can I access the address of the local and global constant 'i's?
Please help me.
Thanks,
Biju
|
|
|
|
|
This is the C++/CLI forum. Borland C++ 4.5 does not do C++/CLI, nor is this snippet using managed extensions. Try the visual C++ forum.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hello,
How can i create an Image object from the standard output , basicly i want to do the following :
1 - redirect the stdout stream to anything else.
2 - create an IStream.
3 - create an Image from the IStream.
Thanks in advance.
A.Barakat
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
