470,643 Members | 1,359 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

home > topics > asp.net > questions > validators inside datagrid do not fire

Post your question to a community of 470,643 developers. It's quick & easy.

Validators inside datagrid do not fire

I have a asp.net page (C#), with a datagrid. I use template for all columns,
and have <asp:requiredfieldvalidator> in with one of the textboxes, to make
sure it's filled in. However, this validation is not firing, even when I
leave the field empty. Below please find the code:

Expand|Select|Wrap|Line Numbers
  1. <%@ Page Language="C#" Debug="true" %>
  2.  
  3. <%@ Import Namespace="System.Data" %>
  4. <%@ Import Namespace="System.Data.SqlClient" %>
  5.  
  6. <html>
  7. <script language="C#"  runat="server">
  8.  
  9. DataSet dsDepartments = new DataSet();
  10. SqlConnection myConnection = new
  11. SqlConnection("server=dbServer;database=Inventory;User
  12. ID=appUser;Password=appPassword;");
  13. SqlDataAdapter myCommand;
  14.  
  15.  
  16. private void Page_Load(object Sender, EventArgs e)
  17. {
  18. if (ViewState["sortexpression"] == null)
  19. {
  20. ViewState["sortexpression"] = "deptName";
  21. ViewState["sortorder"] = " ASC";
  22. }
  23. if (!IsPostBack)
  24. {
  25. ViewState["sortexpression"] = "deptName";
  26. ViewState["sortorder"] = " ASC";
  27. Response.Write("!IsPostBack");
  28. BindGrid();
  29. }
  30. }
  31.  
  32. void doSort(object sender, DataGridSortCommandEventArgs e)
  33. {
  34. Response.Write("doSort");
  35. if (ViewState["sortorder"] == " ASC" && ViewState["sortexpression"] ==
  36. e.SortExpression)
  37. {
  38. ViewState["sortorder"] = " DESC";
  39. }
  40. else
  41. {
  42. ViewState["sortorder"] = " ASC";
  43. ViewState["sortexpression"] = e.SortExpression;
  44. }
  45. BindGrid();
  46. }
  47. void doUpdate(object sender, DataGridCommandEventArgs e)
  48. {
  49. TextBox bName;
  50. TextBox bNote;
  51. TextBox bID;
  52. bName =
  53. (System.Web.UI.WebControls.TextBox)e.Item.FindControl("deptName");
  54. bNote =
  55. (System.Web.UI.WebControls.TextBox)e.Item.FindControl("deptNote");
  56. bID = (System.Web.UI.WebControls.TextBox)e.Item.FindControl("deptID");
  57. dgDepartments.ShowFooter = true;
  58. dgDepartments.EditItemIndex = -1;
  59. SqlConnection Con = new
  60. SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["dbConn
  61. String"]);
  62. SqlCommand Cmd = new SqlCommand(string.Format("UPDATE dept SET deptName
  63. = '{0}', deptNote = '{1}' WHERE deptID={2}", bName.Text, bNote.Text,
  64. Convert.ToInt32(dgDepartments.DataKeys[e.Item.ItemIndex])), Con);
  65. Con.Open();
  66. Cmd.ExecuteNonQuery();
  67. Con.Close();
  68. BindGrid();
  69. }
  70.  
  71. void doDelete(object sender, DataGridCommandEventArgs e)
  72. {
  73. long deptID =
  74. Convert.ToInt32(dgDepartments.DataKeys[e.Item.ItemIndex]);
  75. SqlConnection Con = new
  76. SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["dbConn
  77. String"]);
  78. SqlCommand Cmd = new SqlCommand(string.Format("DELETE FROM dept WHERE
  79. deptID={0}", deptID), Con);
  80. Con.Open();
  81. Cmd.ExecuteNonQuery();
  82. Con.Close();
  83. BindGrid();
  84. }
  85.  
  86. void doEdit(object sender,
  87. System.Web.UI.WebControls.DataGridCommandEventArgs  e)
  88. {
  89. dgDepartments.ShowFooter = false;
  90. dgDepartments.EditItemIndex = (int)e.Item.ItemIndex;
  91. BindGrid();
  92. }
  93.  
  94. void doCancel(object sender, DataGridCommandEventArgs e)
  95. {
  96. dgDepartments.ShowFooter = true;
  97. dgDepartments.EditItemIndex = -1;
  98. BindGrid();
  99. }
  100.  
  101.  
  102. public void BindGrid()
  103. {
  104. myCommand = new SqlDataAdapter("select * from Dept",
  105. myConnection);
  106. myCommand.Fill(dsDepartments, "Dept");
  107. DataView Source = dsDepartments.Tables["Dept"].DefaultView;
  108. Source.Sort = ViewState["sortexpression"].ToString() +
  109. ViewState["sortorder"].ToString();
  110. dgDepartments.DataSource=Source;
  111. Response.Write("BindGrid()");
  112. dgDepartments.DataBind();
  113. }
  114.  
  115. protected void doPage(object source,
  116. System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
  117. {
  118. dgDepartments.CurrentPageIndex=e.NewPageIndex;
  119. BindGrid();
  120. }
  121.  
  122. void doInsert(object sender, DataGridCommandEventArgs e)
  123. {
  124. try
  125. {
  126. if (e.CommandName == "Insert" )
  127. {
  128. TextBox bName;
  129. TextBox bNote;
  130. bName =
  131. (System.Web.UI.WebControls.TextBox)e.Item.FindControl("_deptName");
  132. bNote =
  133. (System.Web.UI.WebControls.TextBox)e.Item.FindControl("_deptNote");
  134. SqlConnection Con = new
  135. SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["dbConn
  136. String"]);
  137. SqlCommand Cmd = new SqlCommand(string.Format("INSERT INTO dept
  138. (deptName, deptNote) VALUES ('{0}', '{1}')", bName.Text, bNote.Text), Con);
  139. Con.Open();
  140. Cmd.ExecuteNonQuery();
  141. Con.Close();
  142. BindGrid();
  143. }
  144. }
  145. catch
  146. {
  147. }
  148. }
  149.  
  150.  
  151. </script>
  152.  
  153. <head>
  154. <link href="../stylesheet.css" rel="stylesheet" type="text/css">
  155. </head>
  156.  
  157. <body>
  158. <H1>Departments</H1>
  159. <form runat="server"  id="form1">
  160. <asp:DataGrid
  161. AllowPaging="true"
  162. AllowSorting="true"
  163. AutoGenerateColumns="false"
  164. CellPadding="3"
  165. CellSpacing="0"
  166. PageSize="10"
  167. Width="100%"
  168. DataKeyField="deptID"
  169. PagerStyle-Mode="NextPrev"
  170. PagerStyle-NextPageText="Next"
  171. PagerStyle-PrevPageText="Previous"
  172. PagerStyle-HorizontalAlign="Center"
  173. PagerStyle-Position="TopAndBottom"
  174. runat="server"
  175. ID="dgDepartments"
  176. ShowFooter="true"
  177. ShowHeader="true"
  178. runat="server"
  179. OnPageIndexChanged="doPage"
  180. onUpdateCommand="doUpdate"
  181. onEditCommand="doEdit"
  182. onDeleteCommand="doDelete"
  183. onCancelCommand="doCancel"
  184. onItemCommand="doInsert"
  185. onSortCommand="doSort"
  187. <HeaderStyle HorizontalAlign="center" BackColor="#E8EBFD"
  188. ForeColor="#3D3DB6" Font-Name="Verdana, Arial, Helvetica, sans-serif"
  189. Font-Bold="true" Font-Size="smaller" />
  190. <ItemStyle BackColor="#F2F2F2" Font-Name="Verdana, Arial, Helvetica,
  191. sans-serif" Font-Size="smaller" />
  192. <AlternatingItemStyle BackColor="#E5E5E5" Font-Name="Verdana, Arial,
  193. Helvetica, sans-serif" Font-Size="smaller" />
  194. <FooterStyle HorizontalAlign="left" BackColor="#E8EBFD"
  195. ForeColor="#3D3DB6" Font-Name="Verdana, Arial, Helvetica, sans-serif"
  196. Font-Bold="true" Font-Size="smaller" />
  197. <PagerStyle BackColor="white" Font-Name="Verdana, Arial, Helvetica,
  198. sans-serif" Font-Size="smaller" />
  199. <Columns>
  200. <asp:templatecolumn HeaderText="ID" Visible="true"
  201. SortExpression="deptID">
  202. <itemtemplate>
  203. <%#DataBinder.Eval(Container.DataItem, "deptID")  %>
  204. </itemtemplate>
  205. <edititemtemplate>
  206. <%#DataBinder.Eval(Container.DataItem,"deptID") %>
  207. </edititemtemplate>
  208. </asp:templatecolumn>
  209. <asp:TemplateColumn HeaderText="Name"  SortExpression="deptName"
  210. Visible="True">
  211. <ItemTemplate>
  212. <%# DataBinder.Eval(Container.DataItem, "deptName")  %>
  213. </ItemTemplate>
  214. <EditItemTemplate>
  215. <asp:textbox text='<%# DataBinder.Eval(Container.DataItem,
  216. "deptName") %>' id="deptName" runat="Server" cssClass="Text" />
  217. <asp:requiredfieldvalidator runat="server" id="Name"
  218. Visible="true" ControlToValidate="deptName" Enabled="true"
  219. ErrorMessage="Required"
  220. Display="Dynamic">Required</asp:requiredfieldvalidator>
  221. </EditItemTemplate>
  222. <footertemplate><asp:textbox id="_deptName" runat="server"
  223. CssClass="Text" />
  224. <asp:requiredfieldvalidator runat="server" id="_Name"
  225. ControlToValidate="_deptName" Error="Fill in a name" Enabled="true"
  226. Display="Dynamic">Required</asp:requiredfieldvalidator>
  227. </footertemplate>
  228. </asp:TemplateColumn>
  229. <asp:TemplateColumn HeaderText="Note"  SortExpression="deptNote"
  230. Visible="True">
  231. <ItemTemplate>
  232. <%# DataBinder.Eval(Container.DataItem, "deptNote") %>
  233. </ItemTemplate>
  234. <EditItemTemplate>
  235. <asp:textbox cssClass="Text" text='<%#
  236. DataBinder.Eval(Container.DataItem, "deptNote") %>' id="deptNote"
  237. runat="server" />
  238. </EditItemTemplate>
  239. <footertemplate>
  240. <asp:textbox id="_deptNote" runat="server" CssClass="Text" />
  241. </footertemplate>
  242. </asp:TemplateColumn>
  243. <asp:templatecolumn HeaderText="Edit">
  244. <itemtemplate><asp:button CssClass="Text" CommandName="edit"
  245. runat="server"  CausesValidation="false" ID="edit"
  246. Text="Edit"/>&nbsp;<asp:button CssClass="Text" CommandName="delete"
  247. runat="server" ID="delete" Text="Delete" /></itemtemplate>
  248. <edititemtemplate><asp:button CssClass="Text" CommandName="update"
  249. runat="server" CausesValidation="true" ID="update" Text="Save"
  250. />&nbsp;<asp:button CssClass="Text" CommandName="cancel" runat="server"
  251. CausesValidation="false" ID="cancel" Text="Cancel"/></edititemtemplate>
  252. <footertemplate><asp:button CssClass="Text" Commandname = "Insert"
  253. runat="server" ID="add" Text="Add" /></footertemplate>
  254. </asp:templatecolumn>
  255. </Columns>
  256. </asp:DataGrid>
  257. </form>
  258. </body>
  259. </html>
  260.  


--
LUIS ESTEBAN VALENCIA
MICROSOFT DCE 3.
MIEMBRO ACTIVO DE ALIANZADEV
http://spaces.msn.com/members/extremed/
Nov 19 '05 #1
4 1944
There are problems trying to implement cell by cell validation using the
grid's Validating event architecture. The problem is that the grid is not the
object handling the data. Instead, a TextBox or some other control is the
control managing the changing of the cell contents. One way to implement the
validation at the grid level is to handle the CurrentCellChanged event, and
if the previous cell's value is not proper, then return to that cell.

Also be sure that your client scripting is running ok. Any Client scripting
that have errors, causes no client validation.

Fernando Hunth
Senior Developer
Huddle Group S.A.
fe******@huddle.com.ar

Huddle Group S.A. | Enterprise Technology Services
Microsoft Certified Partner

Ciudad de la Paz 2719

· Piso 6D (C1428CPU)

· Ciudad de Buenos Aires · Argentina
www.huddle.com.ar


"Luis Esteban Valencia" wrote:
I have a asp.net page (C#), with a datagrid. I use template for all columns,
and have <asp:requiredfieldvalidator> in with one of the textboxes, to make
sure it's filled in. However, this validation is not firing, even when I
leave the field empty. Below please find the code:

Expand|Select|Wrap|Line Numbers
  1.  <%@ Page Language="C#" Debug="true" %>
  3.  <%@ Import Namespace="System.Data" %>
  4.  <%@ Import Namespace="System.Data.SqlClient" %>
  6.  <html>
  7.  <script language="C#"  runat="server">
  9.      DataSet dsDepartments = new DataSet();
  10.      SqlConnection myConnection = new
  11.  SqlConnection("server=dbServer;database=Inventory;User
  12.  ID=appUser;Password=appPassword;");
  13.       SqlDataAdapter myCommand;
  16.  private void Page_Load(object Sender, EventArgs e)
  17.  {
  18.       if (ViewState["sortexpression"] == null)
  19.       {
  20.            ViewState["sortexpression"] = "deptName";
  21.            ViewState["sortorder"] = " ASC";
  22.       }
  23.       if (!IsPostBack)
  24.       {
  25.            ViewState["sortexpression"] = "deptName";
  26.            ViewState["sortorder"] = " ASC";
  27.            Response.Write("!IsPostBack");
  28.            BindGrid();
  29.       }
  30.  }
  32.  void doSort(object sender, DataGridSortCommandEventArgs e)
  33.  {
  34.       Response.Write("doSort");
  35.       if (ViewState["sortorder"] == " ASC" && ViewState["sortexpression"] ==
  36.  e.SortExpression)
  37.       {
  38.            ViewState["sortorder"] = " DESC";
  39.       }
  40.       else
  41.       {
  42.            ViewState["sortorder"] = " ASC";
  43.            ViewState["sortexpression"] = e.SortExpression;
  44.       }
  45.       BindGrid();
  46.  }
  47.  void doUpdate(object sender, DataGridCommandEventArgs e)
  48.  {
  49.       TextBox bName;
  50.       TextBox bNote;
  51.       TextBox bID;
  52.       bName =
  53.  (System.Web.UI.WebControls.TextBox)e.Item.FindControl("deptName");
  54.       bNote =
  55.  (System.Web.UI.WebControls.TextBox)e.Item.FindControl("deptNote");
  56.       bID = (System.Web.UI.WebControls.TextBox)e.Item.FindControl("deptID");
  57.       dgDepartments.ShowFooter = true;
  58.       dgDepartments.EditItemIndex = -1;
  59.       SqlConnection Con = new
  60.  SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["dbConn
  61.  String"]);
  62.       SqlCommand Cmd = new SqlCommand(string.Format("UPDATE dept SET deptName
  63.  = '{0}', deptNote = '{1}' WHERE deptID={2}", bName.Text, bNote.Text,
  64.  Convert.ToInt32(dgDepartments.DataKeys[e.Item.ItemIndex])), Con);
  65.       Con.Open();
  66.       Cmd.ExecuteNonQuery();
  67.       Con.Close();
  68.       BindGrid();
  69.  }
  71.  void doDelete(object sender, DataGridCommandEventArgs e)
  72.  {
  73.       long deptID =
  74.  Convert.ToInt32(dgDepartments.DataKeys[e.Item.ItemIndex]);
  75.       SqlConnection Con = new
  76.  SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["dbConn
  77.  String"]);
  78.       SqlCommand Cmd = new SqlCommand(string.Format("DELETE FROM dept WHERE
  79.  deptID={0}", deptID), Con);
  80.       Con.Open();
  81.       Cmd.ExecuteNonQuery();
  82.       Con.Close();
  83.       BindGrid();
  84.  }
  86.  void doEdit(object sender,
  87.  System.Web.UI.WebControls.DataGridCommandEventArgs  e)
  88.  {
  89.       dgDepartments.ShowFooter = false;
  90.       dgDepartments.EditItemIndex = (int)e.Item.ItemIndex;
  91.       BindGrid();
  92.  }
  94.  void doCancel(object sender, DataGridCommandEventArgs e)
  95.  {
  96.       dgDepartments.ShowFooter = true;
  97.       dgDepartments.EditItemIndex = -1;
  98.       BindGrid();
  99.  }
  102.  public void BindGrid()
  103.  {
  104.            myCommand = new SqlDataAdapter("select * from Dept",
  105.  myConnection);
  106.          myCommand.Fill(dsDepartments, "Dept");
  107.          DataView Source = dsDepartments.Tables["Dept"].DefaultView;
  108.          Source.Sort = ViewState["sortexpression"].ToString() +
  109.  ViewState["sortorder"].ToString();
  110.          dgDepartments.DataSource=Source;
  111.            Response.Write("BindGrid()");
  112.          dgDepartments.DataBind();
  113.  }
  115.  protected void doPage(object source,
  116.  System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
  117.  {
  118.       dgDepartments.CurrentPageIndex=e.NewPageIndex;
  119.       BindGrid();
  120.  }
  122.  void doInsert(object sender, DataGridCommandEventArgs e)
  123.  {
  124.    try
  125.    {
  126.         if (e.CommandName == "Insert" )
  127.         {
  128.              TextBox bName;
  129.              TextBox bNote;
  130.              bName =
  131.  (System.Web.UI.WebControls.TextBox)e.Item.FindControl("_deptName");
  132.              bNote =
  133.  (System.Web.UI.WebControls.TextBox)e.Item.FindControl("_deptNote");
  134.              SqlConnection Con = new
  135.  SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["dbConn
  136.  String"]);
  137.              SqlCommand Cmd = new SqlCommand(string.Format("INSERT INTO dept
  138.  (deptName, deptNote) VALUES ('{0}', '{1}')", bName.Text, bNote.Text), Con);
  139.              Con.Open();
  140.              Cmd.ExecuteNonQuery();
  141.              Con.Close();
  142.              BindGrid();
  143.         }
  144.    }
  145.    catch
  146.    {
  147.    }
  148.  }
  151.  </script>
  153.  <head>
  154.  <link href="../stylesheet.css" rel="stylesheet" type="text/css">
  155.  </head>
  157.  <body>
  158.  <H1>Departments</H1>
  159.  <form runat="server"  id="form1">
  160.  <asp:DataGrid
  161.    AllowPaging="true"
  162.    AllowSorting="true"
  163.    AutoGenerateColumns="false"
  164.    CellPadding="3"
  165.    CellSpacing="0"
  166.    PageSize="10"
  167.    Width="100%"
  168.    DataKeyField="deptID"
  169.    PagerStyle-Mode="NextPrev"
  170.    PagerStyle-NextPageText="Next"
  171.    PagerStyle-PrevPageText="Previous"
  172.    PagerStyle-HorizontalAlign="Center"
  173.    PagerStyle-Position="TopAndBottom"
  174.    runat="server"
  175.    ID="dgDepartments"
  176.    ShowFooter="true"
  177.    ShowHeader="true"
  178.    runat="server"
  179.    OnPageIndexChanged="doPage"
  180.    onUpdateCommand="doUpdate"
  181.    onEditCommand="doEdit"
  182.    onDeleteCommand="doDelete"
  183.    onCancelCommand="doCancel"
  184.    onItemCommand="doInsert"
  185.    onSortCommand="doSort"
  186.  >
  •      <HeaderStyle HorizontalAlign="center" BackColor="#E8EBFD"
  •  ForeColor="#3D3DB6" Font-Name="Verdana, Arial, Helvetica, sans-serif"
  •  Font-Bold="true" Font-Size="smaller" />
  •      <ItemStyle BackColor="#F2F2F2" Font-Name="Verdana, Arial, Helvetica,
  •  sans-serif" Font-Size="smaller" />
  •      <AlternatingItemStyle BackColor="#E5E5E5" Font-Name="Verdana, Arial,
  •  Helvetica, sans-serif" Font-Size="smaller" />
  •      <FooterStyle HorizontalAlign="left" BackColor="#E8EBFD"
  •  ForeColor="#3D3DB6" Font-Name="Verdana, Arial, Helvetica, sans-serif"
  •  Font-Bold="true" Font-Size="smaller" />
  •      <PagerStyle BackColor="white" Font-Name="Verdana, Arial, Helvetica,
  •  sans-serif" Font-Size="smaller" />
  •      <Columns>
  •       <asp:templatecolumn HeaderText="ID" Visible="true"
  •  SortExpression="deptID">
  •            <itemtemplate>
  •                 <%#DataBinder.Eval(Container.DataItem, "deptID")  %>
  •            </itemtemplate>
  •            <edititemtemplate>
  •            <%#DataBinder.Eval(Container.DataItem,"deptID") %>
  •            </edititemtemplate>
  •       </asp:templatecolumn>
  •      <asp:TemplateColumn HeaderText="Name"  SortExpression="deptName"
  •          Visible="True">
  •        <ItemTemplate>
  •            <%# DataBinder.Eval(Container.DataItem, "deptName")  %>
  •  </ItemTemplate>
  •        <EditItemTemplate>
  •            <asp:textbox text='<%# DataBinder.Eval(Container.DataItem,
  •  "deptName") %>' id="deptName" runat="Server" cssClass="Text" />
  •              <asp:requiredfieldvalidator runat="server" id="Name"
  •  Visible="true" ControlToValidate="deptName" Enabled="true"
  •  ErrorMessage="Required"
  •  Display="Dynamic">Required</asp:requiredfieldvalidator>
  •        </EditItemTemplate>
  •        <footertemplate><asp:textbox id="_deptName" runat="server"
  •  CssClass="Text" />
  •         <asp:requiredfieldvalidator runat="server" id="_Name"
  •  ControlToValidate="_deptName" Error="Fill in a name" Enabled="true"
  •  Display="Dynamic">Required</asp:requiredfieldvalidator>
  •        </footertemplate>
  •      </asp:TemplateColumn>
  •      <asp:TemplateColumn HeaderText="Note"  SortExpression="deptNote"
  •          Visible="True">
  •        <ItemTemplate>
  •            <%# DataBinder.Eval(Container.DataItem, "deptNote") %>
  •  </ItemTemplate>
  •        <EditItemTemplate>
  •            <asp:textbox cssClass="Text" text='<%#
  •  DataBinder.Eval(Container.DataItem, "deptNote") %>' id="deptNote"
  •  runat="server" />
  •            </EditItemTemplate>
  •              <footertemplate>
  •               <asp:textbox id="_deptNote" runat="server" CssClass="Text" />
  •              </footertemplate>
  •      </asp:TemplateColumn>
  •       <asp:templatecolumn HeaderText="Edit">
  •            <itemtemplate><asp:button CssClass="Text" CommandName="edit"
  •  runat="server"  CausesValidation="false" ID="edit"
  •  Text="Edit"/> <asp:button CssClass="Text" CommandName="delete"
  •  runat="server" ID="delete" Text="Delete" /></itemtemplate>
  •            <edititemtemplate><asp:button CssClass="Text" CommandName="update"
  •  runat="server" CausesValidation="true" ID="update" Text="Save"
  •  /> <asp:button CssClass="Text" CommandName="cancel" runat="server"
  •  CausesValidation="false" ID="cancel" Text="Cancel"/></edititemtemplate>
  •            <footertemplate><asp:button CssClass="Text" Commandname = "Insert"
  •  runat="server" ID="add" Text="Add" /></footertemplate>
  •       </asp:templatecolumn>
  •      </Columns>
  •    </asp:DataGrid>
  •  </form>
  •  </body>
  •  </html>
  •  

    • --
    LUIS ESTEBAN VALENCIA
    MICROSOFT DCE 3.
    MIEMBRO ACTIVO DE ALIANZADEV
    http://spaces.msn.com/members/extremed/

    Nov 19 '05 #2
    How Could I Implement it on the code I have?'
    more or less?? a snippet of code?

    --
    LUIS ESTEBAN VALENCIA
    MICROSOFT DCE 3.
    MIEMBRO ACTIVO DE ALIANZADEV
    http://spaces.msn.com/members/extremed/
    "Fernando Hunth" <Fe***********@discussions.microsoft.com> escribió en el
    mensaje news:FD**********************************@microsof t.com...
    There are problems trying to implement cell by cell validation using the
    grid's Validating event architecture. The problem is that the grid is not the object handling the data. Instead, a TextBox or some other control is the
    control managing the changing of the cell contents. One way to implement the validation at the grid level is to handle the CurrentCellChanged event, and if the previous cell's value is not proper, then return to that cell.

    Also be sure that your client scripting is running ok. Any Client scripting that have errors, causes no client validation.

    Fernando Hunth
    Senior Developer
    Huddle Group S.A.
    fe******@huddle.com.ar

    Huddle Group S.A. | Enterprise Technology Services
    Microsoft Certified Partner

    Ciudad de la Paz 2719

    · Piso 6D (C1428CPU)

    · Ciudad de Buenos Aires · Argentina
    www.huddle.com.ar


    "Luis Esteban Valencia" wrote:
    I have a asp.net page (C#), with a datagrid. I use template for all columns, and have <asp:requiredfieldvalidator> in with one of the textboxes, to make sure it's filled in. However, this validation is not firing, even when I
    leave the field empty. Below please find the code:

    Expand|Select|Wrap|Line Numbers
    1.  > <%@ Page Language="C#" Debug="true" %>
    2.  >
    3.  > <%@ Import Namespace="System.Data" %>
    4.  > <%@ Import Namespace="System.Data.SqlClient" %>
    5.  >
    6.  > <html>
    7.  > <script language="C#"  runat="server">
    8.  >
    9.  >     DataSet dsDepartments = new DataSet();
    10.  >     SqlConnection myConnection = new
    11.  > SqlConnection("server=dbServer;database=Inventory;User
    12.  > ID=appUser;Password=appPassword;");
    13.  >      SqlDataAdapter myCommand;
    14.  >
    15.  >
    16.  > private void Page_Load(object Sender, EventArgs e)
    17.  > {
    18.  >      if (ViewState["sortexpression"] == null)
    19.  >      {
    20.  >           ViewState["sortexpression"] = "deptName";
    21.  >           ViewState["sortorder"] = " ASC";
    22.  >      }
    23.  >      if (!IsPostBack)
    24.  >      {
    25.  >           ViewState["sortexpression"] = "deptName";
    26.  >           ViewState["sortorder"] = " ASC";
    27.  >           Response.Write("!IsPostBack");
    28.  >           BindGrid();
    29.  >      }
    30.  > }
    31.  >
    32.  > void doSort(object sender, DataGridSortCommandEventArgs e)
    33.  > {
    34.  >      Response.Write("doSort");
    35.  >      if (ViewState["sortorder"] == " ASC" && ViewState["sortexpression"]
  • ==
  •  > e.SortExpression)
  •  >      {
  •  >           ViewState["sortorder"] = " DESC";
  •  >      }
  •  >      else
  •  >      {
  •  >           ViewState["sortorder"] = " ASC";
  •  >           ViewState["sortexpression"] = e.SortExpression;
  •  >      }
  •  >      BindGrid();
  •  > }
  •  > void doUpdate(object sender, DataGridCommandEventArgs e)
  •  > {
  •  >      TextBox bName;
  •  >      TextBox bNote;
  •  >      TextBox bID;
  •  >      bName =
  •  > (System.Web.UI.WebControls.TextBox)e.Item.FindControl("deptName");
  •  >      bNote =
  •  > (System.Web.UI.WebControls.TextBox)e.Item.FindControl("deptNote");
  •  >      bID =
  • (System.Web.UI.WebControls.TextBox)e.Item.FindControl("deptID");
  •  >      dgDepartments.ShowFooter = true;
  •  >      dgDepartments.EditItemIndex = -1;
  •  >      SqlConnection Con = new
  •  >
  • SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["dbConn
  •  > String"]);
  •  >      SqlCommand Cmd = new SqlCommand(string.Format("UPDATE dept SET
  • deptName
  •  > = '{0}', deptNote = '{1}' WHERE deptID={2}", bName.Text, bNote.Text,
  •  > Convert.ToInt32(dgDepartments.DataKeys[e.Item.ItemIndex])), Con);
  •  >      Con.Open();
  •  >      Cmd.ExecuteNonQuery();
  •  >      Con.Close();
  •  >      BindGrid();
  •  > }
  •  >
  •  > void doDelete(object sender, DataGridCommandEventArgs e)
  •  > {
  •  >      long deptID =
  •  > Convert.ToInt32(dgDepartments.DataKeys[e.Item.ItemIndex]);
  •  >      SqlConnection Con = new
  •  >
  • SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["dbConn
  •  > String"]);
  •  >      SqlCommand Cmd = new SqlCommand(string.Format("DELETE FROM dept
  • WHERE
  •  > deptID={0}", deptID), Con);
  •  >      Con.Open();
  •  >      Cmd.ExecuteNonQuery();
  •  >      Con.Close();
  •  >      BindGrid();
  •  > }
  •  >
  •  > void doEdit(object sender,
  •  > System.Web.UI.WebControls.DataGridCommandEventArgs  e)
  •  > {
  •  >      dgDepartments.ShowFooter = false;
  •  >      dgDepartments.EditItemIndex = (int)e.Item.ItemIndex;
  •  >      BindGrid();
  •  > }
  •  >
  •  > void doCancel(object sender, DataGridCommandEventArgs e)
  •  > {
  •  >      dgDepartments.ShowFooter = true;
  •  >      dgDepartments.EditItemIndex = -1;
  •  >      BindGrid();
  •  > }
  •  >
  •  >
  •  > public void BindGrid()
  •  > {
  •  >           myCommand = new SqlDataAdapter("select * from Dept",
  •  > myConnection);
  •  >         myCommand.Fill(dsDepartments, "Dept");
  •  >         DataView Source = dsDepartments.Tables["Dept"].DefaultView;
  •  >         Source.Sort = ViewState["sortexpression"].ToString() +
  •  > ViewState["sortorder"].ToString();
  •  >         dgDepartments.DataSource=Source;
  •  >           Response.Write("BindGrid()");
  •  >         dgDepartments.DataBind();
  •  > }
  •  >
  •  > protected void doPage(object source,
  •  > System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
  •  > {
  •  >      dgDepartments.CurrentPageIndex=e.NewPageIndex;
  •  >      BindGrid();
  •  > }
  •  >
  •  > void doInsert(object sender, DataGridCommandEventArgs e)
  •  > {
  •  >   try
  •  >   {
  •  >        if (e.CommandName == "Insert" )
  •  >        {
  •  >             TextBox bName;
  •  >             TextBox bNote;
  •  >             bName =
  •  > (System.Web.UI.WebControls.TextBox)e.Item.FindControl("_deptName");
  •  >             bNote =
  •  > (System.Web.UI.WebControls.TextBox)e.Item.FindControl("_deptNote");
  •  >             SqlConnection Con = new
  •  >
  • SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["dbConn
  •  > String"]);
  •  >             SqlCommand Cmd = new SqlCommand(string.Format("INSERT INTO
  • dept
  •  > (deptName, deptNote) VALUES ('{0}', '{1}')", bName.Text, bNote.Text),
  • Con);
  •  >             Con.Open();
  •  >             Cmd.ExecuteNonQuery();
  •  >             Con.Close();
  •  >             BindGrid();
  •  >        }
  •  >   }
  •  >   catch
  •  >   {
  •  >   }
  •  > }
  •  >
  •  >
  •  > </script>
  •  >
  •  > <head>
  •  > <link href="../stylesheet.css" rel="stylesheet" type="text/css">
  •  > </head>
  •  >
  •  > <body>
  •  > <H1>Departments</H1>
  •  > <form runat="server"  id="form1">
  •  > <asp:DataGrid
  •  >   AllowPaging="true"
  •  >   AllowSorting="true"
  •  >   AutoGenerateColumns="false"
  •  >   CellPadding="3"
  •  >   CellSpacing="0"
  •  >   PageSize="10"
  •  >   Width="100%"
  •  >   DataKeyField="deptID"
  •  >   PagerStyle-Mode="NextPrev"
  •  >   PagerStyle-NextPageText="Next"
  •  >   PagerStyle-PrevPageText="Previous"
  •  >   PagerStyle-HorizontalAlign="Center"
  •  >   PagerStyle-Position="TopAndBottom"
  •  >   runat="server"
  •  >   ID="dgDepartments"
  •  >   ShowFooter="true"
  •  >   ShowHeader="true"
  •  >   runat="server"
  •  >   OnPageIndexChanged="doPage"
  •  >   onUpdateCommand="doUpdate"
  •  >   onEditCommand="doEdit"
  •  >   onDeleteCommand="doDelete"
  •  >   onCancelCommand="doCancel"
  •  >   onItemCommand="doInsert"
  •  >   onSortCommand="doSort"
  •  > >
  •  >     <HeaderStyle HorizontalAlign="center" BackColor="#E8EBFD"
  •  > ForeColor="#3D3DB6" Font-Name="Verdana, Arial, Helvetica, sans-serif"
  •  > Font-Bold="true" Font-Size="smaller" />
  •  >     <ItemStyle BackColor="#F2F2F2" Font-Name="Verdana, Arial, Helvetica,
  •  > sans-serif" Font-Size="smaller" />
  •  >     <AlternatingItemStyle BackColor="#E5E5E5" Font-Name="Verdana, Arial,
  •  > Helvetica, sans-serif" Font-Size="smaller" />
  •  >     <FooterStyle HorizontalAlign="left" BackColor="#E8EBFD"
  •  > ForeColor="#3D3DB6" Font-Name="Verdana, Arial, Helvetica, sans-serif"
  •  > Font-Bold="true" Font-Size="smaller" />
  •  >     <PagerStyle BackColor="white" Font-Name="Verdana, Arial, Helvetica,
  •  > sans-serif" Font-Size="smaller" />
  •  >     <Columns>
  •  >      <asp:templatecolumn HeaderText="ID" Visible="true"
  •  > SortExpression="deptID">
  •  >           <itemtemplate>
  •  >                <%#DataBinder.Eval(Container.DataItem, "deptID")  %>
  •  >           </itemtemplate>
  •  >           <edititemtemplate>
  •  >           <%#DataBinder.Eval(Container.DataItem,"deptID") %>
  •  >           </edititemtemplate>
  •  >      </asp:templatecolumn>
  •  >     <asp:TemplateColumn HeaderText="Name"  SortExpression="deptName"
  •  >         Visible="True">
  •  >       <ItemTemplate>
  •  >           <%# DataBinder.Eval(Container.DataItem, "deptName")  %>
  •  > </ItemTemplate>
  •  >       <EditItemTemplate>
  •  >           <asp:textbox text='<%# DataBinder.Eval(Container.DataItem,
  •  > "deptName") %>' id="deptName" runat="Server" cssClass="Text" />
  •  >             <asp:requiredfieldvalidator runat="server" id="Name"
  •  > Visible="true" ControlToValidate="deptName" Enabled="true"
  •  > ErrorMessage="Required"
  •  > Display="Dynamic">Required</asp:requiredfieldvalidator>
  •  >       </EditItemTemplate>
  •  >       <footertemplate><asp:textbox id="_deptName" runat="server"
  •  > CssClass="Text" />
  •  >        <asp:requiredfieldvalidator runat="server" id="_Name"
  •  > ControlToValidate="_deptName" Error="Fill in a name" Enabled="true"
  •  > Display="Dynamic">Required</asp:requiredfieldvalidator>
  •  >       </footertemplate>
  •  >     </asp:TemplateColumn>
  •  >     <asp:TemplateColumn HeaderText="Note"  SortExpression="deptNote"
  •  >         Visible="True">
  •  >       <ItemTemplate>
  •  >           <%# DataBinder.Eval(Container.DataItem, "deptNote") %>
  •  > </ItemTemplate>
  •  >       <EditItemTemplate>
  •  >           <asp:textbox cssClass="Text" text='<%#
  •  > DataBinder.Eval(Container.DataItem, "deptNote") %>' id="deptNote"
  •  > runat="server" />
  •  >           </EditItemTemplate>
  •  >             <footertemplate>
  •  >              <asp:textbox id="_deptNote" runat="server" CssClass="Text"
  • />
  •  >             </footertemplate>
  •  >     </asp:TemplateColumn>
  •  >      <asp:templatecolumn HeaderText="Edit">
  •  >           <itemtemplate><asp:button CssClass="Text" CommandName="edit"
  •  > runat="server"  CausesValidation="false" ID="edit"
  •  > Text="Edit"/> <asp:button CssClass="Text" CommandName="delete"
  •  > runat="server" ID="delete" Text="Delete" /></itemtemplate>
  •  >           <edititemtemplate><asp:button CssClass="Text"
  • CommandName="update"
  •  > runat="server" CausesValidation="true" ID="update" Text="Save"
  •  > /> <asp:button CssClass="Text" CommandName="cancel" runat="server"
  •  > CausesValidation="false" ID="cancel" Text="Cancel"/></edititemtemplate>
  •  >           <footertemplate><asp:button CssClass="Text" Commandname =
  • "Insert"
  •  > runat="server" ID="add" Text="Add" /></footertemplate>
  •  >      </asp:templatecolumn>
  •  >     </Columns>
  •  >   </asp:DataGrid>
  •  > </form>
  •  > </body>
  •  > </html>
  •  > 

    • --
    LUIS ESTEBAN VALENCIA
    MICROSOFT DCE 3.
    MIEMBRO ACTIVO DE ALIANZADEV
    http://spaces.msn.com/members/extremed/

    Nov 19 '05 #3
    Take a look at http://www21.brinkster.com/fhunth/De...AQDatagrid.asp

    "Luis Esteban Valencia" wrote:
    How Could I Implement it on the code I have?'
    more or less?? a snippet of code?

    --
    LUIS ESTEBAN VALENCIA
    MICROSOFT DCE 3.
    MIEMBRO ACTIVO DE ALIANZADEV
    http://spaces.msn.com/members/extremed/
    "Fernando Hunth" <Fe***********@discussions.microsoft.com> escribió en el
    mensaje news:FD**********************************@microsof t.com...
    There are problems trying to implement cell by cell validation using the
    grid's Validating event architecture. The problem is that the grid is not

    the
    object handling the data. Instead, a TextBox or some other control is the
    control managing the changing of the cell contents. One way to implement

    the
    validation at the grid level is to handle the CurrentCellChanged event,

    and
    if the previous cell's value is not proper, then return to that cell.

    Also be sure that your client scripting is running ok. Any Client

    scripting
    that have errors, causes no client validation.

    Fernando Hunth
    Senior Developer
    Huddle Group S.A.
    fe******@huddle.com.ar

    Huddle Group S.A. | Enterprise Technology Services
    Microsoft Certified Partner

    Ciudad de la Paz 2719

    · Piso 6D (C1428CPU)

    · Ciudad de Buenos Aires · Argentina
    www.huddle.com.ar


    "Luis Esteban Valencia" wrote:
    I have a asp.net page (C#), with a datagrid. I use template for all columns, and have <asp:requiredfieldvalidator> in with one of the textboxes, to make sure it's filled in. However, this validation is not firing, even when I
    leave the field empty. Below please find the code:

    Expand|Select|Wrap|Line Numbers
    1.  > > <%@ Page Language="C#" Debug="true" %>
    2.  > >
    3.  > > <%@ Import Namespace="System.Data" %>
    4.  > > <%@ Import Namespace="System.Data.SqlClient" %>
    5.  > >
    6.  > > <html>
    7.  > > <script language="C#"  runat="server">
    8.  > >
    9.  > >     DataSet dsDepartments = new DataSet();
    10.  > >     SqlConnection myConnection = new
    11.  > > SqlConnection("server=dbServer;database=Inventory;User
    12.  > > ID=appUser;Password=appPassword;");
    13.  > >      SqlDataAdapter myCommand;
    14.  > >
    15.  > >
    16.  > > private void Page_Load(object Sender, EventArgs e)
    17.  > > {
    18.  > >      if (ViewState["sortexpression"] == null)
    19.  > >      {
    20.  > >           ViewState["sortexpression"] = "deptName";
    21.  > >           ViewState["sortorder"] = " ASC";
    22.  > >      }
    23.  > >      if (!IsPostBack)
    24.  > >      {
    25.  > >           ViewState["sortexpression"] = "deptName";
    26.  > >           ViewState["sortorder"] = " ASC";
    27.  > >           Response.Write("!IsPostBack");
    28.  > >           BindGrid();
    29.  > >      }
    30.  > > }
    31.  > >
    32.  > > void doSort(object sender, DataGridSortCommandEventArgs e)
    33.  > > {
    34.  > >      Response.Write("doSort");
    35.  > >      if (ViewState["sortorder"] == " ASC" && ViewState["sortexpression"]
  •  ==
  •  > > e.SortExpression)
  •  > >      {
  •  > >           ViewState["sortorder"] = " DESC";
  •  > >      }
  •  > >      else
  •  > >      {
  •  > >           ViewState["sortorder"] = " ASC";
  •  > >           ViewState["sortexpression"] = e.SortExpression;
  •  > >      }
  •  > >      BindGrid();
  •  > > }
  •  > > void doUpdate(object sender, DataGridCommandEventArgs e)
  •  > > {
  •  > >      TextBox bName;
  •  > >      TextBox bNote;
  •  > >      TextBox bID;
  •  > >      bName =
  •  > > (System.Web.UI.WebControls.TextBox)e.Item.FindControl("deptName");
  •  > >      bNote =
  •  > > (System.Web.UI.WebControls.TextBox)e.Item.FindControl("deptNote");
  •  > >      bID =
  •  (System.Web.UI.WebControls.TextBox)e.Item.FindControl("deptID");
  •  > >      dgDepartments.ShowFooter = true;
  •  > >      dgDepartments.EditItemIndex = -1;
  •  > >      SqlConnection Con = new
  •  > >
  •  SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["dbConn
  •  > > String"]);
  •  > >      SqlCommand Cmd = new SqlCommand(string.Format("UPDATE dept SET
  •  deptName
  •  > > = '{0}', deptNote = '{1}' WHERE deptID={2}", bName.Text, bNote.Text,
  •  > > Convert.ToInt32(dgDepartments.DataKeys[e.Item.ItemIndex])), Con);
  •  > >      Con.Open();
  •  > >      Cmd.ExecuteNonQuery();
  •  > >      Con.Close();
  •  > >      BindGrid();
  •  > > }
  •  > >
  •  > > void doDelete(object sender, DataGridCommandEventArgs e)
  •  > > {
  •  > >      long deptID =
  •  > > Convert.ToInt32(dgDepartments.DataKeys[e.Item.ItemIndex]);
  •  > >      SqlConnection Con = new
  •  > >
  •  SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["dbConn
  •  > > String"]);
  •  > >      SqlCommand Cmd = new SqlCommand(string.Format("DELETE FROM dept
  •  WHERE
  •  > > deptID={0}", deptID), Con);
  •  > >      Con.Open();
  •  > >      Cmd.ExecuteNonQuery();
  •  > >      Con.Close();
  •  > >      BindGrid();
  •  > > }
  •  > >
  •  > > void doEdit(object sender,
  •  > > System.Web.UI.WebControls.DataGridCommandEventArgs  e)
  •  > > {
  •  > >      dgDepartments.ShowFooter = false;
  •  > >      dgDepartments.EditItemIndex = (int)e.Item.ItemIndex;
  •  > >      BindGrid();
  •  > > }
  •  > >
  •  > > void doCancel(object sender, DataGridCommandEventArgs e)
  •  > > {
  •  > >      dgDepartments.ShowFooter = true;
  •  > >      dgDepartments.EditItemIndex = -1;
  •  > >      BindGrid();
  •  > > }
  •  > >
  •  > >
  •  > > public void BindGrid()
  •  > > {
  •  > >           myCommand = new SqlDataAdapter("select * from Dept",
  •  > > myConnection);
  •  > >         myCommand.Fill(dsDepartments, "Dept");
  •  > >         DataView Source = dsDepartments.Tables["Dept"].DefaultView;
  •  > >         Source.Sort = ViewState["sortexpression"].ToString() +
  •  > > ViewState["sortorder"].ToString();
  •  > >         dgDepartments.DataSource=Source;
  •  > >           Response.Write("BindGrid()");
  •  > >         dgDepartments.DataBind();
  •  > > }
  •  > >
  •  > > protected void doPage(object source,
  •  > > System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
  •  > > {
  •  > >      dgDepartments.CurrentPageIndex=e.NewPageIndex;
  •  > >      BindGrid();
  •  > > }
  •  > >
  •  > > void doInsert(object sender, DataGridCommandEventArgs e)
  •  > > {
  •  > >   try
  •  > >   {
  •  > >        if (e.CommandName == "Insert" )
  •  > >        {
  •  > >             TextBox bName;
  •  > >             TextBox bNote;
  •  > >             bName =
  •  > > (System.Web.UI.WebControls.TextBox)e.Item.FindControl("_deptName");
  •  > >             bNote =
  •  > > (System.Web.UI.WebControls.TextBox)e.Item.FindControl("_deptNote");
  •  > >             SqlConnection Con = new
  •  > >
  •  SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["dbConn
  •  > > String"]);
  •  > >             SqlCommand Cmd = new SqlCommand(string.Format("INSERT INTO
  •  dept
  •  > > (deptName, deptNote) VALUES ('{0}', '{1}')", bName.Text, bNote.Text),
  •  Con);
  •  > >             Con.Open();
  •  > >             Cmd.ExecuteNonQuery();
  •  > >             Con.Close();
  •  > >             BindGrid();
  •  > >        }
  •  > >   }
  •  > >   catch
  •  > >   {
  •  > >   }
  •  > > }
  •  > >
  •  > >
  •  > > </script>
  •  > >
  •  > > <head>
  •  > > <link href="../stylesheet.css" rel="stylesheet" type="text/css">
  •  > > </head>
  •  > >
  •  > > <body>
  •  > > <H1>Departments</H1>
  •  > > <form runat="server"  id="form1">
  •  > > <asp:DataGrid
  •  > >   AllowPaging="true"
  •  > >   AllowSorting="true"
  •  > >   AutoGenerateColumns="false"
  •  > >   CellPadding="3"
  •  > >   CellSpacing="0"
  •  > >   PageSize="10"
  •  > >   Width="100%"
  •  > >   DataKeyField="deptID"
  •  > >   PagerStyle-Mode="NextPrev"
  •  > >   PagerStyle-NextPageText="Next"
  •  > >   PagerStyle-PrevPageText="Previous"
  •  > >   PagerStyle-HorizontalAlign="Center"
  •  > >   PagerStyle-Position="TopAndBottom"
  •  > >   runat="server"
  •  > >   ID="dgDepartments"
  •  > >   ShowFooter="true"
  •  > >   ShowHeader="true"
  •  > >   runat="server"
  •  > >   OnPageIndexChanged="doPage"
  •  > >   onUpdateCommand="doUpdate"
  •  > >   onEditCommand="doEdit"
  •  > >   onDeleteCommand="doDelete"
  •  > >   onCancelCommand="doCancel"
  •  > >   onItemCommand="doInsert"
  •  > >   onSortCommand="doSort"
  •  > > >
  •  > >     <HeaderStyle HorizontalAlign="center" BackColor="#E8EBFD"
  •  > > ForeColor="#3D3DB6" Font-Name="Verdana, Arial, Helvetica, sans-serif"
  •  > > Font-Bold="true" Font-Size="smaller" />
  •  > >     <ItemStyle BackColor="#F2F2F2" Font-Name="Verdana, Arial, Helvetica,
  •  > > sans-serif" Font-Size="smaller" />
  •  > >     <AlternatingItemStyle BackColor="#E5E5E5" Font-Name="Verdana, Arial,
  •  > > Helvetica, sans-serif" Font-Size="smaller" />
  •  > >     <FooterStyle HorizontalAlign="left" BackColor="#E8EBFD"
  •  > > ForeColor="#3D3DB6" Font-Name="Verdana, Arial, Helvetica, sans-serif"
  •  > > Font-Bold="true" Font-Size="smaller" />
  •  > >     <PagerStyle BackColor="white" Font-Name="Verdana, Arial, Helvetica,
  •  > > sans-serif" Font-Size="smaller" />
  •  > >     <Columns>
  •  > >      <asp:templatecolumn HeaderText="ID" Visible="true"
  •  > > SortExpression="deptID">
  •  > >           <itemtemplate>
  •  > >                <%#DataBinder.Eval(Container.DataItem, "deptID")  %>
  •  > >           </itemtemplate>
  •  > >           <edititemtemplate>
  •  > >           <%#DataBinder.Eval(Container.DataItem,"deptID") %>
  •  > >           </edititemtemplate>
  •  > >      </asp:templatecolumn>
  •  > >     <asp:TemplateColumn HeaderText="Name"  SortExpression="deptName"
  •  > >         Visible="True">
  •  > >       <ItemTemplate>
  •  > >           <%# DataBinder.Eval(Container.DataItem, "deptName")  %>
  •  > > </ItemTemplate>
  •  > >       <EditItemTemplate>
  •  > >           <asp:textbox text='<%# DataBinder.Eval(Container.DataItem,
  •  > > "deptName") %>' id="deptName" runat="Server" cssClass="Text" />
  •  > >             <asp:requiredfieldvalidator runat="server" id="Name"
  •  > > Visible="true" ControlToValidate="deptName" Enabled="true"
  •  > > ErrorMessage="Required"
  •  > > Display="Dynamic">Required</asp:requiredfieldvalidator>
  •  > >       </EditItemTemplate>
  •  > >       <footertemplate><asp:textbox id="_deptName" runat="server"
  •  > > CssClass="Text" />
  •  > >        <asp:requiredfieldvalidator runat="server" id="_Name"
  •  > > ControlToValidate="_deptName" Error="Fill in a name" Enabled="true"
  •  > > Display="Dynamic">Required</asp:requiredfieldvalidator>
  •  > >       </footertemplate>
  •  > >     </asp:TemplateColumn>
  •  > >     <asp:TemplateColumn HeaderText="Note"  SortExpression="deptNote"
  •  > >         Visible="True">
  •  > >       <ItemTemplate>
  •  > >           <%# DataBinder.Eval(Container.DataItem, "deptNote") %>
  •  > > </ItemTemplate>
  •  > >       <EditItemTemplate>
  •  > >           <asp:textbox cssClass="Text" text='<%#
  •  > > DataBinder.Eval(Container.DataItem, "deptNote") %>' id="deptNote"
  •  > > runat="server" />
  •  > >           </EditItemTemplate>
  •  > >             <footertemplate>
  •  > >              <asp:textbox id="_deptNote" runat="server" CssClass="Text"
  •  />
  •  > >             </footertemplate>
  •  > >     </asp:TemplateColumn>
  •  > >      <asp:templatecolumn HeaderText="Edit">
  •  > >           <itemtemplate><asp:button CssClass="Text" CommandName="edit"
  •  > > runat="server"  CausesValidation="false" ID="edit"
  •  > > Text="Edit"/> <asp:button CssClass="Text" CommandName="delete"
  •  > > runat="server" ID="delete" Text="Delete" /></itemtemplate>
  •  > >           <edititemtemplate><asp:button CssClass="Text"
  •  CommandName="update"
  •  > > runat="server" CausesValidation="true" ID="update" Text="Save"
  •  > > /> <asp:button CssClass="Text" CommandName="cancel" runat="server"
  •  > > CausesValidation="false" ID="cancel" Text="Cancel"/></edititemtemplate>
  •  > >           <footertemplate><asp:button CssClass="Text" Commandname =
  •  "Insert"
  •  > > runat="server" ID="add" Text="Add" /></footertemplate>
  •  > >      </asp:templatecolumn>
  •  > >     </Columns>
  •  > >   </asp:DataGrid>
  •  > > </form>
  •  > > </body>
  •  > > </html>
  •  > > 

    • --
    LUIS ESTEBAN VALENCIA
    MICROSOFT DCE 3.
    MIEMBRO ACTIVO DE ALIANZADEV
    http://spaces.msn.com/members/extremed/


    Nov 19 '05 #4
    I didnt find anything related. and it says Windows Forms Datagrid???

    --
    LUIS ESTEBAN VALENCIA
    MICROSOFT DCE 3.
    MIEMBRO ACTIVO DE ALIANZADEV
    http://spaces.msn.com/members/extremed/
    "Fernando Hunth" <Fe***********@discussions.microsoft.com> escribió en el
    mensaje news:1C**********************************@microsof t.com...
    Take a look at http://www21.brinkster.com/fhunth/De...AQDatagrid.asp
    "Luis Esteban Valencia" wrote:
    How Could I Implement it on the code I have?'
    more or less?? a snippet of code?

    --
    LUIS ESTEBAN VALENCIA
    MICROSOFT DCE 3.
    MIEMBRO ACTIVO DE ALIANZADEV
    http://spaces.msn.com/members/extremed/
    "Fernando Hunth" <Fe***********@discussions.microsoft.com> escribió en el mensaje news:FD**********************************@microsof t.com...
    There are problems trying to implement cell by cell validation using the grid's Validating event architecture. The problem is that the grid is not
    the
    object handling the data. Instead, a TextBox or some other control is
    the control managing the changing of the cell contents. One way to implement the
    validation at the grid level is to handle the CurrentCellChanged
    event, and
    if the previous cell's value is not proper, then return to that cell.

    Also be sure that your client scripting is running ok. Any Client

    scripting
    that have errors, causes no client validation.

    Fernando Hunth
    Senior Developer
    Huddle Group S.A.
    fe******@huddle.com.ar

    Huddle Group S.A. | Enterprise Technology Services
    Microsoft Certified Partner

    Ciudad de la Paz 2719

    · Piso 6D (C1428CPU)

    · Ciudad de Buenos Aires · Argentina
    www.huddle.com.ar


    "Luis Esteban Valencia" wrote:

    > I have a asp.net page (C#), with a datagrid. I use template for all

    columns,
    > and have <asp:requiredfieldvalidator> in with one of the textboxes,
    to make
    > sure it's filled in. However, this validation is not firing, even

    when I > leave the field empty. Below please find the code:
    >
    >
    Expand|Select|Wrap|Line Numbers
    1.  > > > <%@ Page Language="C#" Debug="true" %>
    2.  > > >
    3.  > > > <%@ Import Namespace="System.Data" %>
    4.  > > > <%@ Import Namespace="System.Data.SqlClient" %>
    5.  > > >
    6.  > > > <html>
    7.  > > > <script language="C#"  runat="server">
    8.  > > >
    9.  > > >     DataSet dsDepartments = new DataSet();
    10.  > > >     SqlConnection myConnection = new
    11.  > > > SqlConnection("server=dbServer;database=Inventory;User
    12.  > > > ID=appUser;Password=appPassword;");
    13.  > > >      SqlDataAdapter myCommand;
    14.  > > >
    15.  > > >
    16.  > > > private void Page_Load(object Sender, EventArgs e)
    17.  > > > {
    18.  > > >      if (ViewState["sortexpression"] == null)
    19.  > > >      {
    20.  > > >           ViewState["sortexpression"] = "deptName";
    21.  > > >           ViewState["sortorder"] = " ASC";
    22.  > > >      }
    23.  > > >      if (!IsPostBack)
    24.  > > >      {
    25.  > > >           ViewState["sortexpression"] = "deptName";
    26.  > > >           ViewState["sortorder"] = " ASC";
    27.  > > >           Response.Write("!IsPostBack");
    28.  > > >           BindGrid();
    29.  > > >      }
    30.  > > > }
    31.  > > >
    32.  > > > void doSort(object sender, DataGridSortCommandEventArgs e)
    33.  > > > {
    34.  > > >      Response.Write("doSort");
    35.  > > >      if (ViewState["sortorder"] == " ASC" &&
  • ViewState["sortexpression"]
  •  > ==
  •  > > > e.SortExpression)
  •  > > >      {
  •  > > >           ViewState["sortorder"] = " DESC";
  •  > > >      }
  •  > > >      else
  •  > > >      {
  •  > > >           ViewState["sortorder"] = " ASC";
  •  > > >           ViewState["sortexpression"] = e.SortExpression;
  •  > > >      }
  •  > > >      BindGrid();
  •  > > > }
  •  > > > void doUpdate(object sender, DataGridCommandEventArgs e)
  •  > > > {
  •  > > >      TextBox bName;
  •  > > >      TextBox bNote;
  •  > > >      TextBox bID;
  •  > > >      bName =
  •  > > > (System.Web.UI.WebControls.TextBox)e.Item.FindControl("deptName");
  •  > > >      bNote =
  •  > > > (System.Web.UI.WebControls.TextBox)e.Item.FindControl("deptNote");
  •  > > >      bID =
  •  > (System.Web.UI.WebControls.TextBox)e.Item.FindControl("deptID");
  •  > > >      dgDepartments.ShowFooter = true;
  •  > > >      dgDepartments.EditItemIndex = -1;
  •  > > >      SqlConnection Con = new
  •  > > >
  •  >
  • SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["dbConn
  •  > > > String"]);
  •  > > >      SqlCommand Cmd = new SqlCommand(string.Format("UPDATE dept SET
  •  > deptName
  •  > > > = '{0}', deptNote = '{1}' WHERE deptID={2}", bName.Text, bNote.Text,
  •  > > > Convert.ToInt32(dgDepartments.DataKeys[e.Item.ItemIndex])), Con);
  •  > > >      Con.Open();
  •  > > >      Cmd.ExecuteNonQuery();
  •  > > >      Con.Close();
  •  > > >      BindGrid();
  •  > > > }
  •  > > >
  •  > > > void doDelete(object sender, DataGridCommandEventArgs e)
  •  > > > {
  •  > > >      long deptID =
  •  > > > Convert.ToInt32(dgDepartments.DataKeys[e.Item.ItemIndex]);
  •  > > >      SqlConnection Con = new
  •  > > >
  •  >
  • SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["dbConn
  •  > > > String"]);
  •  > > >      SqlCommand Cmd = new SqlCommand(string.Format("DELETE FROM dept
  •  > WHERE
  •  > > > deptID={0}", deptID), Con);
  •  > > >      Con.Open();
  •  > > >      Cmd.ExecuteNonQuery();
  •  > > >      Con.Close();
  •  > > >      BindGrid();
  •  > > > }
  •  > > >
  •  > > > void doEdit(object sender,
  •  > > > System.Web.UI.WebControls.DataGridCommandEventArgs  e)
  •  > > > {
  •  > > >      dgDepartments.ShowFooter = false;
  •  > > >      dgDepartments.EditItemIndex = (int)e.Item.ItemIndex;
  •  > > >      BindGrid();
  •  > > > }
  •  > > >
  •  > > > void doCancel(object sender, DataGridCommandEventArgs e)
  •  > > > {
  •  > > >      dgDepartments.ShowFooter = true;
  •  > > >      dgDepartments.EditItemIndex = -1;
  •  > > >      BindGrid();
  •  > > > }
  •  > > >
  •  > > >
  •  > > > public void BindGrid()
  •  > > > {
  •  > > >           myCommand = new SqlDataAdapter("select * from Dept",
  •  > > > myConnection);
  •  > > >         myCommand.Fill(dsDepartments, "Dept");
  •  > > >         DataView Source = dsDepartments.Tables["Dept"].DefaultView;
  •  > > >         Source.Sort = ViewState["sortexpression"].ToString() +
  •  > > > ViewState["sortorder"].ToString();
  •  > > >         dgDepartments.DataSource=Source;
  •  > > >           Response.Write("BindGrid()");
  •  > > >         dgDepartments.DataBind();
  •  > > > }
  •  > > >
  •  > > > protected void doPage(object source,
  •  > > > System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
  •  > > > {
  •  > > >      dgDepartments.CurrentPageIndex=e.NewPageIndex;
  •  > > >      BindGrid();
  •  > > > }
  •  > > >
  •  > > > void doInsert(object sender, DataGridCommandEventArgs e)
  •  > > > {
  •  > > >   try
  •  > > >   {
  •  > > >        if (e.CommandName == "Insert" )
  •  > > >        {
  •  > > >             TextBox bName;
  •  > > >             TextBox bNote;
  •  > > >             bName =
  •  > > > (System.Web.UI.WebControls.TextBox)e.Item.FindControl("_deptName");
  •  > > >             bNote =
  •  > > > (System.Web.UI.WebControls.TextBox)e.Item.FindControl("_deptNote");
  •  > > >             SqlConnection Con = new
  •  > > >
  •  >
  • SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["dbConn
  •  > > > String"]);
  •  > > >             SqlCommand Cmd = new SqlCommand(string.Format("INSERT
  • INTO
  •  > dept
  •  > > > (deptName, deptNote) VALUES ('{0}', '{1}')", bName.Text,
  • bNote.Text),
  •  > Con);
  •  > > >             Con.Open();
  •  > > >             Cmd.ExecuteNonQuery();
  •  > > >             Con.Close();
  •  > > >             BindGrid();
  •  > > >        }
  •  > > >   }
  •  > > >   catch
  •  > > >   {
  •  > > >   }
  •  > > > }
  •  > > >
  •  > > >
  •  > > > </script>
  •  > > >
  •  > > > <head>
  •  > > > <link href="../stylesheet.css" rel="stylesheet" type="text/css">
  •  > > > </head>
  •  > > >
  •  > > > <body>
  •  > > > <H1>Departments</H1>
  •  > > > <form runat="server"  id="form1">
  •  > > > <asp:DataGrid
  •  > > >   AllowPaging="true"
  •  > > >   AllowSorting="true"
  •  > > >   AutoGenerateColumns="false"
  •  > > >   CellPadding="3"
  •  > > >   CellSpacing="0"
  •  > > >   PageSize="10"
  •  > > >   Width="100%"
  •  > > >   DataKeyField="deptID"
  •  > > >   PagerStyle-Mode="NextPrev"
  •  > > >   PagerStyle-NextPageText="Next"
  •  > > >   PagerStyle-PrevPageText="Previous"
  •  > > >   PagerStyle-HorizontalAlign="Center"
  •  > > >   PagerStyle-Position="TopAndBottom"
  •  > > >   runat="server"
  •  > > >   ID="dgDepartments"
  •  > > >   ShowFooter="true"
  •  > > >   ShowHeader="true"
  •  > > >   runat="server"
  •  > > >   OnPageIndexChanged="doPage"
  •  > > >   onUpdateCommand="doUpdate"
  •  > > >   onEditCommand="doEdit"
  •  > > >   onDeleteCommand="doDelete"
  •  > > >   onCancelCommand="doCancel"
  •  > > >   onItemCommand="doInsert"
  •  > > >   onSortCommand="doSort"
  •  > > > >
  •  > > >     <HeaderStyle HorizontalAlign="center" BackColor="#E8EBFD"
  •  > > > ForeColor="#3D3DB6" Font-Name="Verdana, Arial, Helvetica,
  • sans-serif"
  •  > > > Font-Bold="true" Font-Size="smaller" />
  •  > > >     <ItemStyle BackColor="#F2F2F2" Font-Name="Verdana, Arial,
  • Helvetica,
  •  > > > sans-serif" Font-Size="smaller" />
  •  > > >     <AlternatingItemStyle BackColor="#E5E5E5" Font-Name="Verdana,
  • Arial,
  •  > > > Helvetica, sans-serif" Font-Size="smaller" />
  •  > > >     <FooterStyle HorizontalAlign="left" BackColor="#E8EBFD"
  •  > > > ForeColor="#3D3DB6" Font-Name="Verdana, Arial, Helvetica,
  • sans-serif"
  •  > > > Font-Bold="true" Font-Size="smaller" />
  •  > > >     <PagerStyle BackColor="white" Font-Name="Verdana, Arial,
  • Helvetica,
  •  > > > sans-serif" Font-Size="smaller" />
  •  > > >     <Columns>
  •  > > >      <asp:templatecolumn HeaderText="ID" Visible="true"
  •  > > > SortExpression="deptID">
  •  > > >           <itemtemplate>
  •  > > >                <%#DataBinder.Eval(Container.DataItem, "deptID")  %>
  •  > > >           </itemtemplate>
  •  > > >           <edititemtemplate>
  •  > > >           <%#DataBinder.Eval(Container.DataItem,"deptID") %>
  •  > > >           </edititemtemplate>
  •  > > >      </asp:templatecolumn>
  •  > > >     <asp:TemplateColumn HeaderText="Name"  SortExpression="deptName"
  •  > > >         Visible="True">
  •  > > >       <ItemTemplate>
  •  > > >           <%# DataBinder.Eval(Container.DataItem, "deptName")  %>
  •  > > > </ItemTemplate>
  •  > > >       <EditItemTemplate>
  •  > > >           <asp:textbox text='<%# DataBinder.Eval(Container.DataItem,
  •  > > > "deptName") %>' id="deptName" runat="Server" cssClass="Text" />
  •  > > >             <asp:requiredfieldvalidator runat="server" id="Name"
  •  > > > Visible="true" ControlToValidate="deptName" Enabled="true"
  •  > > > ErrorMessage="Required"
  •  > > > Display="Dynamic">Required</asp:requiredfieldvalidator>
  •  > > >       </EditItemTemplate>
  •  > > >       <footertemplate><asp:textbox id="_deptName" runat="server"
  •  > > > CssClass="Text" />
  •  > > >        <asp:requiredfieldvalidator runat="server" id="_Name"
  •  > > > ControlToValidate="_deptName" Error="Fill in a name" Enabled="true"
  •  > > > Display="Dynamic">Required</asp:requiredfieldvalidator>
  •  > > >       </footertemplate>
  •  > > >     </asp:TemplateColumn>
  •  > > >     <asp:TemplateColumn HeaderText="Note"  SortExpression="deptNote"
  •  > > >         Visible="True">
  •  > > >       <ItemTemplate>
  •  > > >           <%# DataBinder.Eval(Container.DataItem, "deptNote") %>
  •  > > > </ItemTemplate>
  •  > > >       <EditItemTemplate>
  •  > > >           <asp:textbox cssClass="Text" text='<%#
  •  > > > DataBinder.Eval(Container.DataItem, "deptNote") %>' id="deptNote"
  •  > > > runat="server" />
  •  > > >           </EditItemTemplate>
  •  > > >             <footertemplate>
  •  > > >              <asp:textbox id="_deptNote" runat="server"
  • CssClass="Text"
  •  > />
  •  > > >             </footertemplate>
  •  > > >     </asp:TemplateColumn>
  •  > > >      <asp:templatecolumn HeaderText="Edit">
  •  > > >           <itemtemplate><asp:button CssClass="Text"
  • CommandName="edit"
  •  > > > runat="server"  CausesValidation="false" ID="edit"
  •  > > > Text="Edit"/> <asp:button CssClass="Text" CommandName="delete"
  •  > > > runat="server" ID="delete" Text="Delete" /></itemtemplate>
  •  > > >           <edititemtemplate><asp:button CssClass="Text"
  •  > CommandName="update"
  •  > > > runat="server" CausesValidation="true" ID="update" Text="Save"
  •  > > > /> <asp:button CssClass="Text" CommandName="cancel" runat="server"
  •  > > > CausesValidation="false" ID="cancel"
  • Text="Cancel"/></edititemtemplate>
  •  > > >           <footertemplate><asp:button CssClass="Text" Commandname =
  •  > "Insert"
  •  > > > runat="server" ID="add" Text="Add" /></footertemplate>
  •  > > >      </asp:templatecolumn>
  •  > > >     </Columns>
  •  > > >   </asp:DataGrid>
  •  > > > </form>
  •  > > > </body>
  •  > > > </html>
  •  > > > 
    • >
    >
    >
    > --
    > LUIS ESTEBAN VALENCIA
    > MICROSOFT DCE 3.
    > MIEMBRO ACTIVO DE ALIANZADEV
    > http://spaces.msn.com/members/extremed/
    >
    >
    >

    Nov 19 '05 #5

    This discussion thread is closed

    Start new discussion

    Replies have been disabled for this discussion.

    Similar topics
    Datagrid events inside a user control
    reply views Thread by Daniel Armstrong | last post: by
    DataGrid Inside Repeater
    7 posts views Thread by Scott Schluer | last post: by
    validators subset
    1 post views Thread by news.microsoft.com | last post: by
    validators in panel
    4 posts views Thread by jobz | last post: by
    Datagrid update command - and validators
    3 posts views Thread by John Blair | last post: by
    Why Custom Validators WON'T work in FoxFire?
    5 posts views Thread by Jason | last post: by
    Validators and client side script
    2 posts views Thread by Mike Surcouf | last post: by
    Vb.net
    1 post views Thread by Korara | last post: by
    BYTES.COM © 2022
    About Us
    Advertise
    Terms Of Use
    Privacy Policy
    Manage Cookies
    Contact Us
    Sitemap

    Follow us! Get the Latest Bytes Updates
    By using this site, you agree to our Privacy Policy and Terms of Use.