#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
}