微软自带报表rdlc使用之绑定数据源

//绑定数据

using System;

using System.Collections.Generic;

using System.Data;

using System.Data.SqlClient;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace Fcw.RDLC

{

public class SQLHelper

{

public static SqlConnection conn = null;

public static SqlCommand cmd = null;

public static string connstr =System.Configuration.ConfigurationSettings.AppSettings[“Connstr”].ToString();

public SQLHelper()
    { }

    #region 建立数据库连接对象
    /// <summary>
    /// 建立数据库连接
    /// </summary>
    /// <returns>返回一个数据库的连接SqlConnection对象</returns>
    public static SqlConnection init()
    {
        try
        {
            conn = new SqlConnection(connstr);
            if (conn.State != ConnectionState.Open)
            {
                conn.Open();
            }
        }
        catch (Exception e)
        {
            throw new Exception(e.Message.ToString());
        }
        return conn;
    }
    #endregion

    #region 设置SqlCommand对象
    /// <summary>
    /// 设置SqlCommand对象       
    /// </summary>
    /// <param name="cmd">SqlCommand对象 </param>
    /// <param name="cmdText">命令文本</param>
    /// <param name="cmdType">命令类型</param>
    /// <param name="cmdParms">参数集合</param>
    private static void SetCommand(SqlCommand cmd, string cmdText, CommandType cmdType, SqlParameter[] cmdParms)
    {
        cmd.Connection = conn;
        cmd.CommandText = cmdText;
        cmd.CommandType = cmdType;
        if (cmdParms != null)
        {
            cmd.Parameters.AddRange(cmdParms);
        }
    }
    #endregion

    #region 执行相应的sql语句，返回相应的DataSet对象
    /// <summary>
    /// 执行相应的sql语句，返回相应的DataSet对象
    /// </summary>
    /// <param name="sqlstr">sql语句</param>
    /// <returns>返回相应的DataSet对象</returns>
    public static DataSet GetDataSet(string sqlstr)
    {
        DataSet ds = new DataSet();
        try
        {
            init();
            SqlDataAdapter ada = new SqlDataAdapter(sqlstr, conn);
            ada.Fill(ds);
            conn.Close();
        }
        catch (Exception e)
        {
            throw new Exception(e.Message.ToString());
        }
        return ds;
    }
    #endregion

    #region 执行相应的sql语句，返回相应的DataSet对象
    /// <summary>
    /// 执行相应的sql语句，返回相应的DataSet对象
    /// </summary>
    /// <param name="sqlstr">sql语句</param>
    /// <param name="tableName">表名</param>
    /// <returns>返回相应的DataSet对象</returns>
    public static DataSet GetDataSet(string sqlstr, string tableName)
    {
        DataSet ds = new DataSet();
        try
        {
            init();
            SqlDataAdapter ada = new SqlDataAdapter(sqlstr, conn);
            ada.Fill(ds, tableName);
            conn.Close();
        }
        catch (Exception e)
        {
            throw new Exception(e.Message.ToString());
        }
        return ds;
    }
    #endregion

    #region 执行不带参数sql语句，返回一个DataTable对象
    /// <summary>
    /// 执行不带参数sql语句，返回一个DataTable对象
    /// </summary>
    /// <param name="cmdText">相应的sql语句</param>
    /// <returns>返回一个DataTable对象</returns>
    public static DataTable GetDataTable(string cmdText)
    {

        SqlDataReader reader;
        DataTable dt = new DataTable();
        try
        {
            init();
            cmd = new SqlCommand(cmdText, conn);
            reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            dt.Load(reader);
            reader.Close();
        }
        catch (Exception ex)
        {
           // throw new Exception(ex.Message.ToString());
        }
        return dt;
    }
    #endregion

    #region 执行带参数的sql语句或存储过程，返回一个DataTable对象
    /// <summary>
    /// 执行带参数的sql语句或存储过程，返回一个DataTable对象
    /// </summary>
    /// <param name="cmdText">sql语句或存储过程名</param>
    /// <param name="cmdType">命令类型</param>
    /// <param name="cmdParms">参数集合</param>
    /// <returns>返回一个DataTable对象</returns>
    public static DataTable GetDataTable(string cmdText, CommandType cmdType, SqlParameter[] cmdParms)
    {
        SqlDataReader reader;
        DataTable dt = new DataTable();
        try
        {
            init();
            cmd = new SqlCommand();
            SetCommand(cmd, cmdText, cmdType, cmdParms);
            reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            dt.Load(reader);
            reader.Close();
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message.ToString());
        }
        return dt;
    }
    #endregion

    #region 执行不带参数sql语句，返回所影响的行数
    /// <summary>
    /// 执行不带参数sql语句，返回所影响的行数
    /// </summary>
    /// <param name="cmdText">增，删，改sql语句</param>
    /// <returns>返回所影响的行数</returns>
    public static int ExecuteNonQuery(string cmdText)
    {
        int count;
        try
        {
            init();
            cmd = new SqlCommand(cmdText, conn);
            count = cmd.ExecuteNonQuery();
            conn.Close();
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message.ToString());
        }
        return count;
    }
    #endregion

    #region 执行带参数sql语句或存储过程，返回所影响的行数
    /// <summary>
    /// 执行带参数sql语句或存储过程，返回所影响的行数
    /// </summary>
    /// <param name="cmdText">带参数的sql语句和存储过程名</param>
    /// <param name="cmdType">命令类型</param>
    /// <param name="cmdParms">参数集合</param>
    /// <returns>返回所影响的行数</returns>
    public static int ExecuteNonQuery(string cmdText, CommandType cmdType, SqlParameter[] cmdParms)
    {
        int count;
        try
        {
            init();
            cmd = new SqlCommand();
            SetCommand(cmd, cmdText, cmdType, cmdParms);
            count = cmd.ExecuteNonQuery();
            cmd.Parameters.Clear();
            conn.Close();
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message.ToString());
        }
        return count;
    }
    #endregion

    #region 执行不带参数sql语句，返回一个从数据源读取数据的SqlDataReader对象
    /// <summary>
    /// 执行不带参数sql语句，返回一个从数据源读取数据的SqlDataReader对象
    /// </summary>
    /// <param name="cmdText">相应的sql语句</param>
    /// <returns>返回一个从数据源读取数据的SqlDataReader对象</returns>
    public static SqlDataReader ExecuteReader(string cmdText)
    {
        SqlDataReader reader;
        try
        {
            init();
            cmd = new SqlCommand(cmdText, conn);
            reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message.ToString());
        }
        return reader;
    }
    #endregion

    #region 执行带参数的sql语句或存储过程，返回一个从数据源读取数据的SqlDataReader对象
    /// <summary>
    /// 执行带参数的sql语句或存储过程，返回一个从数据源读取数据的SqlDataReader对象
    /// </summary>
    /// <param name="cmdText">sql语句或存储过程名</param>
    /// <param name="cmdType">命令类型</param>
    /// <param name="cmdParms">参数集合</param>
    /// <returns>返回一个从数据源读取数据的SqlDataReader对象</returns>
    public static SqlDataReader ExecuteReader(string cmdText, CommandType cmdType, SqlParameter[] cmdParms)
    {
        SqlDataReader reader;
        try
        {
            init();
            cmd = new SqlCommand();
            SetCommand(cmd, cmdText, cmdType, cmdParms);
            reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message.ToString());
        }
        return reader;
    }
    #endregion

    #region 执行不带参数sql语句,返回结果集首行首列的值object
    /// <summary>
    /// 执行不带参数sql语句,返回结果集首行首列的值object
    /// </summary>
    /// <param name="cmdText">相应的sql语句</param>
    /// <returns>返回结果集首行首列的值object</returns>
    public static object ExecuteScalar(string cmdText)
    {
        object obj;
        try
        {
            init();
            cmd = new SqlCommand(cmdText, conn);
            obj = cmd.ExecuteScalar();
            conn.Close();
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message.ToString());
        }
        return obj;
    }
    #endregion

    #region 执行带参数sql语句或存储过程,返回结果集首行首列的值object
    /// <summary>
    /// 执行带参数sql语句或存储过程,返回结果集首行首列的值object
    /// </summary>
    /// <param name="cmdText">sql语句或存储过程名</param>
    /// <param name="cmdType">命令类型</param>
    /// <param name="cmdParms">返回结果集首行首列的值object</param>
    /// <returns></returns>
    public static object ExecuteScalar(string cmdText, CommandType cmdType, SqlParameter[] cmdParms)
    {
        object obj;
        try
        {
            init();
            cmd = new SqlCommand();
            SetCommand(cmd, cmdText, cmdType, cmdParms);
            obj = cmd.ExecuteScalar();
            conn.Close();
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message.ToString());
        }
        return obj;
    }
    #endregion
}

}

//数据绑定之报表------------------------------------------------------------------------------------------------------------------

using Microsoft.Reporting.WinForms;

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

namespace Fcw.RDLC

{

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

}

private void Form1_Load(object sender, EventArgs e)
    {
        //绑定list_order
        DataTable dtorder = SQLHelper.GetDataTable(@"select o.id as orderid,o.ordercode,o.opername,o.ordername,o.comname,o.createtime,o.barcode  from fcwOrder o");
        list_order.DataSource = dtorder;
        list_order.DisplayMember = "ordercode";
        list_order.ValueMember = "ordername";
    }

    private void button1_Click(object sender, EventArgs e)
    {
        StringBuilder sb = new StringBuilder();
        //构造多选的order列表
        foreach (object obj in list_order.SelectedItems)
        {
            DataRowView drv = (DataRowView)obj;
            if(drv!=null)
            {
                sb.Append("'" + drv.Row["ordercode"].ToString() + "',");
            }
        }
        //为report绑定数据源
        if (sb.ToString().Length > 2)
        {
            string orderwhere = sb.ToString().Substring(0, sb.ToString().Length - 1);
            string strsql = @"select o.id as orderid,o.ordercode,o.opername,o.ordername,o.comname,o.createtime,o.barcode,
  d.id as detailid,d.ordercode detailordercode,d.procode,d.proname,d.promodel,d.pronum 
  from fcwOrder o
  join fcwOrderDetails d on d.ordercode=o.ordercode where o.ordercode in (" + orderwhere + ")";
            DataTable dtorder2 = SQLHelper.GetDataTable(strsql);
            reportViewer1.LocalReport.DataSources.Clear();
            reportViewer1.LocalReport.EnableExternalImages = true;
            reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("Order",dtorder2));
            reportViewer1.LocalReport.SetParameters(new ReportParameter("para_Total",dtorder2.Rows.Count.ToString()));
            reportViewer1.RefreshReport();
        }
    }
}

}

微软自带报表rdlc使用之绑定数据源

继续阅读

Unity3D中背景音乐和相关音效的添加，背景音乐暂停、停止和播放的设置

Unity游戏开发背景知识

vs编译完提示不支持尝试的执行操作

【C# MySQL】第一次使用C#对MySQL进行操作的心得

C#基础——与C#的第一次邂逅声明：IDE：第一个C#果实：Console浅析：总结：

英文月日年日期格式的实现

C# 字节数组 byte[] 快速比较算法

C# 字节数组、字符串转化字节数组转字符串字符串转字节数组字节数组转整数整数转字节数组字符串转字节字符串转数值数值转字符串

C#用Zlib压缩或解压缩字节数组

C# 比较两个字节数组是否相等

对于VS中scanf报错永久解决，创建源文件自动添加#define _CRT_SECURE_NO_WARNINGS 1

《C#高级编程》读书笔记 -索引

CQ V1.0分词bates(基于双数组tire树)—应该是目前最快的中文分词算法

C#多线程——前台线程和后台线程

C#+ArcEngine代码检测ArcEngine Runtime是否安装以及是否授权

七牛云-C#SDK-上传-前期准备