ʹÓÃ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
Ïà¹ØÎÊ´ð£º
DataSetµ¼³öxml Åú´¦Àí(Ñ»·)µÃÔõô´¦Àí
XMLÎļþ
<A>
<B>
<C>
</C>
&nb ......
ÎÒ½«Ò»¶Î4000À´×ÖµÄÎı¾¸³Öµ¸øËüÔõô¾Í³ö´íÁË,ÌáʾÔËÐÐʱ´íÎó2176 Õâ¸öÊôÐÔµÄÉèÖÃֵ̫³¤?
ÄãÊÇÔõÑù¸³ÖµµÄ£¿
²âÊÔÁËһϣ¬Óñ¸×¢×ֶθøÎı¾¿ò×öÊý¾ÝÔ´£¬Ã»ÓÐÌáʾÉèÖÃֵ̫³¤,14893×Ö·û
ÒýÓÃÎÒ½«Ò»¶Î4000À´×ÖµÄÎ ......
Çë´óÏÀÖ¸µã£¬¹òлÁË£¬×îºÃÓдúÂë
ÒªÓõ½ADOX¶ÔÏ󣬲éϰïÖúÎĵµ£¬
http://hyadliujing.blog.163.com/blog/static/4484507420091020969233/?mode=edit
ûÓÐÕÒµ½°¡ ¿´ÁËÄãµÄ²©¿ÍÁË£¬ÎÒÊÇÏ뽫accessÀïÃæµÄ¸½¼þ±£´æ ......
ÓÃ"·þÎñÆ÷¿Ø¼þÃû.Style.Add("display","")¿ÉÒÔ¸øÕâ¿Ø¼þÌí¼ÓCSS£¬ÔõôÑù²ÅÄܸø¶Á³öÀ´ÄØ£¿
Ôõô¶¼Ã»È˰ïæ°¡
È˶¼ËÀÄÄÈ¥ÁË
¿Ø¼þID.Style[HtmlTextWriterStyle.BackgroundColor]
¿Ø¼þ ......