microsot visual studio 2005 连接数据库的图片操作.docVIP

实验四 建立项目shiyan4 在解决方案资源管理器中，shiyan4上点右键，选择添加—新建项 在弹出的窗口中选择数据(基于服务的数据库，点击添加，然后点击完成 在菜单栏视图中打开服务器资源管理器，在“表”上点击右键，选择添加新表 5.按下图新建一个表并在行前点击右键来设置主键，点击保存 并输入一个表名 在刚才新建的表上点击右键，选择显示表数据 在表中输入如下的数据并保存 点击菜单数据(显示数据源，在database1dataset上点击右键选择使用向导配置数据集，选中表，点击完成 点击菜单生成—生成解决方案，会在工具箱中生成新的控件，在解决方案资源管理器中生成链接字符串 9.在界面上添加一个datagridview控件和一个button 添加命名空间引用 using System.Data.SqlClient; 10.给form1类添加两个变量 SqlDataAdapter adapter; DataTable table; 11.给Form1添加一个Form1_Load事件，事件中添加代码如下 string connStr = Properties.Settings.Default.Database1ConnectionString;//连接字符串 SqlConnection conn = new SqlConnection(connStr);//建立到数据库的连接 adapter = new SqlDataAdapter(select * from Table1, conn); SqlCommandBuilder builder = new SqlCommandBuilder(adapter); adapter.InsertCommand = builder.GetInsertCommand(); adapter.DeleteCommand = builder.GetDeleteCommand(); adapter.UpdateCommand = builder.GetUpdateCommand(); table = new DataTable(); adapter.Fill(table); dataGridView1.DataSource = table; 12.给按钮save添加一个click事件响应函数，添加如下代码 adapter.Update(table); 作业，做一个如shiyan4_2.exe的小程序，输入一个姓名，点击查询 、 在修改后可以保存 practice activities implementation programme, and XX town party leadership party of mass line education practice activities rectification programme, and XX town carried out four wind aspects highlight problem special regulation implementation programme and XX town system construction plans,. One is to pay special attention to education. A party Lecture with 71 for all party members and cadres education, organizations watch anti-corruption warning education propaganda, promoting seven special and 9+1+X problems of rectification, Enhance the awareness of all the party members and cadres and the sense, honesty in politics and corruption of immunity. Second, well check the urge. Efforts to increase the annual implementation of the supervision to ensure completion of the variou