.NET数据库(MYSQL)操作 -------------------------------------------------------------------------------- myConnection = new SqlConnection("server=localhost;" + //if (!IsPostBack) BindGrid();
源代码: public void BindGrid() myConnection = new SqlConnection("server=localhost;" + SqlDataAdapter myCommand = new SqlDataAdapter("SELECT top 10 * FROM" + DataSet ds = new DataSet(); MyDataGrid.DataSource=ds; } 增删改数据库 源代码: public void AddAuthor_Click()
SqlCommand myCommand = new SqlCommand(insertCmd, myConnection); try } catch this.body.Text = "*************"; } myCommand.Connection.Close();
连接SQL Server数据库 源代码: //作用: 连接SQL Server数据库 //参数:ServerName 服务器名,DBName 数据库名,UserID 用户名,UserPwd 用户密码 public void ConnSQLServer(string ServerName, string DBName) { mCnnDB.ConnectionString = "uid=;pwd= ;driver={SQL Server};" + "server=" +ServerName+ ";database=" + DBName; mCnnDB.Open(mCnnDB.ConnectionString,"sa","",-1); } public void ConnSQLServer(string ServerName, string DBName,string UserID,string UserPwd) { mCnnDB.ConnectionString = "uid=''" + UserID + "'';pwd=''" + UserPwd + "'' ;driver={SQL Server};" + "server=" + ServerName + ";database=" + DBName; mCnnDB.Open(mCnnDB.ConnectionString,UserID,UserPwd,-1);; } 连接ODBC数据库 源代码: // ''作用: 连接ODBC数据库 // ''参数:dsnName ODBC名,UserID 用户名,UserPwd 用户密码 public void ConnODBC(string dsnName ) { mCnnDB.Provider = "MSDASQL"; mCnnDB.ConnectionString = "Data Source=''" + dsnName + "''"; mCnnDB.Open(mCnnDB.ConnectionString,"","",-1); } public void ConnODBC(string dsnName,string UserID, string UserPwd ) { mCnnDB.Provider = "MSDASQL"; mCnnDB.ConnectionString = "User ID=''" +UserID + "'';" + "Password=''" + UserPwd + "'';" + "Data Source=''"+dsnName+ "''"; mCnnDB.Open(mCnnDB.ConnectionString,UserID,UserPwd,-1 ); } (iwgh) |