使用sqlserver从sqldatareader获取数据

本文介绍了使用sqlserver从sqldatareader获取数据的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

大家好，

我是C＃的新手。我试图使用返回类型为'SqlDataReader'的函数填充datareader但不幸的是它给出了一些错误。任何建议都会非常感激。

谢谢，

Akky

Hi guys,
I am new to C#. I am trying to fill a datareader using a function with return type as 'SqlDataReader' but unfortunately its giving some error. Any advice would be really appreciated.
Thanks,
Akky

public static void Main(string[] args)
       {

           SqlDataReader dr = Program.hello("select top 10 firstName,lastName from DimCustomer");
           while (dr.Read())
           {
               Console.WriteLine(dr.GetValue(0));
           }
           Console.ReadLine();

       }
       public static SqlDataReader hello(string query)
       {
           SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=adventure_works;Integrated Security=true;");
           SqlCommand cmd = new SqlCommand(query, con);
           con.Open();
           SqlDataReader dr = cmd.ExecuteReader();
           con.Close();
           return dr;
       }

推荐答案

using System;
using System.Data.SqlClient;

namespace RestApp
{
    class Program
    {
        public static void Main(string[] args)
        {

            SqlDataReader dr = Program.hello("select top 10 firstName,lastName from DimCustomer");
            while (dr.Read())
            {
                Console.WriteLine(dr.GetValue(0));
            }
            Console.ReadLine();

        }
        public static SqlDataReader hello(string query)
        {
            SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=adventure_works;Integrated Security=true;");
            SqlCommand cmd = new SqlCommand(query, con);
            con.Open();
            SqlDataReader dr = cmd.ExecuteReader();

            return dr;
        }
    }


}

class Program
{
    static SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=adventure_works;Integrated Security=true;");
    public static void Main(string[] args)
    {

        SqlDataReader dr = Program.hello("select top 10 firstName,lastName from DimCustomer");
        while (dr.Read())
        {
            Console.WriteLine(dr.GetValue(0));
        }
        con.Close();
        Console.ReadLine();

    }
    public static SqlDataReader hello(string query)
    {

        SqlCommand cmd = new SqlCommand(query, con);
        con.Open();
        SqlDataReader dr = cmd.ExecuteReader();

        return dr;

    }
}

while (reader.Read())
{

      // Do something with rows
     for( int i = 0; i < reader.FieldCount; i++ ){
     }
//... or
     string field = (string)reader["column1"];
}

详情请参阅这些链接

[]

[]

这篇关于使用sqlserver从sqldatareader获取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！