DataList

-
     DataList

Design
Details.aspx

   <div style="padding-top:2em">
            <asp:DataList ID="DataList1" runat="server"  HorizontalAlign="Center" CellPadding="6" CellSpacing="7" RepeatDirection="Horizontal" RepeatColumns="4">
                <ItemTemplate>
                    Image
                      <asp:Image ID="Image" runat="server" Width="281px" Height="184px" ImageUrl='<%# Eval("image") %>' /> <br />
                   Reg Id
                    <asp:Label ID="Reg_Id" runat="server" Text='<%# Eval("Reg_Id") %>' /> <br />

                    Employee Name 
                     <asp:Label ID="Name" runat="server" Text='<%# Eval("Employee_Name") %>' /> <br />
                    ContactNo 
                    <asp:Label ID="Contact" runat="server" Text='<%# Eval("Employee_ContactNo") %>' /> <br />
                    Salary
                         <asp:Label ID="Salary" runat="server" Text='<%# Eval("Employee_Salary") %>' /> <br />
                    Gender
                      <asp:Label ID="Gender" runat="server" Text='<%# Eval("Employee_Gender") %>' /> <br />
                    City
                     <asp:Label ID="City" runat="server" Text='<%# Eval("Employee_City") %>' /> <br />
                    Nationality
                    <asp:Label ID="Natnality" runat="server" Text='<%# Eval("Employee_Nationality") %>' /> <br />
                  
                </ItemTemplate>
            </asp:DataList>
        </div>



Write the below code in Aspx.cs page

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;

namespace CURD_Demo
{
    public partial class Details : System.Web.UI.Page
    {
        SqlConnection con = new SqlConnection();
        SqlCommand cmd = new SqlCommand();
        SqlDataAdapter sda = new SqlDataAdapter();
        DataTable dt = new DataTable();
        DataSet ds1 = new DataSet();
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                con.ConnectionString = "Data Source=(LocalDB)\\v11.0;AttachDbFilename=C:\\Users\\puja.s\\Desktop\\Asp .net Practice\\CURD_Demo\\CURD_Demo\\App_Data\\Database1.mdf;";
                con.Open();
                if (!this.IsPostBack)
                {

                    BindDataList1();

                }
             
            }
            catch (Exception)
            {
                Response.Write("SERVER PROBLEM");
            }
        }

protected void BindDataList1()
         {
cmd.CommandText = "SELECT Employee.EmployeeId, Employee.Employee_Name, Employee.Employee_ContactNo,Employee.Employee_Salary,Employee.Employee_Gender,Employee.Employee_City,Employee.Employee_Nationality,Image.Image, Employee.Reg_Id FROM Employee INNER JOIN Image ON Employee.Image_Id = Image.Image_Id ";
             cmd.Connection = con;
             SqlDataAdapter da = new SqlDataAdapter(cmd);
             da.SelectCommand = cmd;
             DataTable dt = new DataTable();
             da.Fill(dt);
             DataList1.DataSource = dt;
             DataList1.DataBind();
         }
   }
}
Output





Comments

Post a Comment

Popular posts from this blog

Kendo Control(Dynamics)

-
Image
21. Kendo Button:             Write the below code in view                 <div>                     @( Html.Kendo().Button()    .Name( "btnShare" )   .Content( "Share" )   .HtmlAttributes( new  { type =  "button" , @class =  "btn btn-primary" ,      style =  "height:30px; width:120px; border-radius:0;padding: 3px;"  })                        .Events(e => e.Click( "btnShare_Click" ))                  ) </div> <script>      ...
Read more

Override Authorize Filters in MVC

-
Image
Override Authorize Filters in MVC Authorize Filter: It is to limit the access for a user or user specific to the role. Implementation of Override Authorize filters in MVC Step1: Add a controller and named it as HomeController Add [Authorize] attribute before an action or a controller based on the requirement. Suppose user want to restrict the access of particular controller but allow some of action of that controller. So just add [Authorize] before controller                using System; using System.Web.Mvc; using System.Web.Mvc.Filters; namespace WebApplication1.Controllers {     [ Authorize ]     public class HomeController : Controller     {     } } Step 2: Create a class and named it as OverrideAuthorizeAttribute which should inherit AuthorizeAttribute and Implements IOverrideFilter    public ...
Read more

Form Validation

-
Image
How to validate a form using Jquery Write the below code : < form action ="" id ="frmEnquiry" method ="post" novalidate ="novalidate">                 < p class ="your-para"> Your Name : </ p >                 < input type ="text" name ="Name" id ="Name" value ="" onfocus ="this .value= '' ; " onblur ="if ( this .value == '' ) { this .value = '' ;} ">                 < p class ="your-para"> Your Mail : </ p >                 < input type ="text" name ="Email" id ="Email" value ="" onfocus ="this .value= '' ; " onblur ="if ( this .value == '' ) { this .value = '' ;} ">        ...
Read more