searchall.cs

只做了一部分,希望以后能向各位高手学习,好学就是我咯!

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data ;
using System.Data.SqlClient ;

namespace lzl061111152357good5
{
	/// <summary>
	/// searchall 的摘要说明。
	/// </summary>
	public class searchall
	{
		public string connstr="Data Source=172.17.88.6;Initial Catalog=enter;password=lzl520;User id=linzling;";
		//public string connstr="Data Source=172.17.23.44;Initial Catalog=enter;password=12345;User id=sa;";
		//public string connstr="server=localhost;Integrated Security=SSPI;database=enter";
		//public string connstr="Data Source=219.131.136.209;Initial Catalog=enter;password=lzl520;User id=linzling;";
		public void search(string a,System.Windows.Forms.DataGrid l)
		{
			//DataGrid l=new DataGrid();
			//DataConn dc=new DataConn();
			string str=connstr ;
			SqlConnection conn=new SqlConnection (str);
			DataSet dataseta=new DataSet ();
			string sql=a;
			SqlDataAdapter aa=new SqlDataAdapter (sql,conn);
			aa.Fill (dataseta,"t1");
			l.DataSource =dataseta.Tables ["t1"];
			aa.Dispose ();
			dataseta.Dispose ();
			conn.Close();
			conn.Dispose ();
		}
		public void add(string adda)
		{
			//DataConn dc=new DataConn();
			string str=connstr ;
			SqlConnection conn=new SqlConnection (str);
			try
			{			
				DataSet dataset=new DataSet ();
				string StrSQL=adda;
				SqlDataAdapter a1=new SqlDataAdapter (StrSQL,conn);
				a1.Fill (dataset,"computer");
				dataset.AcceptChanges();
				conn.Close();
				conn.Dispose();
				//this.searchall();
				MessageBox.Show("增加数据集记录操作成功！","信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
						    
			}
			catch(Exception Err)
			{
				MessageBox.Show("增加数据集记录操作失败："+Err.Message,"信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
				//如果打开了连接，则关闭它
				if(conn.State==ConnectionState.Open)
				{
					conn.Close();
					conn.Dispose();
				}
			}
		}
		public void change(string ch,string lb)
		{
			string str=connstr ;
			SqlConnection conn=new SqlConnection (str);
			try
			{
				DataSet dataset1=new DataSet ();
				string StrSQL1=ch;
				SqlDataAdapter a11=new SqlDataAdapter (StrSQL1,conn);
				a11.Fill (dataset1,lb);
				dataset1.AcceptChanges();
				MessageBox.Show("修改数据集记录操作成功！","信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
			}
			catch(Exception Err)
			{
				MessageBox.Show("修改数据集记录操作失败："+Err.Message,"信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
				//如果打开了连接，则关闭它
				if(conn.State==ConnectionState.Open)
				{
					conn.Close();
					conn.Dispose();
				}
			}
		}
		public void change1(string ch1,string lb1)
		{
			string str=connstr ;
			SqlConnection conn=new SqlConnection (str);
            DataSet dataset1=new DataSet ();
	    	string StrSQL1=ch1;
			SqlDataAdapter a11=new SqlDataAdapter (StrSQL1,conn);
			a11.Fill (dataset1,lb1);
			dataset1.AcceptChanges();
			conn.Close();
			conn.Dispose();
		}
		public void delect(string del)
		{
			string str=connstr ;
			SqlConnection conn=new SqlConnection(str);
			try
			{			
				DataSet dataset1=new DataSet ();
				string StrSQL1=del;
				SqlDataAdapter a11=new SqlDataAdapter (StrSQL1,conn);
				a11.Fill (dataset1,"enter");
				dataset1.AcceptChanges();
				MessageBox.Show("删除数据集记录操作成功！","信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
				conn.Close();
				conn.Dispose();
			}
			catch(Exception Err)
			{
				MessageBox.Show("删除数据集记录操作失败："+Err.Message,"信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
				//如果打开了连接，则关闭它
				if(conn.State==ConnectionState.Open)
				{
					conn.Close();
					conn.Dispose();
				}
			}
		}
		public void textboxsearch(string tex,TextBox t,string tex1)
		{
			string str=connstr ;
			SqlConnection conn=new SqlConnection (str);
			DataSet dataset=new DataSet ();
			string sql1=tex;
			SqlDataAdapter a1=new SqlDataAdapter (sql1,conn);
			a1.Fill (dataset,"t1");
			t.DataBindings.Add("Text",dataset,tex1);
			a1.Dispose ();
			dataset.Dispose ();
			conn.Dispose ();
		}
		public void textboxsearch1(string tex,TextBox t,string tex1)
		{
			string str=connstr ;
			SqlConnection conn=new SqlConnection (str);
			DataSet dataset=new DataSet ();
			string sql1=tex;
			SqlDataAdapter a1=new SqlDataAdapter (sql1,conn);
			a1.Fill (dataset,"t1");
			t.DataBindings.Add("Text",dataset,"t1.id");
			a1.Dispose ();
			dataset.Dispose ();
			conn.Dispose ();
		}
		public void searchcom(string com,System.Windows.Forms.ComboBox l,string a,string b)
		{
			string str=connstr ;
			SqlConnection conn=new SqlConnection(str);
			DataSet dataset=new DataSet();
			conn.Open();
			string sql1=com;
			SqlDataAdapter a1=new SqlDataAdapter(sql1,conn);
			a1.Fill (dataset,a);
			l.DataSource = dataset; //数据绑定
			l.DisplayMember = b;
			l.ValueMember = b;
			conn.Close();
		}
		public void sqlbf(string tex)
		{
			string str=connstr ;
			SqlConnection conn=new SqlConnection (str);
			string dirstr=tex;//以BK＋当前日期的形式作为备份文件的名字;//+"\\BK"+(System.DateTime.Today .ToShortDateString())
			string sql="backup DATABASE enter TO disk='"+dirstr+"'";
			SqlCommand comd=new SqlCommand (sql,conn);
			conn.Open ();
			try
			{
				comd.ExecuteNonQuery ();
				MessageBox.Show ("备份成功！","",MessageBoxButtons.OK ,MessageBoxIcon.Information );
				tex ="";
			}
			catch
			{
				MessageBox.Show ("备份失败！请仔细检查路径，重新备份。","",MessageBoxButtons.OK,MessageBoxIcon.Error );
			}
			finally
			{
				conn.Close ();
				comd.Dispose ();
			}
		}
		public void sqlhy(string tex)
		{
			string str=connstr ;
			SqlConnection conn=new SqlConnection (str);
			string dirstr=tex+System.DateTime.Now.ToString();//以BK＋当前日期的形式作为备份文件的名字;//+"\\BK"+(System.DateTime.Today .ToShortDateString())
			string sql="RESTORE DATABASE enter FROM TAPE='"+dirstr+"'";
			SqlCommand comd=new SqlCommand (sql,conn);
			conn.Open ();
			try
			{
				comd.ExecuteNonQuery ();
				MessageBox.Show ("还原成功！","",MessageBoxButtons.OK ,MessageBoxIcon.Information );
				tex ="";
			}
			catch
			{
				MessageBox.Show ("还原失败！请仔细检查路径，重新还原。","",MessageBoxButtons.OK,MessageBoxIcon.Error );
			}
			finally
			{
				conn.Close ();
				comd.Dispose ();
			}
		}

	}
}