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
Ïà¹ØÎĵµ£º
ÐÂÊÖÈçºÎѧϰc#¡¢asp.net¡¢ado.netºÍ.NET
Èç¹ûÄãÒѾÓн϶àµÄÃæÏò¶ÔÏ󿪷¢¾Ñ飬Ìø¹ýÒÔÏÂÕâÁ½²½£º
µÚÒ»²½¡¡ÕÆÎÕÒ»ÃÅ.NETÃæÏò¶ÔÏóÓïÑÔ£¬C££»òVB.NET¡£
ÔÚûϵͳѧ¹ýÒ»ÃÅÃæÏò¶ÔÏó£¨OO£©ÓïÑÔµÄÇ°ÌáÏÂȥѧASP.NET¡£
ASP.NETÊÇÒ»¸öÈ«ÃæÏò¶ÔÏóµÄ¼¼Êõ£¬²»¶®OO£¬ÄǾø¶Ôѧ ......
ÎÞÂÛÊÇÔÚsql 2000£¬»¹ÊÇÔÚ sql 2005 ÖÐ,¶¼Ã»ÓÐÌṩ×Ö·û´®µÄ¾ÛºÏº¯Êý£¬ËùÒÔ£¬µ±ÎÒÃÇÔÚ´¦ÀíÏÂÁÐÒªÇóʱ£¬»á±È½ÏÂé·³£ºÓбítb, ÈçÏ£ºid value----- ------1 aa1 bb2 aaa2 bbb2 cccÐèÒªµÃµ½½á¹û£ºid values------ -----------1 aa,bb2 aaa,bbb,ccc¼´£¬ group by id, Çó value µÄºÍ£¨×Ö·û´®Ïà¼Ó£©
1. ¾ÉµÄ½â¾ö·½·¨-- 1. ´´½¨´¦À ......
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 ......
using System;
using System.Collections;
using System.ComponentModel;
using System.Web;
using System.Web.SessionState;
using System.Timers;
using System.Data;
using System.Data.SqlClient;
namespace SMS_joke
{
/// <summary>
/// Global µÄժҪ˵Ã÷¡£
/// </summary>
public class ......
¼Ç¼һÏÂÒÔ±¸Ï´οìËÙÕÒµ½¡£¡£¡£
Íùtb_wf_privgrant±íÖвåÈëÒ»Ìõ¼Ç¼£¬workflow_id×Ö¶ÎÖµ´Ótb_wf_workflow ±íÖлñÈ¡workflow_name='֪ʶÉóºË'µÄËùÓмǼÖÐworkflow_id×î´óÖµ¡£
--oracle
declare a NUMBER(10);
begin
select max(wo ......