电话记录管理的制作4（更改篇）

private void dataGridView1_DoubleCellClick(object sender, DataGridViewCellEventArgs e)
        {
            DialogResult result = MessageBox.Show("是否要修改当前行中单元格的内容?", "提示信息", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
            if (result == DialogResult.Yes)
            {
                Form4 form4 = new Form4();
                form4.Show();
                string headname = dataGridView1.Columns[e.ColumnIndex].Name.ToString();
                string keyname = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();
                string com = "select * from testtwo where ID = @keyname";
                //OleDbParameter head1 = new OleDbParameter(@headname, headname);
                DataSet rea = Sdatareader.dsmethod(com, new OleDbParameter(@keyname, keyname));
                DataRow dr = rea.Tables[0].Rows[0];
                form4.textBox1.Text = dr[dataGridView1.Columns[e.ColumnIndex].Name.ToString()].ToString(); //dr[]中直接放入字段发现不能执行
                form4.textBox2.Text = keyname;
                form4.textBox3.Text = headname;
            }
            //获取每个单元格的行与列
            //int i1 = e.ColumnIndex;
            //int i2 = e.RowIndex;
            //MessageBox.Show(string.Format("行{0},列{1}", i2, i1));
        }

获取行的ID并传给form4中的textbox

        public System.Windows.Forms.TextBox textBox3; //改动这里的private属性以便在form1中插入数据

将form4.designers.cs中进行修改方可传值

private void button1_Click(object sender, EventArgs e)
        {
            string headname = textBox3.Text.Trim();
            string text = textBox1.Text.Trim();
            string realdt = textBox2.Text.Trim();
            //string com = "UPDATE textno1 SET "+headname+" = "+text+" WHERE phone = ";
            string com = "UPDATE testtwo SET " + headname + " =@text WHERE ID =@realdt ";//一开始主键设置为日期后字段名字符串化，参数化均报错，如至少一个参数没有指定等~~
            //string com1 = com + realdt;
            //string com = "UPDATE textno1 SET '"+@headname+ "'= '"+@text+ " WHERE realdatetime = "+@realdt+"";
            //Sdatareader.enqmethod(com1);
            //Sdatareader.enqmethod(com,new OleDbParameter(@headname,headname),new OleDbParameter(@text,text),new OleDbParameter(@realdt,realdt));
            Sdatareader.enqmethod(com, new OleDbParameter(@text, text), new OleDbParameter(@realdt, realdt));
            MessageBox.Show("OK");
        }

form4中的按钮用于进行更改功能