How to get data by Id

Ramco Ramco

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

public List GetAllCustomer()
{
List objCustomer = new List();
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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted 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;
                }
        }
+2
Salman Beg5y ago
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
+1
Ramco Ramco5y ago
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
+1
Salman Beg5y ago
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
+1