where is wrong,please? unconnect SqlServer or logon error!

ahui_net 2002-11-08 03:00:29

<%@ Import namespace="System.Data"%>
<%@ Import namespace="System.Data.SqlClient"%>

<html>
<head>
<style>
body,td,table,tr,p{font-size:12px;}
input,select{font-size:10px;position:relative;top:1px;}
</style>
<script language="C#" runat="server">
protected void Page_Load(Object sender,EventArgs e){
SqlConnection myConnection = new SqlConnection("server=(local);database=TestSql;Trusted_Connection=yes");
SqlDataAdapter myCommand = new SqlDataAdapter("select * from names",myConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds,"names");
MyDataGrid.DataSource=ds.Tables["Categories"].DefaultView;
MyDataGrid.DataBind();
}
</script>
</head>
<body>
<center>
<ASP:DataGrid id="MyDataGrid" runat="server"
AutoGenerateColumns="False"
BackColor="#CCCCFF"
borderCoror="black"
Showfooter="False"
CellPadding=3
Cellspacing="0"
Font-Name="Verdana"
Font-Size="12px"
HeaderStyle-BackColor="#aaaadd"
EnableViewState="false">
</asp:DataGrid>
</center>
</body>
</html>

行 13： SqlDataAdapter myCommand = new SqlDataAdapter("select * from names",myConnection);
行 14： DataSet ds = new DataSet();
行 15： myCommand.Fill(ds,"names");
行 16： MyDataGrid.DataSource=ds.Tables["Categories"].DefaultView;
行 17： MyDataGrid.DataBind();

SqlServer List

Data-Base name:TestSql
Table name:names
field: name(string) sex(string)

...全文

51 3 打赏收藏转发到动态举报

写回复

用AI写文章

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

saucer 2002-11-10

打赏
举报

1. you need to use a same table name:

myCommand.Fill(ds,"names");
MyDataGrid.DataSource=ds.Tables["Categories"].DefaultView;
======>
myCommand.Fill(ds,"names");
MyDataGrid.DataSource=ds.Tables["names"].DefaultView;

2.do not recommend
"server=(local);database=TestSql;Trusted_Connection=yes;"

use SQL Authentication instead:
"server=(local);database=TestSql;UID=YourDBLoginID;PWD=YourDBPassword;"

3. by the way, you do not have any templates in asp:datagrid, you might want to set
AutoGenerateColumns="true"

ahui_net 2002-11-08