Hi Provide me a code for form Fill Stage 1 : First name , last name , middle nam

Question

Hi

Provide me a code for form Fill

Stage 1 :

First name , last name , middle name .. .. .. first name , last name ... .. required field validation using JS

Gender via radio buttons

country , state , city ... selection under drop down list or comboboxes your wish ...

Possible apply some styles to form uisng css &HTML .

Stage 2 :

Display inserted data under gridview and i need to have  a provison to edit data just under textboxes ... i want edit , delete , update .

First do the fallowing later in case if i need anything i will provide you the extensions ..

Efficient & Quick answer gets the marks .. Its very urgent to me ..

Please dont copy from internet ----> Your are welcome to share your pre-developed code just in-case done ..

Min 4 star rating depends upon code effectivity ..

Regards

Sunil G

Explanation / Answer

In Html place this JS which in HTML

<script>

function onEnter(_input)

{

_input.style.backgroundColor = "yellow";

}

function onLeave(_input)

{

_input.style.backgroundColor = "";

var check = _input.value.trim();

if (check.length < 3)

{

_input.focus();

}

}

  

</script>

<asp:TextBox ID="TextBox1" runat="server"

onblur="onLeave(this)" BackColor="#99FFCC" ></asp:TextBox>

<asp:TextBox ID="TextBox3" runat="server"

CODE.CS ::

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using System.Configuration;

using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page

{

SqlDataAdapter da; SqlCommandBuilder cb; DataSet ds;

private SqlConnection con = new SqlConnection("Data Source=SIVA-PC;Initial Catalog=formdb;User ID=sa;Password=123");

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

//TextBox1.Attributes.Add("OnBlur", "CheckNullOrEmpty1()"); Long way but flexible..... and for js code look sown ....

//TextBox3.Attributes.Add("OnBlur", "CheckNullOrEmpty3()");

DDLCOUNTRY();

}

}

public void DDLCOUNTRY()

{

con.Open();

SqlCommand cmd = new SqlCommand("select county,countryid from country", con);

SqlDataReader dr = cmd.ExecuteReader();

DropDownList1.DataSource = dr;

DropDownList1.Items.Clear();

DropDownList1.Items.Add("---please select country---");

DropDownList1.DataTextField = "county";

DropDownList1.DataValueField = "countryid";

DropDownList1.DataBind();

con.Close();

}

public void DDLSTATE()

{

con.Open();

SqlCommand cmd = new SqlCommand();

cmd.CommandText = "select state,stateid from countrystate where countryid=" + DropDownList1.SelectedValue;

cmd.Connection = con;

SqlDataReader dr = cmd.ExecuteReader();

DropDownList2.DataSource = dr;

DropDownList2.Items.Clear();

DropDownList2.Items.Add("---please select state---");

DropDownList2.DataTextField = "state";

DropDownList2.DataValueField = "stateid";

DropDownList2.DataBind();

con.Close();

}

public void DDLCITY()

{

con.Open();

SqlCommand cmd = new SqlCommand();

cmd.CommandText = "select state from statecity where stateid=" + DropDownList2.SelectedValue;

cmd.Connection = con;

SqlDataReader dr = cmd.ExecuteReader();

DropDownList3.DataSource = dr;

DropDownList3.Items.Clear();

DropDownList3.Items.Add("---please select city---");

DropDownList3.DataTextField = "state";

DropDownList3.DataBind();

con.Close();

}

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)

{

DDLSTATE();

}

protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)

{

DDLCITY();

}

/*select gender */

public void select_gender()

{

if (RadioButton1.Checked)

{

Label9.Text = "Male";

}

else if (RadioButton2.Checked)

{

Label9.Text = "Female";

}

}

public void adding_dataset()

{

ds = new DataSet();

da = new SqlDataAdapter("select * from formtable", con);

da.Fill(ds, "sunil");

/* Inserting to dataset by creating a row */

DataRow dr = ds.Tables[0].NewRow();

dr[0] = TextBox1.Text;

dr[1] = TextBox2.Text;

dr[2] = TextBox3.Text;

dr[3] = Label9.Text;

dr[4] = DropDownList1.SelectedItem.ToString();

dr[5] = DropDownList2.SelectedItem.ToString();

dr[6] = DropDownList3.SelectedItem.ToString();

ds.Tables[0].Rows.Add(dr);

/* updating to database */

cb = new SqlCommandBuilder(da);

da.Update(ds, "sunil");

}

protected void Button1_Click(object sender, EventArgs e)

{

select_gender();

adding_dataset();

}

protected void display_grid()

{

da = new SqlDataAdapter("select * from formtable", con);

ds = new DataSet();

da.Fill(ds, "ccc");

GridView1.DataSource = ds.Tables[0];

GridView1.DataBind();

}

protected void Button2_Click(object sender, EventArgs e)

{

ds = null;

display_grid();

}

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

{

GridView1.EditIndex = e.NewEditIndex;

display_grid();

}

protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

{

GridView1.EditIndex = -1;

display_grid();

}

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)

{

int index = GridView1.EditIndex;

TextBox firstname = (TextBox)GridView1.Rows[index].Cells[2].Controls[0];

TextBox middlename = (TextBox)GridView1.Rows[index].Cells[3].Controls[0];

TextBox lastname = (TextBox)GridView1.Rows[index].Cells[4].Controls[0];

TextBox gender = (TextBox)GridView1.Rows[index].Cells[5].Controls[0];

string fn = firstname.Text;

string mn = middlename.Text;

string ln = lastname.Text;

string gen = gender.Text;

con.Open();

string str = string.Format("update formtable set gender='{0}' , lastname='{1}' , middlename='{2}' where firstname='{3}' ", gen, ln, mn, fn);

SqlCommand cmd = new SqlCommand(str, con);

cmd.ExecuteNonQuery();

con.Close();

GridView1.EditIndex = -1;

display_grid();

}

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

string fn = GridView1.Rows[e.RowIndex].Cells[2].Text;

con.Open();

string str = string.Format("delete from formtable where firstname='{0}' ", fn);

SqlCommand cmd = new SqlCommand(str, con);

cmd.ExecuteNonQuery();

con.Close();

GridView1.EditIndex = -1;

display_grid();

}

/* <script type="text/javascript">

function CheckNullOrEmpty1()

{

var inputText = document.getElementById("TextBox1").value;

var textLength = inputText.length;

if (textLength == 0)

{

alert("*** Manditoray field cannot be left empty ***");

document.getElementById("TextBox1").background = "#800000"; //change it to right color code

document.getElementById("TextBox1").focus();

}

}

function CheckNullOrEmpty3() {

var inputText = document.getElementById("TextBox3").value;

var textLength = inputText.length;

if (textLength == 0) {

alert("*** Manditoray field cannot be left empty ***");

document.getElementById("TextBox3").background = "#800000"; //change it to right color code

document.getElementById("TextBox3").focus();

}

}

</script>

  

*/

}

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.