easy Excel (xls) generation using C#

use library for the https://code.google.com/p/excellibrary/ OracleConnection Conn = new OracleConnection(dbConnection.ConStr); try { Conn.Open(); String sql = ” select DIST_ID, DIST_NAME,DIST_BANG from DISTRICT order by DIST_NAME”; DataSet ds_dist = new DataSet(); OracleDataAdapter OrDataAd_dist = new OracleDataAdapter(sql, Conn); OrDataAd_dist.Fill(ds_dist); DataTable dt_dist; dt_dist Read More …

Image and Text data Conversion from Oracle to MySQL using C#

Install the Oracle Client and MySQL client for .NET The sample code ::: String ConStrOracle = “Data Source=iis;Persist Security Info=True;User ID=tmp3;Password=iis2008tmp3;Unicode=True”; OracleConnection ConnOracle = new OracleConnection(ConStrOracle); string strMysqlConnCur = ” server=localhost;user id=root;database=admission2012test”; MySqlConnection ConnMysql = new MySqlConnection(strMysqlConnCur); try { ConnOracle.Open(); Read More …

How to create image from oracle Blob file using C#

try { String ConStr = “Data Source=iis;Persist Security Info=True;User ID=tmp3;Password=iis2008tmp3;Unicode=True”; OracleConnection Conn = new OracleConnection(ConStr); Conn.Open(); string SqlStd = “select APPLICATION_SN, PHOTO, SIGNATURE from UG_APPLICANT_GENERAL_INFO”; DataSet ds = new DataSet(); DataTable dt; OracleDataAdapter OrDataAd = new OracleDataAdapter(SqlStd, Conn); OrDataAd.Fill(ds); dt Read More …