Procedure or function 'spDATA_UPDATE' expects parameter '@Phone', which was not supplied.
#database procedure
alter PROCEDURE [dbo].[spDATA_UPDATE]
@Phone as bigint,
@address as varchar(20),
@email_id as varchar(20)
AS
BEGIN
UPDATE Customer08_Details SET address=@address,email_id=@email_id , Phone=@Phone
END
GO
# dataacess layer
try
{
SqlConnection conn = new SqlConnection(constring);
conn.Open();
SqlCommand cmd = new SqlCommand("spDATA_UPDATE", conn);
cmd.Parameters.AddWithValue("@Phone", DbType.Int64).Value = Phone;
cmd.Parameters.AddWithValue("@email_id", DbType.String).Value = email_id;
cmd.Parameters.AddWithValue("@address", DbType.String).Value = Address;
adp = new SqlDataAdapter(cmd);
adp.Fill(dt);
conn.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return dt;
}
# business logic layer
public DataTable updateCustomerDetai(Int64 Phone, string email_id, string address)
{
DataTable dt = new DataTable();
dt = dal.updateCustomerDetails(Phone, email_id, address);
return dt;
}
#code behind of grid view
protected void gridView_Rowupdating(object sender,GridViewUpdateEventArgs e)
{
DataTable dt = new DataTable();
TextBox phone_no = gridView.Rows[e.RowIndex].FindControl("txtPhone") as TextBox;
long Phone = Convert.ToInt64(phone_no.Text);
TextBox Address = gridView.Rows[e.RowIndex].FindControl("txtAddress") as TextBox;
string address = Address.Text;
TextBox Email = gridView.Rows[e.RowIndex].FindControl("txtEmail") as TextBox;
string Email_id = Email.Text;
dt = bal.updateCustomerDetai(Phone, Email_id, address);
}
2 Replies
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Amit GuptaPosted Sep 25, 2017, 6:30 AM
Sundaram SubramanianPosted Sep 25, 2017, 4:39 AM