c#winform怎样把数据库表中全部数据查询出来赋给richtextbox呢

Question

如题所述

Answer 1

SqlConnection conn = new SqlConnection(@"server=.;user=sa;password=123;database=数据采集");
conn.Open();

string sqlstr = "select * from min1 where 合约='CU**01' and 时间 between '2011-4-11 9:53:00' and '2011-4-15'";
DataSet ds=new DataSet();
SqlDataAdapter ada=new SqlDataAdapter(sqlstr,conn);
ada.Fill(ds);
DataTable dt = ds.Tables[0];

StringBuilder sb = new StringBuilder(textBox1.Text);
string str = "";

foreach (DataRow dr in dt.Rows)
{
for (int i = 0; i < dt.Columns.Count; i++)
{
str += dr[i].ToString()+" ";
}
sb.Append(str+"\r\n");
str = "";
}

richtextbox.Text = sb.ToString();
SQL语句改成你需要的，你看看，大概是这样子的本回答被提问者和网友采纳

Answer 2

用DATAGRIDVIEW控件呀，直接设置数据源就好了。