CC

if(mDataSet.Tables[10].Rows.Count > 0)
    {
     for(int i=0; i < mDataSet.Tables[10].Rows.Count; i++)
     {
      this.labTag.InnerText += mDataSet.Tables[10].Rows[i]["caption"].ToString() + ",";
     } 
    
     this.labTag.InnerText = this.labTag.InnerText .Substring(0,this.labTag.InnerText.Length - 1);
    }
Security security = new Security();
//   if (TextBox1.Text.Trim().ToString()!="")
//   {
//    TextBox1.Text=security.Sqltring(TextBox1.Text.Trim().ToString());
//    TextBox1.Text=TextBox1.Text.Replace("，",",");
//    string[] arry=TextBox1.Text.Split(',');
//    string newid=Request.Params["id"].ToString();
//    string dsn = ConfigurationSettings.AppSettings["conn_DB"].ToString();
//    SqlConnection myConn = new SqlConnection(dsn);
//    for(int i=0;i<arry.Length;i++)
//    {
//     SqlCommand myComm=new SqlCommand();
//     myConn.Open();
//     myComm.Connection=myConn;
//     myComm.CommandType=CommandType.StoredProcedure;
//     myComm.CommandText="tj_keyword";
//     myComm.Parameters.Add(new SqlParameter("@id",SqlDbType.BigInt));
//     myComm.Parameters.Add(new SqlParameter("@keyword",SqlDbType.VarChar));
//     myComm.Parameters["@id"].Value=newid.ToString();
//     myComm.Parameters["@keyword"].Value=arry[i].Trim().ToString();
//     SqlDataReader reader=myComm.ExecuteReader();
//                    myConn.Close();
//   Response.Write ("<script language=javascript>confirm('推荐成功？');window.opener=null;window.close();</script>");
<add key="DBConnection" value = "Password=654123;User ID=sa;Server=SPB361-SERVER;Database=spb_db"  />
//