现在C#学到用ADO.NET连接数据库, 我将连接数据库的基本知识附上, 以便加深印象和供以后查阅, 也提供给广大CSDN的朋友们参考, 有错误的地方希望大家不吝赐教.
- using System;
- using System.Collections.Generic;
- using System.ComponentModel;
- using System.Data;
- using System.Drawing;
- using System.Text;
- using System.Windows.Forms;
- using System.Data.SqlClient;
- namespace OpenCloseDB
- {
- public partial class OpenCloseDB : Form
- {
- public OpenCloseDB()
- {
- InitializeComponent();
- }
- private void btnTest_Click(object sender, EventArgs e)
- {
- string sqlConnStr = "Data Source = 'MyComputer\\SQLEXPRESS';Initial Catalog = 'UserInfo'; User ID = 'sa'; Pwd = 'MyComputer'";//定义连接字符串
- SqlConnection sqlConn = new SqlConnection(sqlConnStr);//创建 Connection 对象
- try
- {
- sqlConn.Open();//打开数据库连接
- MessageBox.Show("打开数据库连接成功!","提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
- }
- catch(Exception ex)
- {
- MessageBox.Show(ex.Message);//打开数据库连接异常处理
- }
- finally
- {
- sqlConn.Close();//关闭数据库连接
- MessageBox.Show("关闭数据库连接成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
- }
- }
- }
- }