Dim IOAConn = ConfigurationSettings.AppSettings("IOAConn")
Dim conn As New SqlClient.SqlConnection(IOAConn), sql
Dim cmd As New SqlClient.SqlCommand
sql = "select max(ID)as ID from wenzhong"
'Dim IOADataTable As New DataTable
'IOADataTable.Select("max(ID) as ID")
cmd.CommandText = sql
cmd.Connection = conn
cmd.Connection.Open()
cmd.ExecuteReader()
Dim ID = cmd】后面怎么写??
Dim conn As New SqlClient.SqlConnection(IOAConn), sql
Dim cmd As New SqlClient.SqlCommand
sql = "select max(ID)as ID from wenzhong"
'Dim IOADataTable As New DataTable
'IOADataTable.Select("max(ID) as ID")
cmd.CommandText = sql
cmd.Connection = conn
cmd.Connection.Open()
cmd.ExecuteReader()
Dim ID = cmd】后面怎么写??
解决方案 »
- DropDownlist 问题
- CSS3+JS实现的时钟
- 一个关于权限设置问题! 求思路!!
- GridView添加行
- 想帮人制作ASP.NET2.0中小型网站,怎么找到客户啊?
- 静态页中的datalist
- 如果在查询条件中使用like的时候涉及到通配符
- 请大家给我(菜鸟级)一些帮助!关于asp的!
- ############请显式设置引发回发事件的控件的 ID 属性什么意思?#######################3
- 如何提交中文用户名的表单,下面是自动登录的例子,英文OK,中文通不过?
- 外面使用 ../test.xsl?id=1,在test.xsl中如何得到这个参数id?
- 在.net中静态生成文章,而对有些篇幅大的文章要进行分页处理,不知道各位是怎么实现的,思路是什么?
Dim cmd As New SqlClient.SqlCommand
dim reader as sqlclinent.sqldatareader
sql = "select max(ID)as ID from wenzhong"
'Dim IOADataTable As New DataTable
'IOADataTable.Select("max(ID) as ID")
cmd.CommandText = sql
cmd.Connection = conn
cmd.Connection.Open()
reader=cmd.ExecuteReader()
if reader.read then
string str=reader.Item(0)
end if