GridView
hi,
I hv taken a gridview And SqlDataSource in asp.net2.0.
Now i want to update my records through gridview using store porcedure.
Now my store procedure hv 4 parameters.
How i can set more than one column in DatKey i grid view .
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" AutoGenerateEditButton="True"
BackColor="White" BorderColor="#E7E7FF" BorderStyle="None" BorderWidth="1px"
CellPadding="3" DataSourceID="SqlDataSource2" GridLines="Horizontal" OnRowEditing="GridView1_RowEditing"
OnRowUpdated="GridView1_RowUpdated" OnSelectedIndexChanged="GridView1_SelectedIndexCha nged" DataKeyNames="CustId" Height="198px" Width="1027px">
<FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" />
<RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" />
<Columns>
<asp:TemplateField HeaderText="History">
<ItemTemplate>
<a href="javascript:History(1234)">History</a>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="DDLBranchName">
<ItemTemplate>
<asp:DropDownList ID="temBranch" DataSourceID="SqlDataSource1" DataTextField="BRANCHNAME" DataValueField="BRANCHID" runat="server"></asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="MFI NAME" HeaderText="Mfi Name" SortExpression="MFI NAME" />
<asp:BoundField DataField="BRANCH NAME" HeaderText="Branch Name" SortExpression="BRANCH NAME" />
<asp:BoundField DataField="APPLICANT" HeaderText="Applicant" SortExpression="APPLICANT" />
<asp:BoundField DataField="Loan Amount" HeaderText="Loan Amount" SortExpression="Loan Amount" />
<asp:BoundField DataField="Loan Date" HeaderText="Loan Date" SortExpression="Loan Date" />
<asp:BoundField DataField="Sanction Amount" HeaderText="Sanction Amount" SortExpression="Sanction Amount" />
<asp:BoundField DataField="Sanction Date" HeaderText="Sanction Date" SortExpression="Sanction Date" />
<asp:TemplateField HeaderText="LinKButtonHistory">
<ItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="server" CommandArgument='<%#Eval("Custid")%>' CommandName="ppppp" OnClientClick="History" >Link History Button</asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Right" />
<SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" />
<HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" />
<AlternatingRowStyle BackColor="#F7F7F7" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:TestJobConnectionString %>"
SelectCommand="sp_DDL_BRANCH" SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:FormParameter DefaultValue="" FormField="DropDownList1" Name="MFIID" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:TestJobConnectionString %>"
SelectCommand="sp_gdv_LMS" SelectCommandType="StoredProcedure" UpdateCommand="sp_UpdLMS" UpdateCommandType="StoredProcedure">
<SelectParameters>
<asp:FormParameter FormField="DropDownList1" Name="MFIID" Type="String" />
<asp:FormParameter DefaultValue="" FormField="DropDownList2" Name="BRANCHID" Type="String" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="MFIID" Type="String" />
<asp:Parameter Name="BRANCHID" Type="String" />
<asp:Parameter Name="CUSTID" Type="String" />
<asp:Parameter Name="SanctionAmt" Type="Decimal" />
<asp:Parameter Name="SanctionDate" Type="DateTime" />
</UpdateParameters>
</asp:SqlDataSource>
================================================
CREATE PROCEDURE sp_UpdLMS
@MFIID as char(10),
@BRANCHID as char(10),
@CUSTID as varchar(20),
@SanctionAmt as decimal(18,0),
@SanctionDate as smalldatetime
AS
BEGIN
update dbo.T_LoanMS set
SanctionDate = @SanctionDate,
SanctionAmount = @SanctionAmt
where
MFIID = @MFIID AND
BranchId = @BRANCHID AND
CustID = @CUSTID
END
GO
Can any one help me Plz.
|