my update stored procedure is not working

if it helps you mark it as answered. so it will help full for others

protected void Page_Load(object sender, EventArgs e)
{
 if (!IsPostBack)
 {
 if (Request.QueryString["ConsultantId"] != null)
ConsultantId = int.Parse(Request.QueryString["ConsultantId"]);
}
}

from where you are getting the Consultant_Id in our code behind.

I think the value of ConsultantId is not getting set correctly in your code behind. Please put the break point and check the value

Regards,
Iftikar

your stored procedure is working . just try to exute it in sql server it updating or not manually.

example-

exec consultant_Update 1,'manjula','amerpet','hyb','AP','50004'

execute like this and see its updating or not  pass the existing consultantID

what is the value passed from your code behind for 

SqlCommand cmdupdate = new SqlCommand("consultant_Update", con); cmdupdate.CommandType = CommandType.StoredProcedure;
cmdupdate.Parameters.AddWithValue("@Consultant_Id", ConsultantId); 


Regards,
Iftikar

CREATE TABLE consultant(
[Consultant_Id] [int] IDENTITY(1,1) NOT NULL PrimaryKey,
[Name] [varchar](50) NULL,
[Phone_Number] [varchar](50) NULL,
[Address] [varchar](50) NULL,
 [City] [varchar](50) NULL,
 [State] [varchar](50) NULL,
[Zip_Code] [varchar](50) NULL,

codebehind:
 btnupdate_Click(object sender, EventArgs e)
{
SqlCommand cmdupdate = new SqlCommand("consultant_Update", con); cmdupdate.CommandType = CommandType.StoredProcedure; cmdupdate.Parameters.AddWithValue("@Consultant_Id", ConsultantId); cmdupdate.Parameters.AddWithValue("@name", txtname.Text.ToString()); cmdupdate.Parameters.AddWithValue("@Phone_Number", txtphonenumber.Text.ToString()); cmdupdate.Parameters.AddWithValue("@Address", txtaddress.Text.ToString()); cmdupdate.Parameters.AddWithValue("@City", txtcity.Text.ToString()); cmdupdate.Parameters.AddWithValue("@State", txtstate.Text.ToString()); cmdupdate.Parameters.AddWithValue("@Zip_Code", txtzipcode.Text.ToString());
con.opn();
cmdupdate.ExecuteNonQuery();
con.close();
}

in thease code when btnupdate was clicked the data was not updaing to DATABASE

Is the value what you have passed for Consultant_Id  is already exist in your table? Please check your table data.

Regards,
Iftikar

can you provide your table design and sample data

try this

alter procedure consultant_Update
(

@name varchar(50),
@Phone_Number varchar(50),
@Address varchar(50),
@City varchar(50),
@State varchar(50),
@Zip_Code varchar(50),
@Consultant_Id int
)

AS
BEGIN
update consultant set
name = @name,
Phone_Number = @Phone_Number,
Address =@Address,
City = @City,
State = @State,
Zip_Code = @Zip_Code where Consultant_Id = @Consultant_Id    
END

Regards,
Iftikar

in this stored procedure you are not passing the @Consultant_Id  but checking thats why it showing error.

i modified the stored procedure just check


create procedure consultant_Update
(

@Consultant_Id  Int,
@name varchar(50),
@Phone_Number varchar(50),
@Address varchar(50),
@City varchar(50),
@State varchar(50),
@Zip_Code varchar(50),

)

AS
BEGIN
update consultant set
name = @name,
Phone_Number = @Phone_Number,
Address =@Address,
City = @City,
State = @State,
Zip_Code = @Zip_Code where Consultant_Id = @Consultant_Id 
END

GO



if Consultant_Id in varchar the take parameter as @Consultant_Id  varchar(50)