C#Á¬½ÓsqlserverÊý¾Ý¿â
µ±ÔÚC#ÓïÑÔÖУ¬Á¬½ÓsqlÊý¾Ý¿âµÄʱºò£¬³£Óõ½sqlconnection½¨Á¢ÓëÊý¾Ý¿âµÄÁ¬½Ó¡£ Óï·¨ÈçÏ£º
String sqlcon = "***";//ÕâÀïÊÇÒ»¸ö×Ö·û´®£¬¾ßÌå¸úÊý¾Ý¿âµÄÑéÖ¤·½Ê½Óйء£
//sql server Éí·ÝÑéÖ¤ Á¬½Ó×Ö·û´®
private string ConnstrSqlServer = "server=·þÎñÆ÷Ãû³Æ;uid=µÇ¼Ãû³Æ;pwd=µÇ¼ÃÜÂë;database=Êý¾Ý¿âÃû³Æ";
//windows Éí·ÝÑéÖ¤Á¬½Ó×Ö·û´®
private string ConnstrWindows = "server=·þÎñÆ÷Ãû³Æ;database=Êý¾Ý¿âÃû³Æ;Trusted_Connection=SSPI";
SqlConnection connection = new SqlConnection(sqlcon);
ÀýÈ磺
SqlConnection connection = new SqlConnection("server=(local);database=dotNET_lab;Trusted_Connection=SSPI");
//windowsÑéÖ¤·½Ê½ ¡£
SqlConnection connection = new SqlConnection("server=(local);uid=sa;password=sa;database=dotNET_lab");
//»ìºÏÑéÖ¤·½Ê½ ¡£
È»ºó£¬
try {
connection.Open();
SqlCommand command = new SqlCommand("select count(*) from admin where username='"+username+"' and password='"+password+"'",connection);
SqlDataReader reader = command.ExecuteReader();
while(reader.Read())
{
n = reader.GetInt32(0);//nÊÇÔÚ֮ǰ¶¨ÒåµÄ£¬Èç¹ûn>0£¬ÏÔÈ»¾Í´æÔÚÕâÑùÒ»¸öÓû§¡£
}
//Console.WriteLine(reader.GetString(1));
}
catch(SqlException ex) {
&n
Ïà¹ØÎĵµ£º
xmlpost by HttpWebRequest:
protected string PostXmlToURL(string url,string data)
{
HttpWebRequest hwr = (HttpWebRequest)HttpWebRequest.Create(url);
hwr.Method = "POST";
Stream stream = hwr.GetRequestStream();
StreamWri ......
΢ÈíµÄSQL SERVERÌṩÁËÁ½ÖÖË÷Òý£º¾Û¼¯Ë÷Òý(clustered index£¬Ò²³Æ¾ÛÀàË÷Òý¡¢´Ø¼¯Ë÷Òý)ºÍ·Ç¾Û¼¯Ë÷Òý(nonclustered index£¬Ò²³Æ·Ç¾ÛÀàË÷Òý¡¢·Ç´Ø¼¯Ë÷Òý)……
(Ò»)ÉîÈëdz³öÀí½âË÷Òý½á¹¹
ʵ¼ÊÉÏ£¬Äú¿ÉÒÔ°ÑË÷ÒýÀí½âΪһÖÖÌØÊâµÄĿ¼¡£Î¢ÈíµÄSQL SERVERÌṩÁËÁ½ÖÖË÷Òý£º¾Û¼¯Ë÷Òý(clustered index£¬Ò²³Æ¾ÛÀàË÷Òý¡¢´ ......
asp.net(c#)ÍøÒ³Ìø×ªÆßÖÖ·½·¨Ð¡½á
·¢²¼Ê±¼ä£º2009-11-25 11:13:03
¡¡¡¡1.Response.Redirect("http://www.yayiba.com",false);
¡¡¡¡Ä¿±êÒ³ÃæºÍÔÒ³Ãæ¿ÉÒÔÔÚ2¸ö·þÎñÆ÷ÉÏ£¬¿ÉÊäÈëÍøÖ·»òÏà¶Ô·¾¶¡£ºóÃæµÄboolֵΪÊÇ·ñÍ£Ö¹Ö´Ðе±Ç°Ò³¡£
Ìø×ªÏòеÄÒ³Ãæ£¬Ô´°¿Ú±»´úÌæ¡£"
ä¯ÀÀÆ÷ÖеÄURLΪз¾¶¡£
:Response.Redirect·½ ......
»¹ÔÚΪ±ÏÒµÉè¼Æ¶ø·³ÄÕô ¿´¿´ÕâÀï ÎÒ°ïÄã¸ã¶¨¾ÍºÃ
±¾ÈËʵ¼Ê¿ª·¢¾Ñé·á¸» ѧ¹ý¸÷Àà³ÌÐò±àд ǰºǫ́¶¼¿ÉÒÔ
ÏÖÔڵŤ×÷²»Ôõô¾°ÆøÑ½ ËùÒÔÕÒµãÍâ¿ìÑø¼Òºý¿Úѽ ºÇºÇ
±¨³êÂï ¹ýµÃÈ¥¾ÍÐÐÁË Ã»Ê²Ã´ÒªÇó ½»¸öÅóÓÑÂï
Èç¹ûÓÐÒâÕß¿ÉÓë±¾ÈËÁªÏµqq604884385 Tel13438309220 ......
function db()
{
//»î¶¯±àºÅ
var activeid = Request.Form("activeid");
//Óû§Ãû
var username = Request.Form("username");
//ÊÖ»úºÅÂë
var mobile = Request.Form("mobile");
var conn= Server.CreateObject("ADODB.connection");
var rs= Serve ......