access db
class Program
{
static void Main(string[] args)
{
String conStr = "Data Source=mesqas;User ID=ctdsp_oee;Password=12345678";
OracleConnection con = new OracleConnection(conStr);
try
{
con.Open();
OracleCommand com = con.CreateCommand();
com.CommandText = "select * from temp";
OracleDataReader read = com.ExecuteReader();
while (read.Read())
{
Console.WriteLine(read.GetString(1));
}
Console.ReadLine();
read.Close();
Ïà¹ØÎĵµ£º
×î½ü×öÁËÒ»¸öÊý¾ÝÕï¶ÏµÄÏîÄ¿£¬ÀïÃæ×Ô¼ºÐ´ÁËÒ»¸öÊý¾Ý¿âµÄ²Ù×÷À࣬°üº¬£ºÁ¬½ÓÊý¾Ý¿â¡¢¶ÁÊý¾Ý±í¡¢Ö´ÐÐSQL²Ù×÷£¬ÊÍ·ÅÊý¾Ý¿âµÈ×é³É£¬Ï£Íû¶Ô´ó¼ÒÓÐÓã¬ÓÉÓÚˮƽÓÐÏÞ£¬ÈôÓдíÎó»òÕß´úÂë²»×ãµØ·½»¶ÓÖ¸Õý£¬Ð»Ð»¡£
ADOOperate.H
//////////////////////////////////////////////////////////////////////
// ......
Ìõ¼þ½ÓÊÕϵͳ £¨CAs:Conditional Access System£©
¡¡¡¡ÓÐÌõ¼þ½ÓÊÕϵͳ£¨CAS£©ÊÇ¿ªÕ¹¸¶·ÑµçÊӵĺËÐļ¼Êõ£¬Á˽âËüµÄÔËÐлúÖÆ£¬ÕÆÎÕºÃËüµÄʹÓúÍά»¤¶Ô¸¶·ÑµçÊÓÒµÎñµÄ³É¹¦¿ªÕ¹·Ç³£¹Ø¼ü¡£CASµÄ×é³É°üÀ¨ÓУºÓû§¹ÜÀíϵͳSMS¡¢ÒµÎñÐÅÏ¢Éú³ÉϵͳSIG¡¢½ÚÄ¿¹ÜÀíPMS/SI±à¼ÏµÍ³¡¢½ÚÄ¿µ÷¶È´¦ÀíEIS¡¢Óû§ÊÚȨ¹ÜÀíϵͳSAS¡¢Ìõ¼þ½ÓÊÕCAµÈ ......
ACCESSÖÐÖظ´ÐеĴ¦Àí
ACCESSÖУ¬Ê¹ÓÃdistinctºÍgroup byºó£¬Èç¹ûÔÚjavaÖÐʹÓÃrs.next()µÄ»°£¬¾Í»áÌáʾ“ÎÞЧµÄÓαꔴíÎó¡£
µ«ÊÇ£¬²¢·Ç²»Ö§³ÖÉÏÃæÁ½¸öÓï·¨¡£
ËùÒÔ£¬¿ÉÒÔͨ¹ýÒÔÏÂÓï·¨½øÐжþ´Î²éѯ£¬½«Öظ´Êý¾ÝÈ¥µô¡£
select stockName from (select stockName from stock group by stockName) order by stock ......
¸üз½·¨Ò»£¬Ö±½ÓÔÚGridViewÖÐÀ´¸üÐÂÊý¾Ý.
¸üз½·¨¶þ£¬´ò¿ªÒ»¸öеÄÒ³ÃæÀ´¸üÐÂÊý¾Ý.
//¸üÐÂ
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
&nbs ......
ÓÉÓÚ³ÌÐòÐèÒª°ÑSQL SERVER ÀïµÄÊý¾Ýµ¼Èëµ½ACCESSÀï.
¸Õ¿ªÊ¼Ê¹ÓÃDataSetÀ´Ñ»·.
Êý¾ÝÁ¿ÉÙµÄʱºò»¹Ëã¿ÉÒÔÓ¦¸¶µÄ¹ýÀ´.
µ«µ±Êý¾Ý¶àµÄʱºò.
»á±¨´í"λÖôíÎó"
ÔÚÍøÉÏËÑÑ°Ò»·¬.ÕÒµ½Ò»¸ö·½·¨.
ʹÓÃinsert into openrowset
½Ó×Å´íÎóÒ»¸ö½ÓÒ»¸öµÄÀ´..
"²åÈë´íÎó: ÁÐÃû»òËùÌṩֵµÄÊýÄ¿Óë±í¶¨Ò岻ƥÅä¡£"
"δÄÜÕÒµ½ OLE DB Ì ......