با سلام اینم کد asp.net و html من :
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class Report_Customer : System.Web.UI.Page
{
SqlConnection sql_conn = new SqlConnection();
DataSet ds = new DataSet();
SqlDataAdapter sql_adp = new SqlDataAdapter();
SqlCommand sql_comm = new SqlCommand();
string str_conn;
protected void Page_Load(object sender, EventArgs e)
{
try
{
str_conn = ConfigurationManager.AppSettings.Get(0);
sql_conn.ConnectionString = str_conn;
sql_adp.SelectCommand = new SqlCommand();
sql_adp.SelectCommand.Connection = sql_conn;
sql_comm.Connection = sql_conn;
sql_adp.SelectCommand.CommandType = CommandType.StoredProcedure;
sql_adp.SelectCommand.CommandText = "select_all_customer";
sql_conn.Open();
sql_adp.Fill(ds, "customer_register");
sql_conn.Close();
grd_user.DataSource = ds;
grd_user.DataMember = "customer_register";
grd_user.DataBind();
if (ds.Tables[0].Rows.Count == 0)
{
lbl_er.Text = ".هیچ اطلاعاتی یافت نشد";
}
ds.Clear();
}
catch (Exception exp)
{
sql_conn.Close();
lbl_er.Text = "خطا در انجام عملیات !";
}
}
protected void grd_user_PageIndexChanging(Object sender, GridViewPageEventArgs e)
{
grd_user.PageIndex = e.NewPageIndex;
grd_user.DataSource = ds.Tables.Add("customer_register"); //GetDataSource();
grd_user.DataMember = "customer_register";
grd_user.DataBind();
}
اینم کدhtml گرید ویو :
<asp:GridView ID="grd_user" runat="server" AllowPaging="True" AutoGenerateColumns="False"
BackColor="White" BorderColor="Gray" BorderStyle="Solid" BorderWidth="1px" CellPadding="4"
ForeColor="Black" Height="1px" Style="z-index: 104; left: 0px; position: absolute; top: 144px" Width="1px" PageSize="5" OnSelectedIndexChanged="grd_user_SelectedIndexChanged">
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<Columns>
<asp:BoundField DataField="password" HeaderText="کلمه عبور" SortExpression="password" />
<asp:BoundField DataField="username" HeaderText="نام کاربری" SortExpression="username" />
<asp:BoundField DataField="country" HeaderText="کشور" />
<asp:BoundField DataField="city" HeaderText="شهر" />
<asp:BoundField DataField="post_code" HeaderText="کد پستی" />
<asp:BoundField DataField="fax" HeaderText="شماره فاکس" />
<asp:BoundField DataField="tel1" HeaderText="شماره تماس" />
<asp:BoundField DataField="email" HeaderText="ایمیل" />
<asp:BoundField DataField="organization_name" HeaderText="نام سازمان" />
<asp:BoundField DataField="types" HeaderText="نوع مشتری" />
<asp:BoundField DataField="family" HeaderText="نام خانوادگی" SortExpression="family" />
<asp:BoundField DataField="sname" HeaderText="نام" SortExpression="sname" />
</Columns>
<RowStyle BackColor="#EFF3FB" />
<EditRowStyle BackColor="#2461BF" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
با تشکر