网站首页  汉语字词  英语词汇  考试资料  写作素材  旧版资料

请输入您要查询的考试资料：

　

标题 asp.net连sql7接口源代码
内容
    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(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()
    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(t{0}t{1}, myreader.getint32(0), myreader.getstring(1));
    }
    myreader.close();
    nwindconn.close();
    }
    }
随便看

　

在线学习网考试资料包含高考、自考、专升本考试、人事考试、公务员考试、大学生村官考试、特岗教师招聘考试、事业单位招聘考试、企业人才招聘、银行招聘、教师招聘、农村信用社招聘、各类资格证书考试等各类考试资料。

　

Copyright © 2002-2024 cuapp.net All Rights Reserved
更新时间：2025/5/19 12:52:35