才学.NET数据库连接方面不久,在网上下载了部分代码,然后自己经过测试调试,写了以下的一段例程,仅
供象我一样的菜鸟学习了解.
该段代码实现了数据库操作的几个基本功能:插入,删除,显示等操作.
本人动手测试成功,利用了SQL Server2000中的pubs数据库中的stores表.
由于时间关系,没有写成完全可以利用的代码, 您可以自己修改使其更加完善.
dataOperator.cs:
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace MyFirstTestPro.dataconn
{
class dataOperator
{
//数据库连接字符串
private string sqlConnectionCommand = "Data Source=(local);Initial Catalog=pubs;User ID=sa;Pwd=admin";
private string dataTableName = "stores";
private string sqlSelectCommand = "select * from stores where stor_id='6380'";
private string sqlDeleteCommand = "delete from stores where stor_id='1234'";
private string id="";
private string stor="";
public void useSqlReader()
{
SqlConnection sqlConnection = new SqlConnection(sqlConnectionCommand);
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandType = System.Data.CommandType.Text;
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandText = sqlSelectCommand;
sqlConnection.Open();
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
id =Convert.ToString(sqlDataReader["stor_id"]); //int keywordid=(int)sqlDataReader["title_id"];
stor =Convert.ToString(sqlDataReader["stor_name"]); //string titlename=(string)sqlDataReader["title"];
}
sqlDataReader.Close();
sqlCommand.Dispose();
sqlConnection.Close();
}
public string getID()
{
return id;
}
public string getTitle()
{
return stor;
}
public void useDeleteDataSet()
{
SqlConnection sqlConnection = new SqlConnection(sqlConnectionCommand);
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandType = CommandType.Text;
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandText = sqlDeleteCommand;
sqlConnection.Open();
int i= sqlCommand.ExecuteNonQuery();
sqlCommand.Dispose();
sqlConnection.Close();
}
public void UseAddDataSet(string storid, string storname)
{
SqlConnection sqlConnection = new SqlConnection(sqlConnectionCommand);
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandType = System.Data.CommandType.Text;
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandText = sqlSelectCommand;
sqlConnection.Open();
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter();
sqlDataAdapter.SelectCommand = sqlCommand;
DataSet dataSet = new DataSet();
//sqlCommandBuilder is for update the dataset to database
SqlCommandBuilder sqlCommandBuilder = new SqlCommandBuilder(sqlDataAdapter);
sqlDataAdapter.Fill(dataSet, dataTableName);
//Do something to dataset then you can update it to Database.Here I just add a row
DataRow row = dataSet.Tables[0].NewRow();
row[0] = storid;
row[1] = storname;
dataSet.Tables[0].Rows.Add(row);
sqlDataAdapter.Update(dataSet, dataTableName);
sqlCommand.Dispose();
sqlDataAdapter.Dispose();
sqlConnection.Close();
}
}
}