一个简单的C#windows应用程序的问题

显示全部楼层 · 2009-11-20 16:51:48

//查询全部新闻
protected IList GetNewsByTitle()
{
IList list = new List();
OleDbConnection conn = GetConn();
string sql = "select * from tb_News where Title="+ textbox1.Text +" order by AddTime desc";
using (OleDbDataReader dr = GetReader(conn, sql))
{
while (dr.Read())
{
NewsModel nm = new NewsModel();
nm.ID = Convert.ToInt32(dr["ID"]);
nm.Title = Convert.ToString(dr["Title"]);
nm.Info = Convert.ToString(dr["Info"]);
nm.AddTime = Convert.ToDateTime(dr["AddTime"]);
list.Add(nm);
}
}
CloseConn(conn);
return list;
}
//创建Access数据库连接对象
protected OleDbConnection GetConn()
{
string WebPath = GetRootURI();
string conn = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + WebPath + "nsDB\\#news.mdb";
OleDbConnection objConnection = new OleDbConnection(conn);
objConnection.Open();
return objConnection;
} // 执行无参SQL语句，并返回OleDbDataReader
public OleDbDataReader GetReader(OleDbConnection Connection, string safeSql)
{
OleDbCommand cmd = new OleDbCommand(safeSql, Connection);
OleDbDataReader reader = cmd.ExecuteReader();
return reader;
}
//关闭Access数据库连接
protected void CloseConn(OleDbConnection conn)
{
conn.Close();
}protected void button1_click(){ Datagridview1.DataSource = GetNewsByTitle();
Datagridview1.DataBind();}---------给你段例子

千问 · 2009-11-20 16:51:48

在button里写if(!string.IsNullOrEmpty(textbox.text)){
得到 conn
声明 DataAdapteradp =new DataAdapter("select * from table where XXX='"+textbox.text+"';",conn);
声明dataset ds
adp.Fill(ds);
datagridview.datasource=ds.table[0];
}

千问 · 2009-11-20 16:51:48

懒人。。。。。

千问 · 2009-11-20 16:51:48

你自己都说出来了还问？让别人给你写代码吗