Example for formview control by using SqlDataSource.

Question

Can anyone explain the Formview control?with example by using sqlDatasource ?

Satyapriya Nayak · Answer

Hi Deepika, Please refer the below links http://www.dotnetfunda.com/tutorials/controls/formview.aspx http://www.beansoftware.com/ASP.NET-Tutorials/FormView-Control.aspx Thanks If this post helps you mark it as answer

Rajkamal S · Answer

Default.aspx code Untitled Page 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"> forecolor="#999966"/> Employee ID: First Name: Last Name: Address: Designation: Text="Edit" CommandName="Edit" RunAt="server"/>   Text="New" CommandName="New" RunAt="server"/>   Text="Delete" CommandName="Delete" RunAt="server"/> Employee ID: Text=' ' RunAt="Server" /> First Name: Text=' ' RunAt="Server" /> Last Name: Text=' ' RunAt="Server" /> Address: Text=' ' RunAt="Server" /> Designation: Text=' ' RunAt="Server" /> Text="Update" CommandName="Update" RunAt="server"/>   Text="Cancel" CommandName="Cancel" RunAt="server"/> Employee ID: Text=' ' RunAt="Server" /> First Name: Text=' ' RunAt="Server" /> Last Name: Text=' ' RunAt="Server" /> Address: Text=' ' RunAt="Server" /> Designation: Text=' ' RunAt="Server" /> Text="Insert" CommandName="Insert" RunAt="server"/>   Text="Cancel" CommandName="Cancel" RunAt="server"/> 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(); } }

Example for formview control by using SqlDataSource.

Answers (2)