вот код
protected System.Web.UI.WebControls.DropDownList DD_Equpment;
public void UploadBtn_Click(object sender, System.EventArgs e)
{
SqlConnection connection = null;
SqlCommand command;
string UserID ="1";
try {
connection = new SqlConnection("------");
command = new SqlCommand( "ListEqupment", connection );
SqlParameter param1 = new SqlParameter( "@m_userid", SqlDbType.Int );
param1.Value = UserID;
command.Parameters.Add( param1 );
connection.Open();
DD_Equpment.DataSource=command.ExecuteReader();
DD_Equpment.DataTextField="equpmentname";
DD_Equpment.DataValueField="equpmentid";
DD_Equpment.DataBind();
connection.Close();
}

catch(Exception myException)
{
ErrorMessage.Text = "Oops. The error: " + myException.Message;
}
finally
{
connection.Close();
}
}
Процедура на sql
Create Proc ListEqupment
(
@m_userid Int
)
As
(
Select equpmentname,equpmentid from
equpment Where user_id=@m_userid
)

GO
выпадает исключение которое перехватывается
Oops. The error: Line 1: Incorrect syntax near 'ListEqupment'.
уже битый час сижу не вижу ошибок
Спасибо

Спасибо огромное !!
Это было оно