Csharp連接數(shù)據(jù)庫(vs2010編寫).doc

說明：該文件是一個(gè)Csharp類，直接導(dǎo)入，然后連接的是（local）數(shù)據(jù)庫，數(shù)據(jù)庫名字為Stu_management，根據(jù)自己的需要可以更改，數(shù)據(jù)庫為windows身份驗(yàn)證。string my_str = server=localhost;database=Stu_management;Integrated Security=SSPI;其中，serve表示數(shù)據(jù)庫的服務(wù)器名字，database表示數(shù)據(jù)庫名字，Integrated Security=SSPI表示數(shù)據(jù)庫為windows身份驗(yàn)證，不需要輸入密碼驗(yàn)證進(jìn)入數(shù)據(jù)庫。using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data;using System.Windows.Forms;using System.Data.SqlClient;namespace Stu_Ach_Man_Sys class sqlcon string my_str = server=localhost;database=Stu_management;Integrated Security=SSPI; SqlConnection my_con; SqlCommand cmd; SqlDataAdapter sda; DataSet ds; DataTable dt; public void GetCon() try my_con = new SqlConnection(my_str); my_con.Open(); catch MessageBox.Show(數(shù)據(jù)庫鏈接失敗); public void CloseCon() my_con = new SqlConnection(my_str); if (my_con.State = ConnectionState.Open) my_con.Close(); public string GetData(string tab, string column, string data) string output = ; GetCon(); cmd = new SqlCommand(); cmd.Connection = my_con; if(tab = Admin) cmd.CommandText = SELECT + column + FROM + tab + WHERE Uid = + + data + ; else if(tab = info) cmd.CommandText = SELECT + column + FROM + tab + WHERE Sid = + + data + ; else if(tab = Class) cmd.CommandText = SELECT + column + FROM + tab + WHERE Class = + + data + ; else if (tab = Subject) cmd.CommandText = SELECT + column + FROM + tab + WHERE Subject = + + data + ; else if (tab = Course) cmd.CommandText = SELECT + column + FROM + tab + WHERE Csid = + + data + ; cmd.CommandType = CommandType.Text; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read() output = string.Format(0, reader.GetString(0); return output; public void InsertData(string tab, string column, string data) GetCon(); cmd = new SqlCommand(); cmd.Connection = my_con; cmd.CommandText = INSERT INTO + tab +( + column +) VALUES ( + data + ); cmd.CommandType = CommandType.Text; try int i = Convert.ToInt32(cmd.ExecuteNonQuery(); catch MessageBox.Show(不能插入同樣的數(shù)據(jù)); public void UpData(string tab, string column, string row, string data) my_con = new SqlConnection(my_str); sda = new SqlDataAdapter(); cmd = new SqlCommand(SELECT * FROM + tab, my_con); sda.SelectCommand = cmd; ds = new DataSet(); sda.Fill(ds, tab); dt = ds.Tablestab; sda.FillSchema(dt, SchemaType.Mapped); DataRow dr = dt.Rows.Find(row); drcolumn = data; SqlCommandBuilder cmdbulider = new SqlCommandBuilder(sda); sda.Update(dt); public void DeleteData(string tab, string column, string data) GetCon(); cmd = new SqlCommand(); cmd.Connection = my_con; cmd.CommandText = DELETE FROM + tab + WHERE + column + = + data +; cmd.CommandType = CommandType.Text; int i = Convert.ToInt32(cmd.ExecuteNonQuery(); public void Createcolumn(string tab, string col_name) GetCon(); cmd = new SqlCommand(); cmd.Connection = my_con; cmd.CommandText = ALTER TABLE + tab + ADD + col_name + nvarchar(50); cmd.CommandType = CommandType.Text; int i = Convert.ToInt32(cmd.ExecuteNonQuery(); public void Deletecolumn(string tab, string col_name) GetCon(); cmd = new SqlCommand(); cmd.Connection = my_con; cmd.CommandText = ALTER TABLE + tab + DROP column + col_name; cmd.CommandType = CommandType.Text; int i = Convert.ToInt32(cmd.ExecuteNonQuery(); public string GetDateStr(string tab, string column) string output = ; GetCon(); cmd = new SqlCommand(); cmd.Connection = my_con; if (tab = Admin) cmd.CommandText = SELECT + column + FROM + tab; else if (tab = info) cmd.CommandText = SELECT + column + FROM + tab; else if (tab = Class) cmd.CommandText = SELECT + column + FROM + tab; else if (tab = Subject) cmd.CommandText = SELECT + column + FROM + tab; else if (tab = Course) cmd.CommandText = SELECT + colu