textbox输入内容,数据库模糊查询显示下拉框中 textbox输入内容,数据库模糊查询显示下拉框中哪位可以写一个例子出来 小弟想看看 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 那你就写在事件里嘛,XXX_Changed事件里写查询语句,把结果集绑定到控件上不就ok了么? private void txtSelect_TextChanged(object sender, EventArgs e) { SqlConnection conn = new SqlConnection("server = .; uid = sa; pwd = ; database = NorthWind"); string sql = "select CompanyName from Customers where CompanyName like '%" + txtSelect.Text.Trim() + "%'"; SqlDataAdapter da = new SqlDataAdapter(sql, conn); DataSet ds = new DataSet(); da.Fill(ds,"Customers"); if (ds.Tables["Customers"].Rows.Count < 0) { return; } else { } }写到这里不知道怎么往下写了 , //这样试试,我没调试,可能会报错,自己该该就行了 AutoCompleteStringCollection cs = new AutoCompleteStringCollection();//全局变量 //窗体的load事件写 private void Form5_Load(object sender, EventArgs e) { this.txtSelect.AutoCompleteMode = AutoCompleteMode.Suggest; this.txtSelect.AutoCompleteSource = AutoCompleteSource.CustomSource; this.txtSelect.AutoCompleteCustomSource = cs; } //文本改变事件 private void txtSelect_TextChanged(object sender, EventArgs e) { cs.Clear(); DataTable tab1 = sqldataset("select CompanyName from Customers where CompanyName like '%" + txtSelect.Text.Trim() + "%'").Tables[0]; for (int i = 0; i < tab1.Rows.Count; i++) { cs.Add(tab1.Rows[i]["CompanyName"].ToString().Trim()); } } private System.Data.DataSet sqldataset(string str) { System.Data.SqlClient.SqlConnection conn = new SqlConnection("server = .; uid = sa; pwd = ; database = NorthWind"); System.Data.SqlClient.SqlDataAdapter getdata; if (conn.State.ToString() == "Closed") conn.Open(); getdata = new SqlDataAdapter(str.Trim(), conn); System.Data.DataSet sj = new System.Data.DataSet(); getdata.Fill(sj, "sj"); getdata.Dispose(); return sj; } 对数据库的访问太多了。google的效果看着简单,还是没那么容易的。 一种是通过 WebService 做的,这是微软官方的视频教程上有讲。第二种,通过 Ajax 技术去做,已经不是什么新的技术了,软件提供了 Ajax 控件包的,可以下载到。当然还有其他方法,不过会相对复杂一点,建议楼主向上述两个方向去研究,本人倾向于使用 Ajax 实现。 我也想找这个例子!CHANG查询数据库绝对不是好办法!!查DATASET也许可以!! button 在win764位系统下异常 ?指定坐标初始化的代码问题 就一句代码,求解释 抽像类的问题 这段代码什么意思 catch (Exception err)怎麼捕捉sqlserver主鍵,外鍵,唯一性 衝突異常??? 如何从头开始学C# 大虾们给点建议 关于winform的reportviewer打印问题 有问题:关于窗体"相互"之间的通讯 这样的条件应该怎么写啊,头疼死了,求帮助! vs.net2005+C#+crystalreport10 报表图标不见了,而且导出打印不能用 [求]VB.net转C#的工具源代码
{
SqlConnection conn = new SqlConnection("server = .; uid = sa; pwd = ; database = NorthWind");
string sql = "select CompanyName from Customers where CompanyName like '%" + txtSelect.Text.Trim() + "%'";
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
da.Fill(ds,"Customers");
if (ds.Tables["Customers"].Rows.Count < 0)
{
return;
}
else
{ }
}写到这里不知道怎么往下写了 ,
AutoCompleteStringCollection cs = new AutoCompleteStringCollection();//全局变量
//窗体的load事件写
private void Form5_Load(object sender, EventArgs e)
{
this.txtSelect.AutoCompleteMode = AutoCompleteMode.Suggest;
this.txtSelect.AutoCompleteSource = AutoCompleteSource.CustomSource;
this.txtSelect.AutoCompleteCustomSource = cs;
}
//文本改变事件
private void txtSelect_TextChanged(object sender, EventArgs e)
{
cs.Clear();
DataTable tab1 = sqldataset("select CompanyName from Customers where CompanyName like '%" + txtSelect.Text.Trim() + "%'").Tables[0];
for (int i = 0; i < tab1.Rows.Count; i++)
{
cs.Add(tab1.Rows[i]["CompanyName"].ToString().Trim());
} }
private System.Data.DataSet sqldataset(string str)
{
System.Data.SqlClient.SqlConnection conn = new SqlConnection("server = .; uid = sa; pwd = ; database = NorthWind");
System.Data.SqlClient.SqlDataAdapter getdata;
if (conn.State.ToString() == "Closed")
conn.Open();
getdata = new SqlDataAdapter(str.Trim(), conn);
System.Data.DataSet sj = new System.Data.DataSet();
getdata.Fill(sj, "sj");
getdata.Dispose();
return sj;
}