hey guys,
i have a gridview and a sqldatasource, binded with each other. and same thing i have did on my local machine, its working fine there, but on dotnetnuke site, i am unable to update records, it never updates, but working fine, on the site which dont have dotnetnuke installed... can anyone suggest is there any dotnetnuke settings exists for making this work..
Below is my GridView and SqlDataSource.
BackColor="#DEBA84" BorderColor="#DEBA84" BorderStyle="None" BorderWidth="1px"
CellPadding="3" CellSpacing="2" DataKeyNames="Title"
DataSourceID="SqlDataSource1" EnableModelValidation="True">
SortExpression="Title" />
SortExpression="PublishedDate" />
SortExpression="Published" />
SortExpression="QuoteLink" />
ConnectionString="<%$ ConnectionStrings:SiteSqlServer %>"
DeleteCommand="DELETE FROM [Quotes] WHERE [Title] = @Title"
InsertCommand="INSERT INTO [Quotes] ([Title], [PublishedDate], [Published], [QuoteLink], [Quote]) VALUES (@Title, @PublishedDate, @Published, @QuoteLink, @Quote)"
SelectCommand="SELECT [Title], [PublishedDate], [Published], [QuoteLink], [Quote] FROM [Quotes]"
UpdateCommand="UPDATE [Quotes] SET [PublishedDate] = @PublishedDate, [Published] = @Published, [QuoteLink] = @QuoteLink, [Quote] = @Quote WHERE [Title] = @Title">
Please reply as soon as possible as it is of utmost important.