I created paramerised store procedure using join query but getting same result

[poonamt]

Hello Friends,
I created web application in .net using C# where i created parameterized store procedure for join query but its showing me same result for different parameter in .net but when i executed that store procedure in sql server in gives me the result.please help me

      protected void Button1_Click(object sender, EventArgs e)
        {
            
            
                cmddispInfo = new SqlCommand("displayDetailsofemp", conn);
                cmddispInfo.CommandType = CommandType.StoredProcedure;
                cmddispInfo.Parameters.Add("@deptid", SqlDbType.Int).Value = Convert.ToInt32(ddldeptid.SelectedValue);
                adpatShowDetails = new SqlDataAdapter(cmddispInfo);
                adpatShowDetails.Fill(dsDisplay);
                GridView1.DataSource = dsDisplay;
                GridView1.DataBind();
            

        }

[PsychoCoder]

We're going to have to see the stored procedure you're executing to determine why it isn't working the way you need/want it to