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

°ïÎÒ½âÊÍһϴúÂë¹ØÓÚ²åÈësqlÓï¾äµÄ

C# code:

//λÓÚperson.csÒ³Ãæ
public class person
{
public string pUser;
public string pPass;

public person()
{
//
//TODO: ÔÚ´Ë´¦Ìí¼Ó¹¹Ô캯ÊýÂß¼­
//
}
}

//λÓÚDbHelper.csÒ³ÃæÖÐ ¹Ø¼üÊÇÕâ¶Î´úÂëÎÒ²»¶®
public static bool insertMethod(person p)
{
SqlConnection conn = DbHelp.creatConn();
conn.Open();
SqlCommand cmd = new SqlCommand("insert into t_user values(@p_user,@p_pass)", conn);
SqlParameter para = new SqlParameter("@p_user", SqlDbType.VarChar, 20);
para.Value = p.pUser;
cmd.Parameters.Add(para);
para = new SqlParameter("@p_pass", SqlDbType.VarChar, 20);
para.Value = p.pPass;
cmd.Parameters.Add(para);
cmd.ExecuteNonQuery();
return true;
}

//λÓÚadd.csÒ³ÃæÖÐ
protected void btnSubmit_Click(object sender, EventArgs e)
{
person p = new person();
p.pUser = this.TextBox1.Text;
p.pPass = this.TextBox2.Text;
if (DbHelp.insertMethod(p))
{
Response.Write("success");
}
}




Äã¶¼3¸öÈý½ÇÁË£¬»á²»¶®£¿

ÒýÓÃ
C# code//λÓÚDbHelper.csÒ³ÃæÖÐ ¹Ø¼üÊÇÕâ¶Î´úÂëÎÒ²»¶®publicstaticbool insertMethod(person p)
{
SqlConnection conn


Ïà¹ØÎÊ´ð£º

sqlת»»ÎÊÌ⣬¼±£¡ - ÉçÇøÖ§³Ö / ¡¶³ÌÐòÔ±¡·ÔÓÖ¾

select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

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

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

sql - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡

Ëæ±ã¸ãÒ»D°æ°É£¬

ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù

http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......

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

sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬
sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º
ÈÕÆÚ 2010-1-25 14:45: ......

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ