Oracle database

 using System;

using System.Data;

using Oracle.ManagedDataAccess.Client;


class Program

{

    static void Main()

    {

        string connectionString = "User Id=your_username;Password=your_password;Data Source=your_datasource";


        using (OracleConnection conn = new OracleConnection(connectionString))

        {

            try

            {

                conn.Open();

                Console.WriteLine("Connected to Oracle Database.");


                string query = "SELECT * FROM your_table"; // Change to your actual query


                using (OracleCommand cmd = new OracleCommand(query, conn))

                using (OracleDataReader reader = cmd.ExecuteReader())

                {

                    DataTable dataTable = new DataTable();

                    dataTable.Load(reader); // Load DataReader into DataTable


                    // Display data (optional)

                    foreach (DataRow row in dataTable.Rows)

                    {

                        foreach (var item in row.ItemArray)

                        {

                            Console.Write(item + "\t");

                        }

                        Console.WriteLine();

                    }

                }

            }

            catch (Exception ex)

            {

                Console.WriteLine("Error: " + ex.Message);

            }

        }

    }

}

----

using System;

using System.Data;

using Oracle.ManagedDataAccess.Client;


class Program

{

    static void Main()

    {

        string connString = "User Id=your_username;Password=your_password;Data Source=your_datasource";


        using (OracleConnection conn = new OracleConnection(connString))

        {

            conn.Open();

            using (OracleCommand cmd = new OracleCommand("SELECT * FROM your_table", conn))

            using (OracleDataReader reader = cmd.ExecuteReader())

            {

                DataTable dt = new DataTable();

                dt.Load(reader); // Fill DataTable with DataReader

            }

        }

    }

}

Comments

Post a Comment

Popular posts from this blog

String Program in C#

using System; using System.Linq; 1)Reverse Name String  in C# String Name="Sudam"; int Len=Name.Length-1; while(Len>=0) { Console.Write(Name[Len]); Len--; } ----------------------------------------- Output --madus ----------------------------------------- 2)Reverse Words of a String in C# string s = "I Name Is Sudam"; string[] a = s.Split(' '); int temp= a.Length - 1; while (temp >= 0) {     Console.Write(a[temp] + ' ');     temp--; } ------------------------------------------ Output --Sudam Is Name I ---------------------------------------- 3) How to Fine count how many double letters are in a string? int doubleLetters = 0; string characters = "Hello"; for (int i = 0; i < characters.Length - 1; i++) {     if (characters[i] == characters[i + 1])     {         doubleLetters++;         i++;     }     Console.WriteLine(doubleLetters); } -----------------------------------------...
Read more

CSV using XmlNode

 To create a CSV from an XmlNode in C#, you can follow these steps: 1. Parse the XML structure using XmlNode. 2. Extract the data you need from child nodes. 3. Write the CSV content using a StringBuilder or directly with StreamWriter. Here's a sample code snippet: using System; using System.IO; using System.Text; using System.Xml; public class XmlToCsvConverter {     public static void ConvertXmlNodeToCsv(XmlNode rootNode, string csvFilePath)     {         StringBuilder csvContent = new StringBuilder();         // Assuming all child nodes have the same structure         // Add header         if (rootNode.HasChildNodes)         {             XmlNode firstRow = rootNode.FirstChild;             for (int i = 0; i < firstRow.ChildNodes.Count; i++)             {     ...
Read more

Extension Method & Partial Class

  Extension - extension method allows you to add new methods in the existing class or in the structure without modifying the source code of the original type and you do not require any kind of special permission from the original type and there is no need to re-compile the original type. Partial Class- It provides a special ability to implement the functionality of a single class into multiple files and all these files are combined into a single class file when the application is compiled. A partial class is created by using a partial keyword. First(): it returns the first element from a sequence means when we query in a collection on specific criteria, if multiple elements are found in a collection of given criteria then the first element of a sequence will return. -First it can't handle the null value. var emp = Employee.GetAllEmp().Where(x => x.Name == "Ashutosh").First();   FirstOrDefault(): FirstOrDefault works same as First() does, FirstOrDefault returns the ...
Read more