数据库操作

publicpartialclass adminAllMusic : MyPage{protectedvoid Page_Load(object sender, EventArgs e){}protectedvoid btnSearch_Click(object sender, EventArgs e) {BindData();}///<summary>///根据用户输入的搜索词和搜索类型，查找歌曲///</summary>privatevoid BindData(){//System.Threading.Thread.Sleep(4000);string type = rblType.SelectedValue;string keyword = txtKeyWords.Text;if (!string.IsNullOrEmpty(type)){Music m = new Music();DataSet ds = null;if (type == "1"){ds = m.SearchByName(keyword);}elseif (type == "2"){ds = m.SearchBySinger(keyword);}elseif (type == "3"){ds = m.SearchByContent(keyword);}GridView1.DataSource = ds;GridView1.DataBind();}}protectedvoid GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e){string musicId = GridView1.DataKeys[e.RowIndex].Value.ToString();Music m = new Music();m.MusicId = Convert.ToInt32(musicId);m.Del();BindData();}protectedvoid GridView1_RowEditing(object sender, GridViewEditEventArgs e){GridView1.EditIndex = e.NewEditIndex;BindData();}protectedvoid GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e){GridView1.EditIndex = -1;BindData();}protectedvoid GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e){//获取主键string musicId = GridView1.DataKeys[e.RowIndex].Value.ToString();//获取音乐名称string musicName =((TextBox)(GridView1.Rows[e.RowIndex].Cells[0].Controls[0])).Text;//获取歌手名称string singer = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text;Music m = new Music();//因为只更新其中的一部分字段内容，因此首先取回该记录所有的信息。

m = m.GetModel(Convert.ToInt32(musicId));m.MusicName = musicName;m.Singer = singer;//更新到数据库m.Modify();//取消编辑模式GridView1.EditIndex = -1;BindData();// File: SqlDbHelper.cs// Author: audrey// Created: 2009年月日10:30:03// Purpose: Definition of Class SqlDbHelperusing System;using System.Data;using System.Data.SqlClient;using System.Collections;using System.Collections.Generic;publicclass SqlDbHelper{//private static string CONNECTION_STRING ="server=william\\sqlexpress;database=musicbar;uid=sa;pwd=william.shan";//DataSource=.\SQLEXPRESS;AttachDbFilename=D:\MusicWebSite\ch6\App_Data\MusicBar.mdf;Integrated Security=True;Connect Timeout=30;User Instance=Trueprivatestaticstring CONNECTION_STRING = @"DataSource=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|MusicBar.mdf;IntegratedSecurity=True;Connect Timeout=30;User Instance=True";//public string connectionString;///<summary>///执行Select语句，///</summary>///<param name="strSql"></param>///<returns></returns>publicstatic DataSet ExecuteSelectSql(string strSql){SqlConnection conn = new SqlConnection(CONNECTION_STRING);SqlDataAdapter da = new SqlDataAdapter(strSql, conn);DataSet ds = new DataSet();try{da.Fill(ds);return ds;}catch (Exception ex){thrownew Exception("执行SQL出现错误：\r\n"+strSql+"\r\n"+ex.ToString());}finally{conn.Close();}//throw new NotImplementedException();}///<summary>///执行UPDATE语句///</summary>///<param name="strSql"></param>///<returns></returns>publicstaticint ExecuteUpdateSql(string strSql){SqlConnection conn = new SqlConnection(CONNECTION_STRING);SqlCommand comm = new SqlCommand();comm.Connection = conn;mandType = CommandType.Text;mandText = strSql;int ret = -1;try{conn.Open();ret = comm.ExecuteNonQuery();return ret;}catch (Exception ex){thrownew Exception("执行SQL出现错误：\r\n" + strSql + "\r\n" + ex.ToString()); }finally{conn.Close();}//throw new NotImplementedException();}///<summary>///执行Delete语句///</summary>///<param name="strSql"></param>///<returns></returns>publicstaticint ExecuteDelSql(string strSql){SqlConnection conn = new SqlConnection(CONNECTION_STRING);SqlCommand comm = new SqlCommand(strSql,conn);int ret = -1;try{conn.Open();ret = comm.ExecuteNonQuery();return ret;}catch (Exception ex){thrownew Exception("执行SQL出现错误：\r\n" + strSql + "\r\n" + ex.ToString()); }finally{conn.Close();}//throw new NotImplementedException();}///<summary>///执行Insert语句///</summary>///<param name="strSql"></param>///<returns></returns>publicstaticint ExecuteInsertSql(string strSql){SqlConnection conn = new SqlConnection(CONNECTION_STRING);SqlCommand comm = new SqlCommand();comm.Connection = conn;mandType = CommandType.Text;mandText = strSql;int ret = -1;try{conn.Open();ret = comm.ExecuteNonQuery();return ret;}catch (Exception ex){thrownew Exception("执行SQL出现错误：\r\n" + strSql + "\r\n" + ex.ToString()); }finally{conn.Close();}//throw new NotImplementedException();}publicstatic Object ExecuteScalar(string strSql){SqlConnection conn = new SqlConnection(CONNECTION_STRING);SqlCommand comm = new SqlCommand();comm.Connection = conn;mandType = CommandType.Text;mandText = strSql;try{conn.Open();SqlDataReader dr = comm.ExecuteReader();if (dr.Read()){return dr[0];}else{returnnull;}}catch (Exception ex){thrownew Exception("执行SQL出现错误：\r\n" + strSql + "\r\n" + ex.ToString()); }finally{conn.Close();}//throw new NotImplementedException();}public SqlConnection GetConnection(){SqlConnection conn = new SqlConnection(CONNECTION_STRING); return conn;//throw new NotImplementedException();}}。