Member Avatar for dmatos
dmatos 0 Newbie Poster

Hello All I'm working with a gridview control, and i chose to code it my self instead of using the wizard microsoft provides.

So i have two questions:

1- Can i use stored procedures to work with parameters so i can send some additional data to the database?

2- Can i edit the Queries that i have in the Update and Delete Commands i have in the SqlDataSource?

Example:

<asp:SqlDataSource ID="SqlDataSource" Runat="server" SelectCommand="SELECT [catCodigo], [catDescripcion], [catSite] FROM [Categorias]"
        UpdateCommand="UPDATE [Categorias] SET [catDescripcion] = @catDescripcion, [catSite] = @catSite, [catUltModificacion] = @catUltModificacion, [catModificadoPor] = @catUltModificadoPor WHERE [catCodigo] = @catCodigo"
        DeleteCommand="DELETE FROM [Categorias] WHERE [catCodigo] = @catCodigo"
        ConnectionString="<%$ ConnectionStrings:CafeteriaSIDConnectionString %>" />

Thanks in Advance!

  • 1 Contributor
  • 0 Replies
  • 44 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.