Using same form for INSERT and EDIT
-
Hello folks, I have done this in ASP but don't know how to handle it ASP.net. I want to use a single form for inserting data into a table and editing the same record. If the QueryString parameter is true I want to be able to populate the text boxes, dropdowns on the form, have the user edit the data and update the record. Does anyone have examples of this, perhaps a tutorial? Thanks Mike
-
Hello folks, I have done this in ASP but don't know how to handle it ASP.net. I want to use a single form for inserting data into a table and editing the same record. If the QueryString parameter is true I want to be able to populate the text boxes, dropdowns on the form, have the user edit the data and update the record. Does anyone have examples of this, perhaps a tutorial? Thanks Mike
using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Data.SqlClient; using System.Drawing; using System.Web; using System.Web.SessionState; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; using Microsoft.ApplicationBlocks.Data; namespace GAVS.Asset.UI { /// /// Summary description for EditUser. /// public class EditUser : System.Web.UI.Page { protected System.Web.UI.WebControls.CustomValidator customValidator; protected System.Web.UI.WebControls.ValidationSummary vsErrors; protected System.Web.UI.WebControls.Label lblInfo; protected System.Web.UI.HtmlControls.HtmlAnchor lbReports; protected System.Web.UI.HtmlControls.HtmlAnchor lbUsers; protected System.Web.UI.HtmlControls.HtmlAnchor lbCategories; protected System.Web.UI.HtmlControls.HtmlAnchor lbProducts; protected System.Web.UI.HtmlControls.HtmlAnchor lbChangePassword; protected System.Web.UI.HtmlControls.HtmlAnchor lbLogout; protected System.Web.UI.WebControls.TextBox txtUsername; protected System.Web.UI.WebControls.TextBox txtPassword; protected System.Web.UI.WebControls.TextBox txtConfirmPassword; protected System.Web.UI.WebControls.DropDownList ddlRole; protected System.Web.UI.WebControls.TextBox txtEmail; protected System.Web.UI.WebControls.RequiredFieldValidator rfvUsername; protected System.Web.UI.WebControls.RequiredFieldValidator rfvPassword; protected System.Web.UI.WebControls.RequiredFieldValidator rfvConfirmPassword; protected System.Web.UI.WebControls.RequiredFieldValidator rfvRole; protected System.Web.UI.WebControls.RequiredFieldValidator rfvEmail; protected System.Web.UI.WebControls.CompareValidator cvConfirmPassword; protected System.Web.UI.WebControls.RegularExpressionValidator revEmail; protected System.Web.UI.WebControls.Button btnSave; private void Page_Load(object sender, System.EventArgs e) { if (! IsPostBack) { BindData(); } } private void BindData() { int userId = UserId; if (userId != 0) { rfvPassword.Enabled = false; rfvConfirmPassword.Enabled = false; SqlDataReader reader = null; try { reader = SqlHelper.ExecuteReader(Global.ConnectionString, "am_User_Get", userId); if (reader.Read()) { txtUsername.Text = reader["UserName"].ToString(); ddlRole.SelectedValue = reader["Role"].ToString(); txtEmail.Text = reader["Email"].ToString();
-
using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Data.SqlClient; using System.Drawing; using System.Web; using System.Web.SessionState; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; using Microsoft.ApplicationBlocks.Data; namespace GAVS.Asset.UI { /// /// Summary description for EditUser. /// public class EditUser : System.Web.UI.Page { protected System.Web.UI.WebControls.CustomValidator customValidator; protected System.Web.UI.WebControls.ValidationSummary vsErrors; protected System.Web.UI.WebControls.Label lblInfo; protected System.Web.UI.HtmlControls.HtmlAnchor lbReports; protected System.Web.UI.HtmlControls.HtmlAnchor lbUsers; protected System.Web.UI.HtmlControls.HtmlAnchor lbCategories; protected System.Web.UI.HtmlControls.HtmlAnchor lbProducts; protected System.Web.UI.HtmlControls.HtmlAnchor lbChangePassword; protected System.Web.UI.HtmlControls.HtmlAnchor lbLogout; protected System.Web.UI.WebControls.TextBox txtUsername; protected System.Web.UI.WebControls.TextBox txtPassword; protected System.Web.UI.WebControls.TextBox txtConfirmPassword; protected System.Web.UI.WebControls.DropDownList ddlRole; protected System.Web.UI.WebControls.TextBox txtEmail; protected System.Web.UI.WebControls.RequiredFieldValidator rfvUsername; protected System.Web.UI.WebControls.RequiredFieldValidator rfvPassword; protected System.Web.UI.WebControls.RequiredFieldValidator rfvConfirmPassword; protected System.Web.UI.WebControls.RequiredFieldValidator rfvRole; protected System.Web.UI.WebControls.RequiredFieldValidator rfvEmail; protected System.Web.UI.WebControls.CompareValidator cvConfirmPassword; protected System.Web.UI.WebControls.RegularExpressionValidator revEmail; protected System.Web.UI.WebControls.Button btnSave; private void Page_Load(object sender, System.EventArgs e) { if (! IsPostBack) { BindData(); } } private void BindData() { int userId = UserId; if (userId != 0) { rfvPassword.Enabled = false; rfvConfirmPassword.Enabled = false; SqlDataReader reader = null; try { reader = SqlHelper.ExecuteReader(Global.ConnectionString, "am_User_Get", userId); if (reader.Read()) { txtUsername.Text = reader["UserName"].ToString(); ddlRole.SelectedValue = reader["Role"].ToString(); txtEmail.Text = reader["Email"].ToString();
Syed Appreciate if you would have put only that section of the code snippet into the message instead of the entire VS.NET View: Select All, Copy and Paste. :) :) Vasudevan Deepak Kumar Personal Web: http://vdeepakkumar.netfirms.com/ I Blog At: http://deepak.blogdrive.com/
-
using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Data.SqlClient; using System.Drawing; using System.Web; using System.Web.SessionState; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; using Microsoft.ApplicationBlocks.Data; namespace GAVS.Asset.UI { /// /// Summary description for EditUser. /// public class EditUser : System.Web.UI.Page { protected System.Web.UI.WebControls.CustomValidator customValidator; protected System.Web.UI.WebControls.ValidationSummary vsErrors; protected System.Web.UI.WebControls.Label lblInfo; protected System.Web.UI.HtmlControls.HtmlAnchor lbReports; protected System.Web.UI.HtmlControls.HtmlAnchor lbUsers; protected System.Web.UI.HtmlControls.HtmlAnchor lbCategories; protected System.Web.UI.HtmlControls.HtmlAnchor lbProducts; protected System.Web.UI.HtmlControls.HtmlAnchor lbChangePassword; protected System.Web.UI.HtmlControls.HtmlAnchor lbLogout; protected System.Web.UI.WebControls.TextBox txtUsername; protected System.Web.UI.WebControls.TextBox txtPassword; protected System.Web.UI.WebControls.TextBox txtConfirmPassword; protected System.Web.UI.WebControls.DropDownList ddlRole; protected System.Web.UI.WebControls.TextBox txtEmail; protected System.Web.UI.WebControls.RequiredFieldValidator rfvUsername; protected System.Web.UI.WebControls.RequiredFieldValidator rfvPassword; protected System.Web.UI.WebControls.RequiredFieldValidator rfvConfirmPassword; protected System.Web.UI.WebControls.RequiredFieldValidator rfvRole; protected System.Web.UI.WebControls.RequiredFieldValidator rfvEmail; protected System.Web.UI.WebControls.CompareValidator cvConfirmPassword; protected System.Web.UI.WebControls.RegularExpressionValidator revEmail; protected System.Web.UI.WebControls.Button btnSave; private void Page_Load(object sender, System.EventArgs e) { if (! IsPostBack) { BindData(); } } private void BindData() { int userId = UserId; if (userId != 0) { rfvPassword.Enabled = false; rfvConfirmPassword.Enabled = false; SqlDataReader reader = null; try { reader = SqlHelper.ExecuteReader(Global.ConnectionString, "am_User_Get", userId); if (reader.Read()) { txtUsername.Text = reader["UserName"].ToString(); ddlRole.SelectedValue = reader["Role"].ToString(); txtEmail.Text = reader["Email"].ToString();