Hi guys. I have gried view that shows me all info from the table i
made. So my SelectCommand works fine. I'v add 3 additional buttons
"new", "edit" and "delete" i'v made their query
but still have mistake by clicking it in browser. I follow from the book
Begginer to Novice 3.5 ASP C# but that's what it's shown. I know something
missing. I'v check in the net but not found how to fixed, because i use
SqlDataSource. Can you advise how to proceed from here? Here's what i did:
<asp:SqlDataSource ID="SqlDataSource5" runat="server" ProviderName="System.Data.SqlClient" ConnectionString="<%$ ConnectionStrings:ThisIsMyConnection%>"
= "SELECT * FROM
[Resident] WHERE (([FNAME] + ' ' + [LNAME] LIKE '%' + @FANDLNAME + '%'))"
Resident SET FNAME=@FNAME, LNAME=@LNAME, MobileNum=@MobileNum,
HomeNum=@HomeNum, OfficeNum=@OfficeNum, FaxNum=@FaxNum WHERE FNAME=@original_FNAME
View Complete Post