|
Here's what im trying to do with the stored procedure
on the lower part of Stored procedure
AS
Insert Into Users(username,password)
Values('myusername','mypassword');
is there anyway that i could put it on textbox
and lower part of Stored P would look like
AS insert Into Users(username,password)
Values(@username,@password);
because executing the first SP would update my database with a username myusername and password with mypassword values.
on the passing of parameters on my text box goes like this
assume cmd sqlclient.sqlcommand
with cmd
.Parameters.AddWithValue(@username,textbox1.text)
.parameters.addwithValue(@password,textbox2.text)
all the commands but these 2 doesn't allow me to pass the value on my textbox to the stored procedure.
This post has been edited by cimpercee: 21 Apr, 2008 - 01:46 AM
|
| 