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 FilterByLinq
{
public partial class Frm_Main : Form
{
public Frm_Main()
{
InitializeComponent();
}
private void Frm_Main_Load(object sender, EventArgs e)
{
string ConnectionString = "server=WIN-GI7E47AND9R\LS; database=db_TomeTwo; uid=sa; pwd=";//声明衔接字符串
using (SqlConnection Conn = new SqlConnection(ConnectionString))//创立数据库衔接目标
{
string sqlstr = "select * from tb_Bookinfo";//界说查询句子
SqlDataAdapter da = new SqlDataAdapter(sqlstr, Conn);//创立数据桥接器目标
DataSet ds = new DataSet();//创立数据目标
da.Fill(ds, "tb_Bookinfo");//填充数据集
//查询在“人邮”出书的图书
var result = from b in ds.Tables["tb_Bookinfo"].AsEnumerable()
where b.Field("b_pub") == "人邮"
select new
{
b_name = b["b_name"].ToString(),
b_price = b["b_price"].ToString()
};
richTextBox1.Text = "人民邮电出书社出书的图书有：
";
foreach (var item in result)//遍历输出查询成果
{
richTextBox1.Text+="图书称号：" + item.b_name + " ****** 单价：" + item.b_price+"
";
}
}
}
}
}
