Question

ASP.NET插入数据到数据库问题，请帮忙修改下代码 下面是一段插入注册信息到数据库的代码

string connectionString = "Server=127.0.0.1;Database=Online Teaching system;user id=sa;pwd=123456;";
string cmdText = "select * from test";
SqlConnection conn = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand(cmdText, conn);
conn.Open();
command.CommandText = "insert into userinfo(username,pwd,name,sex,ID,birthdate,cityorschool,job,tel,email,address,addressID,safeQuestion,safeAnswer,selfIntroduce) values(@username,@pwd,@name,@sex,@ID,@birthdate,@cityorschool,@job,@tel,@email,@address,@addressID,@safeQuestion,@safeAnswer,@selfIntroduce),conn";
command.Parameters.Add("@username", SqlDbType.NVarChar, 50);
command.Parameters.Add("@pwd", SqlDbType.NVarChar, 50);
command.Parameters.Add("@name", SqlDbType.NVarChar, 50);
command.Parameters.Add("@sex", SqlDbType.Char, 2);
command.Parameters.Add("@ID", SqlDbType.VarChar, 50);
command.Parameters.Add("@birthdate", SqlDbType.NVarChar,50);
command.Parameters.Add("@cityorschool", SqlDbType.NVarChar, 50);
command.Parameters.Add("@job", SqlDbType.NVarChar, 50);
command.Parameters.Add("@tel", SqlDbType.NVarChar, 50);
command.Parameters.Add("@email", SqlDbType.NVarChar, 50);
command.Parameters.Add("@address", SqlDbType.Text);
command.Parameters.Add("@addressID", SqlDbType.Int);
command.Parameters.Add("@safeQuestion", SqlDbType.Text);
command.Parameters.Add("@safeAnswer", SqlDbType.NVarChar, 50);
command.Parameters.Add("@selfIntroduce", SqlDbType.Text);
command.Parameters["@username"].Value = this.TextBox1.Text;
command.Parameters["@pwd"].Value = this.TextBox3.Text;
command.Parameters["@name"].Value = this.TextBox4.Text;
command.Parameters["@sex"].Value = this.ListBox1.Text;
command.Parameters["@ID"].Value = this.TextBox5.Text;
command.Parameters["@birthdate"].Value = this.TextBox15.Text;
command.Parameters["@cityorschool"].Value = this.TextBox6.Text;
command.Parameters["@job"].Value = this.TextBox7.Text;
command.Parameters["@tel"].Value = this.TextBox8.Text;
command.Parameters["@email"].Value = this.TextBox9.Text;
command.Parameters["@address"].Value = this.TextBox10.Text;
command.Parameters["@addressID"].Value = this.TextBox11.Text;
command.Parameters["@safeQuestion"].Value = this.TextBox14.Text;
command.Parameters["@safeAnswer"].Value = this.TextBox12.Text;
command.Parameters["@selfIntroduce"].Value = this.TextBox13.Text;
command.ExecuteNonQuery();

conn.close();
这段代码在网页中点击注册后，每次都说 command.ExecuteNonQuery();这个位置有问题，说什么语法错误，请大家帮我看一看

Answer 1

ExecuteNonQuery只能是非查询语句的执行，你使用select肯定报错啊

Answer 2

你前面select * from test，后面又插入用户表，建议你查询和插入分开，不要使用同一个SqlCommand 。