datagirdview和listview,删改查sqlserver数据库的小结

概述        //创建DBhelper数据库链接文件         private static string sqlcon = "server=.;database=myschool;uid=sa;pwd=sa";         public static SqlConnection connection = new SqlConnection(sqlcon); =============

        //创建DBhelper数据库链接文件

        private static string sqlcon = "server=.;database=myschool;uID=sa;pwd=sa";
        public static sqlConnection connection = new sqlConnection(sqlcon);
============================================================

 

            //首先是lv控件的列表显示,(ListvIEw)

            // 清空当前lv表中内容

            ListvIEw.Items.Clear();
            string sql = "select * from question";

            //引用DBhelper中的数据库链接
            sqlCommand command = new sqlCommand(sql,DBhelper.connection);

            //打开数据库,并用dr读取记录
            DBhelper.connection.open();
            sqlDataReader dr = command.ExecuteReader();
            while (dr.Read())
            {
                ListVIEwItem lvi = new ListVIEwItem(dr["Question"].ToString());
                lvi.SubItems.AddRange(new string[] { dr["Answer"].ToString(),dr["Difficulty"].ToString(),dr["SubjectID"].ToString(),dr["OptionA"].ToString(),dr["OptionB"].ToString(),dr["OptionC"].ToString(),dr["OptionD"].ToString() });

                //把questionID数据库索引列保存到tag中
                lvi.Tag = dr["questionID"].ToString();
                lv_biao.Items.Add(lvi);

            } dr.Close();
            DBhelper.connection.Close();

-------------------------------------------------------------------------------------------------------

            //lv控件删除 *** 作和修改差不多,只需要替换掉SQL语句即可(ListvIEw)

            //首先信息框询问是否确定删除 *** 作

            if (MessageBox.Show("确定是否删除?","提示",MessageBoxbuttons.OKCancel,MessageBoxIcon.Question) == DialogResult.OK)
            {
                string sql = string.Format("delete question where questionID = {0}",lv_biao.SelectedItems[0].Tag);
                sqlCommand command = new sqlCommand(sql,DBhelper.connection);
                DBhelper.connection.open();
                int num = command.ExecuteNonquery();
                if (num == 1)
                {
                    MessageBox.Show("删除成功");
                }
                DBhelper.connection.Close();
            }

===========================================================

        //dgv控件的列表显示

        //定义声明好dataadapter,和dataset

        private static sqlDataAdapter da;
        private static DataSet ds = new DataSet();

 

-------------------------------------------------------------------------------------

        //查询按钮下加入如下代码,先清空dataset中的数据(datagrIDvIEw)
            ds.reset();
            string sql = "select questionID,question,answer,difficulty,subjectID,optiona,optionb,optionc,optiond from question";
            da = new sqlDataAdapter(sql,DBhelper.connection);

            //dataadapter填充dataset中的数据
            da.Fill(ds,"test");
            dgv_biao.DataSource = ds.tables["test"];
 --------------------------------------------------------------------------------------------          
         //datagrIDvIEw中的修改,删除如下,修改只要直接改表格中的数据即可

            dgv_biao.Rows.RemoveAt(dgv_biao.SelectedRows[0].Index);
-------------------------------------------------------------------------------------------------------       

         //把删除或修改后的 *** 作提交到数据库中(才真正执行 *** 作,注意数据库中要有主键在dgv中)
            sqlCommandBuilder scb = new sqlCommandBuilder(da);
            da.Update(ds,"test");
----------------------------------------------------------------------------------------------------------------

ps:插入数据部分先省了~有需要的留言...呵呵

总结

以上是内存溢出为你收集整理的datagirdview和listview,删改查sqlserver数据库的小结全部内容，希望文章能够帮你解决datagirdview和listview,删改查sqlserver数据库的小结所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。