?? selectexam.aspx.cs
字號:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
namespace examonline
{
/// <summary>
/// selectexam 的摘要說明。
/// </summary>
public partial class selectexam : System.Web.UI.Page
{
protected System.Web.UI.HtmlControls.HtmlForm Form2;
protected System.Web.UI.HtmlControls.HtmlForm Form3;
protected void Page_Load(object sender, System.EventArgs e)
{
if((bool)Session["IsLogined"]==false)
{
Response.Redirect("index.aspx");
}
}
#region Web 窗體設計器生成的代碼
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 該調用是 ASP.NET Web 窗體設計器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 設計器支持所需的方法 - 不要使用代碼編輯器修改
/// 此方法的內容。
/// </summary>
private void InitializeComponent()
{
}
#endregion
protected void btnSelect_Click(object sender, System.EventArgs e)
{
string sql="";
switch(ddlTarge.SelectedValue)
{
case "1":
sql= "Select * from selectItems where title like '%"+ txtKey.Text +"%' or question like '%"+txtKey.Text+"%'";
break;
case "2":
sql= "Select * from fillblank where title like '%"+ txtKey.Text +"%' or question like '%"+txtKey.Text+"%'";
break;
case "3":
sql= "Select * from essay where title like '%"+ txtKey.Text +"%' or question like '%"+txtKey.Text+"%'";
break;
default:
Session["info"]="出錯了!";
break;
}
SqlConnection cn =new SqlConnection("server=(local);uid=sa;pwd=51aspx;database=examonline");
SqlDataAdapter da =new SqlDataAdapter(sql, cn);
DataSet ds=new DataSet();
try
{
cn.Open();
da.Fill(ds, "selectItems");
}
finally
{
cn.Close();
}
ds.Tables["selectItems"].Columns.Add("examName",GetType());
DataTable table=ds.Tables["selectItems"];
foreach(DataRow row in table.Rows)
{
sql = "Select exam_title from exam where exam_id="+ row["exam_id"];
SqlCommand cmd = new SqlCommand(sql,cn);
SqlDataReader dr;
cn.Open();
dr=cmd.ExecuteReader();
while(dr.Read())
{
row["examName"]=dr.GetString(0);
}
row["title"]=row["title"].ToString().Replace(txtKey.Text,"<font style='BACKGROUND-COLOR: #87cefa'>"+txtKey.Text+"</font>");
row["question"]=row["question"].ToString().Replace(txtKey.Text,"<font style='BACKGROUND-COLOR: #87cefa'>"+txtKey.Text+"</font>");
cn.Close();
}
dgResult.DataSource = ds.Tables["selectItems"];
dgResult.DataBind();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -