填充DataTable失败
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.OleDb;
public partial class PriceUserControl : System.Web.UI.UserControl
{
private string labelText;
private string connectionString;
private GridView resultGridView;
private string tableName;
private string columCondition;
private string errorMessage;
public string LabelText
{
set
{
this.labelText = value;
}
get
{
return this.labelText;
}
}
public string ConnectionString
{
set
{
this.connectionString = value;
}
get
{
return this.connectionString;
}
}
public GridView ResultGridView
{
set
{
resultGridView = value;
}
get
{
return this.resultGridView;
}
}
public string TableName
{
set
{
this.tableName = value;
}
get
{
return this.tableName;
}
}
public string ColumCondition
{
set
{
this.columCondition = value;
}
get
{
return this.columCondition;
}
}
protected void Page_Load(object sender, EventArgs e)
{
this.ColumsName.Text = this.labelText;
}
private DataTable SearchResult()
{
try
{
System.Data.OleDb.OleDbConnection conn = new OleDbConnection(connectionString);
conn.Open();
string sqlString = "select * from" + tableName + "where" + columCondition + "like '%" + this.Conditon.Text.ToString() + "%'";
System.Data.OleDb.OleDbDataAdapter ada = new OleDbDataAdapter(sqlString, conn);
//ada.SelectCommand = new OleDbCommand(sqlString,conn);
System.Data.DataTable dataTable = new DataTable();
ada.Fill(dataTable);
conn.Close();
return dataTable;
}
catch (Exception e)
{
errorMessage = "访问数据库失败,请检测数据库连接!";
return null;
}
}
protected void Btn_Search_Click(object sender, EventArgs e)
{
resultGridView.DataSource = SearchResult().DefaultView;
resultGridView.DataBind();
}
}
------解决方案--------------------sql语句 from后面加个空格 where前面加个空格
------解决方案--------------------sql语句拼接错误,可以把拼接的sql语句粘贴出来,看下就知道了