thanks alot it did it
this is my code
protected void LinkButton1_Click(object sender, EventArgs e)
{
string code = (sender as LinkButton).CommandArgument;
SqlCommand _cmd = new SqlCommand("showoffer", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cmd.Parameters.AddWithValue("@Model", code);
_cn.Open();
SqlDataReader _dr = _cmd.ExecuteReader();
if (_dr.HasRows)
{
DataList1.DataSource = _dr;
DataList1.DataBind();
}
_cn.Close();
}
and SP
ALTER procedure [dbo].[showoffer]
@Model nvarchar(30)
as
begin
select Description,Name,Model,Garranty,Country,image,image1,image2
from House_p
where Model=@Model
end