private void btnquerycode_Click(object sender, EventArgs e)
 {
     try
     {
         string sql = string.Format("select * from Pinfo where P_CODE like '%{0}%'and P_info like '%{1}%'", cbCode.Text, txtinfo.Text);
         SqlHelper.GetReader(sql);
         List <Pinfo_class> info = new List <Pinfo_class>();
         foreach (Pinfo_class item in SqlHelper.GetReader(sql))
         {
             Pinfo_class pclass = new Pinfo_class()
             {
                 P_Code   = item.P_Code,
                 P_Info   = item.P_Info,
                 P_Answer = item.P_Answer
             };
             info.Add(pclass);
         }
         this.dataGridView1.DefaultCellStyle.WrapMode = DataGridViewTriState.True; //自动换行
         this.dataGridView1.DataSource = info;
     }
     catch (Exception ex)
     {
         MessageBox.Show("异常抛出\n" + ex, "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
 }
        private void btnSave_Click(object sender, EventArgs e)
        {
            if (txtcode.TextLength == 0)
            {
                MessageBox.Show("请输入错误代码!!", "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                this.txtcode.Focus();
                return;
            }
            else if (txtinfo.TextLength == 0)
            {
                MessageBox.Show("请输入错误提示信息!!", "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                this.txtinfo.Focus();
                return;
            }
            else if (txtanswer.TextLength == 0)
            {
                MessageBox.Show("请输入解决方法!!", "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                this.txtanswer.Focus();
                return;
            }

            List <Pinfo_class> info = new List <Pinfo_class>();

            Pinfo_class objinfo = new Pinfo_class()
            {
                P_Code   = txtcode.Text.Trim(),
                P_Info   = txtinfo.Text.Trim(),
                P_Answer = txtanswer.Text.Trim()
            };

            info.Add(objinfo);
            string sql = "";

            try
            {
                foreach (Pinfo_class item in info)
                {
                    sql = string.Format("insert into Pinfo VALUES(newID(),'{0}','{1}','{2}')", item.P_Code, item.P_Info, item.P_Answer);
                    int result = SqlHelper.Update(sql);
                }

                this.dataGridView1.DataSource = info;
            }
            catch (Exception ex)
            {
                MessageBox.Show("未能完成该操作" + ex, "错误信息");
            }
        }