{"id":128494,"date":"2023-05-08T10:24:30","date_gmt":"2023-05-08T04:54:30","guid":{"rendered":"https:\/\/www.vskills.in\/certification\/tutorial\/?page_id=128494"},"modified":"2024-04-12T14:15:26","modified_gmt":"2024-04-12T08:45:26","slug":"adding-records-with-insertitemtemplate","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/adding-records-with-insertitemtemplate\/","title":{"rendered":"Adding Records with InsertItemTemplate"},"content":{"rendered":"\n

Adding Records with InsertItemTemplate<\/strong><\/h4>\n\n\n\n

The InsertItemTemplate of the ListView control is used to define the layout of the form that allows users to add new records to the underlying data source.<\/p>\n\n\n\n

To add records with the InsertItemTemplate of the ListView control, follow these steps:<\/p>\n\n\n\n

Define the InsertItemTemplate in the markup of the ListView control, which will contain the input controls for the user to enter the data. Here’s an example:<\/p>\n\n\n\n

<asp:ListView ID=”MyListView” runat=”server” DataSourceID=”MyLinqDataSource”><\/p>\n\n\n\n

    <InsertItemTemplate><\/p>\n\n\n\n

        <tr><\/p>\n\n\n\n

            <td><\/p>\n\n\n\n

                <asp:TextBox ID=”ProductNameTextBox” runat=”server” Text='<%# Bind(“ProductName”) %>’ \/><\/p>\n\n\n\n

            <\/td><\/p>\n\n\n\n

            <td><\/p>\n\n\n\n

                <asp:TextBox ID=”UnitPriceTextBox” runat=”server” Text='<%# Bind(“UnitPrice”) %>’ \/><\/p>\n\n\n\n

            <\/td><\/p>\n\n\n\n

            <td><\/p>\n\n\n\n

                <asp:TextBox ID=”UnitsInStockTextBox” runat=”server” Text='<%# Bind(“UnitsInStock”) %>’ \/><\/p>\n\n\n\n

            <\/td><\/p>\n\n\n\n

            <td><\/p>\n\n\n\n

                <asp:Button ID=”InsertButton” runat=”server” CommandName=”Insert” Text=”Insert” \/><\/p>\n\n\n\n

            <\/td><\/p>\n\n\n\n

        <\/tr><\/p>\n\n\n\n

    <\/InsertItemTemplate><\/p>\n\n\n\n

    …<\/p>\n\n\n\n

<\/asp:ListView><\/p>\n\n\n\n

Handle the ItemCommand event of the ListView control, and check if the CommandName property of the ListViewCommandEventArgs parameter is set to “Insert”. If it is, retrieve the values entered by the user from the input controls of the InsertItemTemplate, and insert them into the underlying data source. Here’s an example:<\/p>\n\n\n\n

protected void MyListView_ItemCommand(object sender, ListViewCommandEventArgs e)<\/p>\n\n\n\n

{<\/p>\n\n\n\n

    if (e.CommandName == “Insert”)<\/p>\n\n\n\n

    {<\/p>\n\n\n\n

        TextBox productNameTextBox = (TextBox)e.Item.FindControl(“ProductNameTextBox”);<\/p>\n\n\n\n

        TextBox unitPriceTextBox = (TextBox)e.Item.FindControl(“UnitPriceTextBox”);<\/p>\n\n\n\n

        TextBox unitsInStockTextBox = (TextBox)e.Item.FindControl(“UnitsInStockTextBox”);<\/p>\n\n\n\n

        \/\/ Insert the new record into the data source<\/p>\n\n\n\n

        using (MyDataContext db = new MyDataContext())<\/p>\n\n\n\n

        {<\/p>\n\n\n\n

            Product newProduct = new Product<\/p>\n\n\n\n

            {<\/p>\n\n\n\n

                ProductName = productNameTextBox.Text,<\/p>\n\n\n\n

                UnitPrice = decimal.Parse(unitPriceTextBox.Text),<\/p>\n\n\n\n

                UnitsInStock = short.Parse(unitsInStockTextBox.Text)<\/p>\n\n\n\n

            };<\/p>\n\n\n\n

            db.Products.InsertOnSubmit(newProduct);<\/p>\n\n\n\n

            db.SubmitChanges();<\/p>\n\n\n\n

        }<\/p>\n\n\n\n

    }<\/p>\n\n\n\n

} Note that this is just an example, and you may need to modify it to fit the specifics of your application and data source. Additionally, it’s important to validate the user input and handle any errors that may occur during the insertion process.<\/p>\n\n\n\n

Apply for ASP.NET Certification Now!!<\/h3>\n\n\n\n

https:\/\/www.vskills.in\/certification\/certified-aspnet-programmer<\/a><\/p>\n\n\n\n

Back to Tutorial<\/a><\/strong><\/h4>\n","protected":false},"excerpt":{"rendered":"

Adding Records with InsertItemTemplate The InsertItemTemplate of the ListView control is used to define the layout of the form that allows users to add new records to the underlying data source. To add records with the InsertItemTemplate of the ListView control, follow these steps: Define the InsertItemTemplate in the markup of the ListView control, which…<\/p>\n","protected":false},"author":22,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[3339],"tags":[],"class_list":["post-128494","page","type-page","status-publish","hentry","category-asp-net-2"],"acf":[],"yoast_head":"\nAdding Records with InsertItemTemplate - Tutorial<\/title>\n<meta name=\"description\" content=\"Adding Records with InsertItemTemplate\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.vskills.in\/certification\/tutorial\/adding-records-with-insertitemtemplate\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Adding Records with InsertItemTemplate - Tutorial\" \/>\n<meta property=\"og:description\" content=\"Adding Records with InsertItemTemplate\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/adding-records-with-insertitemtemplate\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutorial\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/vskills.in\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-12T08:45:26+00:00\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/adding-records-with-insertitemtemplate\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/adding-records-with-insertitemtemplate\/\",\"name\":\"Adding Records with InsertItemTemplate - Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"datePublished\":\"2023-05-08T04:54:30+00:00\",\"dateModified\":\"2024-04-12T08:45:26+00:00\",\"description\":\"Adding Records with InsertItemTemplate\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/adding-records-with-insertitemtemplate\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/adding-records-with-insertitemtemplate\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/adding-records-with-insertitemtemplate\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Adding Records with InsertItemTemplate\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"name\":\"Tutorial\",\"description\":\"Vskills - A initiative in elearning and certification\",\"publisher\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\",\"name\":\"Vskills\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"contentUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"width\":73,\"height\":55,\"caption\":\"Vskills\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/vskills.in\/\",\"https:\/\/x.com\/vskills_in\",\"https:\/\/www.linkedin.com\/company-beta\/1371554\/\",\"https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Adding Records with InsertItemTemplate - Tutorial","description":"Adding Records with InsertItemTemplate","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.vskills.in\/certification\/tutorial\/adding-records-with-insertitemtemplate\/","og_locale":"en_US","og_type":"article","og_title":"Adding Records with InsertItemTemplate - Tutorial","og_description":"Adding Records with InsertItemTemplate","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/adding-records-with-insertitemtemplate\/","og_site_name":"Tutorial","article_publisher":"https:\/\/www.facebook.com\/vskills.in\/","article_modified_time":"2024-04-12T08:45:26+00:00","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/adding-records-with-insertitemtemplate\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/adding-records-with-insertitemtemplate\/","name":"Adding Records with InsertItemTemplate - Tutorial","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"datePublished":"2023-05-08T04:54:30+00:00","dateModified":"2024-04-12T08:45:26+00:00","description":"Adding Records with InsertItemTemplate","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/adding-records-with-insertitemtemplate\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/adding-records-with-insertitemtemplate\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/adding-records-with-insertitemtemplate\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Adding Records with InsertItemTemplate"}]},{"@type":"WebSite","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","name":"Tutorial","description":"Vskills - A initiative in elearning and certification","publisher":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization","name":"Vskills","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","contentUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","width":73,"height":55,"caption":"Vskills"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/vskills.in\/","https:\/\/x.com\/vskills_in","https:\/\/www.linkedin.com\/company-beta\/1371554\/","https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw"]}]}},"_links":{"self":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/128494","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/users\/22"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/comments?post=128494"}],"version-history":[{"count":2,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/128494\/revisions"}],"predecessor-version":[{"id":128496,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/128494\/revisions\/128496"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=128494"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=128494"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=128494"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}