°ïÎÒ½âÊÍһϴúÂë¹ØÓÚ²åÈë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¸öÈý½ÇÁË£¬»á²»¶®£¿
Ïà¹ØÎÊ´ð£º
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......
sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡
Ëæ±ã¸ãÒ»D°æ°É£¬
ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù
http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬
sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º
ÈÕÆÚ 2010-1-25 14:45: ......
tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......