1. 数据库SQL SERVER EXPRESS 2005
数据库名称为Database,数据表为GKFS,各字段定义
2. Code
Default.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<%@ Register TagPrefix="mobile" Namespace="System.Web.UI.MobileControls" Assembly="System.Web.Mobile" %>
<html xmlns="http://www.w3.org/1999/xhtml" >
<body>
<mobile:Form id="FormQuery" runat="server">
<mobile:Label ID="Label1" Runat="server">采集准考证号</mobile:Label>
<mobile:TextBox ID="TextBoxZKZH" Runat="server" Title="采集准考证号">
</mobile:TextBox>
<mobile:Label ID="Label2" Runat="server">采集身份证号</mobile:Label>
<mobile:TextBox ID="TextBoxSFZH" Runat="server" Title="采集身份证号">
</mobile:TextBox>
<mobile:Command ID="CommandQuery" Runat="server" OnClick="CommandQuery_Click">查询</mobile:Command>
</mobile:Form>
<mobile:Form ID="FormResult" Runat="server">
<mobile:Label ID="Label3" Runat="server">采集查询结果</mobile:Label>
<mobile:List ID="List1" Runat="server">
</mobile:List>
<mobile:Command ID="CommandGoBack" Runat="server" OnClick="CommandGoBack_Click" >返回</mobile:Command>
</mobile:Form>
</body>
</html>
Default.aspx.cs
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.Mobile;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.MobileControls;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.MobileControls.MobilePage
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void CommandQuery_Click(object sender, EventArgs e)
{
this.ActiveForm = FormResult;
string mzkzh = this.TextBoxZKZH.Text;
string msfzh = this.TextBoxSFZH.Text;
//连接数据库
SqlConnection conn = new SqlConnection();
conn.ConnectionString = @"Data Source=Mac\SQLEXPRESS;AttachDbFilename=C:\Database.mdf;Integrated Security=True;User Instance=True";
conn.Open();
SqlCommand selecmd = new SqlCommand();
selecmd.CommandText = "select * from GKFS where GKFS.ZKZH = '" + mzkzh.Trim() + "' and GKFS.SFZH= '" + msfzh.Trim() + "'";
selecmd.Connection = conn;
SqlDataReader adatareader = selecmd.ExecuteReader();
if (!adatareader.HasRows)
{
this.List1.Items.Clear();
this.List1.Items.Add("没有找到匹配的记录");
this.List1.Items.Add("请确认身份证号与准考证号是否正确?");
}
while (adatareader.Read())
{
this.List1.Items.Clear();
this.List1.Items.Add("查询结果如下:");
this.List1.Items.Add("准考证号:" + adatareader["ZKZH"]);
this.List1.Items.Add("身份证号:" + adatareader["SFZH"]);
this.List1.Items.Add("姓名:" + adatareader["XM"]);
this.List1.Items.Add("总分:" + adatareader["ZF"]);
this.List1.Items.Add("照顾分:" + adatareader["ZGF"]);
this.List1.Items.Add("综合:" + adatareader["ZH"]);
this.List1.Items.Add("语文:" + adatareader["YW"]);
this.List1.Items.Add("数学:" + adatareader["SX"]);
this.List1.Items.Add("外语:" + adatareader["WY"]);
this.List1.Items.Add("听力:" + adatareader["TL"]);
}
}
protected void CommandGoBack_Click(object sender, EventArgs e)
{
this.ActiveForm = this.FormQuery;
}
}
注意我将Database放在C盘根目录下的。。不然会编译错误的。。
还有就是使用Microsoft Mobile Explorer 3.0查看时候发生错误,望高手赐教。。我将所有文件之间放在IIS虚拟目录中的。。感觉配置有错误。。