validation comparevalidator FOR BIND TEXTBOX in gridview

I bind the data in textbox in the gridview from the SQL table. in that i gonna edit only one textbox using edit and delete option.

so i gonna edit the valuer in the textbox,its should not greater than old value.i can able to do that in table method,bt nt in gridview.

it should editable as per the user values.its not constant value,it ll change as the username,Id

ex:

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

{

SqlConnection con = new SqlConnection("data source=VAAYUSEVA_SVR;Initial Catalog=cppsch;User ID=sa;Password=sa");

public static string x;

protected void Page_Load(object sender, EventArgs e)

{

if (!Page.IsPostBack)

{

string un = Session["Uname"].ToString();

string q = "select * from TBL_CPPMASTER where [USER NAME]='" + un + "'";

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["cppschConnectionString"].ConnectionString);

con.Open();

SqlCommand cmd = new SqlCommand(q, con);

SqlDataReader dr = cmd.ExecuteReader();

while (dr.Read())

{

txtBigNumber.Text = dr["CPPQUANTUM_C"].ToString();

}

for grid view: btis nt wrking:

AutoGenerateColumns="false" ShowFooter="true" HeaderStyle-Font-Bold="true"

onrowcancelingedit="gridView_RowCancelingEdit" DataKeyNames="Id"

onrowdeleting="gridView_RowDeleting" HeaderStyle-BackColor="#E9E9E9"

onrowediting="gridView_RowEditing"

onrowupdating="gridView_RowUpdating"

onrowcommand="gridView_RowCommand"

OnRowDataBound="gridView_RowDataBound" style="margin-left: 0px" >

please help me...i need exact code.....

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kamala Veni10y ago

using System.Text;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
namespace opgcpp.Generator.Forms
{
public partial class f : System.Web.UI.Page
{
SqlConnection con = new SqlConnection("data source=VAAYUSEVA_SVR;Initial Catalog=cppsch;User ID=sa;Password=sa");
public static string x;
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
string un = Session["Uname"].ToString();
string q = "select * from TBL_CPPMASTER where [USER NAME]='" + un + "'";
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["cppschConnectionString"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand(q, con);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
txtBigNumber.Text = dr["CPPQUANTUM_C"].ToString();
}

}
}

}
}
its working...but in grid view not working

AutoGenerateColumns="false" ShowFooter="true" HeaderStyle-Font-Bold="true"
onrowcancelingedit="gridView_RowCancelingEdit" DataKeyNames="Id"
onrowdeleting="gridView_RowDeleting" HeaderStyle-BackColor="#E9E9E9"
onrowediting="gridView_RowEditing"
onrowupdating="gridView_RowUpdating"
onrowcommand="gridView_RowCommand"
OnRowDataBound="gridView_RowDataBound" style="margin-left: 0px" >

<

protected void loadStores()
{
con.Open();
SqlCommand cmd = new SqlCommand("Select * from TBL_CPPMASTER", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
int count = ds.Tables[0].Rows.Count;
con.Close();
if (ds.Tables[0].Rows.Count > 0)
{
gridView.DataSource = ds;
gridView.DataBind();
}
else
{
ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
gridView.DataSource = ds;
gridView.DataBind();
int columncount = gridView.Rows[0].Cells.Count;
// lblmsg.Text = " No data found !!!";
}
}
cant able to upload file.
0
kalu singh rao10y ago
can you attach your complete code here ?
0