Hi Kiley!
Let me Ask you a Question.
Does your GRIDVIEW Control anables you to view the Northwind database (tables) at all? Does any of your Controls, Like SqlDataSource controls CAN retrieve any Data from your SqlServer 2000? at all?
What Server you using? 2000/2005/or the Express one?
Seems like this Listing Must work with the sequence, with the Listing
11-15,11-16- and finally the 11-17.
...Of course you can simply Copy/Paste this code Below.
..What do you mean by can't find SQEXPRESS? directory?
You get an error from SQl 2000 server Right?
There's no SQLEXPRESS Directory, If you simply have a single SQl2000server installed on your PC :)..???
AnyWay Please provide More Info about what Sql Server You Using.
..BE more specific!
... If you cannot retrieve ANY data at all from your Sql Server(Specifically from the NorthWind database) try to REINSTALL the NorthWind data base from the beginning.
This code Works Fine Under SqlServer2005
I have checked it up a minute ago.
works fine.
Listing 11-17
/************************************************
<%@ Page Language="C#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
{
string oldExpression = GridView1.SortExpression;
string newExpression = e.SortExpression;
if (oldExpression.IndexOf(newExpression) < 0)
{
if (oldExpression.Length > 0)
e.SortExpression = newExpression + "," + oldExpression;
else
e.SortExpression = newExpression;
}
else
{
e.SortExpression = oldExpression;
}
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
<title>Listing11-17</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" Runat="server" DataSourceID="SqlDataSource1"
DataKeyNames="CustomerID" AutoGenerateColumns="False"
AllowSorting="True" OnSorting="GridView1_Sorting">
<Columns>
<asp:BoundField ReadOnly="True" HeaderText="CustomerID"
DataField="CustomerID"
SortExpression="CustomerID"></asp:BoundField>
<asp:BoundField HeaderText="CompanyName" DataField="CompanyName"
SortExpression="CompanyName"></asp:BoundField>
<asp:BoundField HeaderText="ContactName" DataField="ContactName"
SortExpression="ContactName"></asp:BoundField>
<asp:BoundField HeaderText="ContactTitle" DataField="ContactTitle"
SortExpression="ContactTitle"></asp:BoundField>
<asp:BoundField HeaderText="Address" DataField="Address"
SortExpression="Address"></asp:BoundField>
<asp:BoundField HeaderText="City" DataField="City"
SortExpression="City"></asp:BoundField>
<asp:BoundField HeaderText="Region" DataField="Region"
SortExpression="Region"></asp:BoundField>
<asp:BoundField HeaderText="PostalCode" DataField="PostalCode"
SortExpression="PostalCode"></asp:BoundField>
<asp:BoundField HeaderText="Country" DataField="Country"
SortExpression="Country"></asp:BoundField>
<asp:BoundField HeaderText="Phone" DataField="Phone"
SortExpression="Phone"></asp:BoundField>
<asp:BoundField HeaderText="Fax" DataField="Fax"
SortExpression="Fax"></asp:BoundField>
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" Runat="server"
SelectCommand="SELECT * FROM [Customers]"
ConnectionString="
<%$ ConnectionStrings:NorthWindConnectionString %>"
DataSourceMode ="DataSet"
ConflictDetection ="CompareAllValues" EnableCaching="True"
CacheKeyDependency ="MyKey" CacheDuration="Infinite">
</asp:SqlDataSource>
</div>
</form>
</body>
</html>
I Still don't know my self what is Cache Dependency,
CacheKeyDependency ="MyKey"
Since this named
Mykey I'm not sure, yep maybe I'm wrong but you can remove this one, atleast it worked fine for me.
I'm still not sure but Maybe-Maybe this cause a problem that you have.
But I also think that you better first check your Sql server, if it's allows you to retrieve ANY data at all.
Tomorrow I'll try to run this code using Sql200Server and we'll see what we got.
Web.Config Your connection string Remember
/********************************
<?xml version="1.0"?>
<!--
Note: As an alternative to hand editing this file you can use the
web admin tool to configure settings for your application. Use
the Website->Asp.Net Configuration option in Visual Studio.
A full list of settings and comments can be found in
machine.config.comments usually located in
\Windows\Microsoft.Net\Framework\v2.x\Config
-->
<configuration>
<appSettings/>
<connectionStrings>
<add name="
NorthwindConnectionString" connectionString="Data Source=MACHINEKEY;Initial Catalog=Northwind;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
<system.web>
<!--
Set compilation debug="true" to insert debugging
symbols into the compiled page. Because this
affects performance, set this value to true only
during development.
-->
<compilation debug="true"/>
<!--
The <authentication> section enables configuration
of the security authentication mode used by
ASP.NET to identify an incoming user.
-->
<authentication mode="Windows"/>
<!--
The <customErrors> section enables configuration
of what to do if/when an unhandled error occurs
during the execution of a request. Specifically,
it enables developers to configure html error pages
to be displayed in place of a error stack trace.
<customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
<error statusCode="403" redirect="NoAccess.htm" />
<error statusCode="404" redirect="FileNotFound.htm" />
</customErrors>
-->
</system.web>
</configuration>
...try to open you WEbBrowser and copy this to the AddressBox:
"C:\SQL Server 2000 Sample Databases Hit the Enter button
This will open a Window. Simply Look for this File: NORTWND.MDF Maybe it's Gone!?
Chapter 11:
