private void button3_Click(object sender, EventArgs e) { string str = @"Data Source=KOTO;Initial catalog=K;integrated Security=True "; SqlConnection conn = new SqlConnection(str); conn.Open(); string selectsql = "TRUNCATE TABLE Message"; SqlCommand cmd = new SqlCommand(selectsql, conn); cmd.CommandType = CommandType.Text; SqlDataReader sdr; sdr = cmd.ExecuteReader(); conn.Close(); for (int i = 0; i < dataGridView1.Rows.Count; i++) { string str2 = @"Data Source=KOTO;Initial catalog=K;integrated Security=True "; SqlConnection conn2 = new SqlConnection(str2); conn2.Open(); string StudentName = dataGridView1.Rows[i].Cells[0].Value.ToString(); string Tel = dataGridView1.Rows[i].Cells[1].Value.ToString(); string StudentSex = dataGridView1.Rows[i].Cells[2].Value.ToString(); string StudentBirthday = dataGridView1.Rows[i].Cells[3].Value.ToString(); string StudentQQ = dataGridView1.Rows[i].Cells[4].Value.ToString(); string Homeaddress = dataGridView1.Rows[i].Cells[5].Value.ToString(); string Email = dataGridView1.Rows[i].Cells[6].Value.ToString(); string Job = dataGridView1.Rows[i].Cells[7].Value.ToString(); string selectsql2 = "insert into Message values('" + StudentName + "','" + Tel + "','" + StudentSex + "','" + StudentBirthday + "','" + StudentQQ + "','" + Homeaddress + "','" + Email + "','" + Job + "')"; SqlCommand cmd2 = new SqlCommand(selectsql2, conn2); cmd2.CommandType = CommandType.Text; SqlDataReader sdr2; sdr2 = cmd2.ExecuteReader(); conn2.Close(); } check a = new check(); a.Show(); }
private void button1_Click(object sender, EventArgs e) { if (name.Text == "" || Tel.Text == "" || sex.Text == "" || QQ.Text == "" || address.Text == "" || Email.Text == "" || job.Text == "") { M.Text = "有未输入的项目"; } else { if (radioButton1.Checked) { sex.Text = "男"; } else if (radioButton2.Checked) { sex.Text = "女"; } string str = @"Data Source=KOTO;Initial catalog=K;integrated Security=True "; SqlConnection conn = new SqlConnection(str); conn.Open(); string selectsql = "insert into Message values('" + name.Text + "','" + Tel.Text + "','" + sex.Text + "','" + dateTimePicker1.Value.Date.ToString("yyyy.mm.dd") + "','" + QQ.Text + "','" + address.Text + "','" + Email.Text + "','" + job.Text + "')"; SqlCommand cmd = new SqlCommand(selectsql, conn); cmd.CommandType = CommandType.Text; SqlDataReader sdr; sdr = cmd.ExecuteReader(); conn.Close(); name.Text = ""; QQ.Text = ""; address.Text = ""; Tel.Text = ""; job.Text = ""; Email.Text = ""; check a = new check(); a.Show(); } }