ASP.NET如何连SQL Sever string connstr="server=localhost;user id=sa;password=;database=yourdb";SqlConnection conn=new SqlConnection(connstr);conn.Open(); 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 <%@Import Namespace="System.Data.SqlClient"%><%@Import Namespace="System.Data"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><HTML> <HEAD> <title>_808</title> <meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.0"> <meta name="CODE_LANGUAGE" content="Visual Basic 7.0"> <meta name="vs_defaultClientScript" content="JavaScript"> <meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5"> <SCRIPT runat="server"> Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load '在此处放置初始化页的用户代码 Dim objConn As SqlConnection=new SqlConnection("server=localhost;uid=sa;pwd=;database=northwind") 'open connection Dim objCmd As sqlDataAdapter=new sqlDataAdapter ("select * from Customers", objConn) 'fill dataset Dim ds As DataSet = New DataSet() objCmd.Fill(ds) DataGrid1.DataSource = ds DataGrid1.DataBind() End Sub </SCRIPT> </HEAD> <body MS_POSITIONING="GridLayout"> <form id="Form1" method="post" runat="server"> <FONT face="宋体"> <asp:DataGrid id="DataGrid1" style="Z-INDEX: 101; LEFT: 13px; POSITION: absolute; TOP: 29px" runat="server" Width="356px" Height="122px" BorderColor="#CC9966" BorderStyle="None" BorderWidth="1px" BackColor="White" CellPadding="4" Font-Names="宋体" Font-Size="X-Small"> <SelectedItemStyle Font-Bold="True" ForeColor="#663399" BackColor="#FFCC66"></SelectedItemStyle> <ItemStyle ForeColor="#330099" BackColor="White"></ItemStyle> <HeaderStyle Font-Bold="True" ForeColor="#FFFFCC" BackColor="#990000"></HeaderStyle> <FooterStyle ForeColor="#330099" BackColor="#FFFFCC"></FooterStyle> <Columns> <asp:HyperLinkColumn Text=" Enter" Target="_self" NavigateUrl="dispnews.asp"></asp:HyperLinkColumn> </Columns> <PagerStyle HorizontalAlign="Center" ForeColor="#330099" BackColor="#FFFFCC"></PagerStyle> </asp:DataGrid></FONT> </form> </body></HTML> 把Sql server的验证改为Sql验证和windows混合认证,也就是通过sa登录修改连接串"server=localhost;database=default_database;user id=sa"这样就应该可以了 asp.net 权限管理如何实现 后台执行js代码问题 变量传值js传值到sql 请教:DataGrid中如何使得Text的ReadOnly属性与某个字段相绑定? 要开发一个类似于淘宝网的电子商务网站 关于datagrid全部记录删除完了只剩下一个header的问题 关于window.alert提示效果的问题 令我十分费解的问题(在线讨论) 关于对话框的问题,急!!!各位大侠帮帮忙 太简单的问题;可我不知道啊! 关于数据库的连接方法 aspx文件中如何使用变量?
<%@Import Namespace="System.Data"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<title>_808</title>
<meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.0">
<meta name="CODE_LANGUAGE" content="Visual Basic 7.0">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
<SCRIPT runat="server">
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'在此处放置初始化页的用户代码 Dim objConn As SqlConnection=new SqlConnection("server=localhost;uid=sa;pwd=;database=northwind") 'open connection
Dim objCmd As sqlDataAdapter=new sqlDataAdapter ("select * from Customers", objConn) 'fill dataset
Dim ds As DataSet = New DataSet()
objCmd.Fill(ds)
DataGrid1.DataSource = ds
DataGrid1.DataBind()
End Sub
</SCRIPT>
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<FONT face="宋体">
<asp:DataGrid id="DataGrid1" style="Z-INDEX: 101; LEFT: 13px; POSITION: absolute; TOP: 29px" runat="server" Width="356px" Height="122px" BorderColor="#CC9966" BorderStyle="None" BorderWidth="1px" BackColor="White" CellPadding="4" Font-Names="宋体" Font-Size="X-Small">
<SelectedItemStyle Font-Bold="True" ForeColor="#663399" BackColor="#FFCC66"></SelectedItemStyle>
<ItemStyle ForeColor="#330099" BackColor="White"></ItemStyle>
<HeaderStyle Font-Bold="True" ForeColor="#FFFFCC" BackColor="#990000"></HeaderStyle>
<FooterStyle ForeColor="#330099" BackColor="#FFFFCC"></FooterStyle>
<Columns>
<asp:HyperLinkColumn Text=" Enter" Target="_self" NavigateUrl="dispnews.asp"></asp:HyperLinkColumn>
</Columns>
<PagerStyle HorizontalAlign="Center" ForeColor="#330099" BackColor="#FFFFCC"></PagerStyle>
</asp:DataGrid></FONT>
</form>
</body>
</HTML>
修改连接串"server=localhost;database=default_database;user id=sa"
这样就应该可以了