sql语句如下
sqlstr="insert into position(ptname,ptnumber,ptsalary,ptaddress,ptdetail.ptsex,ptage,ptdegree,ptexperice) values('"+TextBox1.Text.ToString()+"','"+TextBox2.Text.ToString()+"','"+TextBox3.Text.ToString()+"','"+TextBox4.Text.ToString()+"','"+TextBox6.Text.ToString()+"','"+DropDownList1.SelectedItem.Text.ToString()+"','"+TextBox5.Text.ToString()+"','"+DropDownList2.SelectedItem.Text.ToString()+"','"+TextBox7.Text.ToString()+"')";
sqlstr="insert into position(ptname,ptnumber,ptsalary,ptaddress,ptdetail.ptsex,ptage,ptdegree,ptexperice) values('"+TextBox1.Text.ToString()+"','"+TextBox2.Text.ToString()+"','"+TextBox3.Text.ToString()+"','"+TextBox4.Text.ToString()+"','"+TextBox6.Text.ToString()+"','"+DropDownList1.SelectedItem.Text.ToString()+"','"+TextBox5.Text.ToString()+"','"+DropDownList2.SelectedItem.Text.ToString()+"','"+TextBox7.Text.ToString()+"')";
ptdetail.ptsex
.号应该是,吧
sql.Append("insert into mx_bbs(name_id,name,type,content,farther_id,datatime,fujian_name,fujian_true_namem,fujian_name2,fujian_true_name2) values('");
sql.Append(idd + "','");
sql.Append(dt.Rows[0]["name"] + "','");
sql.Append(dt.Rows[0]["bumen"] + "','");
sql.Append(textarea.Text + fujian + "','");
sql.Append(fujian + fujian2 + "',");
sql.Append(id + ",'");
sql.Append(System.DateTime.Now.ToShortDateString() + "','");
sql.Append(fujian_tname + "','");
sql.Append(fujian_name + "','");
sql.Append(fujian_tname2 + "','");
sql.Append(fujian_name2 + "')");