{"id":191,"date":"2010-05-18T19:21:06","date_gmt":"2010-05-18T13:51:06","guid":{"rendered":"http:\/\/JitendraZaa.com\/blog\/?p=191"},"modified":"2010-05-18T19:21:06","modified_gmt":"2010-05-18T13:51:06","slug":"datagrid-example-part-1","status":"publish","type":"post","link":"https:\/\/www.jitendrazaa.com\/blog\/microsoft\/net\/datagrid-example-part-1\/","title":{"rendered":"DataGrid Example – Part 1"},"content":{"rendered":"

For the basics of DataGrid please refer this post: https:\/\/jitendrazaa.com\/blog\/?p=188<\/a><\/p>\n

In this example, i will explain the basics of DataGrid control like Theming, Databinding etc.<\/p>\n

We will start our example with creating the SQL Express database of Employee which will contain the following fields : Id, FName, LName, Email.<\/p>\n

\"\"<\/a><\/p>\n

Now create a stored procedure to insert the data into Table.<\/p>\n

\nCREATE PROCEDURE dbo.AddEmployee\n@FName varchar(50),\n@LName varchar(50),\n@Email varchar(50)\nAS\nINSERT INTO Employee (FName,LName,Email) values (@FName,@LName,@Email)\n<\/pre>\n
\"\"<\/a><\/p>\n
In ASPX page, write the code to input the Employee information.<\/p>\n
\nFirst Name : <asp:TextBox ID="txtFName" runat="server"\/><br \/>\nLast Name :<asp:TextBox ID="txtLName" runat="server"\/><br \/>\nEmail :<asp:TextBox ID="txtEmail"; runat="server"\/><br \/>\n<asp:Button ID="btnSubmit" Text="Add Record" runat="server" OnClick="btnSubmit_Click"\/>\n<\/pre>\n
Go to the property of Employee.mdf<\/strong> and select connection string as shown in below image.<\/p>\n
\"\"<\/a><\/pre>\n
On the click event of the button write below function:<\/p>\n
\nstring conString = @"Data Source=.SQLEXPRESS;AttachDbFilename=""|DataDirectory|Employee.mdf"";Integrated Security=True;User Instance=True";\nprotected void btnSubmit_Click(object sender, EventArgs e)\n{\nSqlConnection con = null;\nSqlCommand cmd = null;\ntry\u00a0{\ncon = new SqlConnection(conString);\n     con.Open();\n     cmd = new SqlCommand("AddEmployee", con);\n     cmd.CommandType = CommandType.StoredProcedure;\n     cmd.Parameters.AddWithValue("@FName", txtFName.Text);\n     cmd.Parameters.AddWithValue("@LName", txtLName.Text);\n     cmd.Parameters.AddWithValue("@Email", txtEmail.Text);\n     cmd.ExecuteNonQuery();\n     showConfirmationMessage();\n}\ncatch (CustomException ex)\u00a0{\nex.logException();\n}finally{\n    con.Close();\n}\n}\n private void showConfirmationMessage()\n{\n      ClientScriptManager csMngr = Page.ClientScript;\n      csMngr.RegisterStartupScript(Page.GetType(), "Success", "alert('Record Added succesfully');", true);\n}\n<\/pre>\n
 ASPX Code for data grid<\/strong><\/p>\n
\n
\n<asp:DataGrid ID="grdEmp" runat="server">\n<HeaderStyle CssClass="Header" \/>\n<AlternatingItemStyle CssClass="AlternateItemStyle" \/>\n<\/asp:DataGrid>\n<\/pre>\n<\/div>\n
Write below code to bind the data into DataGrid.<\/p>\n
\nprivate void bindData()\n{\nSqlConnection con = null;\nSqlDataAdapter adp = null;\ntry\n{\ncon = new SqlConnection(conString);\ncon.Open();\nadp = new SqlDataAdapter("Select * from Employee",con);\nDataSet ds = new DataSet();\nadp.Fill(ds);\ngrdEmp.DataSource = ds;\ngrdEmp.DataBind();\n}\ncatch (CustomException ex)\n{\nex.logException();\n}finally{\ncon.Close();\n}\n}\n<\/pre>\n
Final output:<\/strong>
\n\"\"<\/a><\/p>\n
<\/a>Download Code<\/a>
\n<\/span><\/span><\/h1>\n","protected":false},"excerpt":{"rendered":"
For the basics of DataGrid please refer this post: https:\/\/jitendrazaa.com\/blog\/?p=188 In this example, i will explain the basics of DataGrid control like Theming, Databinding etc. We will start our example with creating the SQL Express database of Employee which will contain the following fields : Id, FName, LName, Email. Now create a stored procedure to […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"jz_research_post":"","_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[21],"tags":[43,71],"class_list":["post-191","post","type-post","status-publish","format-standard","hentry","category-net","tag-asp-net","tag-datagrid"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":1376,"url":"https:\/\/www.jitendrazaa.com\/blog\/sql\/sqlserver\/use-of-openxml-in-sql-server\/","url_meta":{"origin":191,"position":0},"title":"Use of OPENXML in SQL Server","author":"Jitendra","date":"December 4, 2010","format":false,"excerpt":"In SQL Server, OpenXML is very powerful method for the XML data manipulation. This article shows that how to use the OpenXML for XML string.","rel":"","context":"In "SQL Server"","block_context":{"text":"SQL Server","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/sql\/sqlserver\/"},"img":{"alt_text":"OpenXML in SQL Server","src":"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2010\/12\/OpenXML-in-SQL-Server.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":2861,"url":"https:\/\/www.jitendrazaa.com\/blog\/sql\/pagination-and-switch-case-in-where-clause-sql-server\/","url_meta":{"origin":191,"position":1},"title":"Pagination and Switch Case in Where clause – SQL Server","author":"Jitendra","date":"May 19, 2012","format":false,"excerpt":"Example of using pagination and switch case in where clause in SQL server","rel":"","context":"In "SQL"","block_context":{"text":"SQL","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/sql\/"},"img":{"alt_text":"SQL Server Employee Table","src":"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2012\/05\/SQL-Server-Employee-Table.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":936,"url":"https:\/\/www.jitendrazaa.com\/blog\/java\/jdbc-example-with-microsoft-access-in-swing\/","url_meta":{"origin":191,"position":2},"title":"JDBC Example with Microsoft Access in Swing, Next and Previous navigation","author":"Jitendra","date":"August 31, 2010","format":false,"excerpt":"JDBC - Java Database Connectivity example in Swing","rel":"","context":"In "JAVA"","block_context":{"text":"JAVA","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/java\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2281,"url":"https:\/\/www.jitendrazaa.com\/blog\/webtech\/web\/disable-inputs-after-submit-to-avoid-double-submission-using-jquery-and-ajax\/","url_meta":{"origin":191,"position":3},"title":"Disable inputs after submit to avoid double submission using JQuery and Ajax","author":"Jitendra","date":"June 24, 2011","format":false,"excerpt":"This article will explain the safe way to submit the forms using JQuery. It will avoid accidental double submission.","rel":"","context":"In "HTML"","block_context":{"text":"HTML","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/webtech\/web\/"},"img":{"alt_text":"Disable inputs after submit to avoid double submission using JQuery","src":"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2011\/06\/Disable-inputs-after-submit-to-avoid-double-submission-using-JQuery.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":5882,"url":"https:\/\/www.jitendrazaa.com\/blog\/sql\/sqlserver\/sql-server-read-all-files-in-directory-and-store-in-table\/","url_meta":{"origin":191,"position":4},"title":"SQL Server – Read all files in directory and store in Table","author":"Jitendra","date":"January 18, 2017","format":false,"excerpt":"T-SQL Script to read all files in directory and store back in table - SQL Server","rel":"","context":"In "SQL Server"","block_context":{"text":"SQL Server","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/sql\/sqlserver\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2347,"url":"https:\/\/www.jitendrazaa.com\/blog\/java\/hibernate\/step-by-step-hibernate-tutorial-using-eclipse-wtp\/","url_meta":{"origin":191,"position":5},"title":"Step By Step Hibernate Tutorial Using eclipse WTP","author":"Jitendra","date":"August 8, 2011","format":false,"excerpt":"Step By Step Hibernate (ORM Tool) Tutorial Using eclipse WTP","rel":"","context":"In "Hibernate"","block_context":{"text":"Hibernate","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/java\/hibernate\/"},"img":{"alt_text":"Eclipse Install New Software - Hibernate","src":"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2011\/08\/Eclipse-Install-New-Software-Hibernate.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/191","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/comments?post=191"}],"version-history":[{"count":0,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/191\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/media?parent=191"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/categories?post=191"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/tags?post=191"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}