如何在vb.net中编写存储过程更新查询代码 [英] how to write stored procedure update query code in vb.net
本文介绍了如何在vb.net中编写存储过程更新查询代码的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我目前在vb.net中工作
然后在sqlserver中创建存储过程,即
ALTER 过程 dbo.ChangePass
(
@ UserName varchar ,
@密码 varchar
)
AS
更新 Admin_Set SET 密码= @密码>位置 UserName = @ UserName
返回
所以我也想在vb.net中查询此查询代码
cmd.Parameters.Add(" ,SqlDbType.VarChar) .Value = UsernameTextBox.Text // 此代码在更新查询中不起作用
cmd.Parameters.Add(" ,SqlDbType.VarChar).Value = PasswordTextBox.Text
Dim qr As Integer
qr = cmd.ExecuteNonQuery()
MessageBox.Show(" ,qr.ToString())
解决方案
您是否正在使用此行,如果不使用
cmd.CommandType = CommandType.StoredProcedure;
hi
please help me any one
i am currently work in vb.net
and i create stored procedure in sqlserver i.e
ALTER PROCEDURE dbo.ChangePass
(
@UserName varchar,
@Password varchar
)
AS
UPDATE Admin_Set SET Password=@Password WHERE UserName = @UserName
RETURN
so i want to this query code in vb.net also i tried as fallow
cmd.Parameters.Add("UserName", SqlDbType.VarChar).Value = UsernameTextBox.Text//this code not work in update query
cmd.Parameters.Add("Password", SqlDbType.VarChar).Value = PasswordTextBox.Text
Dim qr As Integer
qr = cmd.ExecuteNonQuery()
MessageBox.Show("SignUp Successful", qr.ToString())
解决方案
are you Using this line, if not use
cmd.CommandType = CommandType.StoredProcedure;
using Stored Procedure in c#
using Stored procedure in VB.Net
这篇关于如何在vb.net中编写存储过程更新查询代码的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文