Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

C#ÖÐÓÃÓÚÁ¬½ÓSQLÊý¾Ý¿âµÄSQLHelperÀà

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;   //ÒýÓÃÃüÃû¿Õ¼ä
namespace DAL
{
    /*******************************************************************************
    * Name: SQLHelper
    * File: SQLHelper.cs
    * Description: ÓÃÓÚÍê³É¶ÔÊý¾Ý¿âµÄÏà¹Ø²Ù×÷
    * Author: Ñ©ÀÇ
    * DateTime: 2010Äê05ÔÂ13ÈÕ
    *******************************************************************************/
    public class SQLHelper
    {
        //ÉèÖÃÁ¬½Ó×Ö·û´® —— SQL ServerÑé֤ģʽµÄÁ¬½Ó×Ö·û´®
        //public static string strConn = @"server = PANLING;database = StudentMIS;uid = sa;pwd = sa";
        //ÉèÖÃÁ¬½Ó×Ö·û´® —— WindowsÑé֤ģʽµÄÁ¬½Ó×Ö·û´®
        public static string strConn = @"server = T403-004\HB_SQLSERVER;database = DB_LibraryManage;Integrated Security = SSPI";
        /// <summary>
        /// ¹¦ÄÜÃèÊö£ºÖ´ÐÐADO.NETÔö¡¢É¾¡¢¸Ä²Ù×÷
        /// </summary>
        /// <param name="strText">ÊäÈë²ÎÊý —— ÒªÖ´ÐеÄSQLÓï¾ä(ÃüÁîÎı¾)</param>
        /// <param name="cmdType">ÊäÈë²ÎÊý —— ÒªÖ´ÐеÄSQLÃüÁîÀàÐÍ</param>
        /// <param name="SqlParams">ÊäÈë²ÎÊý —— ÒªÖ´ÐеÄSQLÓï¾äÖеIJÎÊýÁбí(ÃüÁî²ÎÊýÁбí)</param>
        /// <returns>·µ»ØÖ´ÐÐÓ°ÏìµÄÐÐÊý</returns>
        public static int MyExecu


Ïà¹ØÎĵµ£º

Xml×Ö·û´®ÓëC#¶ÔÏóÖ®¼äÏ໥ת»»

ÎÒÃdz£³£ÐèÒª¶ÁÈ¡xmlÎļþ£¬°ÑÀïÃæµÄÐÅϢת»¯ÎªÎÒÃÇ×Ô¶¨ÒåµÄÀàÐÍ£¬»òÔò°É×Ô¶¨ÒåÀàÐÍת»¯ÎªXml×Ö·û´®¡£ÔÚÕâÀï½éÉÜÒ»¸ö±È½Ï¼òµ¥µÄ¶ÔÏóת»¯·½·¨¡£ÔÚÎÒ×Ô¼ºµÄFramworkÀïÃæÒ²¶à´ÎÓõ½¡£ÀïÃæÉæ¼°µ½½Úµã¡¢ÊôÐÔ¡¢¼¯ºÏ¡£
ʾÀýÒ» ¸ÃxmlÎļþÉæ¼°µ½ÊôÐÔ¡¢½Úµã¼¯ºÏ²»Éæ¼°¸ö½Úµã£º
<?xml version="1.0" encoding="utf-8"?>
<da ......

sql ²éѯ±íµÄÁÐÃû row_number()

select upper(name) from syscolumns
where id =any
(
select Id from sysobjects where name='tb_city'
)
lower
select row_number() over(order by firmid) from dbo.tb_BuildingMaterial
Éú³É  ×ÔÔö  123
select rank() over(order by firmid) from dbo.tb_BuildingMaterial
Éú³É×ÔÔö123  ¸ù¾ÝÅ ......

C# ÓÃSQLн¨Êý¾Ý¿â

1. ³ÌÐòÈçÏ£º
         string str = "Create Database " + "DBname";
         string con = "Data Source=10.0.0.249\\sql2005;Initial Catalog=master;Persist Security Info=True;User ID=sa;Password=sa";
   &n ......

¡¾×ªÔØ¡¿SQL ServerÊý¾ÝÀàÐÍÏê½â

Êý¾ÝÀàÐÍÊÇÊý¾ÝµÄÒ»ÖÖÊôÐÔ£¬ÊÇÊý¾ÝËù±íʾÐÅÏ¢µÄÀàÐÍ¡£ÈκÎÒ»ÖÖÓïÑÔ¶¼ÓÐËü×Ô¼ºËù¹ÌÓеÄÊý¾ÝÀàÐÍ£¬SQL ServerÌṩһÏÂ25ÖÖ¹ÌÓеÄÊý¾ÝÀàÐÍ¡£
SQL ServerÊý¾ÝÀàÐÍÒ»ÀÀ±í
¡¡¡¡·Binary [(n)]
·Varbinary [(n)]
·Char [(n)]
·Varchar[(n)]
·Nchar[(n)]
·Nvarchar[(n)]
· ......

Oracle SQL Developer¹¤¾ß

ÏÂÔØ½âѹÁËOracle SQL Developer¹¤¾ß£¬ÔËÐÐʱ£¬Æô¶¯²»ÁË£¬±¨´íÐÅÏ¢ÈçÏ£º
---------------------------
Unable to create an instance of the Java Virtual Machine
Located at path:
<SQLDEVELOPER>\jdk\jre\bin\client\jvm.dll
---------------------------
ÊÇJVM²ÎÊýÉèÖõÄÎÊÌ⣬ÎҵĽâ¾ö·½°¸ÈçÏ£º
<SQ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ