C# 在控制台窗口中显示数据库中的数据
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/18918100/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Displaying data in console window from database
提问by zarko
I created this simple 'Employee' program to train up my sql. And I decided to show all the data from the database if the user want to.
我创建了这个简单的“员工”程序来训练我的 sql。如果用户愿意，我决定显示数据库中的所有数据。
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
namespace MySQLQueryTest
{
class Program
{
static void Main(string[] args)
{
string response = "";
while (response != "exit")
{
Console.Write(">>");
response = Console.ReadLine();
switch (response.ToLower())
{
case "emp":
employeeMenu();
break;
case "-h":
Console.WriteLine("emp\tDisplays the Employee database menu");
Console.WriteLine("exit\tWill exit the program");
Console.WriteLine("clear\tWill clear the console window");
break;
case "clear":
Console.Clear();
break;
default:
Console.WriteLine("Invalid Command; for help type -h");
break;
}
}
}
static void employeeMenu()
{
Console.WriteLine("-------------Menu-------------");
Console.WriteLine("Type 'list' to list all employees.");
Console.WriteLine("Type 'add' to add an employee.");
Console.WriteLine("------------------------------");
string response = "";
while (response != "exit")
{
Console.Write("EmployeeMenu>");
response = Console.ReadLine();
switch (response.ToLower())
{
case "add":
getInfo();
break;
case "exit":
Console.WriteLine("Returning to Main Menu...");
break;
case "list":
Console.WriteLine("Here I will display all the SQL data");
break;
default:
Console.WriteLine("Invalid Command\n");
break;
}
}
}
static void getInfo()
{
Console.Write("First Name: ");
string fname = Console.ReadLine();
Console.Write("Last Name: ");
string lname = Console.ReadLine();
Console.Write("Job: ");
string job = Console.ReadLine();
addEmployee(fname, lname, job);
}
static void addEmployee(string the_fname, string the_lname, string the_job)
{
var connection = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename='c:\users\omri\documents\visual studio 2012\Projects\Map\Map\db.mdf';Integrated Security=True");
SqlCommand cmd;
connection.Open();
try
{
cmd = connection.CreateCommand();
cmd.CommandText = "INSERT INTO Employees(fname, lname, job) values('" + the_fname + "', '" + the_lname + "', '" + the_job + "');";
cmd.ExecuteNonQuery();
Console.WriteLine("Added " + the_fname + " " + the_lname + " to employee database.");
}
catch (Exception)
{
throw;
}
finally
{
if (connection.State == System.Data.ConnectionState.Open)
{
connection.Close();
}
}
}
}
}
}
I was searching the internet for some answers, but no success, the closest thing I found was this: Displaying result of query.
我在互联网上搜索了一些答案，但没有成功，我发现最接近的是：Displaying result of query。
Not sure this is what i'm looking for. So, my question is how can I show all the Data from Employees? Thank you in advance!
不确定这是我要找的。所以，我的问题是如何显示员工的所有数据？先感谢您！
采纳答案by Adam
Homework assignment?
家庭作业？
You already have code that runs SQL queries when you are adding employees into your database. To show all the employees in your database you want to do something similar to your addEmployee method, but instead of running an INSERT sql command you want to SELECT
在将员工添加到数据库时，您已经拥有运行 SQL 查询的代码。要显示数据库中的所有员工，您需要执行类似于 addEmployee 方法的操作，但不是运行 INSERT sql 命令，而是您想要 SELECT
using (SqlConnection connection = new SqlConnection(YOURCONNECTIONSTRING))
{
connection.Open();
using (SqlCommand command = new SqlCommand("SELECT * FROM Employees", connection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
for (int i = 0; i < reader.FieldCount; i++)
{
Console.WriteLine(reader.GetValue(i));
}
Console.WriteLine();
}
}
}
}
