如何获取url的参数值,并将其插入到数据表项中.
当前页面的url是
http:\\localhost:49267\info.aspx?id=1
以下是连接数据库配置代码
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:T_dwgzConnectionString %>"
DeleteCommand="DELETE FROM [info] WHERE [infoid] = @infoid"
InsertCommand="INSERT INTO [info] ([id], [l1]) VALUES (@id, @l1)"
SelectCommand="SELECT [id], [l1], [infoid] FROM [info] WHERE ([id] = @id)"
UpdateCommand="UPDATE [info] SET [id] = @id, [l1] = @l1 WHERE [infoid] = @infoid">
请问,在InsertCommand="INSERT INTO [info] ([id], [l1]) VALUES (@id, @l1)" 中,
我如何才能将@id,取url中最后一位的数字1并插入到数据表列id中呢?要求:尽可能少的修改代码.