THERE ARE DIFFERENT DATASOURCE CONTROL AVALIABLE IN ASP.NET-
--SQL DATASOURCE --> USE TO WORK WITH SQL SERVER, OLEDB ,ORACLE , OR ORACLE DATABASE
--OBJECT DATASOURCE--> USE TO WORK BUSINESS OBJECTS THAT MANAGES DATA
--ACCESS DATASOURCE --> USE TO WORK WITH MICROSOFT ACCESS
--XML DATASOURCE--> USE TO WORK WITH XLM FILES
--LINQ DATASOURCE -->ENABLES US TO USE LINQ, TO RETRIEVE AND MODIFY DATA FROM A DATA OBJECT
--ENTITY DATA SOURCE-->USE TO WORK WITH ENTITY DATA MODEL
--TO BIND DATA TO A DATABOUND CONTROLWE CAN MAKE USE OF
1)DATASOURCE CONTROLS
2)WITHOUT DATASOURCE CONTROLS
=================================================================
--ASPX PAGE
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="WebApplication3._Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server">
</asp:GridView>
</div>
</form>
</body>
</html>
=======================================================
--.CS PAGE
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
namespace WebApplication3
{
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string strcon = ConfigurationManager.ConnectionStrings["ConnectionStringdb"].ConnectionString;
using (SqlConnection con = new SqlConnection(strcon))
{
SqlCommand cmd = new SqlCommand("SearchEmployee", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
GridView1.DataSource = cmd.ExecuteReader();
GridView1.DataBind();
con.Close();
}
}
}
}
--WEB CONFIG
<?xml version="1.0"?>
<configuration>
<configSections>
......
....
<connectionStrings>
<add name="ConnectionStringdb" connectionString="Data Source=ANURAG-PC\SQLEXPRESS;Initial Catalog=anurag;Integrated Security=True;" providerName="System.Data.SqlClient"/>
</connectionStrings>
<!--<connectionStrings/>-->
<system.web>
--GRID POPULATES
--SO WE ARE NOT USING DATASOURCE CONTROL ...SO WE NEED TO WRITE ALL THE CODES
1)READ CONNECTION STRING
2)CREATE CONNECTION OBJECT
3)CREATE SQL COMMAND OBJECT
4)EXECUTE THE COMMAND
5)RETRIEVE AND BIND THE RESULTS TO THE DATA BOUND CONTROL
----------------------------------------------------------------------------------------------
LETS DO IT WITHOUT DATASOURCE CONTROL
--DRAG AND DROP ANOTHER GRIDVIEW CONTROL
--SQLDATASOURCE
--SQL DATA SOURCE [DRAG AND DROP]
TO THE GRIDVIEW ATTACH THE SQLDATASOURCE
DONE. THAT'S IT
But wait oops grid is not displaying the data. ....
--now if these two values are passed we get the result. [name and age]. we get the result
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionStringdb %>"
SelectCommand="SearchEmployee" SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:Parameter Name="Name" Type="String" DefaultValue="anurag" />
<asp:Parameter Name="Age" Type="Int32" DefaultValue="24" />
</SelectParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionStringdb %>"
SelectCommand="SearchEmployee" SelectCommandType="StoredProcedure" CancelSelectOnNullParameter="false">
<SelectParameters>
<asp:Parameter Name="Name" Type="String" />
<asp:Parameter Name="Age" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
No comments:
Post a Comment