c# - 显示来自SQL数据库的数据

我在VS 2008中设计了一个窗体。我有一个包含以下字段的数据库表：

Fname (char)
MailFrom (char)
MailTo (char)
Subject (char)
Body (char)
MailID (int)

现在，我从数据库中提取数据，并将其显示在表单上的相应字段中。

我后面的代码是：

SqlConnection conn = new SqlConnection(
        "Data Source=PTZ1\\SQLEXPRESS;Initial Catalog = test; Integrated Security=SSPI;User ID=sa; Password=sa@; Trusted_Connection=True;");

    SqlDataReader rdr = null;

    try
    {
        // Open the connection
        conn.Open();

        // Pass the connection to a command object
        SqlCommand cmd = new SqlCommand("select * from testing", conn);

        //
        // Use the connection
        //

        // get query results
        rdr = cmd.ExecuteReader();

        while (rdr.Read())
        {
            Console.WriteLine(rdr[]);
        }
    }
    finally
    {
        // close the reader
        if (rdr != null)
        {
            rdr.Close();
        }

        // Close the connection
        if (conn != null)
        {
            conn.Close();
        }
    }

如何在控制台上存储和显示数据

最佳答案

您可以使用DataTable将查询结果存储在内存中，以在Console上存储和显示该数据：

// Create a String to hold the query.
string query = "SELECT * FROM testing";

// Create a SqlCommand object and pass the constructor the connection string and the query string.
SqlCommand cmd = new SqlCommand(query, conn);

// Use the above SqlCommand object to create a SqlDataReader object.
SqlDataReader rdr = queryCommand.ExecuteReader();

// Create a DataTable object to hold all the data returned by the query.
DataTable dataTable = new DataTable();

// Use the DataTable.Load(SqlDataReader) function to put the results of the query into a DataTable.
dataTable.Load(rdr);

要么


确定您的自定义类别，例如以这种方式发送电子邮件：

class Email
{
    public string Fname { get; set; }
    public string MailFrom { get; set; }
    public string MailTo { get; set; }
    public string Subject { get; set; }
    public string Body { get; set; }
    public int MailID { get; set; }
}

阅读自定义类集合中的值：

List<Email> list = new List<Email>();

while (rdr.Read())
{
    Email o = new Email() { Fname=rdr["Fname"], MailFrom=rdr["MailFrom"],
        MailTo=rdr["MailTo"], Subject=rdr["Subject"], Body=rdr["Body"],
        MailID=Convert.ToInt32(rdr["MailID"]) };

    Console.WriteLine("First Name: {0}", o.Fname);
    Console.WriteLine("MailFrom: {0}", o.MailFrom);
    Console.WriteLine("Mail To: {0}", o.MailTo);
    Console.WriteLine("Subject: {0}", o.Subject);
    Console.WriteLine("Body: {0}", o.Body);
    list.Add(o);
}