How to connect SqlDataSource Control with database, also add extra features like insert, update and delete. Here we will take some steps, these are
Step-1 : Create a SQL Table with some fields like
sno int (primaryKey, Isidentity=true)
name nvarchar(50)
address nvarchar(250)
Step-2 : Add SqlDataSource Control to Design window from toolbox
Step-3 : Select 'Configure Data Source' link using show Smart tag.
Step-4 : Select Database or ConnectionString from Dropdown menu.
Step-5 : Select Table-name from Dropdown menu also select Advanced tab.
Step-6 : Select Insert, Update and delete checkbox option.
Step-7 : Click to Test Query and Finish button
<div>
Database items
ConnectionString="<%$ ConnectionStrings:xyz %>"
DeleteCommand="DELETE FROM [emp] WHERE [sno] = @sno"
InsertCommand="INSERT INTO [emp] ([name], [address]) VALUES (@name, @address)"
SelectCommand="SELECT * FROM [emp]"
UpdateCommand="UPDATE [emp] SET [name] = @name, [address] = @address WHERE [sno] = @sno">
<DeleteParameters>
<asp:Parameter Name="sno" Type="Int32" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="name" Type="String" />
<asp:Parameter Name="address" Type="String" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="name" Type="String" />
<asp:Parameter Name="address" Type="String" />
<asp:Parameter Name="sno" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>
Step-1 : Create a SQL Table with some fields like
sno int (primaryKey, Isidentity=true)
name nvarchar(50)
address nvarchar(250)
Step-2 : Add SqlDataSource Control to Design window from toolbox
Step-3 : Select 'Configure Data Source' link using show Smart tag.
Step-4 : Select Database or ConnectionString from Dropdown menu.
Step-5 : Select Table-name from Dropdown menu also select Advanced tab.
Step-6 : Select Insert, Update and delete checkbox option.
Step-7 : Click to Test Query and Finish button
Now generate source code in page file
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<form id="form1" runat="server"><div>
Database items
<br />
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:xyz %>"
DeleteCommand="DELETE FROM [emp] WHERE [sno] = @sno"
InsertCommand="INSERT INTO [emp] ([name], [address]) VALUES (@name, @address)"
SelectCommand="SELECT * FROM [emp]"
UpdateCommand="UPDATE [emp] SET [name] = @name, [address] = @address WHERE [sno] = @sno">
<DeleteParameters>
<asp:Parameter Name="sno" Type="Int32" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="name" Type="String" />
<asp:Parameter Name="address" Type="String" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="name" Type="String" />
<asp:Parameter Name="address" Type="String" />
<asp:Parameter Name="sno" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>
</div>
</form>
</body>
</html>
</form>
</body>
</html>
Tidak ada komentar:
Posting Komentar