Question

采用C#的情况下，如何连接到数据库把数据库中的一些信息列出来？

如何在控制台也就是像VC那种一样在cmd窗口显示出数据库中表的信息的那种？？？？？？？谢谢

Answer 1

首先连接数据库，然后用SQL语句查询出要打印出来的信息保存到一个内存表datatable中，然后用双重循环打印出来就可以了！

Answer 2

SQL Server的例子如下用的时候改一下连接字符串"Data Source=.;Initial Catalog=shangbiao;Integrated Security=True";using System;using System.Collections.Generic;using System.Text;using System.Data;using System.Data.SqlClient; namespace ShangManagementSystem.BaseClass{ class BaseCon { ///<summary> ///建立数据库连接 ///</summary> ///<returns>返回SqlConnection对象</returns> public SqlConnection getcon() { string str_sqlcon = "Data Source=hwj;Initial Catalog=shangbiao;Integrated Security=True"; SqlConnection myCon = new SqlConnection(str_sqlcon); return myCon; } ///<summary> ///执行SqlCommand ///</summary> ///<param name="str_sqlstr">SQL语句</param> public void getcom(string str_sqlstr) { SqlConnection sqlcon = this.getcon(); sqlcon.Open(); SqlCommand sqlcom = new SqlCommand(str_sqlstr, sqlcon); sqlcom.ExecuteNonQuery(); sqlcom.Dispose(); sqlcon.Close(); sqlcon.Dispose(); } ///<summary> ///创建一个DataSet对象 ///</summary> /// <param name="str_sqlstr">SQL语句</param> /// <param name="str_table">表名</param> ///<returns>返回DataSet对象</returns> public DataSet getds(string str_sqlstr, string str_table) { SqlConnection sqlcon = this.getcon(); SqlDataAdapter sqlda = new SqlDataAdapter(str_sqlstr, sqlcon); DataSet myds = new DataSet(); sqlda.Fill(myds, str_table); return myds; } ///<summary> ///创建一个SqlDataReader对象 ///</summary> /// <param name="str_sqlstr">SQL语句</param> ///<returns>返回SqlDataReader对象</returns> public SqlDataReader getread(string str_sqlstr) { SqlConnection sqlcon = this.getcon(); SqlCommand sqlcom = new SqlCommand(str_sqlstr, sqlcon); sqlcon.Open(); SqlDataReader sqlread = sqlcom.ExecuteReader(CommandBehavior.CloseConnection); return sqlread; } }}