Web.config里配置一下数据库连接
<connectionStrings>
<add name="ConnectionString" connectionString="user id=sa;password=连接数据库密码;Data Source=计算机名称;Initial Catalog=数据库名称"/></connectionStrings>
前台aspx添加一个按钮一个gridview
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" AllowPaging="True" PageSize="10" >
<Columns>
<asp:BoundField DataField="Name" HeaderText="姓名" InsertVisible="False">
<ItemStyle Width="60px" />
</asp:BoundField>
</Columns>
</asp:GridView>
<asp:Button ID="Button1" runat="server" οnclick="Button1_Click" Text="Button" />
后台aspx.cs添加方法
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.Linq;
using System.Data.Linq.Mapping;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
namespace LinqTest1
{
public partial class _Default : System.Web.UI.Page
{
SqlConnection sqlconn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
protected void Page_Load(object sender, EventArgs e)
{
}
[Table(Name = "KQ")]
public class KQInfo
{
[Column(Name = "name")]
public string Name { get; set; }
}
protected void Button1_Click(object sender, EventArgs e)
{
DataContext dc = new DataContext(sqlconn);
Table<KQInfo> kqtable = dc.GetTable<KQInfo>();
var aaa = from kq in kqtable orderby kq.Name ascending select kq;
GridView1.DataSource = aaa.Distinct().ToList();
GridView1.DataBind();
}
}
}
这里有一个排序问题,原理上应该是按升序排列,但是没有效果,不知为什么,希望高手指点。