Viewing source for recipe1318cs.aspx
<%@ Page Language="C#" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SqlClient" %>
<script runat="server">
private void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
BindGrid();
}
else
{
if ((Request.Form["__EventTarget"] != null) && (Request.Form["__EventTarget"] == "myDblClick"))
{
DblClickDataGrid.SelectedIndex = Int32.Parse(Request.Form["__EVENTARGUMENT"]);
}
}
}
private void BindGrid()
{
String selectStatement = "select Top 10 ";
selectStatement += "OrderID, ";
selectStatement += "CustomerID, ";
selectStatement += "Freight, ";
selectStatement += "ShipName, ";
selectStatement += "ShipAddress ";
selectStatement += "from Orders";
SqlConnection objConnection = new SqlConnection("server=Localhost;database=NorthWind;Trusted_Connection=yes");
SqlDataAdapter objDataAdapter = new SqlDataAdapter(selectStatement, objConnection);
DataSet objDataSet = new DataSet();
try
{
objDataAdapter.Fill(objDataSet, "Orders");
DblClickDataGrid.DataSource = objDataSet.Tables["Orders"].DefaultView;
DblClickDataGrid.DataBind();
}
catch (SqlException SqlEx)
{
Response.Write(SqlEx.Message);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
objConnection.Close();
}
}
private void DblClickDataGrid_ItemDataBound(object sender, DataGridItemEventArgs e)
{
if ((e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem))
{
e.Item.Attributes.Add("ondblclick", "Javascript:__doPostBack('myDblClick','" + e.Item.ItemIndex + "');");
}
}
</script>
<html>
<head>
</head>
<body>
<form runat="server">
<asp:DataGrid id="DblClickDataGrid" OnItemDataBound="DblClickDataGrid_ItemDataBound" Runat="Server">
<SelectedItemStyle backcolor="Yellow" />
<Columns>
<asp:ButtonColumn Text="Select" HeaderText="Select" CommandName="Select"></asp:ButtonColumn>
</Columns>
</asp:DataGrid>
</form>
</body>
</html>