progress openedge odbc connection string c#
C#
using System;
using System.Data;
using System.Data.Odbc;
public class TestConnect
{
public static void Main(string[] args)
{
//The connection string assumes there is a DSN named sports for a Progress database.
//Alternatively, a DSN-less connection string could be used in its place. See article# 000022406 for more details.
string connectionString = "DSN=sports;" +
"UID=sysprogress;" +
"PWD=x";
IDbConnection dbconn;
dbconn = new OdbcConnection(connectionString);
dbconn.Open();
IDbCommand dbcmd = dbconn.CreateCommand();
string sqlstr = "SELECT country,name FROM pub.customer";
dbcmd.CommandText = sqlstr;
IDataReader reader = dbcmd.ExecuteReader();
while(reader.Read()) {
string country = (string) reader["country"];
string name = (string) reader["name"];
Console.WriteLine("Customer : " + name + " country is: " + country );
}
reader.Close();
reader = null;
dbcmd.Dispose();
dbcmd = null;
dbconn.Close();
dbconn = null;
}
}
Also in C#:
- Title
- unity reset scene
- Category
- C#
- Title
- c# MD5.Create returning nul
- Category
- C#
- Title
- escape double quotes c#
- Category
- C#
- Title
- how to find object by ag unity
- Category
- C#
- Title
- c# remove spaces from string
- Category
- C#
- Title
- Failed to retrieve Firebase Instance Id
- Category
- C#
- Title
- c# reverse list
- Category
- C#
- Title
- asp net mvc 5 return view from another controller
- Category
- C#
- Title
- out parameters c#
- Category
- C#
- Title
- asp.net c# set session timeout
- Category
- C#
- Title
- c# linq join multiple conditions
- Category
- C#
- Title
- xamarin forms alarm
- Category
- C#
- Title
- C# .net core convert int to enum
- Category
- C#
- Title
- internal c#
- Category
- C#
- Title
- loop over enum values
- Category
- C#
- Title
- unity coroutine
- Category
- C#
- Title
- unity vector3 smoothdamp not reaching target
- Category
- C#
- Title
- how to use more than one condition in ef join
- Category
- C#
- Title
- how to stop a form c#
- Category
- C#
- Title
- zip file ignoring directory starting with dot
- Category
- C#
- Title
- how to convert int to string unity c#
- Category
- C#
- Title
- add new page to site c# programmatically
- Category
- C#
- Title
- how to convert string to bool c#
- Category
- C#
- Title
- c# remove character from string at index
- Category
- C#
- Title
- c# console writeline color
- Category
- C#
- Title
- unity docs player input
- Category
- C#
- Title
- __dopostback
- Category
- C#
- Title
- unity 2d rotate towards direction
- Category
- C#
- Title
- bytes size c#
- Category
- C#
- Title
- c# relaxed boolean cast
- Category
- C#
- Title
- try catch c#
- Category
- C#
- Title
- The type or namespace name 'Scrollbar' could not be found
- Category
- C#
- Title
- c# random number between 0 and 1
- Category
- C#
- Title
- C# get object property name
- Category
- C#
- Title
- class selector to property in asp net core dropdown
- Category
- C#
- Title
- c# split a string and return list
- Category
- C#
- Title
- how to cast list to observablecollection c#
- Category
- C#
- Title
- list c#
- Category
- C#
- Title
- c# clear list items
- Category
- C#
- Title
- sort datatable c#
- Category
- C#
- Title
- unity resources load
- Category
- C#
- Title
- how do loops on C#
- Category
- C#
- Title
- how to reload app.config file at runtime in c#
- Category
- C#
- Title
- linq foreach c#
- Category
- C#
- Title
- c# form set auto scale
- Category
- C#
- Title
- message uwp c#
- Category
- C#
- Title
- c# Authorization has been denied for this request
- Category
- C#
- Title
- set rotation to velocity unity
- Category
- C#
- Title
- C# sprint key
- Category
- C#
- Title
- unity get decimal part of float
- Category
- C#
- Title
- socket in c#
- Category
- C#
- Title
- get waht is differnt between two arrays c#
- Category
- C#
- Title
- c# try catch error
- Category
- C#
- Title
- how to trigger event when a com device is connected in c#
- Category
- C#
- Title
- animator hash in unity
- Category
- C#
- Title
- invalidoperationexception c# ui thread
- Category
- C#
- Title
- as c#
- Category
- C#
- Title
- Category
- C#
- Title
- unity make a int arry with preset values
- Category
- C#
- Title
- unity set list of strings
- Category
- C#
- Title
- .net core cli
- Category
- C#
- Title
- convert base64 string to string c#
- Category
- C#
- Title
- unity 2d joystick controls
- Category
- C#
- Title
- onmouseclick unity
- Category
- C#
- Title
- c# 2 timespan return yesterday
- Category
- C#
- Title
- attribute usage c#
- Category
- C#
- Title
- leantween move ui
- Category
- C#
- Title
- c# access session in class
- Category
- C#
- Title
- unity load scene
- Category
- C#
- Title
- how to add a componet to a gameobject throgh code unity
- Category
- C#
- Title
- c# merge two lists as queryable
- Category
- C#
- Title
- c# discord bot
- Category
- C#
- Title
- c# make request to rest api
- Category
- C#
- Title
- c# mixed multidimensional array
- Category
- C#
- Title
- move character unity
- Category
- C#
- Title
- c# property get set
- Category
- C#
- Title
- unity timer with miliseconds
- Category
- C#
- Title
- list of vectors c#
- Category
- C#
- Title
- visual studio clear text script
- Category
- C#
- Title
- initialise icollection c#
- Category
- C#
- Title
- c# variable
- Category
- C#
- Title
- nullable unique constraint ef
- Category
- C#
- Title
- wpf datatrigger enum binding
- Category
- C#
- Title
- how to put double quotes in a string c#
- Category
- C#
- Title
- get random value from list c#
- Category
- C#
- Title
- how to get odd saturday in a month in c#
- Category
- C#
- Title
- c# print
- Category
- C#
- Title
- populate combobox from array c#
- Category
- C#
- Title
- unity custom update
- Category
- C#
- Title
- using serial port in c#
- Category
- C#
- Title
- c# verify in class exist in list
- Category
- C#
- Title
- response redirect new tab
- Category
- C#
- Title
- C# assigning image location
- Category
- C#
- Title
- eventos c#
- Category
- C#
- Title
- check if multiple variables are null c#
- Category
- C#
- Title
- print content of array c#
- Category
- C#
- Title
- c# read excel file
- Category
- C#
- Title
- how to change scenes in unity
- Category
- C#
- Title
- c# exit program
- Category
- C#
- Title
- load information with txt file to uwp c#
- Category
- C#