How to pass values to a view in sql server

[>Kareem<]

I have created a view called business this runs sucessfully ,but the problem is how will i use dynamic values in place of 12.925432,77.5940171 ,I want to pass parameter in sql query from c# code behind.\[code\]create view [dbo].[business] as SELECT Id, Name1, ZipCode, StreetName, StreetNumber, State1, Lat, Lng, Keyword, ( 6371 * ACOS( COS( (12.925432/57.2958) ) * COS( (Lat/57.2958) ) * COS( ( Lng/57.2958 ) - (77.5940171/57.2958) ) + SIN( 12.925432/57.2958 ) * SIN( Lat/57.2958 ) ) ) AS distance FROM Business_Details ;\[/code\]This will be my query from c# code behind.....\[code\]DataSet ds = new DataSet();SqlCommand com = new SqlCommand();SqlDataAdapter sqlda = new SqlDataAdapter(com);//sqlda.SelectCommand.CommandText = "SELECT Id,Name1,ZipCode,StreetName,StreetNumber,State1,Lat,Lng,Keyword, ( 6371 * ACOS( COS( (12.925432/57.2958) ) * COS( (Lat/57.2958) ) * COS( ( Lng/57.2958 ) - (77.5940171/57.2958) ) + SIN( 12.925432/57.2958 ) * SIN( Lat/57.2958 ) ) ) AS distance FROM Business_Details where( (StreetName like '%jayanagar%')and (Keyword like '%plumbing%' ))ORDER BY distance;";sqlda.SelectCommand.CommandText = "select * from business where (( distance < '" + radius + "' ) and (StreetName like '%" + streetname + "%') and (Keyword like '%" + keyword1 + "%' )) order by distance";sqlda.SelectCommand.Connection = con;sqlda.Fill(ds);con.Close();.....\[/code\]