在文本框中给定值时显示特定数据 [英] To display the paticular data when a value is given in the textbox

问题描述

当我在文本框中给出一个值(id)时，我应该在fckeditor的同一页面上获取特定数据(例如我的情况下的描述).为此，我编写了一种方法如下:

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

但是我知道要在哪里校准此方法.一旦我在文本框中输入一个值并按Tab键，我就应该获取数据.我什至怀疑还有其他方法可以编写此程序以满足任何人的需要，请帮助我.

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.

推荐答案

看看

这篇关于在文本框中给定值时显示特定数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！