using namespace System;using namespace System::ComponentModel;using namespace System::Collections;using namespace System::Windows::Forms;using namespace System::Data;using namespace System::Drawing;using namespace System::Data::SqlClient;private: System::ComponentModel::IContainer^ components;private:/// <summary>/// 必需的設計器變量。/// </summary>String^st1;String^secn;SqlConnection^sqlc;SqlDataAdapter^sqld1;private: System::Void button1_Click(System::Object^ sender, System::EventArgs^ e) {st1=L"select * from KC where km like'"+textBox1->Text+"%";//%可通配任意字符，以實現對姓名的查詢secn=L"integrated security =SSPI;data source=.;initial catalog=da";sqlc=gcnew SqlConnection(secn);sqld1=gcnew SqlDataAdapter(st1,sqlc);//數據庫采用集成認證方式，數據源為本地數據庫，數據庫名為daSqlCommandBuilder^builder2=gcnew SqlCommandBuilder(sqld1);this->dataSet1->Clear();sqld1->Fill(dataSet1,"KC");this->bindingSource1->DataSource=this->dataSet1->Tables[1];//生成單表命令，以便對DataSet所做的更改與關聯(lián)的SQL Server數據庫的更改相協(xié)調}private: System::Void button2_Click(System::Object^ sender, System::EventArgs^ e) {this->sqld1->Update(dataSet1,"KC");sqlc->Close();