“System.Data.SqlClient.SqlException”类型的异常在 System.Data.dll 中发生,但未在用户代码中进行处理其他信息: 第 1 行: 'tb_User' 附近有语法错误。代码如下
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;namespace CR.BaseClass
{
class BaseOperate
{
#region 建立数据库连接
/// <summary>
/// 建立数据库连接.
/// </summary>
/// <returns>返回SqlConnection对象</returns>
public SqlConnection getcon()
{
string StrSqlcon = "Data Source=127.0.0.1;Database=db_CRM;User id=sa;PWD=";
SqlConnection myCon = new SqlConnection(StrSqlcon);
return myCon;
}
#endregion #region 执行SqlCommand命令
/// <summary>
/// 执行SqlCommand
/// </summary>
/// <param name="StrSqlstr">SQL语句</param>
public void getcom(string StrSqlstr)
{
SqlConnection sqlcon = this.getcon();
sqlcon.Open();
SqlCommand sqlcom = new SqlCommand(StrSqlstr, sqlcon);
sqlcom.ExecuteNonQuery();
sqlcom.Dispose();
sqlcon.Close();
sqlcon.Dispose();
}
#endregion #region 创建DataSet对象
/// <summary>
/// 创建一个DataSet对象
/// </summary>
/// <param name="StrSqlstr">SQL语句</param>
/// <param name="StrTable">表名</param>
/// <returns>返回DataSet对象</returns>
public DataSet getds(string StrSqlstr, string StrTable)
{
SqlConnection sqlcon = this.getcon();
SqlDataAdapter sqlda = new SqlDataAdapter(StrSqlstr, sqlcon);
DataSet myds = new DataSet(); ;
sqlda.Fill(myds, StrTable);
return myds;
}
#endregion #region 创建SqlDataReader对象
/// <summary>
/// 创建一个SqlDataReader对象
/// </summary>
/// <param name="StrSqlstr">SQL语句</param>
/// <returns>返回SqlDataReader对象</returns>
public SqlDataReader getread(string StrSqlstr)
{
SqlConnection sqlcon = this.getcon();
SqlCommand sqlcom = new SqlCommand(StrSqlstr, sqlcon);
sqlcon.Open();
SqlDataReader sqlread = sqlcom.ExecuteReader(CommandBehavior.CloseConnection);
return sqlread;
}
#endregion
}
}
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;namespace CR.BaseClass
{
class BaseOperate
{
#region 建立数据库连接
/// <summary>
/// 建立数据库连接.
/// </summary>
/// <returns>返回SqlConnection对象</returns>
public SqlConnection getcon()
{
string StrSqlcon = "Data Source=127.0.0.1;Database=db_CRM;User id=sa;PWD=";
SqlConnection myCon = new SqlConnection(StrSqlcon);
return myCon;
}
#endregion #region 执行SqlCommand命令
/// <summary>
/// 执行SqlCommand
/// </summary>
/// <param name="StrSqlstr">SQL语句</param>
public void getcom(string StrSqlstr)
{
SqlConnection sqlcon = this.getcon();
sqlcon.Open();
SqlCommand sqlcom = new SqlCommand(StrSqlstr, sqlcon);
sqlcom.ExecuteNonQuery();
sqlcom.Dispose();
sqlcon.Close();
sqlcon.Dispose();
}
#endregion #region 创建DataSet对象
/// <summary>
/// 创建一个DataSet对象
/// </summary>
/// <param name="StrSqlstr">SQL语句</param>
/// <param name="StrTable">表名</param>
/// <returns>返回DataSet对象</returns>
public DataSet getds(string StrSqlstr, string StrTable)
{
SqlConnection sqlcon = this.getcon();
SqlDataAdapter sqlda = new SqlDataAdapter(StrSqlstr, sqlcon);
DataSet myds = new DataSet(); ;
sqlda.Fill(myds, StrTable);
return myds;
}
#endregion #region 创建SqlDataReader对象
/// <summary>
/// 创建一个SqlDataReader对象
/// </summary>
/// <param name="StrSqlstr">SQL语句</param>
/// <returns>返回SqlDataReader对象</returns>
public SqlDataReader getread(string StrSqlstr)
{
SqlConnection sqlcon = this.getcon();
SqlCommand sqlcom = new SqlCommand(StrSqlstr, sqlcon);
sqlcon.Open();
SqlDataReader sqlread = sqlcom.ExecuteReader(CommandBehavior.CloseConnection);
return sqlread;
}
#endregion
}
}
拿出SQL语句来调试,应该是SQL语句错误