SelectCommand Problem

for some reason the following code fails. I want to present all of the information of the CD (from table B)that inlcudes the song name the user types in the text box(table A).

Meaning the user types the name, it's located in table A, for each CD id in table A I want to present all the info from table B. Do I have to use DataRelation?:

private void Button1_Click(object sender, System.EventArgs e)

{

System.Data.SqlClient.SqlDataAdapter da=new SqlDataAdapter();

string str=TextBox1.Text;

 

System.Data.SqlClient.SqlParameter sparam=new SqlParameter("@song",SqlDbType.NVarChar);

sparam.Direction=ParameterDirection.Input;

sparam.Value=str;

da.SelectCommand=new SqlCommand();

da.SelectCommand.Connection=sqlConnection1;

da.SelectCommand.CommandText="CdInfoSP";

da.SelectCommand.CommandType=CommandType.StoredProcedure;

da.SelectCommand.Parameters.Add(sparam);

 

da.Fill(dataSet11,"CdInfoSP");

 

DataGrid1.DataSource=dataSet11;

 

DataGrid1.DataBind();

DataGrid1.Visible=true;

 

 

}

 

My Stored procedure is:

CREATE PROCEDURE dbo.CdInfoSP  (@song nvarchar)
AS
select cd_id,cd_name,year from song_cd_artist,cd_info where
song_name like '%@song%' and cdofsong_id=cd_id
GO

 

I hope someone can help me!

Thanks in advance!