Question

System.ArgumentException: 不支持关键字: "integratedsecurity".

行 39: public DataSet GetDataTableBySql(String SqlStr)
行 40: {
行 41: Con.ConnectionString = GetConnectionString();
行 42: Com.Connection = Con;
行 43: Com.CommandText = SqlStr;
[ArgumentException: 不支持关键字: “integratedsecurity”。]
System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey) +4907780
System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules) +98
System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) +55
System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) +24
System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) +200
System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value) +62
System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) +4
DB.GetDataTableBySql(String SqlStr) in e:\vs2008\App_Code\DB.cs:41
xs_xs_login.btn_Login_Click(Object sender, EventArgs e) in e:\vs2008\xs\xs\login.aspx.cs:37
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565

Answer 1

楼上的这位你干过C#没？
那上面写的很清楚，string userid=....你还问userid是怎么定义的，这明显不是数据类型的事，
我觉得是你这句有问题：
string sql = "select UserName from Users where UserID='0'";

应该是：
string sql = "select UserName from Users where UserID={0}";
这样吧。占位符。可以试试看，如果userid在数据库里不是数字，那就
string sql = "select UserName from Users where UserID='{0}'";试试。
实在不行就不要用占位符了 直接拼串：
string sql = "select UserName from Users where UserID="+userid;