Function getdata() As System.Data.DataTable
Dim conn As New SqlConnection("data source=liming;initial catalog=zls;uid=sa;pwd=;")
Dim asapter As New SqlDataAdapter("select u.userid,u.username,u.address,u.typenumname,w.nmtabnum,w.amtabnum, w.typewatermeteprice,i.InTabManName from userinfo u left outer join usewaterinfo w on u.userid =w.userid INNER JOIN InTabManMS AS i ON u.InTabManID = i.InTabManID where u.userid=" + TextBox1.Text + " and w.payyesno= 0 order by w.id", conn)
Dim mydataset As New DataSet()
Dim ex As Exception
Try
asapter.Fill(mydataset, "customer")
Catch ex
Response.Write(ex.ToString())
End Try
Return (mydataset.Tables(0)) GridView1.DataSource = getdata()
GridView1.DataBind()
End Function
Dim conn As New SqlConnection("data source=liming;initial catalog=zls;uid=sa;pwd=;")
Dim asapter As New SqlDataAdapter("select u.userid,u.username,u.address,u.typenumname,w.nmtabnum,w.amtabnum, w.typewatermeteprice,i.InTabManName from userinfo u left outer join usewaterinfo w on u.userid =w.userid INNER JOIN InTabManMS AS i ON u.InTabManID = i.InTabManID where u.userid=" + TextBox1.Text + " and w.payyesno= 0 order by w.id", conn)
Dim mydataset As New DataSet()
Dim ex As Exception
Try
asapter.Fill(mydataset, "customer")
Catch ex
Response.Write(ex.ToString())
End Try
Return (mydataset.Tables(0)) GridView1.DataSource = getdata()
GridView1.DataBind()
End Function
解决方案 »
- GridView导出Excel时进把图片一起导出,求方法?
- 怎样将html页面嵌入到aspx页里边
- DataList 单元格宽度控制问题?
- 请帮助将WinForm 语句转换成 WebForm 的语句
- 谁能找到免费asp.net空间网站?
- WebControls问题(急!!!)
- 求一段添加产品的C#+ASP.net源码。
- 就是无法写入数据:看看那里错了
- 【JS弹出一个加载的图片】居中5秒后消失
- 怎样实现数据库中的行列转换?在线等待!
- 我想学习ajax,,我的系统是xp sp2 + vs2005 我需要下载那个版本的Ajax呀?好像有几个版本的,那个版本的能用
- 长时间使用ie抓取大量网页数据的时候报错
设断点跟踪一下
Try
asapter.Fill(mydataset, "customer")
Catch ex
Response.Write(ex.ToString())
End Try
Return (mydataset.Tables(0))
这里是否产生异常了,是的话这里的Return了,没有执行绑定GridView1的代码
GridView1.DataSource = getdata()
检查一下getdata返回是还为null
GridView1.DataBind() ,放到Button1.Click里就可以