Hi
I declare the code in console is below .this is used for gridview binding, new row data insert,edit, update, delete.
I need to validate all the footer row textboxs when i click the insert button by using JavaScript.
I dont have any idea in JavaScript.
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;
using System.Web.Configuration;
using System;
public partial class _Default : System.Web.UI.Page
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["empDBConnectionString"].ConnectionString);
protected void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
GridFill();
}
}
protected void GridFill()
{
try
{
con.Open();
SqlCommand cmd = new SqlCommand("Select * from emp", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
if (ds.Tables[0].Rows.Count > 0)
{
GridView1.DataSource = ds;
GridView1.DataBind();
}
else
{
ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
GridView1.DataSource = ds;
GridView1.DataBind();
int columncount = GridView1.Rows[0].Cells.Count;
GridView1.Rows[0].Cells.Clear();
GridView1.Rows[0].Cells.Add(new TableCell());
GridView1.Rows[0].Cells[0].ColumnSpan = columncount;
GridView1.Rows[0].Cells[0].Text = "No Records Found";
}
}
catch
{
}
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("Insert"))
{
try
{
TextBox txtname = GridView1.FooterRow.FindControl("txtempname1") as TextBox;
TextBox txtage = GridView1.FooterRow.FindControl("txtempage1") as TextBox;
TextBox txtEmail = GridView1.FooterRow.FindControl("txtempemail1") as TextBox;
DropDownList ddlgender = GridView1.FooterRow.FindControl("ddlempgender1") as DropDownList;
SqlCommand cmd = new SqlCommand("insert into emp values(@empname,@empage,@empemail,@empgender)", con);
cmd.Parameters.Add("@empname", SqlDbType.VarChar).Value = txtname.Text;
cmd.Parameters.Add("@empage", SqlDbType.VarChar).Value = txtage.Text;
cmd.Parameters.Add("@empemail", SqlDbType.VarChar).Value = txtEmail.Text;
cmd.Parameters.Add("@empgender", SqlDbType.VarChar).Value = Convert.ToString(ddlgender.Text);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
GridFill();
}
catch
{
}
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Label lblempid1 = GridView1.Rows[e.RowIndex].FindControl("lblempid") as Label;
TextBox txtname = GridView1.Rows[e.RowIndex].FindControl("txtempname") as TextBox;
TextBox txtage = GridView1.Rows[e.RowIndex].FindControl("txtempage") as TextBox;
TextBox txtEmail = GridView1.Rows[e.RowIndex].FindControl("txtempemail") as TextBox;
DropDownList ddlgender = GridView1.Rows[e.RowIndex].FindControl("ddlempgender") as DropDownList;
SqlCommand cmd = new SqlCommand("update emp set empname='" + txtname.Text + "',empage='" + txtage.Text + "',empemail='" + txtEmail.Text + "',empgender='" + ddlgender.SelectedValue + "' where empid='" + lblempid1.Text + "'", con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
GridView1.EditIndex = -1;
GridFill();
Response.Write("Row Updated");
}
protected void GridView1_RowDeleting1(object sender, GridViewDeleteEventArgs e)
{
int empid = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value);
SqlCommand cmd = new SqlCommand("DELETE FROM emp WHERE EMPID=" + empid + "", con);
con.Open();
int temp = cmd.ExecuteNonQuery();
if (temp == 1)
{
Response.Write("Row Deleted");
}
con.Close();
GridFill();
}
protected void GridView1_RowCancelingEdit1(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
GridFill();
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
GridFill();
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
string sValue = ((HiddenField)GridView1.SelectedRow.Cells[0].FindControl("HiddenField1")).Value;
GridFill();
Response.Write("Product Id=" + sValue);
}
protected void Button1_Click(object sender, EventArgs e)
{
Response.Redirect("empdetails.aspx");
}
protected void GridView1_PreRender(object sender, EventArgs e)
{
ClientScriptManager cs = Page.ClientScript;
TextBox lblempid = (TextBox)GridView1.FooterRow.FindControl("lblempid");
TextBox txtempname = (TextBox)GridView1.FooterRow.FindControl("txtempname1");
TextBox txtempage = (TextBox)GridView1.FooterRow.FindControl("txtempage1");
TextBox txtempemail = (TextBox)GridView1.FooterRow.FindControl("txtempemail1");
cs.RegisterArrayDeclaration("grd_vb", string.Concat("'", lblempid.ClientID, "'"));
cs.RegisterArrayDeclaration("grdName_Txt", String.Concat("'", txtempname.ClientID, "'"));
cs.RegisterArrayDeclaration("grdAge_Int", String.Concat("'", txtempage.ClientID, "'"));
cs.RegisterArrayDeclaration("grdEmail_Txt", String.Concat("'", txtempemail.ClientID, "'"));
}
}
I need to validate all the footer row textbox when i click the insert button using javascript. What could I do. Any one kindly assist me.
Thanks