个人常用

using Socut.Data;//引用命名空间public CReader dr;public CData myData=new CData ();//调用组件中的类CData,插入数据，需用此类public DataSet ds=new DataSet ();//将DataSet实例化public CReader dr;public CData myData=new CData ();public DataSet ds=new DataSet ();// 在此处放置用户代码以初始化页面string strID=Request["id"];ds=myData.GetDataSet ("SELECT n_id,n_title,n_content FROM socut_news WHERE n_id='"+strID+"'",0,0,"dsTable");if(!Page.IsPostBack )//此句一定要加，否则无法更新{TextBox1.Text =ds.Tables ["dsTable"].Rows [0][1].ToString ();TextBox2.Text =ds.Tables ["dsTable"].Rows [0][2].ToString ();}//增删改string strID=Request["id"];myData.GetExecuteNonQuery("UPDATE socut_news SET n_title='"+TextBox1.Text +"',n_content='"+TextBox2.Text +"' WHERE n_id='"+strID+"'");Label1.Text ="更新成功！";//string strID=Request["id"];myData.GetExecuteNonQuery("DELETE FROM socut_news WHERE n_id='"+strID+"'");Label1.Text ="删除成功！";//string strID=System.Guid .NewGuid().ToString();//GUID编号IDstring strTime=System.DateTime.Now .ToString();//当前时间myData.GetExecuteNonQuery("INSERT INTO socut_news (n_id,n_title,n_content,n_time) VALUES ('"+strID+"','"+TextBox1.Text+"','"+TextBox2.Text+"','"+strTime+"')");Label1.Text="添加成功！";ds=myData.GetDataSet ("SELECT * FROM socut_news",0,0,"TableName");DataGrid1.DataSource =ds;//设置数据源DataGrid1.DataBind ();//绑定数据// 在此处放置用户代码以初始化页面string strID=Request["id"];//获取浏览器地址参数idds=myData.GetDataSet ("SELECT n_id,n_title,n_time,n_content FROM socut_news WHERE n_id='"+strID+"'",0,0,"dsTable");Label1.Text =ds.Tables ["dsTable"].Rows [0][1].ToString ();//读取虚拟表的第一列(事实上是第二列，因为这是从0开始数)Label2.Text =ds.Tables ["dsTable"].Rows [0][2].ToString ();Label3.Text =ds.Tables ["dsTable"].Rows [0][3].ToString ();dr=new CReader("SELECT * FROM socut_user WHERE u_name='"+TextBox1.Text+"'");//根据输入的名称在数据库中寻找myData.GetExecuteNonQuery("INSERT INTO socut_user (u_name,u_pass) VALUES ('"+TextBox1.Text +"','"+TextBox2.Text +"')");Label1.Text ="注册成功！";public string GetList(){ string strBody=null;//新闻主体 dr=new CReader ("SELECT TOP 10 * FROM socut_news");//提取前10条新闻 while(dr.Read ())//循环读取 { strBody+="<a href="news/view.aspx?id="+dr["n_id"]+"" mce_href="news/view.aspx?id="+dr["n_id"]+"" target=_blank>"+dr["n_title"]+"</a><br>"; } dr.Close ();//切记一定要关闭阅读器 return strBody;}drLogin.Close ();//一切读取行为结束后，一定要关闭阅读器 Response.Write("<mce:script type="text/javascript"><!--alert('已安全退出，单击确定返回登陆首页！');window.parent.location.href='Admin_Login.aspx';// --></mce:script>");string AddInfo = "UPDATE [AboutUs] SET [Title]='" + this.txtTitle.Text + "',[Content]='" + this.NewsContent.Value + "',[updatetime]=#" + NewsDT + "# WHERE ID=" + strID;