Insert data in database using 3 Tier Architecture .In this article i am explaining you how to insert record in database using 3-Tier Architecture.You can create separate project for Business and data access layer or also can keep in App_code folder.This is aspx.cs code.Here code communicate through Business Layer.protected void btnSubmit_Click(object...
Friday, April 24, 2009
Thursday, April 16, 2009
Export Gridview to Excel and PDF file using asp.net and c#
In this article i am explaining you how to display report using aspx page.Exporting Gridview to excel and PDF report is one of the most common requirement in real world.So i have written this code,you can customize ConvertDataInPdf method according to your requirement.aspx code.<asp:GridView ID="GridView1" runat="server" EnableTheming="False" OnRowDataBound="GridView1_RowDataBound"Width="100%">...
Find tables that contain a certain field in database
Some times user need to get information about a table field,means how many table contains this field. A table field eg 'xyz' have relationship with many table and you want to see all table.Write below query.select * from information_schema.columns where column_name = 'xyz'Thanks & RegardsSant...
