How to get data by Id

Question

Hi

I have belwo for all Customers. What will bet the procedure for GetById & how to fecth in Controller

public List<Customer> GetAllCustomer()
{
List<Customer> objCustomer = new List<Customer>();
using (SqlConnection con = new SqlConnection(Common.Con))
{
con.Open();
SqlCommand cmd = new SqlCommand("sp_Customer", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", "R");
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
objCustomer.Add(new Customer
{
Id = rdr["Id"].ToString(),
Description = rdr["Description"].ToString(),
IsActive = Convert.ToBoolean(rdr["IsActive"]),
});
}
return objCustomer;
}
}

Thanks

Sachin Singh · Answer

procedure create procedure spGetCustomerById @Id int =null as begin select * from CustomerTable where Id=@Id end method public Customer GetAllCustomer( int Id) { Customer objCustomer = new Customer(); using (SqlConnection con = new SqlConnection(Common.Con)) { con.Open(); SqlCommand cmd = new SqlCommand( "spGetCustomerById" , con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue( "@Id" , Id); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { objCustomer.Add( new Customer { Id = rdr[ "Id" ].ToString(), Description = rdr[ "Description" ].ToString(), IsActive = Convert.ToBoolean(rdr[ "IsActive" ]), }); } return objCustomer; } }

Salman Beg · Answer

You can see this link and create partial view and call it. Create another action method and there you need to pass id as a parameter. https://www.tutorialsteacher.com/articles/how-to-bind-model-to-partial-view https://www.codeproject.com/Tips/898017/Different-Ways-to-Pass-Data-to-Partial-View

Ramco Ramco · Answer

Hi This will remai same public List GetAllCustomer() { Secondly i want to call Partial View. Can u pls guide what will be the controller. I have already created Stored Procedure Thanks

Salman Beg · Answer

You need to create another stored procedure and where you need to pass id as a parameter. And in the stored procedure put where condition. For example, select * from Emp where Id=1; so in this sql line inplace of 1 you need to pass your id from ui and based on that it will retrieve all the value and return the result. Thanks