<appSettings>
<add key="ConnectionString" value="Initial Catalog=OnlineAccess;Data Source=localhost;Integrated Security=SSPI"/>
</appSettings>
public void ConncetToDB()
{
try
{
conn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
dataAdapter = new SqlDataAdapter();
conn.Open();
}
catch (Exception ex)
{
throw ex;
}
}
<script type="text/javascript" language="javascript">
var xmlRequest;
function createXMLHttpRequest()
{
if(window.ActiveXObject)
{
xmlRequest = new ActiveXObject("Microsoft.XMLHTTP");
}
else if(window.XMLHttpRequest)
{
xmlRequest = new XMLHttpRequest();
}
}
//重新刷新验证码
function refreshImg(){
createXMLHttpRequest();
//将请求发送到Servlet中去
var url = "ValidationCodeImage.aspx";
xmlRequest.open("POST",url,false);
//判断服务器的状态是否为正常的
xmlRequest.onreadystatechange = function()
{
if(xmlRequest.readyState == 4)
{
if(xmlRequest.status == 200)
{
document.getElementById("showPic").innerHTML=
"<img id='imgCod' alt='' src='ValidationCodeImage.aspx'/>";
}
else if (xmlHttp.status == 404) {
alert("Request URL does not exist");
}
else {
alert("Error: status code is " + xmlHttp.status);
}
}
}
xmlRequest.send(null);
} </script>
<script language="javascript" type="text/javascript">>
function checkUser()
{
var strName = document.getElementById("CustomerID").values;
if(register.Checkuser(strName).value == true)
{
document.getElementById("messageCustomerID").innerText = "用户名已经存在";
}else
{
document.getElementById("messageCustomerID").innerText = "用户名可用";
}
}
</script>
[AjaxPro.AjaxMethod]
public bool Checkuser(string strCustomer)
{
// CustomerControl objCustomerControl = new CustomerControl();
//Hashtable ht= new Hashtable();
//ht.Add("@CustomerId", this.txtCustomerId.Text);
// DataSet objDataSet = (DataSet)objCustomerControl.FindByProc(ht, "SelectCustomer");
DBConnect objDBConnect = new DBConnect();
DataSet objDataSet=
(DataSet)objDBConnect.BrowseDB("select * from customer where CustomerId='" + strCustomer + "'", 1, "customer");
if (objDataSet.Tables[0].Rows.Count>=1)
{
return true;
}
return false;
}
<script language="javascript" type="text/javascript">
function checkUser()
{
var customerId = document.getElementById("txtCustomerId").value;
if(register.Checkuser(customerId).value == true)
{
document.getElementById("lblMess").innerText ="该用户名已经存在!";
}
else
{
document.getElementById("lblMess").innerText ="验证通过!";
}
}
</script>