從Form中textBox中讀取數(shù)據(jù)存入數(shù)據(jù)庫
using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Windows.Forms;using System.Data.SqlClient;namespace addStaffInfo{ public partial class Form1 : Form { public Form1() { InitializeComponent(); } PRivate void label2_Click(object sender, EventArgs e) { } private void label4_Click(object sender, EventArgs e) { } private void textBox5_TextChanged(object sender, EventArgs e) { } private void button2_Click(object sender, EventArgs e) { this.Close(); } private void button1_Click(object sender, EventArgs e) { string str= "Data Source = YANG*****; Initial Catalog = appDB; Integrated Security = True"; SqlConnection myConn =new SqlConnection(str); myConn.Open(); string sqlStr=" insert into Table_1(姓名,電話,銀行卡卡號,開戶地址,備注) values('"+textBox1.Text.ToString()+"','"+textBox2.Text.ToString()+ "','" + textBox3.Text.ToString() + "','" + textBox4.Text.ToString() + "','" + textBox5.Text.ToString() + "') "; SqlCommand myCmd = new SqlCommand(sqlStr, myConn); int i= myCmd.ExecuteNonQuery();//受影響的行數(shù) MessageBox.Show(i.ToString()); myConn.Close(); } private void textBox6_TextChanged(object sender, EventArgs e) { } private void textBox7_TextChanged(object sender, EventArgs e) { } private void Form1_Load(object sender, EventArgs e) { } }}新聞熱點(diǎn)
疑難解答
