MFC ADO连接数据库有关问题啊
MFC ADO连接数据库问题啊!~急!
CoInitialize(NULL);
_ConnectionPtr pConn(__uuidof(Connection));
_RecordsetPtr pRst(__uuidof(Recordset));
pConn->ConnectionString="Provider=SQLOLEDB.1;Password=admin;Persist Security Info=True;User ID=sa;Initial Catalog=ziran;Data Source=PC-201003061855\GSQL";
pConn->Open("","","",adConnectUnspecified);
pRst=pConn->Execute("select * from t_name",NULL,adCmdText);
//(_bstr_t)pRst->GetCollect("name");
m_list.InsertColumn(0,"商品编号");
m_list.InsertColumn(1,"商品名称");
//获取列表的宽度
RECT rect;
m_list.GetWindowRect(&rect);
int wid=rect.right-rect.left;
//为你的每列分宽度
m_list.SetColumnWidth(0,wid/4);
m_list.SetColumnWidth(1,3*wid/4);
m_list.SetExtendedStyle(LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT|LVS_EX_HEADERDRAGDROP);
m_list.InsertItem(0,"");
m_list.SetItemText(0,0,(_bstr_t)pRst->GetCollect("name"));
pRst->Close();
pConn->Close();
pRst.Release();
pConn.Release();
CoUninitialize();
编译通过 运行后 点击这个!~直接程序卡死!~请高手帮忙看下哪的问题!~
------解决方案--------------------
先单步执行一下,看看死在哪里了,
------解决方案--------------------
那个Data Source=PC-201003061855\GSQL,改成这个试试看Data Source=PC-201003061855\\GSQL
中间是两个反斜杠
------解决方案--------------------
Data Source=PC-201003061855\\GSQL
CoInitialize(NULL);
_ConnectionPtr pConn(__uuidof(Connection));
_RecordsetPtr pRst(__uuidof(Recordset));
pConn->ConnectionString="Provider=SQLOLEDB.1;Password=admin;Persist Security Info=True;User ID=sa;Initial Catalog=ziran;Data Source=PC-201003061855\GSQL";
pConn->Open("","","",adConnectUnspecified);
pRst=pConn->Execute("select * from t_name",NULL,adCmdText);
//(_bstr_t)pRst->GetCollect("name");
m_list.InsertColumn(0,"商品编号");
m_list.InsertColumn(1,"商品名称");
//获取列表的宽度
RECT rect;
m_list.GetWindowRect(&rect);
int wid=rect.right-rect.left;
//为你的每列分宽度
m_list.SetColumnWidth(0,wid/4);
m_list.SetColumnWidth(1,3*wid/4);
m_list.SetExtendedStyle(LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT|LVS_EX_HEADERDRAGDROP);
m_list.InsertItem(0,"");
m_list.SetItemText(0,0,(_bstr_t)pRst->GetCollect("name"));
pRst->Close();
pConn->Close();
pRst.Release();
pConn.Release();
CoUninitialize();
编译通过 运行后 点击这个!~直接程序卡死!~请高手帮忙看下哪的问题!~
------解决方案--------------------
先单步执行一下,看看死在哪里了,
------解决方案--------------------
那个Data Source=PC-201003061855\GSQL,改成这个试试看Data Source=PC-201003061855\\GSQL
中间是两个反斜杠
------解决方案--------------------
Data Source=PC-201003061855\\GSQL