我想创建一个关于SqlCommand的子函数,那样的话,就可以随时调用啦.
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<Script Languate="VB" Runat="Server">
Public sqlconnstring as string="Data Source=lxycai\zhouwei;Integrated Security=SSPI;" & _
"User id=sa;Password=lxycai;Initial Catalog=lxy_zhouwei"'-------------------创建CMD对象------------
Function CreateCmd(Byval strSQL As String)
Dim Iconn As New SqlConnection()
Iconn.ConnectionString = sqlconnstring
Iconn.Open()
Dim objCmd As New SqlCommand()
objCmd.Connection = Iconn
objCmd.CommandText = strSQL
CreateCmd= objCmd.ExecuteNonQuery()
End Function
'-------------------创建CMD对象---------------'这样去调用
Dim sql_re as string
sql_re="insert into [ave_dealscore](stu_num,course_code,course_name,course_score) (SELECT stu_num,course_code,course_name,course_score FROM avg_zhou1())"
call CreatCmd(sql_re)
出现错误是:BC30451: 名称“CreatCmd”未声明。帮我看看哈!
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<Script Languate="VB" Runat="Server">
Public sqlconnstring as string="Data Source=lxycai\zhouwei;Integrated Security=SSPI;" & _
"User id=sa;Password=lxycai;Initial Catalog=lxy_zhouwei"'-------------------创建CMD对象------------
Function CreateCmd(Byval strSQL As String)
Dim Iconn As New SqlConnection()
Iconn.ConnectionString = sqlconnstring
Iconn.Open()
Dim objCmd As New SqlCommand()
objCmd.Connection = Iconn
objCmd.CommandText = strSQL
CreateCmd= objCmd.ExecuteNonQuery()
End Function
'-------------------创建CMD对象---------------'这样去调用
Dim sql_re as string
sql_re="insert into [ave_dealscore](stu_num,course_code,course_name,course_score) (SELECT stu_num,course_code,course_name,course_score FROM avg_zhou1())"
call CreatCmd(sql_re)
出现错误是:BC30451: 名称“CreatCmd”未声明。帮我看看哈!
解决方案 »
- 请问sharppcap 怎么用?
- 求一个可在统计网站访问量,流量的系统?
- VS2005用户控件ASCX拖到表格中,为什么显示时会到表格以外?
- datetable更新的问题 请教(急)
- 共140分!【今日头条焦点问题】:无法验证数据!装了微软8月31日.Net框架补丁解决视图状态已损坏的正确错误显示!求高人相助,解决立即结
- 水晶报表问题
- ○究竟该用什么来赋值?????
- asp.net2.0 access连接问题
- 请教异常处理方法
- 关于B/S项目的邮件发送Jmail类的问题
- datagrid中超级模板列的响应事件如何写?急!!
- DataList或DataGrid模板CheckBoxList中的问题(300)
<%@ Import Namespace="System.Data.SqlClient" %>
<Script Languate="VB" Runat="Server">
Public sqlconnstring as string="Data Source=lxycai\zhouwei;Integrated Security=SSPI;" & _
"User id=sa;Password=lxycai;Initial Catalog=lxy_zhouwei"'-------------------创建CMD对象------------
SUB CreateCmd(Byval strSQL As String)
Dim Iconn As New SqlConnection()
Iconn.ConnectionString = sqlconnstring
Iconn.Open()
Dim objCmd As New SqlCommand()
objCmd.Connection = Iconn
objCmd.CommandText = strSQL
CreateCmd= objCmd.ExecuteNonQuery()
End sub
'-------------------创建CMD对象---------------'这样去调用
Dim sql_re as string
sql_re="insert into [ave_dealscore](stu_num,course_code,course_name,course_score) (SELECT stu_num,course_code,course_name,course_score FROM avg_zhou1())"
call CreatCmd(sql_re)
出现错误是:BC30451: 名称“CreatCmd”未声明。
<%@ Import Namespace="System.Data.SqlClient" %>
<Script Languate="VB" Runat="Server">
Public sqlconnstring as string="Data Source=lxycai\zhouwei;Integrated Security=SSPI;" & _
"User id=sa;Password=lxycai;Initial Catalog=lxy_zhouwei"'-------------------创建CMD对象------------
SUB CreateCmd(Byval strSQL As String)
Dim Iconn As New SqlConnection()
Iconn.ConnectionString = sqlconnstring
Iconn.Open()
Dim objCmd As New SqlCommand()
objCmd.Connection = Iconn
objCmd.CommandText = strSQL
objCmd.ExecuteNonQuery()
End sub
'-------------------创建CMD对象---------------'这样去调用
Sub avg_required_click(sender As Object, e As EventArgs)
Dim sql_re as string
sql_re="insert into [ave_dealscore](stu_num,course_code,course_name,course_score) (SELECT stu_num,course_code,course_name,course_score FROM avg_zhou1())"
call CreatCmd(sql_re)End sub
</script>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body>
<form runat="server">
<asp:Button ID="Button" Text="计算" Width="150" Height="25" runat="server" OnClick="avg_required_click"/>
</form>
</body>
</html>出现错误是:BC30451: 名称“CreatCmd”未声明。
你打错字了
CreateCmd!!!!
不是CreatCmd!!!!!!!!!!!!11