sqlÓï¾ä²éѯÔõôÅжϲéѯ½á¹ûΪ¿Õ£¿
sqldataadapterÊʺÏÓÃÔÚ²éѯ½Ï¶à×Ö¶Îʱ.....
string sou = "select * from art where content like '%" + TextBox1.Text + "%'";
SqlDataAdapter da = new SqlDataAdapter(sou, conn);
DataSet ds = new DataSet();
da.Fill(ds);
if (ds.Tables[0].rows.count==0)
{
Response.Write("ûÓмǼ£¡");
}
else
{
this.sou.DataSource = ds;
this.sou.DataBind();
}
ÎÊÌâ³ö´¦:http://topic.csdn.net/u/20100120/18/815c7c81-51ab-4c30-ae81-138ebae9acc6.html?seed=1865372266&r=62957114#r_62957114
Ïà¹ØÎĵµ£º
ÈçºÎ½â¾ö SQL Server 2000 ÖеÄÁ¬½ÓÎÊÌâ
Chris Tull, Microsoft Help and Support
ÕâһƪÎÄÕÂÄܰïÖúÄã½â¾ö΢Èí SQL ËźòÆ÷ 2000 µÄÁ¬½ÓÐÔÎÊÌâ¡£ÕâһƪÎÄÕ°üº¬ÄãÄÜÄðïÖú½â¾öÄãµÄÁ¬½ÓÐÔÎÊÌâµÄͨ³£Á¬½ÓÐÔÎÊÌâºÍ²½ÖèµÄÃèÊö¡£
SQL ServerµÄÀýÖ¤ºÍ¿Í»§¶ËÉêÇëÖ®¼äµÄ¹µÍ¨µÄ SQL Server 2000 Ö§³ÖһЩ·½·¨¡£Èç¹ûÄãµÄ¿Í»§ÉêÇëºÍS ......
ÔÚÓ¦ÓÃϵͳ¿ª·¢³õÆÚ£¬ÓÉÓÚ¿ª·¢Êý¾Ý¿âÊý¾Ý±È½ÏÉÙ£¬¶ÔÓÚ²éѯSQLÓï¾ä£¬¸´ÔÓÊÓͼµÄµÄ±àдµÈÌå»á²»³öSQLÓï¾ä¸÷ÖÖд·¨µÄÐÔÄÜÓÅÁÓ£¬µ«ÊÇÈç¹û½«Ó¦ÓÃϵͳÌύʵ¼ÊÓ¦Óúó£¬Ëæ×ÅÊý¾Ý¿âÖÐÊý¾ÝµÄÔö¼Ó£¬ÏµÍ³µÄÏìÓ¦ËٶȾͳÉΪĿǰϵͳÐèÒª½â¾öµÄ×îÖ÷ÒªµÄÎÊÌâÖ®Ò»¡£ÏµÍ³ÓÅ»¯ÖÐÒ»¸öºÜÖØÒªµÄ·½Ãæ¾ÍÊÇSQLÓï¾äµÄÓÅ»¯¡£¶ÔÓÚº£Á¿Êý¾Ý£¬ÁÓÖÊSQLÓï¾ä ......
ORA-07445 Óë PL/SQL Developer °¸ÀýÒ»Ôò
×÷Õߣºeygle |English Version ¡¾×ªÔØÊ±ÇëÒÔ³¬Á´½ÓÐÎʽ±êÃ÷ÎÄÕ³ö´¦ºÍ×÷ÕßÐÅÏ¢¼°±¾ÉùÃ÷¡¿
Á´½Ó£ºhttp://www.eygle.com/archives/2009/02/ora_07445_plsql_developer.html
--------------------------------------------------------------------------------
ǰ¼¸Ì죬ÓÖÓÐÒ»¸ö ......
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
namespace ConsoleApplication4
{
class Program
{
static void Main(string[] args)
{
//sqlserverÉí·ÝÑéÖ¤
//string sqlconn = "ser ......
½ñÌìÎÒѧϰÁËsqlµÄ¼òµ¥²éѯÓï¾ä£¬
һЩ»ù±¾µÄ¸ÅÄ
1 ϵͳȨÏÞ£ºÊý¾Ý¿âÖеĶÔÏó£¬ ±í£¬´´½¨±í£¬É¾³ý±í
2 ¶ÔÏóȨÏÞ£º¶ÔÊý¾ÝµÄÔö¡¢É¾¡¢¸Ä¡¢²é¡ ......