这是我的程序,不过我的显示的效果不是很理想,希望大家给点帮助,数据库的数据还是可以取出来,至于显示的格式大家可以讨论一下
<%@ import NameSpace="System.Data"%>
<%@ Import Namespace="System.Data.OleDb" %>//很多书上的system.data.ado,system.data.sql在Bata2都是不可以用的,只有OleDB可以使用
<%@ Page Language="C#" Debug="true" %>
<HTML>
<HEAD>
</HEAD>
<script language="C#" runat="Server">
void Page_Load(Object sender,EventArgs E)
{
string myConnection = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist
Security Info=False;Initial Catalog=Circuit;Data Source=MyServer;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=MyServer;Use Encryption for Data=False;Tag with column collation when possible=False";//这里的myConnection可用C#自带的连接数据库的工具来自动生成,把它粘贴过来就可以了,
其中MyServer是我的SQL服务器的名称
OleDbConnection myConn = new OleDbConnection(myConnection);
string myInsertQuery = "SELECT *, Circuit_ID.* FROM Circuit_ID where Bureau_A
_ID='000001'";
OleDbCommand myOleDbCommand = new OleDbCommand(myInsertQuery);
DataSet ds=new DataSet();
OleDbDataAdapter adapter = new OleDbDataAdapter();
adapter.SelectCommand =new OleDbCommand(myInsertQuery, myConn);
adapter.Fill(ds,"Circuit_ID");
DataView dv=new DataView();
dv=ds.Tables["Circuit_ID"].DefaultView;
//myOleDbCommand.Connection = myConn;
DataGrid1.DataSource=dv;
DataGrid1.DataBind();
}
</script>
<Center>
<H1>
数据库测试网页
</H1>
<HR>
<ASP:DataGrid id="DataGrid1" runat="server" BackColor="#F4FFF4" BorderColor="B
lack" CellPadding="3" Font-Name="Verdana" Font-Size="8pt" HeaderStyle-BackColor="
#aaaadd" Font-Names="Verdana" AllowPaging="True">
<HeaderStyle BackColor="#AAAADD">
</HeaderStyle>
</ASP:DataGrid>
</Center>
</HTML>
<%@ import NameSpace="System.Data"%>
<%@ Import Namespace="System.Data.OleDb" %>//很多书上的system.data.ado,system.data.sql在Bata2都是不可以用的,只有OleDB可以使用
<%@ Page Language="C#" Debug="true" %>
<HTML>
<HEAD>
</HEAD>
<script language="C#" runat="Server">
void Page_Load(Object sender,EventArgs E)
{
string myConnection = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist
Security Info=False;Initial Catalog=Circuit;Data Source=MyServer;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=MyServer;Use Encryption for Data=False;Tag with column collation when possible=False";//这里的myConnection可用C#自带的连接数据库的工具来自动生成,把它粘贴过来就可以了,
其中MyServer是我的SQL服务器的名称
OleDbConnection myConn = new OleDbConnection(myConnection);
string myInsertQuery = "SELECT *, Circuit_ID.* FROM Circuit_ID where Bureau_A
_ID='000001'";
OleDbCommand myOleDbCommand = new OleDbCommand(myInsertQuery);
DataSet ds=new DataSet();
OleDbDataAdapter adapter = new OleDbDataAdapter();
adapter.SelectCommand =new OleDbCommand(myInsertQuery, myConn);
adapter.Fill(ds,"Circuit_ID");
DataView dv=new DataView();
dv=ds.Tables["Circuit_ID"].DefaultView;
//myOleDbCommand.Connection = myConn;
DataGrid1.DataSource=dv;
DataGrid1.DataBind();
}
</script>
<Center>
<H1>
数据库测试网页
</H1>
<HR>
<ASP:DataGrid id="DataGrid1" runat="server" BackColor="#F4FFF4" BorderColor="B
lack" CellPadding="3" Font-Name="Verdana" Font-Size="8pt" HeaderStyle-BackColor="
#aaaadd" Font-Names="Verdana" AllowPaging="True">
<HeaderStyle BackColor="#AAAADD">
</HeaderStyle>
</ASP:DataGrid>
</Center>
</HTML>
ConnStr = New SqlConnection("server=192。168。0。200";database="hello";uid="boy";pwd="1234";)
ConnStr = New SqlConnection("server=192。168。0。200;database=hello;uid=boy;pwd=1234;")
还可被替换成
<%@ Import Namespace="System.Data.SqlClient" %>
sqldataAdpater mydata=new sqldataAdpater("select * from tablename",myconn);
dataset dataset1=new dataset();
mydata.fill(dataset1,"tablename");
datagrid.datasoure=dataset1;
datagrid.databine();
这样就可以了,哪有那么烦呀。