日期:2014-05-17  浏览次数:20496 次

填充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语句粘贴出来,看下就知道了