Your StoreProcedure :
create procedure SP_Example(@var1 varchar(20))
As
Begin
Select Column1 ,Column2,Column3 From tempTable where Column1= @var1
End
-----------
Code for asp.net
SqlCommand Cmd;
SqlDataReader dr;
SqlConnection Con = new SqlConnection("Your connection String");
Cmd = new SqlCommand("SP_Example", Con);
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.Parameters.Add("@Column1 ",SqlDbType.VarChar).Value="D025";
Con.Open();
while(dr.read())
{
Response.Write(dr[0].ToString()+" "+dr[1].ToString()+" "+ dr[2].ToString()+"\n");
}