• 时事博文
  • 文化时尚
  • 潮流娱乐
  • 生活常识
  • 健康生活
  • 旅游攻略
  • 体育风云
  • 财经博文
  • 汽车频道
  • 科技
  • 游戏
  • 女人
  • 互联网
  • 军事博览
  • 个性推荐
  • 当前位置: 精彩博文网 > 时事博文 > 正文

    ASP.NET复习资料_ASP.NET连SQL7接口源代码

    时间:2018-08-15 16:43:08 来源:精彩博文网 本文已影响 精彩博文网手机站

    The following example shows what a simple 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 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()

    mandText = "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();

    mandText = "SELECT CategoryID, CategoryName FROM Categories";

    nwindConn.Open();

    SqlDataReader myReader = catCMD.ExecuteReader();

    while (myReader.Read())

    {

    Console.WriteLine("t{0}t{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()

    mandText = "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();

    mandText = "SELECT CategoryID, CategoryName FROM Categories";

    nwindConn.Open();

    OleDbDataReader myReader = catCMD.ExecuteReader();

    while (myReader.Read())

    {

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

    }

    myReader.Close();

    nwindConn.Close();

    }

    }

    • 时事博文
    • 文化时尚
    • 潮流娱乐
    • 科技
    • 游戏
    • 女人
    • 个性推荐