测试 sql语句的运行时间

 #region 搜索 InitdltSearchnew1
  private void InitdltSearchnew1()
  {
    string sqlstr = string.Format(@"
        declare @d datetime
        set @d=getdate()  
        select top 6 ArtId,Title,Articles.Created,ClsName,Content
        from Articles join NewsCls
        on NewsCls.ClsId=Articles.ClsId
        where Title like '%{0}%'or Content like '%{0}%'
        order by ArtId desc
        select [searchtime]=datediff(ms,@d,getdate())
        ",Title);
   IStatement dbment = Db.CreateStatement();
   dbment.CommandText = sqlstr;
   DataSet ds = dbment.GetDataSet();
   if(ds.Tables[0] != null)
   {  
    ds.Tables[0].Columns.Add("Alert");
    for(int i=0;i<ds.Tables[0].Rows.Count ;i++)
    {
     string NohtmlContent=Common.StringTools.NoHTML(ds.Tables[0].Rows[i]["Content"].ToString());
     int   SearchTitlePlace=ds.Tables[0].Rows[i]["Title"].ToString().IndexOf(Title);
     int   SearchContentPlace=NohtmlContent.IndexOf(Title);
     ds.Tables[0].Rows[i]["Alert"] =ds.Tables[0].Rows[i]["Title"].ToString();
     if(SearchTitlePlace>-1)
     {
      
      ds.Tables[0].Rows[i]["Title"]=ds.Tables[0].Rows [i]["Title"].ToString().ToLower().Replace(Title.ToLower(), "<font color='#FF0000'>"+Title+"</font>");
     }
     else
     {
      ds.Tables[0].Rows[i]["Title"] = Common .CommonClass.RepSubString(ds.Tables[0].Rows[i]["Title"].ToString(),0,30,"...");
     }
     if(SearchContentPlace>-1)
     {
      ds.Tables[0].Rows[i]["Content"]=Common .CommonClass.OverWriteRepSubString(NohtmlContent,SearchContentPlace-50,150,"...").Replace(Title.ToLower(), "<font color='#FF0000'>"+Title+"</font>");
     }
     else
     {
      ds.Tables[0].Rows[i]["Content"] = Common .CommonClass.RepSubString(NohtmlContent,0,150,"...");
     }
    }

    dltSearchnew1.DataSource = ds.Tables[0];
    dltSearchnew1.DataBind();
   }
   sSeachTime+=int.Parse(ds.Tables[1].Rows[0][0].ToString());
  }
  #endregion