这个一般都是由于主题引用了不存在的分类导致的

解决方法:
1 查看已经被删除了的分类id

SELECT DISTINCT typeid FROM web.dnt_topics WHERE typeid NOT IN (SELECT DISTINCT typeid FROM web.dnt_topictypes)

2 更新包含此分类的主题

UPDATE dnt_topics SET typeid=0 WHERE typeid IN (a1,a2,a3)

a1,a2,a3就是上面查询的结果(排除0)

转自：http://summer.xiye.cn/showtopic-117.aspx

• 这个是加密代码,使用的进制转换,c#的是使用char数组,在使用39.9511,119.60881 这两个值时,就会有差异...找了半天,很乱,就不管了.
• function jiami(e53,B92_)
  {
  var WVd94=parseInt(parseFloat(e53)*100000);
  var j7_2=parseInt(parseFloat(B92_)*100000);
  var rpB=(j7_2-WVd94+parseInt(licenseKey)).toString(16);
  var ie9=(j7_2+WVd94).toString(16);
  var H1433='';
  for(var i=0;i<rpB.length;i++)
  {
  var k6A36=parseInt(rpB.charAt(i),16);
  H1433+=(((k6A36>=10)?(k6A36+7):k6A36)+10).toString(36)
  }
  H1433+='z';
  for(var i=0;i<ie9.length;i++)
  {
  var k6A36=parseInt(ie9.charAt(i),16);
  H1433+=(((k6A36>=10)?(k6A36+7):k6A36)+10).toString(36)
  }
  return H1433.toUpperCase();
  }
  ------------------------------上面是js的加密代码------------------------------------------

               float floatstr1 = float.Parse(str1);
               float floatstr2 = float.Parse(str2);
               string chars16 = "0123456789ABCDEF";
               string chars36 = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ";
               int intstr1 = Convert.ToInt32(floatstr1 * 100000);
               int intstr2 = Convert.ToInt32(floatstr2 * 100000);
               string strtemp1 = Parse((intstr2 - intstr1 + licenseKey), chars16);
               string strtemp2 = Parse((intstr1 + intstr2), chars16);
               string strtemp3 = "";
               StringBuilder strb1 = new StringBuilder(strtemp1);
               StringBuilder strb2 = new StringBuilder(strtemp2);
               int maxLength1 = strb1.Length;
               int maxLength2 = strb2.Length;

•                for (int i = 0; i < maxLength1; i++)
                 {
                     int inttemp = Parse1(strb1[maxLength1-1-i], chars16);
                     strtemp3 += Parse((((inttemp >= 10) ? (inttemp + 7) : (inttemp)) + 10), chars36);
                 }
                 strtemp3 += "Z";
                 for (int i = 0; i < maxLength2; i++)
                 {
                     int inttemp = Parse1(strb2[maxLength2-1-i], chars16);
                     strtemp3 += Parse((((inttemp >= 10) ? (inttemp + 7) : (inttemp)) + 10), chars36);
                 }
                 Console.WriteLine(strtemp3.ToUpper());
                 Console.Read();
                // return strtemp3.ToUpper();
•            }
            public static string Parse(int num, string chars)
             {
                 StringBuilder sb1 = new StringBuilder();
                 while (num > 0)
                 {
                     sb1.Append(chars[num % chars.Length]);
                     num /= chars.Length;
                 }
                 return sb1.ToString();
•            }
             public static int Parse1(char charValue, string chars)
             {
                 char[] chartemp = chars.ToCharArray();
                 int result = 0;
                 for (int i = 0; i < chartemp.Length; i++)
                 {
                     if (charValue.Equals(chartemp[i]))
                     {
                         result = i;
                         break;
                     }
                 }
                 return result;
             }
          }
•    ---------------------------这上面是c#代码----------------------------

reg扩展名的注册文件不能有空格,否则系统会判断错误!!!

title="<%# XPath('rate')%>"   // 千万记得别用两双引号.

public void test(object sender,ajaxtoolkit.ratingEventargs e)
{
    e.tag=表达式;
}

gridviewRowEventargs e //同上

e.Row.Cells[0].Attributes.Add("onmouseout","javascript代码");

xml内存读取

xmlDocument xd =new XmlDocument();
xd=XmlDSrating.GetXmlDocument();
string path="路径";
xmlNodeList xnl;
xnl =xd.SelectNodes(path);

    public void allchecked(object sender, Eventargs e)
    {
        for (int i = 0; i < GridView1.Rows.Count; i++)
        {
            ((CheckBox)GridView1.Rows[i].FindControl("CheckBox1")).Checked = true;//两个括号
        }   //checkbox的属性 autopostback 得设置为true  要不,不会触发服务器.
    }
//输出gridview上的值到excel;
        Response.Clear();
        Response.Buffer = true;
        Response.AppendHeader("Content_disposition", "attachment;filename=FileName.xls");
        Response.ContentEncoding = System.Text.Encoding.UTF7;//不能使用gb2312,出乱码;
        Response.ContentType = "application/ms_excel";
        StreamWriter sw = new StreamWriter();
        HtmlTextWriter htw = new HtmlTextWriter(sw);
        this.GridView1.RenderControl(htw);
        Response.Output.Write(sw.ToString());
        Response.Flush();
        Response.End();

做gridview的自定义翻页按钮时,必须使用手动绑定..
public void GridView1_PageIndexChanging(object sender,gridviewPageEventargs e)
{
   gridview1.pageIndex=e.NewPageIndex;//前一页就是pageindex等于pageindex-1,最后一页就是pageindex=pagecount-1
   GridViewDataBind();
}
存储过程在OleDb里的指令是CommandType.Text,在SqlCommand里是COmmandType.StoreProcedure;
SqlCommand scmd=new sqlcommand();
cmd.CommandText="ReadCustomerAndOrders";//存储过程
SqlDataReader rd=scmd.ExecuteReader();
if(rd.read())
//...read result set
reader.NextResult();

private static void ReadOrderData(string connectionString)
{
    string queryString =
        "SELECT OrderID, CustomerID FROM dbo.Orders;";
    using (SqlConnection connection = new SqlConnection(    //这时候用using..
               connectionString))
    {
        SqlCommand command = new SqlCommand(
            queryString, connection);
        connection.Open();
        SqlDataReader reader = command.ExecuteReader();
        try
        {
            while (reader.Read())
            {
                Console.WriteLine(String.Format("{0}, {1}",
                    reader[0], reader[1]));
            }
        }
        finally
        {
            // Always call Close when done reading.
            reader.Close();
        }
    }
}