i have table called cus_details which contains all the details about the customer details.
i need to get one or two customer details when user selected.
if i pass one values means it shows records.
ReturnNewViewcmd.Parameters.AddWithValue("@id", '28119'); if it's two values means query returns no records
con.Open();
ReturnNewViewcmd.Connection = con;
//old proc CES_CIR_JIV_RESTOCKNEWRETURNS_sample
ReturnNewViewcmd.CommandText = "reports_customer";
ReturnNewViewcmd.CommandType = CommandType.StoredProcedure;
ReturnNewViewcmd.Parameters.AddWithValue("@id", '28119,28778'); //no record found
ReturnNewViewda = new SqlDataAdapter(ReturnNewViewcmd);
ReturnNewViewda.Fill(ReturnNewViewdt);
create proc reports_customer(
@id varchar(100)
)
as begin
select * from cus_details where cus_id in (@id)
endThanks