vinnie-paz
شنبه 18 خرداد 1392, 16:50 عصر
سلام دوستانِ عزیزم میخواستم بدونم نقش DataKeyNames در قسمت FormLoad و همینطور [DataKeys[i در قسمت GridViwe در دستورات زیر چیه لطفا اگه امکانش هست توضیحات کامل بدید ممنونتون میشم.
using System;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string ConnectionString = "Server=localhost\\SqlExpress;Database=Store;Integ rated Security=True";
SqlConnection conn = new SqlConnection(ConnectionString);
string CommandText = "SELECT * FROM Customers";
SqlCommand comm = new SqlCommand(CommandText, conn);
conn.Open();
SqlDataReader r = comm.ExecuteReader();
GridView1.DataSource = r;
GridView1.DataKeyNames = new string[] { "CustomerID" };
GridView1.DataBind();
r.Close();
conn.Close();
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
// Obtain the index of the selected row
int i;
i = GridView1.SelectedIndex;
// Read the CustomerID
string cusID = (string)GridView1.DataKeys[i].Value;
string ConnectionString = "Server=localhost\\SqlExpress;Database=Store;Integ rated Security=True";
SqlConnection conn = new SqlConnection(ConnectionString);
string CommandText = "SELECT * FROM Customers WHERE CustomerID=@cusID";
SqlCommand comm = new SqlCommand(CommandText, conn);
comm.Parameters.Add("@CusID", SqlDbType.NChar, 5).Value = cusID;
conn.Open();
SqlDataReader r = comm.ExecuteReader();
DetailsView1.DataSource = r;
DetailsView1.DataBind();
r.Close();
conn.Close();
}
}
using System;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string ConnectionString = "Server=localhost\\SqlExpress;Database=Store;Integ rated Security=True";
SqlConnection conn = new SqlConnection(ConnectionString);
string CommandText = "SELECT * FROM Customers";
SqlCommand comm = new SqlCommand(CommandText, conn);
conn.Open();
SqlDataReader r = comm.ExecuteReader();
GridView1.DataSource = r;
GridView1.DataKeyNames = new string[] { "CustomerID" };
GridView1.DataBind();
r.Close();
conn.Close();
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
// Obtain the index of the selected row
int i;
i = GridView1.SelectedIndex;
// Read the CustomerID
string cusID = (string)GridView1.DataKeys[i].Value;
string ConnectionString = "Server=localhost\\SqlExpress;Database=Store;Integ rated Security=True";
SqlConnection conn = new SqlConnection(ConnectionString);
string CommandText = "SELECT * FROM Customers WHERE CustomerID=@cusID";
SqlCommand comm = new SqlCommand(CommandText, conn);
comm.Parameters.Add("@CusID", SqlDbType.NChar, 5).Value = cusID;
conn.Open();
SqlDataReader r = comm.ExecuteReader();
DetailsView1.DataSource = r;
DetailsView1.DataBind();
r.Close();
conn.Close();
}
}