Navigator : Home > Tutorials > Controls Tutorials > ...
GridView and DetailsView control in ASP.NET 2.0(C#)
This tutorial will show you how to use a GridView control in combination with a DetailsView control in ASP.NET and C# to display master-detail information.
To refresh the GridView control after a new record is inserted into DetailsView control
Server Intellect offers Windows Hosting Dedicated Servers at affordable prices. I'm very pleased!
public void CustomerDetail_ItemInserted(object sender,DetailsViewInsertedEventArgs e)
{
CustomersView.DataBind(); } |
Insert the values entered
public void CustomerDetail_ItemInserting(object sender,DetailsViewInsertEventArgs e)
{
for (int i = 0; i < e.Values.Count; i++) {
if (e.Values[i] != null) {
e.Values[i] = Server.HtmlEncode(e.Values[i].ToString()); } } |
DataSource setting
<asp:SqlDataSource ID="Customers" runat="server"
ConnectionString=
"<%$ ConnectionStrings:NorthwindConnectionString %>"
SelectCommand="SELECT [CompanyName], [ContactName], [CustomerID]
FROM [Customers]">
</asp:SqlDataSource>
<asp:SqlDataSource ID="Details"
ConnectionString=
"<%$ ConnectionStrings:NorthwindConnectionString %>"
runat="server"
SelectCommand="SELECT * FROM [Customers]
WHERE ([CustomerID] = @CustomerID)"
InsertCommand="INSERT INTO [Customers] ([CustomerID],
[CompanyName], [ContactName], [ContactTitle], [Address],
[City], [Region], [PostalCode], [Country], [Phone], [Fax])
VALUES (@CustomerID, @CompanyName, @ContactName, @ContactTitle,
@Address, @City, @Region, @PostalCode, @Country, @Phone, @Fax)"
UpdateCommand="UPDATE [Customers] SET [CompanyName] = @CompanyName,
[ContactName] = @ContactName, [ContactTitle] = @ContactTitle,
[Address] = @Address, [City] = @City, [Region] = @Region,
[PostalCode] = @PostalCode, [Country] = @Country,
[Phone] = @Phone, [Fax] = @Fax
WHERE [CustomerID] = @CustomerID"> |
Try Server Intellect for Windows Server Hosting. Quality and Quantity!
Looking for the VB.NET 2005 Version? Click Here!
Looking for more ASP.NET Tutorials? Click Here!