dim conn as new SqlConnection("Provider=SQLOLEDB.1;Data Source=MySQLServer;Initial Catalog=NORTHWIND;Integrated Security=SSPI"
cnn.open'disclose
cnn.close()
cnn.open'disclose
cnn.close()
解决方案 »
- 如何获取上上级目录路径?
- 速度求救!把一段含有‘-’的字段截取成两部分?
- ASP.NET站内会员互相发信息
- !!!!!!!!!!!!!!!当我打开一个页面的时候可以获得当前系统时间,关闭页面时候如何获得当前时间呢?他们这两个时间如何计算出小时呢?
- 关于ASP。NET 内置登陆带来的一些小问题
- 求高手关于OWC11中spreadsheet插入行的解答
- 简单...关于表格的简单应用........来的都有分
- 多数据源的问题--好烦哦,为此忙了几天了!
- 我用vs添加数据连接,可是什么结果也没有???
- 如何用javascript操纵ASP。NET控件??
- 怎样收邮件
- 如何判断DataGrid中Checkbox是否选中
string ConnString="data source=local; initial catalog=本地数据库名称;uid=sa;pwd=";
SqlDataAdapter myCommand = new SqlDataAdapter("Select * From t_Table",ConnString);
DataSet ds = new DataSet();
myCommand.Fill(ds,"t_Table");
......
<%@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>