C# SQL ¼òµ¥ÎÊÌâ
select count(*) from Stu Ôõô°ÑÕâ¸ö²éѯ½á¹ûÔÚlableÉÏÏÔʾ?
lable.Text=??
·µ»ØµÄÊÇÒ»¸öobject£¬Ö±½ÓTostring()¾ÍÐÐÁË
´úÂëÔõôд?
public string GetCount()
{
string R = string.Empty;
using (OracleConnection Conn = new OracleConnection("Á¬½Ó´®"))
{
OracleCommand Comm = Conn.CreateCommand();
Comm.CommandText = "select count(*) from St";
Comm.ExecuteNonQuery();
R = Comm.ExecuteReader()[0].ToString();
}
return R;
}
Äã±íÀïÃæ¾ÍÒ»¸ö×Ö¶ÎÂð£¿
Èç¹û¶àµÄ»°¾ÍÓÃÒ»¸öÑ»·È¥ÊµÏÖ¡£
public object GetCount()
{
using (OracleConnection Conn = new OracleConnection("Á¬½Ó´®"))
{
Oracl
Ïà¹ØÎÊ´ð£º
´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......
ÔÚÊý¾Ý¿âÖÐÓÐÕÅ±í£¬ÓÐid,nameÁ½ÁУ¬id ÊÇÖ÷¼ü,ûÓÐÉèÖÃ×ÔÔöÊôÐÔ,ÔÚ³ÌÐòÖÐÈ¡³öÕâÕűí·ÅÈëdatatable£¬ÔÚÕâ¸ödatatableÖвåÈëÒ»Ìõ¼Ç¼£¬µ±¸üÐÂÊý¾Ý¿âʱÌáʾidÁв»ÄÜΪ¿Õ£¬ÇëÎʸÃÔõô½â¾ö£¿
¸øËüÒ»¸öÖµ£¡£¡Ö÷¼ü²»ÄÜΪ¿Õ ......
sql 2005Êý¾Ý¿âÎÒÏëµÃµ½Ò»×Ö·û´®Îª:
sldkf|||sdeww
erkv|||rltdk
jemcl|||ligf
¾ÍÊÇ|||ºóÃæµÄ×Ö·ûÓÐʲôº¯ÊýÄܵõ½Âð£¿ÊÇÔÚsqlÓï¾äдµÄ£¬²»ÊÇÔÚÒ³ÃæÐ´µÄ£¬ÄÇλ¸ßÊÖÀ´Ö¸½ÌÏ£¬ÐÂÊÖ£¬Ð»Ð»
ÔÎ µ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......