You need to add the parameters to execute SP.
Find the code sample below.
SqlCommand cmd = new SqlCommand();<br />
cmd.Connection = sqlcon;<br />
cmd.CommandText = "GetLinkName";<br />
cmd.CommandType = CommandType.StoredProcedure;<br />
<br />
#region Parameters<br />
SqlParameter p = new SqlParameter();<br />
p.ParameterName = "@pagename";<br />
p.Value = "something";
p.SqlDbType = SqlDbType.NVarChar;<br />
cmd.Parameters.Add(p);<br />
<br />
p = new SqlParameter();<br />
p.ParameterName = "@pagelinks";<br />
p.Value = "something";
p.SqlDbType = SqlDbType.NVarChar;<br />
cmd.Parameters.Add(p); <br />
<br />
#endregion<br />
<br />
SqlDataAdapter da = new SqlDataAdapter(cmd);<br />
DataSet ds = new DataSet();<br />
da.Fill(ds);<br />
MyList.DataSource = ds;<br />
MyList.DataBind();