SqlDataAdapter类(ado.net) [英] SqlDataAdapter class (ado.net)

问题描述

我正在尝试为sql连接和数据适配器创建一个类，这样我就可以在所有站点中使用它，而不必一直重复，而且我在从页面调用它时也遇到了问题.抱歉，我是ado.net的新用户.
我建立了连接，并且工作正常，但我认为这不是建立连接的最佳方法.

I am trying to make a class for sql connection and data adapter so i can use it in all the site without repeating it all the time, also i have a problem with calling it from the page. sorry i am new in ado.net.
I made the connection and it works fine ,but i don''t think it''s the best way to make it.

public static SqlConnection OpenConnection()
    {
      
        SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["MyLocal"].ConnectionString);

       try
        {
            sqlConn.Open();
            
            sqlConn.Close();
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.Message);

           
        }
            
        return sqlConn;
    }

数据适配器

data adapter

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

/// <summary>
/// Summary description for DB
/// </summary>
public class DB
{
   // private SqlConnection sqlConn; 
	public DB()
	{
		//
		// TODO: Add constructor logic here
		//
	}

    public static DataSet DataReader(DataSet dataset,
     string connectionString, string queryString)
    {
        using (SqlConnection connection =
            new SqlConnection(ConfigurationManager.ConnectionStrings["MyLocal"].ConnectionString;))
        {
            SqlDataAdapter adapter = new SqlDataAdapter();
            adapter.SelectCommand = new SqlCommand(
                queryString, connection);
            adapter.Fill(dataset);
            return dataset;
        }
    }

这是我在其他页面中的代码

HERE IS MY CODE IN OTHER PAGE

public partial class Idea : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        this.Master.HighlightMenu = "Customers";

        
      // Open Connection
      //  DB.OpenConnection();
        DB.OpenConnection();
        
           
            string sql = "SELECT * FROM Customer Order by LastName, FirstName";

            //Declare a SQL Adapter
            SqlDataAdapter da = new SqlDataAdapter(sql, DB.OpenConnection());

            //Declare a DataTable
            DataTable dt = new DataTable();

            //Populate the DataTable
            da.Fill(dt);

            //Bind the Listview
            lv.DataSource = dt;
            lv.DataBind();

            dt.Dispose();
            da.Dispose();
            DB.OpenConnection().Close();}

推荐答案

为什么要重新创建轮子? 数据访问应用程序块 [

Why recreate the wheel? Data Access Application Block[^]

这篇关于SqlDataAdapter类(ado.net)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！