使用.net sdk的命令行工具

csc /t:library /out:mydll.dll source.cs

  1.通过wsdl工具  
    新建成的webservice:oo ，oo.asmx?wsdl保存成 .wsdl文件
    在dos里输入
    C:\Program   Files\Microsoft   Visual   Studio   .NET   2003\SDK\v1.1\Bin>  
  wsdl /l:cs /n:oo /out:oo.cs oo.wsdl      
   生成C#的oo.cs
   直接把这个类放到新建的普通web项目中加上 using oo;   
  2.在VS.net中,直接添加web引用就可以了,也就是添加你的wsdl文件 
    右键项目选择引用webreference
    把服务的url写上确定即可以引用，但是这种情况下服务必须是开启的 

下载 MySQL Connector ODBC 5.1.5 win32 msi.zip（驱动） 和 mysql-5.0.18-win32.exe（数据库）
安装成功后：
webconfig:
<appSettings>
    <add key='DConn' value='Driver={MySQL ODBC 5.1 Driver};server=192.168.0.96;Database=test;uid=root;password=0;option=3'></add>
</appSettings>
using System.Data.Odbc;
无参存储过程
 _ConStr = System.Configuration.ConfigurationManager.AppSettings['DConn'].ToString();           
            OdbcConnection conn = new OdbcConnection(_ConStr);
            conn.Open();                     
            DataSet ds = new DataSet();

1.放一个 ScriptManager ，放一个UpdatePanel ，内部这个正常加一个刷新的事件，然后把这个事件写到Triggers里面，就OK了
<cc1:ScriptManager ID='ScriptManager1' runat='server' EnablePartialRendering='True'>
    </cc1:ScriptManager>
<cc1:UpdatePanel ID='UpdatePanel3' runat='server'>
        <ContentTemplate>
        <span style='font-size: 10pt'>Purpose</span><span style='font-size: 7pt;font-weight: bold;'>:</span></strong><span
                            style='font-size: 12pt; font-family: Times New Roman'>
                            &l

1.应用模板后引用当前页的内容
<script language='javascript'>
        function CheckFrm()
        {
            if(document.forms(0).<%=FirstName.ClientID%>.value=='')
            {
                alert('First Name is Mandatory!');
                document.forms(0).<%=FirstName.ClientID%>.focus();
                return;
            }
        }
</script>
2.无刷新赋值
 <td>
 <

1. 
 using System;
 using System.Data;
 using System.Data.Odbc;
 using System.Data.Common;
 using System.IO;
 using System.Text;
 using System.Collections;
 private string _conStr;
  private OdbcConnection _odbcCon;
  public DBManage()
  {
    _conStr = SysConfig.ConStr;
    _odbcCon = new OdbcConnection(_conStr);
  }
  public DBManage(string strcon)
  {
      _conStr = strcon;
      _odbcCon = new OdbcConnection(_conStr);
  }
  public DataSet GetDataSet(String commandText)
  {
   DataSet _ds = new DataSet();
            OdbcCommand _command = new OdbcCommand();

if(a is null,b,a) as c
CASE
WHEN price IS NULL THEN 'Unpriced'
WHEN price < 10 THEN 'Bargain'
WHEN price BETWEEN 10 and 20 THEN 'Average'
ELSE 'Gift to impress relatives'
END
upper(AgentAlias)
concat('%',upper(replace(Salesagent1,' ','')),'%')
convert(if (uploadfile is null or uploadfile = '','<a>No</a>',concat('<a href=LoanDocuments/',uploadfile,' target=_blank>Yes View Uploaded on Date:',Convert(Uploaded_File_Date,char(20)),'</a>')),char) as uploadfile

<asp:HyperLinkField DataNavigateUrlFields='ID' HeaderText='Delete' Text='&lt;img src='images/trashcan.gif'  border='0'&gt;'
                                                DataNavigateUrlFormatString='~/AEDAgent_List.aspx?id={0}'>
                                                <ItemStyle HorizontalAlign='Center' />
                           &nb

public static string getIp()
    {
        if (HttpContext.Current.Request.ServerVariables['HTTP_VIA'] != null)
            return HttpContext.Current.Request.ServerVariables['HTTP_X_FORWARDED_FOR'].ToString();
        else
            return HttpContext.Current.Request.ServerVariables['REMOTE_ADDR'].ToString();
    }
    public static string getBrower()
    {
        HttpBrowserCapabilities bc = new HttpBrowserCapabilities();
        bc = HttpContext.Current.Request.Browser;
        return bc.Type;
    }
    public static string getPlatfo

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Drawing;

public partial class CheckImage : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        this.CreateCheckCodeImage(GenerateCheckCode());
    }
    private string GenerateCheckCode()
    {
        int number;
        char code;
        string checkCode = String.Empty;

        System.Random r