tag:blogger.com,1999:blog-88613587334743803482024-03-05T23:27:21.963-08:00Dot Net Spoon FeedingWelcome to My Blog....!
This is the right place to Look out your Solutions.Anonymoushttp://www.blogger.com/profile/12736277943632394967noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-8861358733474380348.post-54909138340534879422013-07-01T05:56:00.001-07:002013-07-01T05:56:35.393-07:00What is Repeater Control in Asp.Net and How to use Repeater control to bind data...?<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Introduction</b><br />Here I will explain you, what is Repeater Control and nhow to use this control to bind data in Asp.Net.<br /><br /><b>Description</b><br />
The Repeater control in ASP.NET
is a data-bound container control that can be used to automate the
display of a collection of repeated list items. These items can be bound
to either of the following data sources:<br />
<ul>
<li>Database Table </li>
<li>XML File </li>
</ul>
In a Repeater control, the data is rendered as DataItems that are
defined using one or more templates. You can even use HTML tags such as
<li>, <ul>, or <div> if required. Similar to the
DataGrid, DataList, or GridView controls, the Repeater control has a <b>DataSource</b> property that is used to set the DataSource of this control to any <b>ICollection</b>, <b>IEnumerable</b>, or <b>IListSource<code></code>
</b>instance. Once this is set, the data from one of these types of data
sources can be easily bound to the Repeater control using its <b>DataBind()</b> <code></code> method.<br />
However, the Repeater control by itself does not support paging or
editing of data. The Repeater control is light weight and does not
contain so many features as the DataGrid contains. However, it enables
you to place HTML code in its templates. It is great in situations where
you need to display the data quickly and format the data to be
displayed easily.....<a href="http://chauhanshekhar.blogspot.in/p/what-is-repeater-control-in-aspnet.html" target="_blank"><b>[Continue]</b></a><br />
<br /></div>
Anonymoushttp://www.blogger.com/profile/12736277943632394967noreply@blogger.com0tag:blogger.com,1999:blog-8861358733474380348.post-46528251445398703132013-06-25T12:58:00.001-07:002013-07-06T01:25:47.971-07:00How to display Master-Detail Data with ModalPopup Extender and GridView<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Introducton</b><br />
Here I will explain how to show Master-detail data using Ajax ModalPopup Extender in GridView Using Asp.Net C#.<br />
<br />
<b>Description</b><br />
In the earlier days , we have often used the combination of <a href="http://code.msdn.microsoft.com/CSASPNETGridView-5b16ce70" target="_blank"><b>GridView </b></a>and <b><a href="http://msdn.microsoft.com/en-us/library/aa479325.aspx" target="_blank">DetailView</a> </b>to
display the Master-Details. Similarly, developers have used pop-ups to
show the similar scenarios where a user clicks on a gridview row and the
details are displayed in a pop-up window. <br />
<br />
Here I am exploring the <b><a href="http://www.asp.net/ajaxLibrary/AjaxControlToolkitSampleSite/ModalPopup/ModalPopup.aspx" target="_blank">ModalPopup</a></b> extender control which allows a page to display contents in a modal manner...<b><a href="http://chauhanshekhar.blogspot.in/p/blog-page_24.html">[Continue]</a></b>
</div>
Anonymoushttp://www.blogger.com/profile/12736277943632394967noreply@blogger.com0tag:blogger.com,1999:blog-8861358733474380348.post-20821643711857201672013-06-24T04:39:00.004-07:002013-07-06T01:26:33.772-07:00How to Show Images into gridview using Asp.Net C#<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: justify;">
<span style="color: #666666;"><b>Introduction</b><br />Here I will explain how to retrieve images from database and shows into GridView using asp.net.<br /><br /><b>Description</b><br />In my earlier post I already explain, how to insert images into database using Asp.net C# in binary format. For more details <a href="http://chauhanshekhar.blogspot.in/2013/06/how-to-upload-images-into-sql-server.html" target="_blank">click</a> here. and how to <a href="http://chauhanshekhar.blogspot.in/p/how-to-show-images-in-gridview-from.html" target="_blank">display images into GridView using HTTPhandler file</a>.<br /><br />I have an table in my database for </span><span style="color: #666666;"><span style="color: #666666;">UserProfile, image path is stored in</span> database table and actual images are stored in project image folder. There are two ways to display images into my gridview. One is using <a href="http://www.youtube.com/watch?v=_hrJQ3D6WTw" target="_blank"><b>TemplateField </b></a>and another one is using <a href="http://www.youtube.com/watch?v=JwNiH6koWAg" target="_blank"><b>ImageField</b></a>.<b> </b>We used both way to demonstrate you.<b>....</b></span><b><a href="http://chauhanshekhar.blogspot.in/p/blog-page_23.html" target="_blank">[Continue]</a></b></div>
</div>
Anonymoushttp://www.blogger.com/profile/12736277943632394967noreply@blogger.com0tag:blogger.com,1999:blog-8861358733474380348.post-45829288967739079282013-06-21T02:15:00.001-07:002013-07-06T01:28:17.296-07:00How to Import data from excel to SQL database using Asp.Net C#<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: #666666;"><b> Introduction</b><br /> Here I will explain how to import data into database from excel work sheet using Asp.Net.<br /><br /><b> Description</b><br /> In my earlier post we explain, how to <a href="http://chauhanshekhar.blogspot.in/p/how-to-export-gridview-data.html" target="_blank">export</a> data from Gridview into different document formats like <a href="http://chauhanshekhar.blogspot.in/p/how-to-export-gridview-data.html" target="_blank">excel</a>, <a href="http://chauhanshekhar.blogspot.in/p/how-to-export-gridview-data.html" target="_blank"><br /><span style="color: #666666;"> </span>word</a> & <a href="http://chauhanshekhar.blogspot.in/p/how-to-export-gridview-data.html" target="_blank">pdf</a>. For more details <a href="http://chauhanshekhar.blogspot.in/p/how-to-export-gridview-data.html" target="_blank">click</a> here.<br /><br /> There are lots of easiest ways available for import data from Excel to SQL server like<br /> 1. Excel itself provide easy options<br /> 2. SQL server has very easy Import/Export option<br /> 3. SQL server has packing option<br /> There are lot of more methods of the same....For read more <a href="http://support.microsoft.com/kb/321686" target="_blank">click</a> here.<br /><br /> Our requirement is to import data into SQL database from excel sheet using Asp.Net C#. For this, we use <br /> <b>OLEDB </b>connection to read data from excel sheet in this post. </span><span style="color: #666666;"> If we have excel in .xls format then we use <i><b><br /> Microsoft.Jet.OLEDB.4.0</b></i> and we have .xlsx format then use <i><b>Microsoft.ACE.OLEDB.12.0</b></i>.....</span><span style="color: #666666;"><b></b></span><b><a href="http://chauhanshekhar.blogspot.in/p/how-to-import-data-from-excel-to-sql.html" target="_blank">[Continue]</a></b>
</div>
Anonymoushttp://www.blogger.com/profile/12736277943632394967noreply@blogger.com1tag:blogger.com,1999:blog-8861358733474380348.post-7846627880794617612013-06-15T13:08:00.002-07:002013-07-06T01:29:19.921-07:00How to Export GridView Data in Excel, Word & PDF format using Asp.Net<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: justify;">
<span style="color: #666666;"><b>Introduction</b><br />Here I will explain how to export gridview data in <a href="http://www.aspsnippets.com/Articles/Export-GridView-To-Word-Excel-PDF-CSV-Formats-in-ASP.Net.aspx" target="_blank">Excel</a>, <a href="http://www.aspsnippets.com/Articles/Export-GridView-To-Word-Excel-PDF-CSV-Formats-in-ASP.Net.aspx" target="_blank">Word</a> & <a href="http://www.aspsnippets.com/Articles/Export-GridView-To-Word-Excel-PDF-CSV-Formats-in-ASP.Net.aspx" target="_blank">PDF</a> file using Asp.Net.<br /><br /><b>Description</b><br />In my earlier post I already explain, how to bind gridview using SqlDatasource. For more details <a href="http://chauhanshekhar.blogspot.in/p/how-to-add-sqldatasource-in.html" target="_blank">click</a> here.<br /><br />Some times we required to export our gridview data in to excel, word or pdf format. Here we see how to export gridview content in excel , word and PDF format using Asp.net C#. as we know we don't have direct feature to export griview in PDF format. So here you see that, we are using third party library <b><a href="http://www.c-sharpcorner.com/UploadFile/f2e803/basic-pdf-creation-using-itextsharp-part-i/" target="_blank">ITextSharp</a> </b>reference. You can download dll from <a href="http://sourceforge.net/projects/itextsharp/files/itextsharp/iTextSharp-5.4.2/" target="_blank">ITextSharp</a> and add that dll reference in you web site.</span><span style="color: #666666;"><b>....</b></span><b><a href="http://chauhanshekhar.blogspot.in/p/how-to-export-gridview-data.html" target="_blank">[Continue]</a></b></div>
</div>
Anonymoushttp://www.blogger.com/profile/12736277943632394967noreply@blogger.com0tag:blogger.com,1999:blog-8861358733474380348.post-36683094141615434972013-06-15T04:21:00.000-07:002013-07-06T01:30:17.452-07:00How to Reterive/Show Images in GridView From SQL server using Handler in Asp.Net<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: justify;">
<span style="color: #666666;"><b>Introduction</b><br />Here I will explain how to retrieve images from database and shows into GridView using asp.net.<br /><br /><b>Description</b><br />In my earlier post I already explain, how to insert images into database using Asp.net C# in binary format. For more details <a href="http://chauhanshekhar.blogspot.in/2013/06/how-to-upload-images-into-sql-server.html" target="_blank">click</a> here.<br /><br />Here we see how to retrieve images from database and display into gidview. As I already told you retrieving binary images from database is easy but displaying is very difficult that's why we will use <b>HTTPHandler</b> to solve this problem.</span><span style="color: #666666;"><b>....</b></span><b><a href="http://chauhanshekhar.blogspot.in/p/how-to-show-images-in-gridview-from.html" target="_blank">[Continue]</a></b></div>
</div>
Anonymoushttp://www.blogger.com/profile/12736277943632394967noreply@blogger.com0tag:blogger.com,1999:blog-8861358733474380348.post-78497905329592575252013-06-13T01:21:00.000-07:002013-07-06T01:31:08.566-07:00How to Insert images into SQL Server from ASP.NET Using C#<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: justify;">
<span style="color: #666666;">
<b>Introduction</b>
<br />
Here I will explain how to insert images into database using asp.net
<br /><br /><b>Description:</b><br />Earlier we save images into directory folder and we save image path into database but better way is to inserting images directly into database and retrieve them from database. Using this, the images are stored in database in binary form. So to retrieve images from database we need handler file, i will explain this later.<br />Here, we see how to insert images into database in binary form using Asp.Net C#.</span><span style="color: #666666;"><b>....</b></span><b><a href="http://chauhanshekhar.blogspot.in/p/blog-page_13.html" target="_blank">[Continue]</a></b></div>
</div>
Anonymoushttp://www.blogger.com/profile/12736277943632394967noreply@blogger.com0