一個Ajax.NET的查詢實例

protected WebControlLibrary.InputCalendar pStartTime;

protected WebControlLibrary.InputCalendar pEndTime;

protected System.Data.SqlClient.SqlConnection Conn=new SqlConnection();

protected System.Web.UI.WebControls.TextBox eformsn;

protected System.Web.UI.WebControls.Label Label1;

protected System.Web.UI.WebControls.DataGrid DataGrid1=new DataGrid();

protected System.Web.UI.WebControls.Button Button2;

protected System.Web.UI.HtmlControls.HtmlInputText applicant;

public string toExcel;

private void Page_Load(object sender, System.EventArgs e)

{

AjaxPro.Utility.RegisterTypeForAjax(typeof(eol.index));

}

public DataSet DB(string dataName, string sqlCmd)

{

string connStr="server=172.16.0.120;uid=msikdb;pwd=dbmsik;database="+dataName;

Conn.ConnectionString=connStr;