asp.net ¶à×Ö¶ÎÄ£ºý²éѯ´úÂë
¾³£Óõ½¶à×ֶεÄÄ£ºý²éѯ£¬ÉÏÃæµÄº¯Êý¿ÉÒÔʵÏÖ£¬ÀýÈçstrKeyWordsֵΪ“½Å±¾Ö®¼Ò”ʱ
string strField = "id|className|classAdd";
string strKeyWords = this.tbxKeyWords.Text.Trim();
string strSql = dbexe.searchText("select * from class", strField, strKeyWords);
¾³£Óõ½¶à×ֶεÄÄ£ºý²éѯ£¬ÉÏÃæµÄº¯Êý¿ÉÒÔʵÏÖ£¬ÀýÈçstrKeyWordsֵΪ“½Å±¾Ö®¼Ò”ʱ£¬¿ÉÒÔÊä³ö£º
select * from class where id like '%½Å±¾Ö®¼Ò%' or className like '%½Å±¾Ö®¼Ò%' or classAdd like '%½Å±¾Ö®¼Ò%'
º¯Êý£º
/// <summary>
/// ¸ù¾Ý¹Ø¼ü×ÖʵÏÖ¶à×Ö¶ÎÄ£ºý²éѯ
/// </summary>
/// <param name="sqlStr">select * from talbe sqlÓï¾ä</param>
/// <param name="sqlText">ÅжÏÓï¾äÌõ¼þ£¬ÊÇÒ»¸öÓÃ|¸ô¿ªµÄ×Ö·û´®</param>
/// <param name="keywords">¹Ø¼ü×Ö</param>
public static string searchText(string strSql, string strField, string keywords)
{
StringBuilder sb = new StringBuilder(strSql);
if (strField != string.Empty)
{
sb.Append(" where ");
string[] arrKey = strField.Split('|');
for (int i = 0; i < arrKey.Length; i++)
{
sb.Append(arrKey[i] + " like '%" + keywords + "%' or ");
}
string str = sb.ToString();
//È¥³ý×îºóÒ»¸ö"or"
if (str.IndexOf("or") >= 0)
{
return str.Remove(str.LastIndexOf("or"));
}
return str;
}
return strSql;
}
Ïêϸ³ö´¦²Î¿¼£ºhttp://www.jb51.net/article/15251.htm
Ïà¹ØÎĵµ£º
using System;
using System.Data;
using System.Diagnostics;
using System.Collections.Generic;
using MySql.Data.MySqlClient;
namespace System
{
/// <summary>
/// Description of MySqlDBUtil.
/// </summary>
public class MySqlDBUtil
{
&nbs ......
Asp.net¿Ø¼þ£¨°üÀ¨Web·þÎñÆ÷¿Ø¼þºÍHtml·þÎñÆ÷¿Ø¼þ£©¶¼Ã»ÓÐË«»÷ʼþ£¬ÄÇô¸ÃÈçºÎ½«Ë«»÷ʼþ¸¶¸øAsp.Net¿Ø¼þÄØ£¿ÎÒÃÇÒÔLable¿Ø¼þΪÀý¡£
Ò»¡¢Ê×ÏȼÓÈë¿Ø¼þ£¬IDΪLable1£¬È»ºó¼ÓÈëÒ»¸öButton¿Ø¼þ£¬IDΪButton1£¬´úÂëÈçÏÂ
& ......
Paging long articles in ASP.NET using C#
Long articles are better broken into bite-sized chunks over several pages. With static HTML, this is easily achieved by dividing the article into logical separations and creating separate .htm files for each. Here's how to do it using C# for an article that ......
Asp.netÍøÕ¾·¢²¼µ½IISÉÏ£¬²Ù×÷ÎļþµÄʱºò·¢Éú‘System.UnauthorizedAccessException:¶Ô·¾¶“***”µÄ·ÃÎʱ»¾Ü¾ø’¡£
˵Ã÷ûÓÐÊÚÓèAsp.net¶ÔÎļþµÄд·ÃÎÊȨ£¬ÍøÉÏÕÒÁËÒ»ÏÂ:
ÈôÒªÊÚÓè ASP.NET ¶ÔÎļþµÄд·ÃÎÊȨ£¬ÇëÔÚ×ÊÔ´¹ÜÀíÆ÷ÖÐÓÒ»÷¸ÃÎļþ£¬Ñ¡Ôñ“ÊôÐÔ”£¬È»ºóÑ¡Ôñ“°²È«”Ñ¡Ïî¿ ......
using System;
using System.Collections.Generic;
using System.Text;
namespace Common
{
/// <summary>
/// ת»»ÈËÃñ±Ò´óС½ð¶î¡£
/// </summary>
public class Rmb
{
/// <summary>
/// ת»»ÈËÃñ±Ò´óС½ð¶î
/// </summary>
/// <param name="num">½ð¶î</ ......