C#——·ÃÎÊSQL Server 2005¹«¹²Àà
ÏÂÃæÊÇÎÒ×ܽá³öÀ´µÄÒ»¸öÊý¾Ý¿â·ÃÎʹ«¹²À࣬»ùÓÚADO.NET£¬C#µÄ£¬ÆäÖУ¬ÒÔÖØÔصķ½Ê½ÊµÏÖʹÓôæÊô¹ý³ÌµÄ½Ó¿ÚºÍ²»Óô洢¹ý³ÌµÄ½Ó¿Ú£¬ÈçÓв»Í×Çë´ó¼ÒÖ¸Õý£¬Ð»Ð»~
×÷Õߣºshinehoo
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace shinehoo.db
{
/// <summary>
/// ¶ÔÊý¾Ý¿âµÄһЩ¹«¹²²Ù×÷
/// </summary>
public class DBOperate
{
/// <summary>
/// ½¨Á¢Êý¾Ý¿âÁ¬½Ó
/// </summary>
/// <returns>·µ»ØSqlConnection¶ÔÏó</returns>
public static SqlConnection getConnection()
{
SqlConnection myCon;
try
{
string strSqlCon = "Data Source = SHINEHOO-PC\\SQLEXPRESS; Initial Catalog = ShineHoo_DB; Integrated Security = True";
//SqlConnectionÀàÓÃÀ´Á¬½ÓÊý¾Ý¿â
myCon = new SqlConnection(strSqlCon);
}
catch (Exception e)
{
throw e;
}
return myCon;
}
/// <summary>
/// Ö´ÐÐSqlCommandÃüÁî
/// </summary>
/// <param name="strSqlCommand">SQLÓï¾ä</param>
public static void getCommand(string strSqlCommand)
{
SqlConnection sqlcon = getConnection();
try
{
//SqlConnectionÀàµÄOpen()·½·¨ÓÃÀ´´ò¿ªÊý¾Ý¿âÁ¬½Ó
sqlcon.Open();
//ÉùÃ÷½«¶ÔÊý¾Ý¿âÖ´ÐÐÒ»¸öSQLÓï¾ä»ò´æ´¢¹ý³Ì
SqlCommand sqlcom = new SqlCommand(strSqlCommand, sqlcon);
//Ö´ÐÐSqlCommandÃüÁî
sqlcom.ExecuteNonQuery();
}
catch (Exception e)
{
throw e;
}
finally
{
//¹Ø±ÕÊý¾Ý¿âÁ¬½Ó
sqlcon.Close();
//sqlcon.Dispose();
}
}
Ïà¹ØÎĵµ£º
Äã´´½¨µÄÿһ¸ö±¸·Ý¶¼ÊÇÒ»¸ö±¸·ÝÉ豸£¬¹ØÓÚËüµÄϸ½ÚÐÅÏ¢¶¼´æ´¢ÔÚmsdb..backupset±íÖС£Ò»¸ö±¸·ÝÉ豸¿ÉÒÔ±»´æ´¢ÔÚµ¥Ò»Îļþ£¬»òÊǶà¸öÎļþÖС£Í¬Ñù£¬Ò»¸öÎļþÒ²¿ÉÒÔ´æ´¢¶à¸ö±¸·ÝÉ豸¡£
ËùÒÔ£¬¼ÙÈçÄãÿ´Î±¸·Ý¶¼Ê¹ÓÃÏàͬµÄÎļþÃû£¬Îļþ¾Í»áÒ»Ö±Ôö³¤¡£Ò»¸öÆÕ±éµÄÎó½âÊÇ£ºÈç¹ûÄãÿ´ÎʹÓÃÏàͬµÄÎļþÃû£¬ÄǾɵı¸·ÝÉ豸¾Í»á±»¸²¸Ç¡ ......
ÓÉÓÚÏîÄ¿ÐèÒª£¬Óõ½ÆäËûÏîÄ¿×éÓÃVC¿ª·¢µÄ×é¼þ£¬ÔÚwebºǫ́´úÂëÎÞ·¨·ÃÎÊÕâ¸ö×é¼þ£¬ËùÒÔÖ»ºÃͨ¹ýºǫ́µ÷ÓÃǰ̨µÄjavascript£¬´Ó¶ø²Ù×÷Õâ¸ö×é¼þ¡£ÔÚÍøÉÏÕÒÁËÕÒ£¬·¢ÏÖÓÐÈýÖÖ·½·¨¿ÉÒÔ·ÃÎʵ½Ç°Ì¨´úÂ룺
µÚÒ»ÖÖ£¬OnClientClick (vs2003²»Ö§³ÖÕâ¸ö·½·¨)
<asp:Button ID="Button1" runat="se ......
1. newÓм¸ÖÖÓ÷¨
3ÖÖ ÊµÀý¶ÔÏó ·½·¨Òþ²Ø
2.ÈçºÎ°ÑÒ»¸öarray¸´ÖƵ½arrayListÀï
foreach( object o in array )arrayList.Add(o);
3.datagrid.datasouse¿ÉÒÔÁ¬½ÓʲôÊý¾ÝÔ´
Êý¾Ý¼¯DataSet
4.¸ÅÊö·´ÉäºÍÐòÁл¯
¶¯Ì¬»ñµÃ ......
¶¯Ì¬¼ÓÔØDLLÐèҪʹÓÃWindows APIº¯Êý£ºLoadLibrary¡¢GetProcAddressÒÔ¼°FreeLibrary¡£ÎÒÃÇ¿ÉÒÔʹÓÃDllImportÔÚC#ÖÐʹÓÃÕâÈý¸öº¯Êý¡£
[DllImport("Kernel32")]
public static extern int GetProcAddress(int handle, String funcname);
[DllImport("Kernel32")]
public static extern int L ......
ÏÂÃæÊÇÎÒ×Ô¼º×ܽáµÄÒ»¸ö±È½Ï¼òµ¥µÄc#µ÷ÓÃSQL Server 2005´æ´¢¹ý³ÌµÄСÀý×Ó£¬Ö÷ÒªÊǽéÉÜÕû¸ö¹ý³Ì£¬ÓÐÎÊÌâµÄ»°Çë´óϺÃÇÖ¸µ¼£¬Ð»Ð»~
×÷Õߣºshinehoo
1£©´æ´¢¹ý³ÌÕâÑùдµÄ
ALTER PROCEDURE dbo.procShowLog
(
@StartTime datetime,
@EndTime datetime,
......