遇到一个问题大家帮帮忙吧...C#的
工具是VS2005数据库是SQL2000
有一个表,然后我想要在BUTTON的CLICK事件时查询在TEXT里输入的数据
然后在dataGridView中清空原记录并重新填充查询到的内容该怎么写呢 最好有个完整的例子/程序```包括连接数据库之类的
谢谢大家
工具是VS2005数据库是SQL2000
有一个表,然后我想要在BUTTON的CLICK事件时查询在TEXT里输入的数据
然后在dataGridView中清空原记录并重新填充查询到的内容该怎么写呢 最好有个完整的例子/程序```包括连接数据库之类的
谢谢大家
//把这个做全局变量,然后还要配置下WebConfig
OracleConnection conn = new OracleConnection(ConfigurationManager.ConnectionStrings["NewZLCConnString"].ToString()); //下面的是Button_Click事件
string sqlstr = "select * from table where 查询字段=txtbox.text ";
OracleDataAdapter oda = new OracleDataAdapter(sqlstr, conn);
DataSet ds = new DataSet();
conn.Open();
oda.Fill(ds, "table ");
GridView1.DataSource = ds;
GridView1.DataBind();
conn.Close();我用的是Oracle...改成SQL就能用了
using System.Data;
using System.Data.SqlClient; string str="data source=.;database=数据库名;uid=sa;pwd=;";
SqlConnection sql=new SqlConnection(str);
sql.Open();
SqlDataAdapter myAda=new SqlDataAdapter(str,sql);
DataSet mySet=new DataSet();
myAda.Fill(mySet,"0");
GridView1.DataSource = mySet;
GridView1.DataBind();
sql.Close();
SqlConnection con = new SqlConnection(your connection string); string sqlstr = "select * from table where 字段="+txtbox.text ;
SqlDataAdapter adpter = new SqlDataAdapter (sqlstr, conn);
DataSet ds = new DataSet();
conn.Open();
adpter.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
conn.Close();
using System.Data;
using System.Data.SqlClient; string str="data source=.;database=数据库名;uid=sa;pwd=;";
SqlConnection sql=new SqlConnection(str);
sql.Open();
string sel="select * from 表 where 字段='"+Text1.text+"';"; //
SqlDataAdapter myAda=new SqlDataAdapter(sel,sql); // 5楼这2句错了。
DataSet mySet=new DataSet();
myAda.Fill(mySet,"0");
GridView1.DataSource = mySet;
GridView1.DataBind();
sql.Close();
using (SqlConnection connection =
new SqlConnection(connectionString))
{
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = new SqlCommand(
queryString, connection);
adapter.Fill(dataset);
DataSet dataset = new DataSet(); dataview.datasource = dataset; }
建议看看MSDN的ADO部分。
private DataTable dtSource = new DataTable(); #region 画面初始化 /// <summary>
/// 画面初始化
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
BindToGrid();
}
}
catch (Exception ex)
{
this.ShowMessage(ex.Message);
}
} #endregion #region 获取数据源 /// <summary>
/// 获取数据源
/// </summary>
/// <param name="strTable">表名</param>
/// <param name="code">编号</param>
/// <param name="name">名称</param>
private void GetDataSource()
{
TB_Item_ApplyBus busi = new TB_Item_ApplyBus();
dtSource = busi.Select(GetWhere()).Tables[0];
} #endregion #region 绑定值到GRID /// <summary>
/// 绑定值到GRID
/// </summary>
private void BindToGrid()
{
GetDataSource(); this.GridView1.DataSource = dtSource ;
this.GridView1.DataBind();
} #endregion
#region 检索数据
/// <summary>
/// 检索数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnQuery_Click(object sender, EventArgs e)
{
try
{
BindToGrid();
}
catch (Exception ex)
{
this.ShowMessage(ex.Message);
}
} #endregion #region 获取检索条件 /// <summary>
/// 获取检索条件
/// </summary>
/// <returns></returns>
private string GetWhere()
{
string strWhere = ""; if (!txtList_no.Value.Equals(string.Empty))
{
strWhere += " AND A.list_no like '%" + txtList_no.Value.Trim() + "%'";
}
return strWhere;
} #endregion
/// <summary>
/// 生成DataSet
/// </summary>
/// <param name="connectionString"></param>
/// <param name="cmdType"></param>
/// <param name="cmdText"></param>
/// <param name="commandParameters"></param>
/// <returns></returns>
public static DataSet ExecuteDataSet(string connectionString, CommandType cmdType, string cmdText, params SqlParameter[] commandParameters)
{
SqlCommand cmd = new SqlCommand();
SqlConnection conn = new SqlConnection(connectionString); // we use a try/catch here because if the method throws an exception we want to
// close the connection throw code, because no datareader will exist, hence the
// commandBehaviour.CloseConnection will not work
try
{
PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters);
DataSet ds = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = cmd;
adapter.Fill(ds);
cmd.Parameters.Clear();
return ds;
}
catch
{
throw;
}
finally
{
conn.Close();
}
}
if (textbox.text!="")
{ sql+=" and xx='"+textbox.text+ "'"
}
拼接好SQL,然后执行这条sql 然后绑定数据查询后重新执行以上代码
string str="data source=.;database=数据库名;uid=sa;pwd=;";
SqlConnection sql=new SqlConnection(str);
sql.Open();
string sel="select * from 表 where 字段='"+Text1.text+"';"; //
SqlDataAdapter myAda=new SqlDataAdapter(sel,sql); // 5楼这2句错了。
DataSet mySet=new DataSet();
myAda.Fill(mySet,"0");
GridView1.DataSource = mySet;
//GridView1.DataBind(); //没有这句,人家要的是C#
sql.Close();
第1行: '=' 附近有语法错误啊