C# 操作 SQL Server(查询)
来源:互联网 发布:王牌特工2 知乎 编辑:程序博客网 时间:2024/06/17 15:37
#region------------------------------Sql Server 数据库操作 示例----------------------------------------------
/// <summary>
/// Sql Server 数据库操作
/// </summary>
public static void SqlServerDemo()
{
string sqlConnStr = "Data Source=;Initial Catalog=;User=root;Password=;";
SqlConnection sqlConn = new SqlConnection(sqlConnStr);
sqlConn.Open();
#region------------查询,利用SqlDataAdapter 查询-----------
string sql = "Select top 10 * from Articles";
SqlDataAdapter sqlAdapter = new SqlDataAdapter(sql, sqlConn);
DataTable sqlDataTable = new DataTable();
sqlAdapter.Fill(sqlDataTable);
foreach (DataRow row in sqlDataTable.Rows)
{
Console.WriteLine("题名:" + row["title"]);
for (int i = 0; i < row.ItemArray.Length; i++)
{
string str = row[i].ToString();
}
}
Console.WriteLine("条数为:" + sqlDataTable.Rows.Count);
#endregion
#region------------查询,利用Reader, 依次读取每一条数据--------------
SqlCommand sqlCommand = new SqlCommand(sql, sqlConn);
SqlDataReader sqlReader = sqlCommand.ExecuteReader();
int j = 0;
while (sqlReader.Read())
{
j++;
for (int i = 0; i < sqlReader.FieldCount; i++)
{
string str = sqlReader[i].ToString();
}
Console.WriteLine("题名:" + sqlReader["title"]);
}
Console.WriteLine("条数为:" + j);
sqlReader.Close();
#endregion
sqlConn.Close();
}
#endregion
}
/// <summary>
/// Sql Server 数据库操作
/// </summary>
public static void SqlServerDemo()
{
string sqlConnStr = "Data Source=;Initial Catalog=;User=root;Password=;";
SqlConnection sqlConn = new SqlConnection(sqlConnStr);
sqlConn.Open();
#region------------查询,利用SqlDataAdapter 查询-----------
string sql = "Select top 10 * from Articles";
SqlDataAdapter sqlAdapter = new SqlDataAdapter(sql, sqlConn);
DataTable sqlDataTable = new DataTable();
sqlAdapter.Fill(sqlDataTable);
foreach (DataRow row in sqlDataTable.Rows)
{
Console.WriteLine("题名:" + row["title"]);
for (int i = 0; i < row.ItemArray.Length; i++)
{
string str = row[i].ToString();
}
}
Console.WriteLine("条数为:" + sqlDataTable.Rows.Count);
#endregion
#region------------查询,利用Reader, 依次读取每一条数据--------------
SqlCommand sqlCommand = new SqlCommand(sql, sqlConn);
SqlDataReader sqlReader = sqlCommand.ExecuteReader();
int j = 0;
while (sqlReader.Read())
{
j++;
for (int i = 0; i < sqlReader.FieldCount; i++)
{
string str = sqlReader[i].ToString();
}
Console.WriteLine("题名:" + sqlReader["title"]);
}
Console.WriteLine("条数为:" + j);
sqlReader.Close();
#endregion
sqlConn.Close();
}
#endregion
}
- C# 操作 SQL Server(查询)
- C#操作sql server
- C# 操作 sql server
- C#操作SQL Server数据库
- C#操作SQL Server数据库
- C#操作SQL Server数据库
- C#操作SQL Server数据库
- C#操作SQL Server数据库
- C#操作SQL Server数据库
- C#操作SQL Server数据库
- C# SQL Server 操作笔记
- C#操作SQL Server数据库
- C#操作SQL Server数据库
- C#操作SQL Server数据库
- C#操作SQL Server数据库
- sql server的查询操作练习(知识点)
- sql server数据库及c#操作sql server数据库(第四次C#作业)
- C#连接SQL Server并查询数据
- Sybase触发器
- [easy_install]常用安装和卸载第三方库方法
- Hadoop中的RPC
- 为什么要用抽象类
- libvirt与qemu通信
- C# 操作 SQL Server(查询)
- 论我为什么想去实习--研究僧之反思
- 私人数组
- GridView1_RowUpdating取不到新值
- Tizen 开发 - UI:Scene Management
- poj_1201Intervals
- javaweb框架--自定义标签与freemaker结合
- Interleaving String
- 2、Cocoa Touch