TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
hari haran
NA
1
0
need code for update button using stored procedure in hidden id
Jul 15 2010 5:33 AM
hi
i create stored procedure like below
ALTER procedure [dbo].[sampleregis]
@RegId int,
@FullName varchar(50),
@UserName varchar(50),
@Password varchar(50),
@RePassword varchar(50),
@Gender char(10),
@Age int,
@Address varchar(50),
@option varchar(10)
as
set nocount off
IF @option='delete'
delete from samplereg1 where RegId=@RegId
if @option='insert'
IF EXISTS(select FullName,UserName,Password,RePassword,Gender,Age,Address from samplereg1 where FullName=@FullName)
return -1
ELSE
insert into samplereg1 (FullName,UserName,Password,RePassword,Gender,Age,Address)values(@FullName,@UserName,@Password,@RePassword,@Gender,@Age,@Address)
if @option='update'
begin
UPDATE samplereg1 set Fullname=@Fullname,UserName=@UserName,Password=@Password,RePassword=@RePassword,Gender=@Gender,Age=@Age,Address=@Address where RegId=@RegId
End
in that i want to make update using button.so i have to use regid as a hidden field.
in my update button code is like below
TextBox txtRef1=FindControl("TxtName") as TextBox;
TextBox txtVal2=FindControl("TxtUserName") as TextBox;
TextBox txtRec3=FindControl("TxtPassword") as TextBox;
TextBox txtRbv4=FindControl("TxtRePassword") as TextBox;
TextBox txtRnh5=FindControl("DropDownList1") as TextBox;
TextBox txtRds6=FindControl("TxtAge") as TextBox;
TextBox txtRgr7=FindControl("TxtAddress") as TextBox;
HiddenField hdnRef8=FindControl("hdnRefId") as HiddenField;
SqlConnection conn = new SqlConnection(GetConnectionString());
SqlCommand cmd = new SqlCommand("sampleregis", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@RegId", SqlDbType.Int).Value = Convert.ToInt32(hdnRef8.Value);
cmd.Parameters.Add("@FullName", SqlDbType.VarChar, 50).Value = txtRef1.Text;
cmd.Parameters.Add("@UserName", SqlDbType.VarChar, 50).Value = txtVal2.Text;
cmd.Parameters.Add("@Password", SqlDbType.VarChar, 50).Value = txtRec3.Text;
cmd.Parameters.Add("@RePassword", SqlDbType.VarChar, 50).Value = txtRbv4.Text;
cmd.Parameters.Add("@Gender", SqlDbType.VarChar, 50).Value = txtRnh5.Text;
cmd.Parameters.Add("@Age", SqlDbType.Int).Value = Convert.ToInt32(txtRds6.Text);
cmd.Parameters.Add("@Address", SqlDbType.VarChar, 50).Value = txtRgr7.Text;
cmd.Parameters.Add("@option", SqlDbType.VarChar, 10).Value = "update";
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
but if i execuite means ill get error like this line
cmd.Parameters.Add("@RegId", SqlDbType.Int).Value = Convert.ToInt32(hdnRef8.Value);
error is
Object reference not set to an instance of an object.
so please any one help me .i need urgently.
thanks in advance
HARI
Reply
Answers (
0
)
how can i list paragraphes in a word document?
Visual Studio Interfaces