I've the following scenario, a web page that dispaly a GridView using
SqlDataSource define thus:
<asp:SqlDataSou rce ID="BoardTypes " runat="server" ConnectionStrin g='<%$
ConnectionStrin gs:ConnectionSt ring %>'
SelectCommand=" SELECT BoardTypes.Boar dTypeId,
BoardTypes.Boar dTypeName, BoardTypes.Boar dTypeDescriptio n,
BoardTypes.Vali dityEndDate, BoardTypes.Vali dityStartDate,
OrganizationUni t.Name AS OrganizationalU nitName FROM BoardTypes INNER
JOIN OrganizationUni t ON OrganizationUni t.Id =
BoardTypes.Orga nizationalUnitI d WHERE (BoardTypes.IsC ancelled =
@IsCancelled)"
InsertCommand=" INSERT INTO BoardTypes(Boar dTypeName,
BoardTypeDescri ption, ValidityStartDa te, ValidityEndDate ,
OrganizationalU nitId, IsCancelled) VALUES (@BoardTypeName ,
@BoardTypeDescr iption, @ValidityStartD ate, @ValidityEndDat e,
@Organizational UnitId, 0)">
<SelectParamete rs>
<asp:Paramete r DefaultValue="f alse" Name="IsCancell ed"
Type="Boolean" />
</SelectParameter s>
<InsertParamete rs>
<asp:Paramete r Name="BoardType Name" Type="string" />
<asp:Paramete r Name="BoardType Description" Type="string"/>
<asp:Paramete r Name="ValidityS tartDate" Type="datetime" />
<asp:Paramete r Name="ValidityE ndDate" Type="datetime"/>
<asp:Paramete r Name="Organizat ionalUnitId" Type="string"/>
</InsertParameter s>
</asp:SqlDataSour ce>
I've a form that collects information about a new row and then post it
to the server. What I want to do is to take the values from the form
plus several other values that I get elsewhere, and insert them to the
database programmaticall y.
It's a dumb question, but I googled and looked in the help, and I can't
find the way to do it.
How do I pass the correct parameters? I tried InsertParameter s.Add(),
but they already exist.
Another question:
Is it possible to create a page/file where I will declare all the data
sources? My goal is to be able to reuse a data source on several
classes, I can't see an immediate way to do it, though.
