ASP.NETʵÏÖÔöɾ¸Ä²éµÈ¹¦ÄÜ(Access°æ)ϵͳ֮ËÄ É¾³ý
//¸ù¾ÝÖ÷¼üÀ´É¾³ý±íÖеÄÊý¾Ý¡£
//ɾ³ý
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
OleDbConnection sqlConnection = new OleDbConnection(GetConnection());
string sqlstr = "delete from MResume where id=" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "";
OleDbCommand sqlcom = new OleDbCommand(sqlstr, sqlConnection);
sqlConnection.Open();
sqlcom.ExecuteNonQuery();
sqlConnection.Close();
//PopulatePublishersGridView();
string sqlstr2 = getSQlStr();
bind(sqlstr2);
}
Ïà¹ØÎĵµ£º
ת×Ô£ºhttp://dev.yesky.com/243/2230743.shtml
ADO(ActiveX Data Object)ÊÇMicrosoftÊý¾Ý¿âÓ¦ÓóÌÐò¿ª·¢µÄнӿڣ¬Êǽ¨Á¢ÔÚOLE DBÖ®Éϵĸ߲ãÊý¾Ý¿â·ÃÎʼ¼Êõ£¬¼´Ê¹Äã¶ÔOLE DB£¬COM²»Á˽âÒ²ÄÜÇáËɶԸ¶ADO,ÒòΪËü·Ç³£¼òµ¥Ò×Óã¬ÉõÖÁ±ÈÄãÒÔÍùËù½Ó´¥µÄODBC API¡¢DAO¡¢RDO¶¼ÒªÈÝÒ×ʹÓ㬲¢²»Ê§Áé»îÐÔ¡£±¾ÎÄÏêϸµØ½éÉÜÔÚVisual C ......
ACCESSÖÐÖØ¸´ÐеĴ¦Àí
ACCESSÖУ¬Ê¹ÓÃdistinctºÍgroup byºó£¬Èç¹ûÔÚjavaÖÐʹÓÃrs.next()µÄ»°£¬¾Í»áÌáʾ“ÎÞЧµÄÓαꔴíÎó¡£
µ«ÊÇ£¬²¢·Ç²»Ö§³ÖÉÏÃæÁ½¸öÓï·¨¡£
ËùÒÔ£¬¿ÉÒÔͨ¹ýÒÔÏÂÓï·¨½øÐжþ´Î²éѯ£¬½«Öظ´Êý¾ÝÈ¥µô¡£
select stockName from (select stockName from stock group by stockName) order by stock ......
using System;
using System.Collections;
using System.Collections.Specialized;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections.Generic;
using System.Text;
namespace Maticsoft.DBUtility
{
/// <summary>
  ......
asp.net¼òÌå×Öת·±Ìå×ÖµÄÀà¿â
Õâ¶«Î÷ËäÈ»¼òµ¥£¬µ«Ò²²»Ê§Îª¾µäµÄÀà¿â£¬¸öÈ˶øÑÔ£¬¾Í·Ç³£Ï²»¶Õâ¸öÀà¿â¡£
ÓÃÎÄ×ּǼÏÂÀ´°É£¬Áô¸ö¼ÇÄî°É
ÔÚvsÖУ¬ÓÐÒ»¸ö¾µäµÄMicrosoft.VisualBasic.dllµÄVBÀà¿â£¬¸ù¾Ý¹Ù·½µÄÃèÊö£º
ËüÄÜÌṩ¶ÔÐí¶à .NET Framework ÀàµÄ¼òµ¥Ö±¹ÛµÄ· ......
ΪÁËÄÜÈÃÀ´×Ô²»Í¬ÎÄ»¯Ï°¹ß»òʹÓò»Í¬ÓïÑÔ×÷ΪĸÓïµÄ·Ã¿ÍÄܹ»ÔĶÁÎÒÃǵÄÍøÕ¾£¬Ôò±ØÐëΪÕâЩ¶ÁÕßÌṩÓÃËûÃÇ×Ô¼ºµÄÓïÑÔ²é¿´ÍøÒ³µÄ·½·¨¡£Ò»ÖÖ·½·¨ÊÇ·Ö±ðÓø÷ÓïÑÔÖØÐ´´½¨Ò³Ã棬µ«ÕâÖÖ·½·¨¿ÉÄÜÐèÒª´óÁ¿¹¤×÷Á¿¡¢ÈÝÒ׳ö´í²¢ÇÒÔÚ¸ü¸ÄÔʼҳʱºÜÄÑά»¤¡£ÀûÓà ASP.NET£¬¿ÉÒÔʹ´´½¨µÄÒ³Ãæ»ùÓÚä¯ÀÀÆ÷µÄÊ×Ñ¡ÓïÑÔÉèÖûòÓû§ÏÔʽѡÔñµÄÓïÑÔ ......