public partial class _Default : System.Web.UI.Page
{
SqlConnection sqlcon;
SqlCommand sqlcom;
string strCon = "Data Source=(local);Database=数据库名;Uid=帐号;Pwd=密码";
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bind();
}
public void bind()
{
if(TextBox1.Text==""||TextBox1.Text==null)
{
string sqlstr = "select * from 表";
}
else
{
string sqlstr = "select * from 表 where 条件="+TextBox1.Text.Trim();
}
sqlcon = new SqlConnection(strCon);
SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
DataSet myds = new DataSet();
sqlcon.Open();
myda.Fill(myds, "表");
GridView1.DataSource = myds;
GridView1.DataKeyNames = new string[] { "id" };//主键
GridView1.DataBind();
sqlcon.Close();
}
}
要实时显示就用ajax,给你一个实时显示时间的例子,类似方式实现;如有不懂,追问
http://blog.csdn.net/mygis2005/article/details/7404807