Except Query
The SQL Except clause/operator is used to combine two SELECT statements and returns rows from the first SELECT statement that are not returned by the second SELECT statement. This means EXCEPT returns only rows, which are not available in second SELECT statement.
DEMO
HTML CODING
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:TextBox ID="txtCountry" runat="server"></asp:TextBox>
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Search" />
<table><tr><td></td><td> <asp:GridView ID="GridView1" runat="server">
<AlternatingRowStyle BackColor="#9999FF" />
<HeaderStyle BackColor="#FF3300" />
<RowStyle BackColor="#FF99FF" />
</asp:GridView>
</td></tr></table>
</div>
</form>
</body>
</html>
C# CODING
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;
public partial class Default3 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["dbcon"].ToString());
con.Open();
SqlCommand cmd = new SqlCommand
("select country from country except select country from register where country='"+txtCountry.Text+"'",con);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adp.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}
}
0 comments:
Post a Comment