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
Ïà¹ØÎÊ´ð£º
±íÈçÏÂ
½ÌÊÒID ×ùλÊý ¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä 2009Äê1ÔÂ1ÈÕ 2009Äê1ÔÂ2ÈÕ 2009Äê1ÔÂ3ÈÕ
101 50 08£º00 08£º30 30 40 50
101 50 09£º00 ......
ÐèÇóÈçÏ£º
a±í:
p_id status
1 0
2 0
b±í
rec_id pid purchase_qty receive_qty flag
1 1 10 10 0
2 ......
txt ºÍXML ¸ñʽÏàÓ¦
²»½èÖúDataSet
µ¼Èë¶ÁÈ¡TXTÎļþ
È»ºóÖ±½ÓдÈëXML(ͬһÎļþ,²»Í¬Êý¾Ý,µÝÔöÔÊý¾ÝûÓб»¸²¸ÇÇé¿öÏÂÔö¼ÓÊý¾Ý.)
½Ì¸öÒªµã»ò×îºÃÊÇÓиö´úÂëÌáʾµÄ
¹ý·ºÃºº °ï¸öæÈö^^
²»»á£¬°ïÂ¥Ö÷ ......
´ó¼ÒºÃ£¬ÎÒ×î½üά»¤Ò»¸öÏîÄ¿£¬100¶à¸ö±í
Ö»ÄÜÓÃjdbcÖ±Á¬
Óöµ½Á˶à¸ö±í ¹ØÁª ²éѯµÄÇé¿ö Çë´ó¼ÒÖ¸½Ì
±ÈÈç
student(studentid,classid)
class(classid,classname)
class_teacher(classid,teacherid)Õâ¸öÊÇÖмä±í ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......