62,047
社区成员
发帖
与我相关
我的任务
分享
protected void btn_Click(object sender, EventArgs e)
{
LinkButton btn = sender as LinkButton;
int rowIndex = (btn.NamingContainer as GridViewRow).RowIndex;
string dataKey = GridView1.DataKeys[rowIndex].Value.ToString();
string selectStr = "Select Details from Customers Where CustomerID=@CustomerID";
string connStr = ConfigurationManager.ConnectionStrings["TestSqlConnection"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
SqlParameter para = new SqlParameter("@CustomerID", SqlDbType.Text, 1000);
SqlCommand cmd = new SqlCommand(selectStr);
conn.Open();
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
try
{
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
if (dr.Read())
{
this.Details.InnerText = dr.GetString(0);
}
}
catch
{ }
}