Question

用C#连接SQL后listbox显示不对齐

这是我的代码：
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace 连接数据库
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)
{
SqlConnection cn = new SqlConnection("Data Source=J7MPVHBRQBDX4QI;initial catalog=library;integrated security=true");
SqlCommand cmd = new SqlCommand("select count(*) from Book",cn);
cn.Open();
int number = (int)cmd.ExecuteScalar();
cn.Close();
MessageBox.Show(number.ToString());
}

private void button2_Click(object sender, EventArgs e)
{
SqlConnection cn = new SqlConnection("Data Source=J7MPVHBRQBDX4QI;initial catalog=library;integrated security=true");
SqlCommand cmd = new SqlCommand("select * from Book",cn);
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
listBox1.Items.Add("ID:"+dr.GetInt32(0)+" name:"+dr.GetString(1)+" author:"
+dr.GetString(2)+" price:"+dr.GetSqlMoney(3));
}
}
}
}
}

想让那几个数据对齐，刚学不懂，是不是要在数据库上改，我用的是SQL SERVER 2008和VS2010





Answer 1

去掉空格，trim（）试试

Answer 2

lkdsfkhls5657ds35fd354dfs3sd35