½â¾öasp.netÒ³Ãæ²åÈëÊý¾ÝʱȨÏÞ²»×ãÎÊÌâ
static void Main(string[] args)
{
string connstr = "Data Source=***;user=system;password=***;";
OracleConnection conn = new OracleConnection(connstr);
conn.Open();
string orclstr="insert into SYS.A_MODULE values('03','²é¿´Éú²úÈÎÎñ','²é¿´Éú²úÈÎÎñ½ø¶È')";
try
{
OracleCommand cmd = new OracleCommand(orclstr, conn);
cmd.ExecuteNonQuery();
}
catch (InvalidOperationException ex)
{
Console.Write(ex.Message);
}
}
ÔËÐвúÉúȨÏÞ²»×ãÎÊÌâ
½â¾ö·½·¨£º
ÎÊÌâÒѽâ¾ö£¬·¸Á˸ö´í£¬ÔÚsql developerÀïн¨Á¬½Óʱ£¬Èç¹ûÑ¡ÔñsystemÓû§µÇ¼£¬ÔòroleÑ¡Ôñdefault,²âÊÔOK,²åÈëÊý¾ÝÒ²OK£»µ«ÊÇÑ¡ÔñsysÓû§µÇ¼ʱ£¬role±ØÐëÑ¡Ôñsysdba²ÅÄܲâÊÔÁ¬½Óͨ¹ý£¬µ«ÎÊÌâÒ²³öÔÚÕ⣺Êý¾Ý¿âÁ¬½ÓÊÇOKÁË£¬ÔÚasp.netÒ³ÃæÐ´Á¬½Ó×Ö·û´®Ê±Èç¹ûuser=sys,ÔËÐÐʱÌáʾ±ØÐëÓÃsysdbaÓû§µÇ¼£¬ÄÉÃÆÁË£¬ÎÒÔÚsql developerÀï¾ÍÊÇÑ¡ÔñÁËroleΪsysdba²Å½¨Á¢µÄÁ¬½Óѽ£¡£¡£¡ÕÒÁ˺öà×ÊÁÏ£¬¿´À´ÊÇÕâ¸ösysÓû§µÄÎÊÌ⣬ÓкöཨÒé˵×îºÃ²»ÓÃsys£¬×Ô¼ºÐ½¨Óû§£¬ÔÚÐÂÓû§Ï½¨±í£¬¾ÍÒ»ÇÐOK£¡£¡±¾È˲âÊÔÁËÒ»ÏÂsystem,roleΪdefault½¨Á¢µÄÁ¬½Ó£¬½¨ÁËÕÅ±í£¬insertûÎÊÌâ
ÁíÒ»ÖÖ½â¾ö°ì·¨£º
ÔÚsql developerÖÐÓÃsysÓû§µÇ¼£¬ÔÚÿ¸ö±íµÄÊôÐÔÀï¸ü¸Ä£¬°ÑÏà¹ØÈ¨ÏÞgrant¸øsystemÓû§¡£¡£¡£¡£ÎÊÌâ½â¾ö
Ïà¹ØÎĵµ£º
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.IO;
using System.Xml;
using System.Text; ......
ÔÚÒÔǰµÄASPʱºò£¬µ±ÇëÇóÒ»¸ö*.aspÒ³ÃæÎļþµÄʱºò£¬Õâ¸öHTTPÇëÇóÊ×ÏȻᱻһ¸öÃûΪinetinfo.exe½ø³ÌËù½Ø»ñ£¬Õâ¸ö½ø³Ìʵ¼ÊÉϾÍÊÇwww·þÎñ¡£½Ø»ñÖ®ºóËü»á½«Õâ¸öÇëÇóת½»¸øasp.dll½ø³Ì£¬Õâ¸ö½ø³Ì¾Í»á½âÊÍÕâ¸öaspÒ³Ãæ£¬È»ºó½«½âÊͺóµÄÊý¾ÝÁ÷·µ»Ø¸ø¿Í»§¶Ëä¯ÀÀÆ÷¡£ÆäʵASP.DLLÊÇÒ»¸öÒÀ¸½ÔÚIISµÄISAPIÎļþ£¬Ëü¸ºÔðÁ˶ÔÖîÈçASPÎļþ£¬A ......
¾ÍÊÇÔÚʹÓÃjmail·¢ËÍÓʼþʱ£¬Ê¹ÓõÄÊÇ×Ô¶¯É¨Ãè¹æ¶¨¼ä¸ôʱ¼ä×Ô¶¯·¢Ë͵ģ¬ÏÖÔÚÊÇÏëʵÏÖÒѾ·¢Ë͵ÄÓʼþ½«²»ÔÙ·¢ËÍ£¬¸÷λ´óϺÔõôʵÏÖ£¬ÇóÖú£¡
Ê×ÏÈÃ÷È·µÄÊÇÔÚÊý¾Ý¿â±íÖв¢Ã»Óбêʶ×Ö¶ÎÀ´±æ±ðÓʼþÊÇ·ñÒѾ·¢ËÍ¡£Èç¹ûÎÒÀ´ÉèÖÃÒ»¸öÈ«¾Ö±äÁ¿À´´æ´¢ÕâЩÒѾ·¢ËÍÓʼþµÄID£¬È»ºóÔÚÔÙ´ÎɨÃèʱÀ´±æ±ðÕâЩIDÊÇ·ñÒѾ´æÔڵķ½Ê½À´Åжϣ¬¸ ......
//ʵÀý»¯Ò»¸öSmtpClientsmtp.DeliveryMethod = SmtpDeliveryMethod.Network;
SmtpClient smtp = new SmtpClient();
smtp.DeliveryMethod = SmtpDeliveryMethod.Network;
//½«smtpµÄ³öÕ¾·½Ê½ÉèΪ Networksmtp.EnableSsl = false;
//smtp·þÎñÆ÷ÊÇ·ñÆôÓÃSSL¼ÓÃÜ
smtp ......