Question

异常详细信息: System.Data.SqlClient.SqlException: 对象名 'intoBus' 无效。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;

public partial class _2 : System.Web.UI.Page
{

static string strConn = "Data Source=(local);Initial Catalog=CheCi;Integrated Security=True";
SqlConnection myConn = new SqlConnection(strConn);
SqlCommand myComm;

protected void Button1_Click(object sender, EventArgs e)
{
string strSql="insert into"+"Bus(BusID,BeginStation,EndStation,ServiceTime,Description)"+
"values(@BusID,@BeginStation,@EndStation,@ServiceTime,@Description)";
myComm = new SqlCommand(strSql, myConn);
myComm.Parameters.Add("@BusID",SqlDbType.VarChar,10);
myComm.Parameters.Add("@BeginStation",SqlDbType.VarChar,20);
myComm.Parameters.Add("@EndStation",SqlDbType.VarChar,20);
myComm.Parameters.Add("@ServiceTime",SqlDbType.VarChar,20);
myComm.Parameters.Add("@Description",SqlDbType.VarChar,50);
myComm.Parameters["@BusID"].Value=txtBusID.Text.Trim();
myComm.Parameters["@BeginStation"].Value=txtBeginStation.Text.Trim();
myComm.Parameters["@EndStation"].Value=txtEndStation.Text.Trim();
myComm.Parameters["@ServiceTime"].Value=txtServiceTime.Text.Trim();
myComm.Parameters["@Description"].Value=txtDescription.Text.Trim();
myConn.Open();
myComm.ExecuteNonQuery();
myConn.Close();
Response.Redirect("Default2.aspx");

}
protected void Page_Load(object sender, EventArgs e)
{

}
protected void Button2_Click(object sender, EventArgs e)
{
Response.Redirect("Default2.aspx");
}
}

Answer 1

"insert into 这里加上空格"+"Bus(BusID,BeginStation,EndStation,ServiceTime,Description)"+

Answer 2

呵呵给您寂寞