ʹÓÃc#¶ÔaccessÊý¾Ý¿âÖÐijһÐнøÐÐupdateµÄÎÊÌâ
ÍíÉϸüÐÂÊý¾Ý¿âµÄʱºò·¢ÏÖ¿ÉÒÔ¸üÐÐÒ»ÐУ¬Êý¾Ý¿âÖ»ÊÇÌ«ÀÃÁË£¬ÔÚ´Ë·¢ÌûÇó¾È¸÷λ´óÏÀ£º
ÎÒÓиö±ípro ÖÐÓÐname,date£¬intro×ֶΣ¬ÏëÎÊÏ£¬ÔõôÀ´Ê¹ÓÃupdate¸üÐÂijһÐдúÂ룬ÊÇupdate pro set name=xx,date=xx,intro=xx where name=yy Âð£¿
ÄǾßÌåµÄ¶ÁÈ¡Êý¾Ý¿âºÍ¸üÐÂÓï¾äÔõôд°¡£¬ÊµÔÚ²»»áÁË Ð»ÁË£¡
using(OleDbConnection conn = new OleDbConnection(""))
{
string strSql = "update pro set [name]=@name where name=@n ";
OleDbCommand cmd = new OleDbCommand(strSql, objConn);
cmd.Parameters.AddWithValue("@name", "");
cmd.Parameters.AddWithValue("@n", "");
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
"update pro set [name]=@name where name=@n ΪʲôҪ¼Ó@°¡£¿
cmd.Parameters.AddWithValue("@name", ""); Õâ¾äÊÇʲôÒâ˼°¡£¿
Êý¾Ý¿âÍüÍêÁË£¬ºÇºÇ
Äã¿ÉÒÔÈ¥ÍøÉÏÕÒϹØÓÚAccessÊý¾Ý¿âµÄ²Ù×÷ÊÇÈçºÎ½øÐеġ£ÎÒÏëÓкܶàµÄ×ÊÁÏ¡£
OleDbConnection thisConnection = new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=" + System.Web.HttpContext.Current.Server.MapPath("~/App_Data\\web1.mdb"));
st
Ïà¹ØÎÊ´ð£º
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
ÎÊÌ⣱
ÎÒÓÃADOÁ¬½ÓÉèÁËÓû§ÃûÃÜÂëµÄÊý¾Ý¿â
µ«ÊÇÎÒ·¢ÏÖÎÒ²»ÊäÈë Óû§ÃûºÍÃÜÂë ¶¼¿ÉÒÔÁ¬½Ó³É¹¦ ¶øÇÒ»¹ÄܰÑÊý¾Ý¶Á³öÀ´
¼ôÁËÒ»¸öÃûΪtestÊý¾Ý¿â ½¨ÁËÒ»¸öÃûΪpeopleµÄ±í
¼ûÁËÒ»¸ö Óû§Ãû1234 ÃÜÂë1234 µÄ ......
ÓÃ"·þÎñÆ÷¿Ø¼þÃû.Style.Add("display","")¿ÉÒÔ¸øÕâ¿Ø¼þÌí¼ÓCSS£¬ÔõôÑù²ÅÄܸø¶Á³öÀ´ÄØ£¿
Ôõô¶¼Ã»È˰ïæ°¡
È˶¼ËÀÄÄÈ¥ÁË
¿Ø¼þID.Style[HtmlTextWriterStyle.BackgroundColor]
¿Ø¼þ ......
ÎÒ»ú×ÓÀïÃæÃ»ÓÐACCESS,ÇëÎÊÔÚ²»ÖØ×°ÏµÍ³µÄÇé¿öϸÃÈçºÎ°ÑËü×°ÉÏ,֮ǰÎÒÊÔ×°¹ýÆäËü°æ±¾µÄSP3 OFFICE,µ«»¹ÊÇ×°²»ÉÏ,
ÇëÎÊÓÐʲôºÃ°ì·¨Âð?
°²×°OFFICE £¬Ñ¡Ôñ°²×°ACCESS¾Í¿ÉÒÔѽ ¡£
ÒýÓÃ
°²×°OFFICE £¬Ñ¡Ôñ°²×° ......
dwr.xml:
<create creator="struts" javascript="PrisonerActionForm">
<param name="formBean" value="prisonerForm"/>
< ......