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²»ÔÊÐí½øÐÐÔ¶³ÌÁ¬½Ó¿ÉÄܻᵼÖ´Ëʧ°Ü--µÄ½â¾ö
ÎÒÓõÄXPµÄ
Ïà¹ØÎÊ´ð£º
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......
protected void btnLogin_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......
sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬
sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º
ÈÕÆÚ 2010-1-25 14:45: ......