winston insani
Şöyle bir kodum var.string ConnectionString = ConfigurationManager. ConnectionStrings["ora"].ConnectionString; OracleConnection conn = new OracleConnection(ConnectionString); string sql = @"SELECT DISTINCT(B.MUS_K_ISIM), A.HESAP_NO FROM S_TAKIP_MUSTERI A, S_TEKLIF B WHERE A.HESAP_
Şöyle bir kodum var.
string ConnectionString = ConfigurationManager.
ConnectionStrings["ora"].ConnectionString;
OracleConnection conn = new OracleConnection(ConnectionString);
string sql = @"SELECT DISTINCT(B.MUS_K_ISIM), A.HESAP_NO
FROM S_TAKIP_MUSTERI A, S_TEKLIF B
WHERE A.HESAP_NO = B.HESAP_NO
ORDER BY B.MUS_K_ISIM";
conn.Open();
OracleCommand cmd = new OracleCommand(sql, conn);
cmd.CommandType = System.Data.CommandType.Text;
OracleDataReader dr = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
Ben OracleDataReader'dan gelen verileri nasıl Excel'e atıp export edebilirim?
string ConnectionString = ConfigurationManager.
ConnectionStrings["ora"].ConnectionString;
OracleConnection conn = new OracleConnection(ConnectionString);
string sql = @"SELECT DISTINCT(B.MUS_K_ISIM), A.HESAP_NO
FROM S_TAKIP_MUSTERI A, S_TEKLIF B
WHERE A.HESAP_NO = B.HESAP_NO
ORDER BY B.MUS_K_ISIM";
conn.Open();
OracleCommand cmd = new OracleCommand(sql, conn);
cmd.CommandType = System.Data.CommandType.Text;
OracleDataReader dr = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
Ben OracleDataReader'dan gelen verileri nasıl Excel'e atıp export edebilirim?
0
