To display the paticular data when a value is given in the textbox

See more:

C#3.0

C#

when i give a value(id) in a textbox based on that i should get the paticular data(like description in my case) on the same page in the fckeditor.For this i have written a method as following:

private void GetCasestudy()
       {

           DataTable dt = new DataTable();
           dt = clsAdminBLL.GetCasestudy();
           if (dt.Rows.Count > 0)
           {
               FCKeditor1.Value = dt.Rows[0]["description"].ToString();
           }
       }

and my stored procedure as:

ALTER PROCEDURE [dbo].[getcasestudy]
    -- Add the parameters for the stored procedure here
    @txtcaseid  int
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    -- Insert statements for procedure here
    SELECT description from [GTK_Casestudy] WHERE casestudy_id=@txtcaseid
END

But iam understanding where to cal this method.As soon as i enter a value in the textbox and press tab i should get the data ..I even doubt that there is some other way to write the procedure for my need anyone please help me.