ASP.netÖÐC#ÀïÈçºÎÄܹ»¶ÁÈ¡Êý¾Ý¿â£¿
ÎÒµÄÎÊÌâÊÇ
ASP.netÖÐC#ÀïÈçºÎÄܹ»¶ÁÈ¡Êý¾Ý¿â
ÎÒÏÖÔÚÐèÒªÔÚÒ»¸ödatabaseÀïÃæ¶Áȡһ¸öÊý¾Ý½øÈëint±äÁ¿½øÐнøÒ»²½²Ù×÷
µ«ÊÇÍøÉϵķ½·¨¶¼³¢ÊÔÁ˶¼²»ÐÐ
ÎÒÊdzõѧÕߣ¬Ï£Íû¸ßÊÖÄÜÖ¸µãÒ»¶þ
ллÀ²£¡
ллÁË£¡
ÎÒ¸Õ²Åͨ¹ý±àÒëÁË£¬
µ«ÊÇÎÒÓÐÒ»¸ö²»Àí½âµÄµØ·½£¬
ÎÒʹÓÃÉÏÃæµÄ´úÂëÈç¹ûÈ¥µôIfÓï¾äµÄ»°¾Í»á±¨´í
ÕâÊÇʲôÔÒòÄØ£¿
//¶ÔÊý¾Ý¿â²Ù×÷µÄÀà
public class databaseUntil
{
private OracleCommand cmd = null;
private OracleConnection conn = null;
private string connstr;//´ÓÊý¾Ý¿âÖжÁÈ¡µÄÁ¬½ÓÓï¾ä
public databaseUntil()
{
//Data Souuce£º±¾µØ»ú£º¾ÍÊÇÊý¾Ý¿âÃû£»Ô¶³Ì»ú×Ó£ºÈç¹ûÔÚ±¾µØ×°ÓÐoracleÊý¾Ý¿âµÄ¿Í»§¶ËÔòÒ²ÊÇÊý¾Ý¿âÃû£¬·ñÔò²Î¿¼ÍøÂç×ÊÔ´Òª¼ÓÒ»¸öÓò¡£
connstr = ConfigurationManager.ConnectionStrings["oracleConnString"].ConnectionString;
}
//½¨Á¢Êý¾Ý¿âÁ¬½Ó
//·µ»ØÒ»¸öÊý¾Ý¿âµÄÁ¬½ÓOracleConnection¶ÔÏó
public OracleConnection init()
{
try
{
conn = new OracleConnection(connstr);
if (conn.State != ConnectionState.Open)
{
&nb
Ïà¹ØÎÊ´ð£º
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
asp.net ajaxÖÐupdatepanelÀïÃæµÄ¿Ø¼þÀïÃæÓиöbuttonºÍÈô¸Étextbox
ÎÒµã»÷buttonÑéÖ¤ÐÅÏ¢³öÏÖ£¬µ«ÊǾÍÊÇÎÞ·¨À¹½ØÎÒbuttonºóÃæÔËÐеÄʼþ£¡
ÑéÖ¤µÄ´úÂëÊÇJSÑéÖ¤»¹ÊÇ.netÖеÄÑéÖ¤¿Ø¼þ£¬»òÊǰ´Å¥Ê¼þÖеĺǫ́ÑéÖ¤£¿
......
DataSetµ¼³öxml Åú´¦Àí(Ñ»·)µÃÔõô´¦Àí
XMLÎļþ
<A>
<B>
<C>
</C>
&nb ......
СµÜÊǽñÄê¸Õ±ÏҵѧÉúÕÒÁ˺ܳ¤Ê±¼ä¹¤×÷ÁË,×ÜÊÇʧ°Ü£¬Ò»Ð©¹«Ë¾¶¼ÒªÓй¤×÷¾ÑéµÄ£¬¶¼±ÀÀ£ÁË£¬ËùÒÔÏëÇë¸÷λ´ó¸ç°ï¸öæ
½ñÌìÎÒÈ¥ÃæÊÔÁËÒ»¼Ò¹«Ë¾£¬ËûÊÇÏë×öÒ»¸ö¡°Ò½ÁƵÄÍøÕ¾¡±Ï൱ÓÚÊÇÍÆ¹ã×Ô¼ºµÄÒ½ÁÆ·½·¨°É£¬Ëû½ÐÎ ......
CREATE PROCEDURE [selectvipcompany]
@username varchar(50),
@companyname varchar(50),
@endtime varchar(1)
AS
declare @sql varchar(1000)
set @sql='' ......