c++ 连接 sql server 2005

显示全部楼层 · 2014-9-28 20:06:53

1.提取单条记录/*#import "c:\Program Files\Common Files\System\ADO\msado15.dll" \no_namespace rename("EOF", "EndOfFile")*/CoInitialize(NULL);_bstr_t varSource="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%%0"; //*.mdb//_bstr_t varSource="Data Source=127.0.0.1;Initial Catalog=db2;User Id=;Password=;"_ConnectionPtr m_pConnection(_uuidof(Connection));m_pConnection->Open(varSource,"","",adModeUnknow);_RecordsetPtr m_pSet(_uuidof(Recordset));try {m_pSet->Open(%%1,m_pConnection.GetInterfacePtr()adOpenDynamic,adLockPessimistic,adCmdText);}catch(_com_error *e){{AfxMessageBox(e->ErrorMessage());return;}_variant_t var;CString %%2="";long fldc=m_pSet->GetFields()->GetCount();long i=0;try {m_pSet->MoveFirst();if(!m_pSet->adoEOF){for(i=0;iGetCollect((long)i);var.ChangeType(VT_BSTR);%%2+=var.bstrVal;%%2+=" ";}//m_pSet->MoveNext();}}catch(_com_error *e){AfxMessageBox(e->ErrorMessage());delete e;}//m_pSet->MoveFirst();CoUninitialize();7.执行命令/*#import "c:\Program Files\Common Files\System\ADO\msado15.dll" \no_namespace rename("EOF", "EndOfFile")*/if(m_pConnection==NULL) return;_variant RecordAffected;try{m_pConnection->Execute((_bstr_t)%%1,&RecordAffected,adCmdText);}catch(_com_error ce){//执行SQL失败}

千问 · 2014-9-28 20:06:53

1.连接字符串：Data Source=.;Initial Catalog=#;Integrated Security=True//其中“#”号用你想使用的数据库名代替。并且确保你想使用的数据库已经存在并且已附加好。2.读取：SqlConnection connection = new SqlConnection("Data Source=.;Initial Catalog=#;Integrated Security=True");//建立数据库连接String sql = String.Format("Select 要读取的列名 from 表名");//查询语句自己写了SqlCommand command = new SqlCommand(sql,connection);connection.Open();SqlDataReader read = command.ExecuteReader();while(read.Read()) //循环读取数据{ Console.WriteLine(read[0].ToString()); //打印所有读到的数据}read.Close();connection.Close();3.插入：SqlConnection connection = new SqlConnection("Data Source=.;Initial Catalog=#;Integrated Security=True");//建立数据库连接String sql = String.Format("Insert into 表名(列名1，列名2，列名N) values (值1，值2，值N)");//插入语句同样自己写SqlCommand command = new SqlCommand(sql,connection);connection.Open();command.ExecuteNonQuery();//用ExecuteNonQuery()方法执行插入语句， //他返回在数据库里受影响的行数(就是返回成功插入了几条记录),所以//可以判断command.ExecuteNonQuery()的值是否大于0来确定是否插入成功connection.Close();有点忙，没时间细说你自己多研究下。