WPF listview 如何绑定 Oracle 数据库 以及不错的oralceHelper.cs 文件

今天搞了搞 WPF 中 listview 绑定数据库的方法！网上找了不少资料看看了，半天找不到一个合适直接解决问题的！

不过从各个版本中找到了几种可能解决方法！

可以先看看这个人的方法吧：http://www.cnblogs.com/xiaokang088/archive/2010/12/30/1922181.html；

看不懂，实现不了？！

那就接着往下看吧。。。

看看这个人的能不能帮你解决问题：http://blog.csdn.net/xiaodenanhai/article/details/8706274

卧槽，怎么都不行？！！

接着看，Xaml前台文件：

<Window x:Class="WpfTest.MainWindow"        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"        Title="MainWindow" Height="321" Width="417">  <Grid>        <Grid.ColumnDefinitions>            <ColumnDefinition Width="395*" />            <ColumnDefinition Width="0*" />        </Grid.ColumnDefinitions>        <ListView Height="262" Margin="0,0,0,8" VerticalAlignment="Bottom" ItemsSource="{Binding}" Name="listView2" HorizontalAlignment="Center">            <ListView.View>                <GridView>                    <GridViewColumn Header="用户名" DisplayMemberBinding="{Binding Path=LOGINNAME}"  Width="100" />                    <GridViewColumn Header="登录名" DisplayMemberBinding="{Binding Path=USERNAME}" Width="100"/>                    <GridViewColumn Header="身份证" DisplayMemberBinding="{Binding Path=IDCARD}" Width="100"/>                    <GridViewColumn Header="权限" DisplayMemberBinding="{Binding Path=ROLEID}" Width="100"/>                </GridView>            </ListView.View>        </ListView>    </Grid></Window>

Xaml后台文件：

using System.Windows;using System.Data;using System.Data.OleDb;namespace WpfTest{    /// <summary>    /// MainWindow.xaml 的交互逻辑    /// </summary>    public partial class MainWindow : Window    {               public MainWindow()        {            InitializeComponent();            getData();                  }       // SqlDataAdapter sda;              void getData()        {           // OleDbDataReader dr;          //  OleDbDataAdapter odda;            DataTable dt = new DataTable();            DataSet ds=new DataSet();            string sqlstr = "select LOGINNAME,USERNAME,IDCARD,ROLEID from t_user";            OleDbParameter[] param = new OleDbParameter[]{            };            dt = OracleHelper.ExecuteDataTable("Data Source=orcl;User Id=root;Password=root;Unicode=True", CommandType.Text, sqlstr, null);            listView2.ItemsSource = dt.DefaultView;        }    }}

OracleHelper.cs 

.netFrameWork4.0 下 添加 OracleClient.dll （微软已过期了）或者来个更这是的装一个odp.net 

using System;using System.Configuration;using System.Data;using System.Collections;using System.Data.OleDb;using System.Data.SqlClient;  using System.Data.OracleClient;namespace WpfTest{         public abstract class OracleHelper    {        public static readonly string TwHotelConnString = "Provider=msdaora;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))(CONNECT_DATA=(sid =orcl)));User Id=root;Password=root;Unicode=True";                 private static Hashtable parmCache = Hashtable.Synchronized(new Hashtable());        public static int ExecuteNonQuery(string connectionString, CommandType cmdType, string cmdText, params OracleParameter[] commandParameters)        {            OracleCommand cmd = new OracleCommand();            using (OracleConnection conn = new OracleConnection(connectionString))            {                PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters);                int val = cmd.ExecuteNonQuery();                cmd.Parameters.Clear();                return val;            }        }        public static DataTable ExecuteDataTable(string connectionString, CommandType cmdType, string cmdText, params OracleParameter[] commandParameters)        {            OracleCommand cmd = new OracleCommand();            OracleConnection conn = new OracleConnection(connectionString);            try            {                PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters);                                OracleDataAdapter da = new OracleDataAdapter();                DataTable dt = new DataTable();                                da.SelectCommand = cmd;                da.Fill(dt);                return dt;            }            finally            {                conn.Close();            }        }        public static DataSet ExecuteDataSet(string connectionString, CommandType cmdType, string cmdText, params OracleParameter[] commandParameters)        {            OracleCommand cmd = new OracleCommand();            OracleConnection conn = new OracleConnection(connectionString);            try            {                PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters);                OracleDataAdapter da = new OracleDataAdapter();                DataSet ds = new DataSet();                da.SelectCommand = cmd;                da.Fill(ds);                return ds;            }            finally            {                conn.Close();            }        }        public static int ExecuteNonQuery(OracleConnection connection, CommandType cmdType, string cmdText, params OracleParameter[] commandParameters)        {            OracleCommand cmd = new OracleCommand();            PrepareCommand(cmd, connection, null, cmdType, cmdText, commandParameters);            int val = cmd.ExecuteNonQuery();            cmd.Parameters.Clear();            connection.Close();            return val;        }        public static int ExecuteNonQuery(OracleTransaction trans, CommandType cmdType, string cmdText, params OracleParameter[] commandParameters)        {            OracleCommand cmd = new OracleCommand();            PrepareCommand(cmd, trans.Connection, trans, cmdType, cmdText, commandParameters);            int val = cmd.ExecuteNonQuery();            cmd.Parameters.Clear();            trans.Connection.Close();            return val;        }        public static OracleDataReader ExecuteReader(string connectionString, CommandType cmdType, string cmdText, params OracleParameter[] commandParameters)        {            OracleCommand cmd = new OracleCommand();            OracleConnection conn = new OracleConnection(connectionString);            try            {                PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters);                OracleDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);                cmd.Parameters.Clear();                return rdr;            }            catch            {              conn.Close();              throw;            }            //finally            //{            //  conn.Close();            //}        }        public static object ExecuteScalar(string connectionString, CommandType cmdType, string cmdText, params OracleParameter[] commandParameters)        {            OracleCommand cmd = new OracleCommand();            using (OracleConnection connection = new OracleConnection(connectionString))            {                PrepareCommand(cmd, connection, null, cmdType, cmdText, commandParameters);                object val = cmd.ExecuteScalar();                cmd.Parameters.Clear();                return val;            }        }        public static object ExecuteScalar(OracleConnection connection, CommandType cmdType, string cmdText, params OracleParameter[] commandParameters)        {            OracleCommand cmd = new OracleCommand();            PrepareCommand(cmd, connection, null, cmdType, cmdText, commandParameters);            object val = cmd.ExecuteScalar();            cmd.Parameters.Clear();            connection.Close();            return val;        }        public static void CacheParameters(string cacheKey, params OracleParameter[] commandParameters)        {            parmCache[cacheKey] = commandParameters;        }        public static OracleParameter[] GetCachedParameters(string cacheKey)        {            OracleParameter[] cachedParms = (OracleParameter[])parmCache[cacheKey];            if (cachedParms == null)                return null;            OracleParameter[] clonedParms = new OracleParameter[cachedParms.Length];            for (int i = 0, j = cachedParms.Length; i < j; i++)                clonedParms[i] = (OracleParameter)((ICloneable)cachedParms[i]).Clone();            return clonedParms;        }        private static void PrepareCommand(OracleCommand cmd, OracleConnection conn, OracleTransaction trans, CommandType cmdType, string cmdText, OracleParameter[] cmdParms)        {            if (conn.State != ConnectionState.Open)                conn.Open();            cmd.CommandTimeout = 180;            cmd.Connection = conn;            cmd.CommandText = cmdText;                      if (trans != null)                cmd.Transaction = trans;            cmd.CommandType = cmdType;            if (cmdParms != null)            {                foreach (OracleParameter parm in cmdParms)                    cmd.Parameters.Add(parm);            }        }    }}