By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,956 Members | 1,224 Online
Bytes IT Community

Home Questions Articles Browse Topics Latest Top Members FAQ

home > topics > asp.net > questions > validators inside datagrid do not fire
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,956 IT Pros & Developers. It's quick & easy.

Validators inside datagrid do not fire

P: n/a
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
Share this Question
Share on Google+
4 Replies
P: n/a
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
    P: n/a
    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
    P: n/a
    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
    P: n/a
    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

    Replies have been disabled for this discussion.

    Question stats

    • viewed: 1808
    • replies: 4
    • date asked: Nov 19 '05
    BYTES.COM © 2020 About Bytes | Advertise on Bytes | Privacy Policy | Manage Cookies
    Sitemap | ASP.NET Answers Sitemap | ASP.NET Insights Sitemap

    Follow us to get the Latest Bytes Updates