string connectionString = "server=\'(local)\'; user id=\'admin\'; password=\'87536259\'; database=\'Library\'";
System.Data.SqlClient.SqlConnection dbConnection = new System.Data.SqlClient.SqlConnection(connectionString);
string queryString = "SELECT [图书库].[价格], [图书库].[图书编号], [图书库].[条形码], [图书库].[币种], [图书库].[作者], [图书库].[ISBN" +
"], [图书库].[出版社], [图书库].[出版时间], [图书库].[书名], [图书库].[页数], [图书库].[存放位置], [图书库].[借出次数]" +
", [图书库].[入库时间], [图书库].[图书类别] FROM [图书库]";
SqlCommand dbCommand = new SqlCommand(queryString,dbConnection);
dbCommand.Connection.Open();
System.Data.SqlClient.SqlDataReader dr = dbCommand.ExecuteReader();
while(dr.Read())
{
//dr["币种"];以这样的方式获取对应字段值
} |
