前台代码
<input type="text" id="md_dm" > //输入框
<input type="button" id="Button2" value="查询" > //按钮
调用后台方法的代码:
$("#Button2").click(function () {
var md_mc = $("#md_dm").val();
alert(md_mc);
search(md_mc);
});
后台方法:
public bool search(string s)
{
string md = s;
String sqlconn = "uid=sa;pwd=1;database=ZJK;server=XXXXX-PC";
SqlConnection conn = new SqlConnection(sqlconn);
conn.Open();
string sqlstr = "SELECT [md_mc],[md_dm] FROM [tmd] where [md_mc]= '" + md + "'"; SqlDataAdapter sda = new SqlDataAdapter(sqlstr, conn);
DataTable dt = new DataTable();
sda.Fill(dt);//填充数据到dt
GridView1.DataSource = dt;
GridView1.DataBind();//将数据显示到gridview1
if (dt == null)
return false;
else
return true;
}