grid view help me plz.......

Posted Date: 15 Apr 2008 Posted By:: balamurugan Member Level: Gold Member Rank: 1458 Points: 2 Responses: 2

the above coding is edit inside of gridview.but through one error is as
System.Data.SqlClient.SqlException: Procedure or function fun_update has too many arguments specified.

code is

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" AutoGenerateEditButton="True"
DataSourceID="SqlDataSource1" Style="z-index: 100; left: 328px; position: absolute;
top: 104px" Width="320px">
<Columns>
<asp:BoundField DataField="username" HeaderText="username" SortExpression="username" />
<asp:BoundField DataField="password" HeaderText="password" SortExpression="password" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:masterConnectionString3 %>"
SelectCommand="SELECT * FROM [test]" UpdateCommand="fun_update" UpdateCommandType="StoredProcedure" ConflictDetection="CompareAllValues">
<UpdateParameters>
<asp:Parameter Name="uname" Type="string" />
<asp:Parameter Name="password" Type="string" />

</UpdateParameters>
</asp:SqlDataSource>

how to clear the error

Responses

#215221 Author: karthik Member Level: Gold Member Rank: 137 Date: 15/Apr/2008 Rating: Points: 2
fun_update is ur SP. is it give me ur input and SP

#215224 Author: vipul Member Level: Gold Member Rank: 43 Date: 15/Apr/2008 Rating: Points: 2
hi, plz check your sp where you pass parameter in which you how many paramete you pass and check code side how many parameter you passed. if it is same pararmeter then plz display here your sp and gridview code so i can say anything. Thanks & Regards Patel Vipul Developer Heaven

Post Reply

This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.

	Next : asp.net application on mobile browsers
	Previous : how to compare textboxvalues with entered values
	Return to Discussion Forum
	Post New Message
	Category:

Related Messages

Follow us on Twitter: https://twitter.com/dotnetspider

Active Members
Today

Last 7 Days

baskar (298)
Asheej T K (173)
Ultimaterengan (167)

more...

Awards & Gifts

Email subscription