我需要如何在存储过程中编写select语句,以及如何连接我的vb.net WEB应用程序 [英] i need how to write a select statements in stored procedure , and how to connect my vb.net WEB aplication
本文介绍了我需要如何在存储过程中编写select语句,以及如何连接我的vb.net WEB应用程序的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我需要如何在存储过程中编写select语句,以及如何连接我的vb.net WEB应用程序
please帮助先生,
i需要你的大帮助
解决方案
从这里开始:
创建程序(sql) [ ^ ]
解决:使用GridView Web服务器控件中的存储过程显示数据 [ ^ ]
Dim sqlConnection1 作为 新 SqlConnection ( 您的连接字符串)
Dim cmd As 新 SqlCommand
Dim reader As SqlDataReader
cmd.CommandText = StoredProcedureName
cmd.CommandType = CommandType.StoredProcedure
cmd.Connection = sqlConnection1
sqlConnection1.Open()
reader = cmd.ExecuteReader()
< span class =code-comment>' 此处可通过DataReader对象访问数据。
' 使用Read方法(true / false)查看读者是否有记录并前进到下一条记录
' 您可以将While循环用于多个记录(而reader.Read()... End While)
如果 reader.Read()那么
someVar = reader( 0 )
someVar2 = reader( 1 )
someVar3 = reader( NamedField)
结束 < span class =code-keyword>如果
sqlConnection1.Close()
和sql server jus
CREATE PROCEDURE < pre lang = vb> StoredProcedureName
AS
SELECT * FROM table
GO< / pre>
i need how to write a select statements in stored procedure , and how to connect my vb.net WEB aplication
please help sir,
i need ur big help
解决方案
Start here:
CREATE PROCEDURE (sql)[^]
Walkthrough: Displaying Data Using a Stored Procedure in the GridView Web Server Control[^]
Dim sqlConnection1 As New SqlConnection("Your Connection String") Dim cmd As New SqlCommand Dim reader As SqlDataReader cmd.CommandText = "StoredProcedureName" cmd.CommandType = CommandType.StoredProcedure cmd.Connection = sqlConnection1 sqlConnection1.Open() reader = cmd.ExecuteReader() ' Data is accessible through the DataReader object here. ' Use Read method (true/false) to see if reader has records and advance to next record ' You can use a While loop for multiple records (While reader.Read() ... End While) If reader.Read() Then someVar = reader(0) someVar2 = reader(1) someVar3 = reader("NamedField") End If sqlConnection1.Close()
and in sql server jus
CREATE PROCEDURE <pre lang="vb">StoredProcedureName AS SELECT * FROM table GO</pre>
这篇关于我需要如何在存储过程中编写select语句,以及如何连接我的vb.net WEB应用程序的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文