频道栏目
首页 > 程序开发 > Web开发 > ASP.Net > 正文
ASP.NET连SQL7接口源代码
2006-07-14 07:07:30      个评论      
收藏   我要投稿
The following example shows what a simple ADO.NET application that connects to the Northwind database and returns a list of Categories would look like. The example writes the output to the console, or command prompt.

The following example shows what a simple ADO.NET application that connects to the Northwind database and returns a list of Categories. The example writes the output to the console, or command prompt.

SqlClient

[Visual Basic]

Imports System

Imports System.Data

Imports System.Data.SqlClient

Imports Microsoft.VisualBasic

Public Class Sample

Public Shared Sub Main()

Dim nwindConn As SqlConnection = New SqlConnection("Data Source=localhost;" & _

"User Id=sa;Password=pwd;Initial Catalog=northwind")

Dim catCMD As SqlCommand = nwindConn.CreateCommand()

catCMD.CommandText = "SELECT CategoryID, CategoryName FROM Categories"

nwindConn.Open()

Dim myReader As SqlDataReader = catCMD.ExecuteReader()

Do While myReader.Read()

Console.WriteLine(vbTab & "{0}" & vbTab & "{1}", myReader.GetInt32(0), myReader.GetString(1))

Loop

myReader.Close()

nwindConn.Close()

End Sub

End Class

[C#]

using System;

using System.Data;

using System.Data.SqlClient;

class Sample

{

public static void Main()

{

SqlConnection nwindConn = new SqlConnection("Data Source=localhost;User Id=sa;Password=pwd;Initial Catalog=northwind");

SqlCommand catCMD = nwindConn.CreateCommand();

catCMD.CommandText = "SELECT CategoryID, CategoryName FROM Categories";

nwindConn.Open();

SqlDataReader myReader = catCMD.ExecuteReader();

while (myReader.Read())

{

Console.WriteLine(" {0} {1}", myReader.GetInt32(0), myReader.GetString(1));

}

myReader.Close();

nwindConn.Close();

}

}

OleDb

[Visual Basic]

Imports System

Imports System.Data

Imports System.Data.OleDb

Imports Microsoft.VisualBasic

Public Class Sample

Public Shared Sub Main()

Dim nwindConn As OleDbConnection = New OleDbConnection("Provider=SQLOLEDB;Data Source=localhost;" & _

"User Id=sa;Password=pwd;Initial Catalog=northwind")

Dim catCMD As OleDbCommand = nwindConn.CreateCommand()

catCMD.CommandText = "SELECT CategoryID, CategoryName FROM Categories"

nwindConn.Open()

Dim myReader As OleDbDataReader = catCMD.ExecuteReader()

Do While myReader.Read()

Console.WriteLine(vbTab & "{0}" & vbTab & "{1}", myReader.GetInt32(0), myReader.GetString(1))

Loop

myReader.Close()

nwindConn.Close()

End Sub

End Class

[C#]

using System;

using System.Data;

using System.Data.OleDb;

class Sample

{

public static void Main()

{

OleDbConnection nwindConn = new OleDbConnection("Provider=SQLOLEDB;Data Source=localhost;User Id=sa;Password=pwd;Initial Catalog=northwind");

OleDbCommand catCMD = nwindConn.CreateCommand();

catCMD.CommandText = "SELECT CategoryID, CategoryName FROM Categories";

nwindConn.Open();

OleDbDataReader myReader = catCMD.ExecuteReader();

while (myReader.Read())

{

Console.WriteLine(" {0} {1}", myReader.GetInt32(0), myReader.GetString(1));

}

myReader.Close();

nwindConn.Close();

}

}


点击复制链接 与好友分享!回本站首页
相关TAG标签 源代码 接口
上一篇:我对.Net技术中asp.net应用的一点看法
下一篇:ASP.NET中密码保护,MD5和SHA1算法的使用
相关文章
图文推荐
点击排行

关于我们 | 联系我们 | 广告服务 | 投资合作 | 版权申明 | 在线帮助 | 网站地图 | 作品发布 | Vip技术培训 | 举报中心

版权所有: 红黑联盟--致力于做实用的IT技术学习网站