Csharp连接数据库(vs2010编写).doc

说明：该文件是一个Csharp类，直接导入，然后连接的是（local）数据库，数据库名字为Stu_management，根据自己的需要可以更改，数据库为windows身份验证。string my_str = server=localhost;database=Stu_management;Integrated Security=SSPI;其中，serve表示数据库的服务器名字，database表示数据库名字，Integrated Security=SSPI表示数据库为windows身份验证，不需要输入密码验证进入数据库。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(数据库链接失败); 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(不能插入同样的数据); 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