Question

cmd.ExecuteNonQuery() 出现异常，新人跪谢指导

我是初学者，给表插入数据时老是出错，拜托前辈给点指导吧

class Program
{
static void Main(string[] args)
{
string dataDir = AppDomain.CurrentDomain.BaseDirectory;
if (dataDir.EndsWith(@"\bin\Debug\")
|| dataDir.EndsWith(@"\bin\Release\"))
{
dataDir = System.IO.Directory.GetParent(dataDir).Parent.Parent.FullName;
AppDomain.CurrentDomain.SetData("DataDirectory", dataDir);
}

using (SqlConnection conn = new SqlConnection(@"data source=.\SQLEXPRESS;AttachDBFilename=|DataDirectory|D5.mdf;Integrated Security=true;User Instance=true"))
{
conn.Open();
Console.WriteLine("数据库连接打开............");

using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "insert into Table(name) values ( '王八')";
cmd.ExecuteNonQuery();
Console.WriteLine("插入数据成功............");
}
}

Console.ReadKey();
}
}

Answer 1

cmd.CommandText = "insert into Table(name) values ( '王八')";

这句话table 为数据库表的具体名称，而不是table

实例：
cmd.CommandText = "insert into Student(name) values ( '王八')";

Good Luck！ 希望能够帮助到你！

如果可以请采纳！谢谢！