程序设计与编码.docVIP

程序设计与编码 1.开发平台 sql server 2008 +visual studio 2008 + windows xp 2.主要代码 关键字搜索： public partial class MasterPage : System.Web.UI.MasterPage { protected void Page_Load(object sender, EventArgs e) { Label1.Text = DateTime.Now.ToString(); } protected void Button1_Click1(object sender, EventArgs e) { string input = TextBox1.Text .ToString () ; string sql = select * from news where title like %+input+%; string strcon = data source=localhost;initial catalog=news;User ID=sa;Password=2008sql; SqlConnection conn = new SqlConnection(strcon); conn.Open(); SqlCommand cmd = new SqlCommand(sql , conn); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { ListBox1.Items.Add(dr[title].ToString()); } dr.Close(); conn.Close(); } } cs文件： protected void Button1_Click(object sender, EventArgs e) { string strCon = Data Source=1847\\SQL2008;Initial Catalog=news;Integrated Security=True;User ID=sa; Password=123; SqlConnection conn =new SqlConnection(strCon); conn.Open(); string strsql = select * from admin ; /* SqlCommand cmd = new SqlCommand(strsql, conn); SqlDataReader dr = cmd.ExecuteReader(); string groud = dr.[groud]; * */ string strsql1=select * from admin where usersname= + TextBox1.Text + and password= + TextBox2.Text + ; SqlCommand cmd1 = new SqlCommand(strsql1, conn); //创建 Command SqlDataReader dr = cmd1.ExecuteReader(); object a= dr[groud]; int groud = (int)a;cmd1.ExecuteNonQuery(); if(groud==1) Response.Redirect(admin.aspx); if(groud==0) Response.Redirect(user.aspx); conn.Close(); } 管理用户界面： asp:SqlDataSource ID=SqlDataSource1 runat=server ConnectionString=%$ ConnectionStrings:newsConnectionString % DeleteCommand=DELETE FROM [admin] WHERE