protected void Button1_Click(object sender, EventArgs e)
{
String bianhao = bianhao2.Text.ToString();
//String sql = "select * from product_ab where product_ab.number='" + bianhao + "' order by cpid desc limit 0,1";
/* conn.Open();
MySqlDataAdapter sda = new MySqlDataAdapter(sql,conn);
DataSet ds = new DataSet();
sda.Fill(ds, "product_ab");
GridView1.DataSource = ds.Tables["product_ab"];
GridView1.DataKeyNames = new string[] { "cpid" };
GridView1.DataBind();
conn.Close();*/
String sql = " select * from (product_ab inner join stocknote on stocknote.cpid=product_ab.cpid) inner join provider on stocknote.pid=provider.pid where product_ab.number='" + bianhao + "' order by product_ab.cpid desc limit 0,1 ";
conn.Open();
MySqlCommand com = new MySqlCommand(sql,conn);
MySqlDataReader sdr = com.ExecuteReader();
GridView1.DataSource = sdr;
GridView1.DataBind();
conn.Close(); }
以上代码全部是正确的,就是当我点击按钮没有查找到记录时怎么弹出对话框提示‘没有查找到数据’,如果有就显示在了gridview中!!
{
String bianhao = bianhao2.Text.ToString();
//String sql = "select * from product_ab where product_ab.number='" + bianhao + "' order by cpid desc limit 0,1";
/* conn.Open();
MySqlDataAdapter sda = new MySqlDataAdapter(sql,conn);
DataSet ds = new DataSet();
sda.Fill(ds, "product_ab");
GridView1.DataSource = ds.Tables["product_ab"];
GridView1.DataKeyNames = new string[] { "cpid" };
GridView1.DataBind();
conn.Close();*/
String sql = " select * from (product_ab inner join stocknote on stocknote.cpid=product_ab.cpid) inner join provider on stocknote.pid=provider.pid where product_ab.number='" + bianhao + "' order by product_ab.cpid desc limit 0,1 ";
conn.Open();
MySqlCommand com = new MySqlCommand(sql,conn);
MySqlDataReader sdr = com.ExecuteReader();
GridView1.DataSource = sdr;
GridView1.DataBind();
conn.Close(); }
以上代码全部是正确的,就是当我点击按钮没有查找到记录时怎么弹出对话框提示‘没有查找到数据’,如果有就显示在了gridview中!!
解决方案 »
- asp.net可以模拟鼠标键盘吗?象桌面程序一样
- 修改密码页面用javascript来编写脚本,可是我不知道脚本放在那里,是放在母板页中还是内容页中,还有脚本我也有错误,高手来啊
- 跪求 一条SQL更新语句?
- asp.net关于post传值,中间页面过期的问题
- 请教一个问题
- 【紧急求助】datatable 中的求平均值问题
- dropdownlist数据绑定时怎么改变默认的SelectedItem项啊?请高手们指教~~~ 下午的问题啊~~~
- 安全问题-怎样控制一个用不能访问一个文件
- 关于在aspx文件里使用扩展方法
- 如何去GridView 表头的边框?
- ASP.NET用iframe问题,iframe中包括一个按扭,单击了的话连容器页也刷新了!
- web网站下载图片到手机
{
//绑定gridview
}
else
{
response.Write("<script>alert('没有查找到数据!')</script>");
}
if (sdr != null)
{
GridView1.DataSource = sdr;
GridView1.DataBind();
}
else
{
RegisterStartupScript("","<script>alert('抱歉,没有查到记录!')</script>");
}
conn.Close();
这样也不行啊,这个提示对话框不出啊???
也不行啊???