C#´ò°üSQLÊý¾Ý¿â²¿Êð°²×°
²Î¿¼¡¶ASP.NETÓëSQLÒ»Æð´ò°ü²¿Êð°²×°¡·£¬ÕâÆªÎÄÕÂÊÇÕë¶ÔVB.NETÓëSQL Ò»Æð´ò°üµÄ,µ«ÊÇÎÒʹÓõÄÊÇC#,µ±È»Ö»ÒªÐÞ¸ÄÒ»ÏÂÖ÷Òª°²×°Àà¿â¾ÍÐÐÁË!C#µÄÀà¿â´úÂëÈçÏÂ:DBCustomAction.cs
using System;
using System.Collections;
using System.Data.SqlClient;
using System.ComponentModel;
using System.Configuration.Install;
using System.Diagnostics;
using System.IO;
using System.Xml;
using System.Reflection;
namespace PMS
{
/// <summary>
/// DBCustomAction µÄժҪ˵Ã÷¡£
/// </summary>
[RunInstaller(true)]
public class DBCustomAction : System.Configuration.Install.Installer
{
/// <summary>
/// ±ØÐèµÄÉè¼ÆÆ÷±äÁ¿¡£
/// </summary>
private System.ComponentModel.Container components = null;
public DBCustomAction()
{
// ¸Ãµ÷ÓÃÊÇÉè¼ÆÆ÷Ëù±ØÐèµÄ¡£
InitializeComponent();
// TODO: ÔÚ InitializeComponent µ÷ÓúóÌí¼ÓÈκγõʼ»¯
}
private void ExecuteSql(string conn,string DatabaseName,string Sql)
{
SqlConnection mySqlConnection=new SqlConnection(conn);
SqlCommand Command=new SqlCommand(Sql, mySqlConnection);
mySqlConnection.Open();
mySqlConnection.ChangeDatabase(DatabaseName);
try
{
Command.ExecuteNonQuery();
}
finally
{
//close Connection
mySqlConnection.Close();
}
}
/// <summary>
/// ÇåÀíËùÓÐÕýÔÚʹÓõÄ×ÊÔ´¡£
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
&nb
Ïà¹ØÎĵµ£º
JAVA£×Ö·û´®¹ýÂËÀà
package cn.com.hbivt.util;
/**
* Title:
*
* Description:
*
* Copyright: Copyright (c) 2005
*
* Company:
*
* @author not attributable
* @version 1.0
*/
public class StringUtils {
......
±±´óÇàÄñJAVA¡¢C#¡¢.NETµÈÈí¼þ¼¼Êõ¾ÍÒµÅàѵ°à
ÐÅÏ¢¼¼Êõʱ´ú£¬´òÔìITר²Å¡£¶«Ý¸±±´óÇàÄñ½ðÂëÐ£ÇøÁªºÏ3000Óà¼ÒITÃûÆó£¬¶¨ÏòÅàÑøÆóÒµ½ôȱµÄITÈí¼þ¹¤³ÌʦÈ˲š£
Åàѵ¿Î³Ì¼ò½é£º
ÒÀÍб±¾©´óѧ½ÌÓý×ÊÔ´¡¢±±´óÇàÄñ¼¯ÍÅÔÚITÐÐÒµµÄÓÅÊÆ¡¢Ó¡¶ÈAPTECHרҵ»¯µÄITÖ°Òµ½ÌÓý¾Ñ飬ACCP½Ì³Ì²ÉÓÃÈ«Çòͬ²½Ñз¢»úÖÆ ......
ÔÚAsp.netÖУ¬´ÓAÒ³ÃæÖе¯³öBÒ³Ãæ£¬ÔÚBÒ³ÃæÖÐÑ¡ÔñÊý¾Ýºó£¬¹Ø±Õ²¢½«Êý¾Ý¸üе½AÒ³Ãæ£¬ÊÇÒ»ÖÖ³£Óõķ½Ê½¡£Ö»ÊÇÎÒ¶ÔJavascript²»ÊìϤ£¬ËùÒÔµ·¹ÄÁËÒ»ÏÂÎ磬ÖÕÓÚÓÐÁËÒ»µã³É¼¨¡£
¡¡¡¡²âÊÔÏîÄ¿ÓÐÁ½¸öÒ³Ãæ£ºDefault.aspx¼°Default2.aspx£¬ÔÚDefault.aspxÒ³ÃæÉÏÓÐÒ»¸öTextBox1¼°Ò»¸öButton1£¬Button1ÓÃÓÚ´¥·¢Default2.aspx£¬TextBox ......
ÒªÔÚSQL ServerÊý¾Ý¿âÖд洢m³²¢´òÓ¡³öÀ´, ·½·¨ÈçÏ£º
1£©½«Êý¾Ý¿âÖÐÏàÓ¦×ֶεÄÊý¾ÝÀàÐÍÉèΪnchar»ònvarcharÀàÐÍ¡£
2£©´ÓExcelÖеõ½m³£¬¸´ÖÆÕ³Ìùµ½½ÓÊÕÊý¾ÝµÄ¿Ø¼þÖУ¨TextBox¡¢DataGridViewµÈ£©¡£±£´æ¼´¿É¡£
×¢£º1£©nchar,nvarcharÓëchar,varcharµ ......