為什么我的資料庫總是只能接收第一個資料而已，后面提供的資料都寫不進資料庫里面
private void timer1_Tick(object sender, EventArgs e)
{
if (this.Receive_TextBox.Text != "")
{ Insert(); }
}
SqlDataAdapter sda;
SqlDataAdapter sda1;
public void Insert()//將資料寫入資料庫
{
try
{ //截取字串
string str = this.Receive_TextBox.Text.Trim().ToString();
string s = str.Substring(str.Length-8, 8);
SqlConnection conn = new SqlConnection(@"Server=PC-20161210PXBA\SQLEXPRESS;database=HM;uid=sa;pwd=");
conn.Open();
string str_sql = "insert into Sing(AttendanceDate,Attendancein,Attendanceout,ICcard) "
+ "values(@AttendanceDate,@Attendancein,@Attendanceout,@ICcard)";
SqlCommand cmd1 = new SqlCommand(str_sql, conn);
//SqlParameter parn2 = new SqlParameter("@EmployeeNo","");
//cmd1.Parameters.Add(parn2);
//SqlParameter parn1 = new SqlParameter("@EmployeeName","" );
//cmd1.Parameters.Add(parn1);
SqlParameter parn = new SqlParameter("@ICcard", s);
cmd1.Parameters.Add(parn);
SqlParameter parn3 = new SqlParameter("@AttendanceDate", dateTimeAttendDate.Value.ToString("yyyy-MM-dd ") + comboAttendIn.Text.Trim().ToString());
cmd1.Parameters.Add(parn3);
SqlParameter parn4 = new SqlParameter("@Attendancein", comboAttendIn.Text.Trim().ToString());
cmd1.Parameters.Add(parn4);
SqlParameter parn5 = new SqlParameter("@Attendanceout", comboAttendOut.Text.Trim().ToString());
cmd1.Parameters.Add(parn5);
// SqlParameter parn6 = new SqlParameter("@queqin", "");
//cmd1.Parameters.Add(parn6);
cmd1.ExecuteNonQuery();
conn.Close();
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/51999.html
標籤：數據庫及相關技術
上一篇：求助(c++)
下一篇：DEV單步跟蹤二叉樹的創建問題