帮忙看下这段程序哪里出了错？C# sql200 错误提示：varchar附近有语法错误

private void bao_cun_Click_1(object sender, EventArgs e)
{
MyClass.getsqlcom("Insert into [user](username,password)values('" + registname.Text.Trim() + "','" + mima.Text.Trim() + "')");
string sqlStr ="create table ";
sqlStr+=registname.Text.Trim() +"CDinfor";
sqlStr += "编码 varchar(50) indentity(1,1) primary key ,";
sqlStr += "曲名 varchar(50) ,";
sqlStr += "作家 varchar(50) ,";
sqlStr += "演奏 varchar(50) ,";
sqlStr += "音乐介质 varchar(50) ,";
sqlStr += "国别 varchar(50) ,";
sqlStr += "专辑 varchar(50) ,";
sqlStr += "出版 varchar(50) ,";
sqlStr += "年代 varchar(50) ,";
sqlStr += "一级分类 varchar(50) ,";
sqlStr += "一级分类 varchar(50) ,";
sqlStr += "一级分类 varchar(50) ,";
sqlStr += "foreign key username references [user])";
MyClass.getsqlcom(sqlStr);
}

sqlStr+=registname.Text.Trim() +"CDinfor";
sqlStr += "编码 varchar(50) indentity(1,1) primary key ,";
括号呢？
你调试的时候把sqlstr的值取出来在查询分析器里运行一遍试试不就知道了

你好！ sqlStr+=registname.Text.Trim() +"CDinfor"; 希望对你有所帮助，望采纳。

你在最后一行设个断点 看看SQL在哪报错， 你这看着都累。。。