c#直连sqlserver数据库

不多说了，直接上码。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;
namespace WH
{
    class SqlserverCZ
    {
      
            public static string SQLStringec = "Data Source=;Initial Catalog=;User ID=;password=";

            public static System.Data.DataTable GetDataec(string sql)
            {

                SqlConnection SQLconn = new SqlConnection(SQLStringec);
                SqlCommand SQLcmd = new SqlCommand(sql, SQLconn);
                SqlDataAdapter SQLoda = new SqlDataAdapter(SQLcmd);
                DataTable SQLdtORA = new DataTable();
                SQLdtORA.Clear();
                try
                {
                    SQLconn.Open();
                    SQLoda.Fill(SQLdtORA);
                    return SQLdtORA;
                }
                finally
                {
                    SQLdtORA.Dispose();
                    SQLoda.Dispose();
                    SQLcmd.Dispose();
                    SQLconn.Dispose();
                }
            }

            public static void SaveDataec(string sql)
            {
                SqlConnection SQLconn = new SqlConnection(SQLStringec);
                SqlCommand SQLcmd = new SqlCommand(sql, SQLconn);
                try
                {
                    SQLconn.Open();
                    SQLcmd.ExecuteNonQuery();
                }
                finally
                {
                    SQLcmd.Dispose();
                    SQLconn.Close();
                    SQLconn.Dispose();
                }
            }
        }
    }

 使用方法：

 DataTable aa = SqlserverCZ.GetDataec("select *  from tree");
            dataGridView1.DataSource = aa.DefaultView;