Monday, May 2, 2011

Define parameter for commands of SqlDataSource


Define parameter for commands of SqlDataSource by anil nain 9416077273
" runat="server">DeleteCommand="DELETE FROM [Company] WHERE [ID] = @ID"
InsertCommand="INSERT INTO [Company] ([Title], [Address]) VALUES (@Title, @Address)"

SelectCommand="SELECT [ID], [Title], [Address] FROM [Company]"
UpdateCommand="UPDATE [Company] SET [Title] = @Title, [Address] = @Address WHERE [ID] = @ID">




<%--




--%>