How to use controls ?

Question

what is the use of datalist detailviewlistview and formview?

Rajkamal S · Answer

what is the use triggers and indexes ? how to use with example?

Rajkamal S · Answer

m nice thank u .

Satyapriya Nayak · Answer

For Formview Normal 0 Default.aspx code @ Page Language =C# AutoEventWireup =true CodeFile =Default.aspx.cs Inherits =_Default %> DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd> html xmlns =http://www.w3.org/1999/xhtml> head runat =server> title > Untitled Page title > head > body > form id =form1 runat =server> div > div > asp : FormView ID =EmployeeFormView DataKeyNames =EmployeeID Gridlines =Both AllowPaging =true RunAt =server onitemdeleting =EmployeeFormView_ItemDeleting onpageindexchanging =EmployeeFormView_PageIndexChanging onitemupdating =EmployeeFormView_ItemUpdating oniteminserted =EmployeeFormView_ItemInserted oniteminserting =EmployeeFormView_ItemInserting onitemupdated =EmployeeFormView_ItemUpdated onmodechanging =EmployeeFormView_ModeChanging BackColor =#FFFF66 BorderColor =#FF8080> HeaderStyle backcolor =Navy forecolor =#999966/> RowStyle backcolor =White ForeColor =#CC3300/> EditRowStyle backcolor =#66FF99 ForeColor =#FF9966/> ItemTemplate > table > tr > td align =right> b > Employee ID: b > td > td > # Eval( EmployeeID ) %> td > tr > tr > td align =right> b > First Name: b > td > td > # Eval( FirstName ) %> td > tr > tr > td align =right> b > Last Name: b > td > td > # Eval( LastName ) %> td > tr > tr > td align =right> b > Address: b > td > td > # Eval( Address ) %> td > tr > tr > td align =right> b > Designation: b > td > td > # Eval( Designation ) %> td > tr > tr > td colspan =2> asp : LinkButton ID =EditButton Text =Edit CommandName =Edit RunAt =server/>   asp : LinkButton ID =NewButton Text =New CommandName =New RunAt =server/>   asp : LinkButton ID =DeleteButton Text =Delete CommandName =Delete RunAt =server/> td > tr > table > ItemTemplate > EditItemTemplate > table > tr > td align =right> b > Employee ID: b > td > td > asp : TextBox ID =txtEmployeeID2 Text =' # Bind(EmployeeID) %> ' RunAt =Server /> td > tr > tr > td align =right> b > First Name: b > td > td > asp : TextBox ID =txtFirstName2 Text =' # Bind(FirstName) %> ' RunAt =Server /> td > tr > tr > td align =right> b > Last Name: b > td > td > asp : TextBox ID =txtLastName2 Text =' # Bind(LastName) %> ' RunAt =Server /> td > tr > tr > td align =right> b > Address: b > td > td > asp : TextBox ID =txtAddress2 Text =' # Bind(Address) %> ' RunAt =Server /> td > tr > tr > td align =right> b > Designation: b > td > td > asp : TextBox ID =txtDesignation2 Text =' # Bind(Designation) %> ' RunAt =Server /> td > tr > tr > td colspan =2> asp : LinkButton ID =UpdateButton Text =Update CommandName =Update RunAt =server/>   asp : LinkButton ID =CancelUpdateButton Text =Cancel CommandName =Cancel RunAt =server/> td > tr > table > EditItemTemplate > InsertItemTemplate > table > tr > td align =right> b > Employee ID: b > td > td > asp : TextBox ID =txtEmployeeID1 Text =' # Bind(EmployeeID) %> ' RunAt =Server /> td > tr > tr > td align =right> b > First Name: b > td > td > asp : TextBox ID =txtFirstName1 Text =' # Bind(FirstName) %> ' RunAt =Server /> td > tr > tr > td align =right> b > Last Name: b > td > td > asp : TextBox ID =txtLastName1 Text =' # Bind(LastName) %> ' RunAt =Server /> td > tr > tr > td align =right> b > Address: b > td > td > asp : TextBox ID =txtAddress1 Text =' # Bind(Address) %> ' RunAt =Server /> td > tr > tr > td align =right> b > Designation: b > td > td > asp : TextBox ID =txtDesignation1 Text =' # Bind(Designation) %> ' RunAt =Server /> td > tr > tr > td colspan =2> asp : LinkButton ID =InsertButton Text =Insert CommandName =Insert RunAt =server/>   asp : LinkButton ID =CancelInsertButton Text =Cancel CommandName =Cancel RunAt =server/> td > tr > table > InsertItemTemplate > asp : FormView > form > body > html > Default.aspx.cs code using System; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class _Default : System.Web.UI. Page { string connStr = ConfigurationManager .ConnectionStrings[ ConnectionString ].ConnectionString; SqlDataAdapter sqlda = new SqlDataAdapter (); SqlCommand com = new SqlCommand (); DataTable dt; protected void Page_Load( object sender EventArgs e) { if (!IsPostBack) { bindgrid(); } } private void bindgrid() { SqlConnection conn = new SqlConnection (connStr); dt = new DataTable (); com.Connection = conn; com.CommandText = SELECT * FROM Employees ; sqlda = new SqlDataAdapter (com); sqlda.Fill(dt); EmployeeFormView.DataSource = dt; EmployeeFormView.DataBind(); } protected void EmployeeFormView_PageIndexChanging( object sender FormViewPageEventArgs e) { EmployeeFormView.PageIndex = e.NewPageIndex; bindgrid(); } protected void EmployeeFormView_ItemDeleting( object sender FormViewDeleteEventArgs e) { DataKey key = EmployeeFormView.DataKey; SqlConnection conn = new SqlConnection (connStr); com.Connection = conn; com.CommandText = DELETE FROM Employees WHERE EmployeeID=' + key.Value.ToString() + ' ; conn.Open(); com.ExecuteNonQuery(); conn.Close(); Response.Write( Record deleted successfully ); bindgrid(); } protected void EmployeeFormView_ItemUpdating( object sender FormViewUpdateEventArgs e) { DataKey key = EmployeeFormView.DataKey; TextBox txtFirstName = ( TextBox )EmployeeFormView.FindControl( txtFirstName2 ); TextBox txtLastName = ( TextBox )EmployeeFormView.FindControl( txtLastName2 ); TextBox txtAddress = ( TextBox )EmployeeFormView.FindControl( txtAddress2 ); TextBox txtDesignation = ( TextBox )EmployeeFormView.FindControl( txtDesignation2 ); SqlConnection conn = new SqlConnection (connStr); com.Connection = conn; com.CommandText = UPDATE Employees SET FirstName =' + txtFirstName.Text + 'LastName =' + txtLastName.Text + 'Address =' + txtAddress.Text + 'Designation =' + txtDesignation.Text + ' WHERE EmployeeID=' + key.Value.ToString() + ' ; conn.Open(); com.ExecuteNonQuery(); Response.Write( Record updated successfully ); bindgrid(); conn.Close(); } protected void EmployeeFormView_ModeChanging( object sender FormViewModeEventArgs e) { EmployeeFormView.ChangeMode(e.NewMode); bindgrid(); if (e.NewMode == FormViewMode .Edit) { EmployeeFormView.AllowPaging = false ; } else { EmployeeFormView.AllowPaging = true ; } } protected void EmployeeFormView_ItemInserted( object sender FormViewInsertedEventArgs e) { EmployeeFormView.ChangeMode( FormViewMode .ReadOnly); } protected void EmployeeFormView_ItemUpdated( object sender FormViewUpdatedEventArgs e) { EmployeeFormView.ChangeMode( FormViewMode .ReadOnly); } protected void EmployeeFormView_ItemInserting( object sender FormViewInsertEventArgs e) { TextBox txtEmployeeID = ( TextBox )EmployeeFormView.FindControl( txtEmployeeID1 ); TextBox txtFirstName = ( TextBox )EmployeeFormView.FindControl( txtFirstName1 ); TextBox txtLastName = ( TextBox )EmployeeFormView.FindControl( txtLastName1 ); TextBox txtAddress = ( TextBox )EmployeeFormView.FindControl( txtAddress1 ); TextBox txtDesignation = ( TextBox )EmployeeFormView.FindControl( txtDesignation1 ); SqlConnection conn = new SqlConnection (connStr); com.Connection = conn; com.CommandText = INSERT INTO Employees Values(' + txtEmployeeID.Text + '' + txtFirstName.Text + ' ' + txtLastName.Text + ' ' + txtAddress.Text + ' ' + txtDesignation.Text + ') ; conn.Open(); com.ExecuteNonQuery(); Response.Write( Record inserted successfully ); bindgrid(); conn.Close(); } } For Detailsview Untitled Page BackColor=White BorderColor=#CCCCCC BorderStyle=None BorderWidth=1px CellPadding=3> Imports System.Data Imports System.Data.SqlClient Partial Public Class _Default Inherits System.Web.UI.Page Dim strConnString As String = System.Configuration.ConfigurationManager.ConnectionStrings.Item(ConnectionString).ToString() Dim con As New SqlConnection(strConnString) Dim str As String Dim com As SqlCommand Dim sqlda As SqlDataAdapter Dim ds As DataSet Protected Sub Page_Load(ByVal sender As Object ByVal e As System.EventArgs) Handles Me.Load If Not IsPostBack Then bind() End If End Sub Sub bind() con.Open() str = select * from employee com = New SqlCommand(str con) sqlda = New SqlDataAdapter(com) ds = New DataSet sqlda.Fill(ds employee) de1.DataSource = ds de1.DataMember = employee de1.DataBind() con.Close() End Sub End Class Thanks

Satyapriya Nayak · Answer

Hi Rajkamal For Datalist Normal 0 Program Default.aspx code @ Page Language =C# AutoEventWireup =true CodeFile =Default.aspx.cs Inherits =_Default %> DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd> html xmlns =http://www.w3.org/1999/xhtml> head runat =server> title > Untitled Page title > head > body > form id =form1 runat =server> div > table border =1> asp : DataList ID =dl1 runat =server> HeaderTemplate > font color =red> b > Employee Details b > font > HeaderTemplate > itemtemplate > tr > td > font color =Green> b > ID b > font > td > td > font color =Green> b > NAME b > font > td > td > font color =Green> b > SALARY b > font > td > td > font color =Green> b > ADDRESS b > font > td > td > font color =Green> b > DESIGNATION b > font > td > tr > tr > td > font color =#ff8000> b > # Eval( empid ) %> b > font > td > td > font color =Fuchsia> b > # Eval( empname ) %> b > font > td > td > font color =#663300> b > # Eval( empsal ) %> b > font > td > td > font color =Purple> b > # Eval( empadd ) %> b > font > td > td > font color =#808040> b > # Eval( empdes ) %> b > font > td > tr > itemtemplate > asp : DataList > table > table width =100% border =0> tr > td > asp : label id =lbl1 runat =server BackColor =Yellow BorderColor =Yellow Font-Bold =True ForeColor =#FF3300> asp : label > td > tr > tr > td > asp : button id =btnPrevious runat =server text =Previous Width =60px onclick =btnPrevious_Click> asp : button > asp : button id =btnNext runat =server text =Next Width =60px onclick =btnNext_Click> asp : button > td > tr > table > div > form > body > html > Default.aspx.vb code using System; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class _Default : System.Web.UI. Page { string strConnString = ConfigurationManager .ConnectionStrings[ ConnectionString ].ConnectionString; string str ; SqlCommand com; SqlDataAdapter sqlda; DataSet ds; protected void Page_Load( object sender EventArgs e) { if (!IsPostBack) { binddatalist(); } } private void binddatalist() { SqlConnection con = new SqlConnection (strConnString); con.Open(); str = select * from employee ; com = new SqlCommand (str con); sqlda = new SqlDataAdapter (com); ds = new DataSet (); sqlda.Fill(ds employee ); PagedDataSource Pds1 = new PagedDataSource (); Pds1.DataSource = ds.Tables[0].DefaultView; Pds1.AllowPaging = true ; Pds1.PageSize = 3; Pds1.CurrentPageIndex = CurrentPage; lbl1.Text = Showing Page:  + (CurrentPage + 1).ToString() +  of  + Pds1.PageCount.ToString(); btnPrevious.Enabled = !Pds1.IsFirstPage; btnNext.Enabled = !Pds1.IsLastPage; dl1.DataSource = Pds1; dl1.DataBind(); con.Close(); } public int CurrentPage { get { object s1 = this .ViewState[ CurrentPage ]; if (s1 == null ) { return 0; } else { return Convert .ToInt32(s1); } } set { this .ViewState[ CurrentPage ] = value ; } } protected void btnPrevious_Click( object sender EventArgs e) { CurrentPage -= 1; binddatalist(); } protected void btnNext_Click( object sender EventArgs e) { CurrentPage += 1; binddatalist(); } } For listview Normal 0 Code @ Page Language =C# AutoEventWireup =true CodeBehind =Default.aspx.cs Inherits =ListView_in_Asp.net._Default %> DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd> html xmlns =http://www.w3.org/1999/xhtml > head runat =server> title > Untitled Page title > head > body > form id =form1 runat =server> div > asp : ListView ID =ListView1 runat =server> LayoutTemplate > table id =itemPlaceholderContainer border =1> tr > th > EmpID th > th > EmpName th > th > Empaddress th > th > Salary th > tr > tr runat =server ID =itemPlaceholder> tr > table > LayoutTemplate > ItemTemplate > tr > td > asp : Label ID =lblempid runat =server Text =' # Eval(empid) %> ' /> td > td > asp : Label ID =lblempname runat =server Text =' # Eval(empname) %> ' /> td > td > asp : Label ID =lblempaddress runat =server Text =' # Eval(empaddress) %> ' /> td > td > asp : Label ID =lblempsal runat =server Text =' # Eval(empsal) %> ' /> td > tr > ItemTemplate > asp : ListView > div > form > body > html > using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace ListView_in_Asp.net { public partial class _Default : System.Web.UI. Page { string strConnString = ConfigurationManager .ConnectionStrings[ ConnectionString ].ConnectionString; SqlCommand com; SqlDataAdapter sqlda; DataSet ds; string str; protected void Page_Load( object sender EventArgs e) { SqlConnection con = new SqlConnection (strConnString); con.Open(); str = select * from employee ; com = new SqlCommand (str con); sqlda = new SqlDataAdapter (com); ds = new DataSet (); sqlda.Fill(ds employee ); ListView1.DataMember = employee ; ListView1.DataSource = ds; ListView1.DataBind(); con.Close(); } } } Thanks

Rajkamal S · Answer

thank u.I want some example coding and design ..

Rajkamal S · Answer

thank u.I want some example coding and design ..

Satyapriya Nayak · Answer

Hi Rajkamal These controls are used to display data from some data source like database or XML file. Please refer the below link http://www.beansoftware.com/ASP.NET-Tutorials/Repeater-DataList-ListView-GridView.aspx Thanks