Webpart vs. Visual Webpart in SharePoint 2010

Using Visual Web Parts vs. Traditional Web Parts in SharePoint 2010

 Learn about the advantages of using Visual Web Parts and traditional Web Parts in SharePoint 

• Differences between a Web User Control and a Web Part
• Differences between Visual Web Parts and Code-Only Web Parts
• Creating a Code-Only Web Part and a Visual Web Part
• Conclusion
• Additional Resources
  
  http://msdn.microsoft.com/en-us/library/hh857549.aspx

Read and Display SharePoint List Data in Gridview Control

READ AND DISPLAY SHAREPOINT LIST DATA IN GRIDVIEW CONTROL

I have developed a custom web part which reads data from SharePoint List and display in a GridView control by Visual Studio 2010.

In this scenario, I have a list name "Employee" with 4 collumns named Title, Birthday, Male, Position.

Add the following code to the .ascx file

ID="grid" runat="server" AutoGenerateColumns="false">   
       
       
           
              
   

    
Add the following code to the .cs file:

protected void Page_Load(object sender, EventArgs e)
{
            SPWeb web = SPContext.Current.Web;
            SPList list = web.Lists["Employee"];
            SPListItemCollection items = list.Items;
            grid.DataSource = items.GetDataTable();
            grid.DataBind();
}

Add the web part to the Sharepoint page, we have the following result

Hope this helps!