我用以下代码添加数据到数据库内
private void addButton_Click(object sender, System.EventArgs e)
{
string strSQL = "INSERT INTO userTable (QQName,ftpName,ftpPwd,userDomain,regTime) VALUES (";
strSQL+=this.qqNameTextBox.Text+","+this.ftpNameTextBox.Text+","+this.ftpPwdTextBox.Text+","+this.domainTextBox.Text+",#"+System.DateTime.Today+"#)";
OleDbConnection myConn = new OleDbConnection(strDSN);
// 实例化OleDbCommand对象
OleDbCommand myCmd = new OleDbCommand(strSQL, myConn);
// 打开数据库,执行插入SQL语句 myConn.Open();
myCmd.ExecuteNonQuery();
MessageBox.Show("数据添加成功");
}控件中输入纯数字的就能添加,但输入字母就不能添加,数据库中字段类型是文本型,不知道为什么,求解!
private void addButton_Click(object sender, System.EventArgs e)
{
string strSQL = "INSERT INTO userTable (QQName,ftpName,ftpPwd,userDomain,regTime) VALUES (";
strSQL+=this.qqNameTextBox.Text+","+this.ftpNameTextBox.Text+","+this.ftpPwdTextBox.Text+","+this.domainTextBox.Text+",#"+System.DateTime.Today+"#)";
OleDbConnection myConn = new OleDbConnection(strDSN);
// 实例化OleDbCommand对象
OleDbCommand myCmd = new OleDbCommand(strSQL, myConn);
// 打开数据库,执行插入SQL语句 myConn.Open();
myCmd.ExecuteNonQuery();
MessageBox.Show("数据添加成功");
}控件中输入纯数字的就能添加,但输入字母就不能添加,数据库中字段类型是文本型,不知道为什么,求解!
strSQL+=this.qqNameTextBox.Text+"','"+this.ftpNameTextBox.Text+"','"+this.ftpPwdTextBox.Text+"','"+this.domainTextBox.Text+"',#"+System.DateTime.Today+"#)";
'"+this.ftpNameTextBox.Text+"'