ADO.NET 整理
DataReader 读取数据
//简单的读取数据用这个 是只读的
SqlConnection thisConnection = new SqlConnection("server=(local);database=数据库名;uid=sa;pwd=123");//建立一个 SQL Server 数据库的连接
thisConnection.Open();//打开链接
SqlCommand thisCommand = thisConnection.CreateCommand();//创建命令对象
thisCommand.CommandText = "数据库选择语句";//比较查找出需要的数据
SqlDataReader thisReader = thisCommand.ExecuteReader();//运行SQL命令
//如果是验证是否存在,可以使用if(thisReader.Read()) 如果是显示数据,用while(thisReader.Read()) .Read()如果有对象,则返回ture
thisReader.Close();
thisConnection.Close();
//简单的读取数据用这个 是只读的
SqlConnection thisConnection = new SqlConnection("server=(local);database=数据库名;uid=sa;pwd=123");//建立一个 SQL Server 数据库的连接
thisConnection.Open();//打开链接
SqlCommand thisCommand = thisConnection.CreateCommand();//创建命令对象
thisCommand.CommandText = "数据库选择语句";//比较查找出需要的数据
SqlDataReader thisReader = thisCommand.ExecuteReader();//运行SQL命令
//如果是验证是否存在,可以使用if(thisReader.Read()) 如果是显示数据,用while(thisReader.Read()) .Read()如果有对象,则返回ture
thisReader.Close();
thisConnection.Close();
Dataset读取数据
//DateSet用DataAdapter.Fill()填充数据
SqlConnection thisConnection = new SqlConnection("server=(local);database=数据库名;uid=sa;pwd=123");//建立一个 SQL Server 数据库的连接
SqlDataAdapter thisAdapter = new SqlDataAdapter("数据库操作语句", thisConnection);
DataSet thisDataSet = new DataSet();
thisAdapter.Fill(thisDataSet,"表名");
//对表中数据进行操作
foreach(DataRow theRow in thisDataSet.Tables["表名"].Rows){中间进行行操作 theRow["列名"]}
thisConnection.Close();
Dataset更新数据
SqlConnection thisConnection = new SqlConnection("server=(local);database=数据库名;uid=sa;pwd=123");
SqlDataAdapter thisAdapter = new SqlDataAdapter("数据库操作语句", thisConnection);
SqlCommandBuilder thisBuilder = new SqlCommandBuilder(thisAdapter);
DataSet thisDataSet = new DataSet();
thisAdapter.Fill(thisDataSet, "表名");
thisDataSet.Tables["表名"].Rows[第几个元素]["列名"] = 要赋的值;//精确定位操作元素,进行操作 赋值
thisAdapter.Update(thisDataSet, "表名");
thisConnection.Close();
Dataset添加新行
SqlConnection thisConnection = new SqlConnection("server=(local);database=数据库名;uid=sa;pwd=123");//建立一个 SQL Server 数据库的连接
SqlDataAdapter thisAdapter = new SqlDataAdapter("数据库操作语句", thisConnection);
SqlCommandBuilder thisBuilder = new SqlCommandBuilder(thisAdapter);
DataSet thisDataSet = new DataSet();
thisAdapter.Fill(thisDataSet, "表名");
DataRow thisRow = thisDataSet.Tables["Customers"].NewRow();
thisRow["列项名"] = "要添加的值";
thisDataSet.Tables["表名"].Rows.Add(thisRow);
thisAdapter.Update(thisDataSet, "表名");
thisConnection.Close();
也可以用SQL语句
SqlConnection thisConnection = new SqlConnection("server=(local);database=数据库名;uid=sa;pwd=123");//建立一个 SQL Server 数据库的连接
thisConnection.Open();
string conn_Add = "INSERT INTO 表(列名,列名)VALUS('" + 要添加的变量 + "','" + 要添加的变量 + "')";
SqlCommand thisCommand = new SqlCommand(conn_Add, 表);
thisCommand.ExecuteNonQuery();
thisConnection.Close();
Dataset查找行
SqlConnection thisConnection = new SqlConnection("server=(local);database=数据库名;uid=sa;pwd=123");//建立一个 SQL Server 数据库的连接
SqlDataAdapter thisAdapter = new SqlDataAdapter("数据库操作语句", thisConnection);
SqlCommandBuilder thisBuilder = new SqlCommandBuilder(thisAdapter);
DataSet thisDataSet = new DataSet();
thisAdapter.Fill(thisDataSet, "表名");
DataRow findRow = thisDataSet.Tables["表名"].Rows.Find("要添加的项");
if (findRow == null)//如果在表中没有找到要添加的项,则可以进行添加
{
DataRow thisRow = thisDataSet.Tables["表名"].NewRow();
thisRow["列名"] = "要添加的项";
thisDataSet.Tables["表名"].Rows.Add(thisRow);
if ((findRow = thisDataSet.Tables["表名"].Rows.Find("要添加的项")) != null) //添加的主项不为空
{
进行提示已经添加;
}
}
else
{
提示已经存在;//如果要添加的项目已经存在,则进行错误提示
}
thisAdapter.Update(thisDataSet, "Customers");
thisConnection.Close();
Dataset删除行
SqlConnection thisConnection = new SqlConnection("server=(local);database=数据库名;uid=sa;pwd=123");//建立一个 SQL Server 数据库的连接
SqlDataAdapter thisAdapter = new SqlDataAdapter("数据库操作语句", thisConnection);
SqlCommandBuilder thisBuilder = new SqlCommandBuilder(thisAdapter);
DataSet thisDataSet = new DataSet();
thisAdapter.Fill(thisDataSet, "表名");
DataRow findRow = thisDataSet.Tables["表名"].Rows.Find("要删除的项");
if (findRow != null)
{
findRow.Delete();
thisAdapter.Update(thisDataSet, "表名");
}
thisConnection.Close();
也可以用SQL语句
SqlConnection thisConnection = new SqlConnection("server=(local);database=数据库名;uid=sa;pwd=123");//建立一个 SQL Server 数据库的连接
thisConnection.Open();
string searchSql = "Delete from 表名 where 列名='" + 变量值 + "'";
SqlCommand thisCommand = new SqlCommand(searchSql, thisConnection);
thisCommand.ExecuteNonQuery();
del_Conn.Close();//