This article i will explain How to use Datacontrol In Asp.Net.
Example
| <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>Untitled Page</title> </head> <body> <form id="form1" runat="server"> <div> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource2" DataKeyNames="id"> <Columns> <asp:BoundField DataField="id" HeaderText="id" SortExpression="id" /> <asp:BoundField DataField="name" HeaderText="name" SortExpression="name" /> <asp:BoundField DataField="sirname" HeaderText="sirname" SortExpression="sirname" /> <asp:BoundField DataField="mobile" HeaderText="mobile" SortExpression="mobile" /> <asp:CommandField ButtonType="Button" HeaderText="delete" ShowDeleteButton="True" /> <asp:CommandField ButtonType="Button" HeaderText="Edit" ShowEditButton="True" /> </Columns> <FooterStyle BackColor="Red" BorderColor="#660033" /> </asp:GridView> <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:rajniConnectionString3 %>" DeleteCommand="DELETE FROM tb1 WHERE (id = @id)" SelectCommand="SELECT * FROM [tb1]" InsertCommand="INSERT INTO [tb1] ([id], [name], [sirname], [mobile]) VALUES (@id, @name, @sirname, @mobile)" UpdateCommand="UPDATE tb1 SET name = @name, sirname = @sirname, mobile = @mobile WHERE (id = @id)"> <InsertParameters> <asp:Parameter Name="id" Type="Int32" /> <asp:Parameter Name="name" Type="String" /> <asp:Parameter Name="sirname" Type="String" /> <asp:Parameter Name="mobile" Type="String" /> </InsertParameters> </asp:SqlDataSource> <br /> <br /> <br /> <br /> </div> </form> </body> </html> |
0 comments :
Post a Comment