c#数据库连接

//此方法是使用Windows身份验证连接本地sql数据库
using System;
using System.Data;
using System.Data.SqlClient;//连接sql数据库，需自己添加
using System.Windows.Forms;
namespace DataSearching
{
    public partial class Form1 : Form
    {
        private string ConnectionString ="Server = .;database=MyDatabase;integrated security = sspi";
        private SqlConnection conn = null;
        private SqlDataAdapter DataAdapter = null;
        private DataSet dataset = null;
        private SqlCommand cmd = null;
        public Form1()
        {
            InitializeComponent();
        }
        private void button1_Click(object sender, EventArgs e)
        {
            string tb1 = textBox1.Text;
            if (comboBox2.Text == " like ") tb1 = "%" + textBox1.Text + "%";
            string strSQL = "SELECT * FROM student Where ";
            strSQL += comboBox1.Text + comboBox2.Text + "'" + tb1 + "'";
            try
            {
                cmd.CommandText = strSQL;
                DataAdapter.SelectCommand = cmd;
                dataset.Clear();
                DataAdapter.Fill(dataset, "t1");
                dataGridView1.DataSource = dataset;
                dataGridView1.DataMember = "t1";
            }
            catch
            {
                MessageBox.Show("请正确设置检索条件！");
            }
            finally
            {
                if (conn != null) conn.Close();
            }
        }
        private void Form1_Load(object sender, EventArgs e)
        {
            try
            {
                conn = new SqlConnection(ConnectionString);
                conn.Open();
                DataAdapter = new SqlDataAdapter();
                dataset = new DataSet();
                cmd = new SqlCommand();
                cmd.Connection = conn;
                cmd.CommandText = "SELECT * FROM student";
                DataAdapter.SelectCommand = cmd;
                DataAdapter.Fill(dataset, "t1");
                comboBox1.Items.Clear();
                //先获取所有的字段，以用于构造查询条件
                for (int i = 0; i < dataset.Tables["t1"].Columns.Count; i++)
                    comboBox1.Items.Add(dataset.Tables["t1"].Columns[i].ToString());
                dataset.Clear();
                comboBox2.Items.Add(" = ");  //设置比较运算符
                comboBox2.Items.Add(" < ");
                comboBox2.Items.Add(" > ");
                comboBox2.Items.Add(" like ");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
    }
}

 

要连接Oracle数据库，需先添加OracleClient引用，然后引用System.Data.OracleClient命名空间，在使用OracleConnection对象进行连接。

注意：在使用VS时会找不到System.Data.OracleClient这个引用，可以使用以下方法解决；右击项目的属性，

在弹出窗口中有一个【目标框架】下拉框选项，默认全是，.Net FRAMWORK 4 CLIENT PROFILE(NET Framwork 4 Client profile 是 .NET Framework 4 简精版 )，

将此选项更改为 .NET FRAMEWORK 4。再打开【解决方法资源管理器】窗口，在项目的【引用】上单击鼠标右键，在弹出的快捷菜单中选择【添加引用】命令，添加OracleClient引用，就ok了

using System;
using System.Data;
using System.Data.OracleClient;
using System.Windows.Forms;
namespace DataSearching
{
    public partial class Form1 : Form
    {
        private string ConnectionString = "User Id = sunc; Password = hr;Data Source = xe";
        private OracleConnection conn = null;
        private OracleDataAdapter DataAdapter = null;
        private DataSet dataset = null;
        private OracleCommand cmd = null;
        public Form1()
        {
            InitializeComponent();
        }
        private void button1_Click(object sender, EventArgs e)
        {
            string tb1 = textBox1.Text;
            if (comboBox2.Text == " like ") tb1 = "%" + textBox1.Text + "%";
            string strSQL = "SELECT * FROM student Where ";
            strSQL += comboBox1.Text + comboBox2.Text + "'" + tb1 + "'";
            try
            {
                cmd.CommandText = strSQL;
                DataAdapter.SelectCommand = cmd;
                dataset.Clear();
                DataAdapter.Fill(dataset, "t1");
                dataGridView1.DataSource = dataset;
                dataGridView1.DataMember = "t1";
            }
            catch
            {
                MessageBox.Show("请正确设置检索条件！");
            }
            finally
            {
                if (conn != null) conn.Close();
            }
        }
        private void Form1_Load(object sender, EventArgs e)
        {
            try
            {
                conn = new OracleConnection(ConnectionString);
                conn.Open();
                DataAdapter = new OracleDataAdapter();
                dataset = new DataSet();
                cmd = new OracleCommand();
                cmd.Connection = conn;
                cmd.CommandText = "SELECT * FROM student";
                DataAdapter.SelectCommand = cmd;
                DataAdapter.Fill(dataset, "t1");
                comboBox1.Items.Clear();
                //先获取所有的字段，以用于构造查询条件
                for (int i = 0; i < dataset.Tables["t1"].Columns.Count; i++)
                    comboBox1.Items.Add(dataset.Tables["t1"].Columns[i].ToString());
                dataset.Clear();
                comboBox2.Items.Add(" = ");  //设置比较运算符
                comboBox2.Items.Add(" < ");
                comboBox2.Items.Add(" > ");
                comboBox2.Items.Add(" like ");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
    }
}

其中 private string ConnectionString = "User Id = sunc; Password = hr;Data Source = xe";
User Id 为用户名，password 为用户名对应的密码；
Data Sourse 获取方式：打开数据库，连接上用户，右击用户名查看属性 对应SID内容即为DATA SOURCE；