Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

visual 2005Á¬½Ósql 2005

¸÷λǰ±²£¬ÎÒÊÇÐÂÊÖ£¬ÔÚvisual 2005ÖÐʹÓÃC££.netÁ¬½Ósql 2005,Á¬½Ó²»ÉÏÊý¾Ý¿â´íÎóÌáʾÈçÏ£º
Óû§´úÂëδ´¦ÀíSqlException
ÔÚ½¨Á¢Óë·þÎñÆ÷µÄÁ¬½Óʱ³ö´í¡£ÔÚÁ¬½Óµ½ SQL Server 2005 ʱ£¬ÔÚĬÈϵÄÉèÖÃÏ SQL Server ²»ÔÊÐí½øÐÐÔ¶³ÌÁ¬½Ó¿ÉÄܻᵼÖ´Ëʧ°Ü¡£ (provider: ÃüÃû¹ÜµÀÌṩ³ÌÐò, error: 40 - ÎÞ·¨´ò¿ªµ½ SQL Server µÄÁ¬½Ó)
ÎҵĴúÂëÈçÏ£º
DB.CS´úÂ룺
public static SqlConnection createConnection()
{
return new SqlConnection("Server=.;Database=website;Uid=sa;Pwd=;");

}

GridView´úÂ룺

if (!this.IsPostBack)
{
SqlConnection con=db.createConnection();
con.Open();£­£­£­´íÎó³öÏÖÔÚÕâÀ²»ÖªµÀʲôԭÒò
SqlCommand cmd = new SqlCommand("select news_title from news",con);
SqlDataReader sdr = cmd.ExecuteReader();
this.GridView1.DataSource = sdr;
this.GridView1.DataBind();

}
1.°Ñtcp/ip´ò¿ª


°Ñ´íÎó·Åµ½googleÉÏËÑË÷°É

SQL SERVER2005ûÓÐÆôÓðɡ£ÄãÊÇɶ²Ù×÷ϵͳ¡£

1.°Ñtcp/ip´ò¿ª ¾Í¿ÉÒÔÁË
×Ô¼ºÉÏÍøÕÒÒ»ÏÂÔõô´ò¿ª tcp/ip¹ÜµÀ

ÔÚÁ¬½Óµ½SQL Server2005ʱ,ÔÚĬÈϵÄÉèÖÃÏÂSQL Server²»ÔÊÐí½øÐÐÔ¶³ÌÁ¬½Ó¿ÉÄܻᵼÖ´Ëʧ°Ü--µÄ½â¾ö

ÒýÓÃ
SQL SERVER2005ûÓÐÆôÓðɡ£ÄãÊÇɶ²Ù×÷ϵͳ¡£

ÎÒÓõÄXPµÄ

ÒýÓÃ
1.°Ñtcp/ip´ò¿ª  ¾Í¿ÉÒÔÁË
×Ô¼ºÉÏ


Ïà¹ØÎÊ´ð£º

Êý¾ÝÒÔxml¸ñʽ·µ»Ø - MS-SQL Server / Ó¦ÓÃʵÀý

´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......

ASPÁ´½ÓSQLµÄ¼òµ¥µÇ½½çÃæ - .NET¼¼Êõ / ASP.NET

protected void btnLogin_Click(object sender, EventArgs e)
  {
  SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......

sqlserver´íÎó - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬
sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º
ÈÕÆÚ 2010-1-25 14:45: ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ