User-606362864 posted
Hello,
I am new to C# and ASP.NET. I am using VS 2008. I have been trying to build a simple web page that would query iSeries using a DSN. I was able to get the connection made to the iSeries and get the data back. I am able to displaying
data returned if I request data in three columns.
For example, SELECT FName, LName, Town FROM Customer.
What I have on the ASP page is a text field where user can give the connection string Dsn=MYDSNNAME;uid=USERNAME;pwd=PASSWORD. A text field where a query can be written and a submitt button.
When submit button is clicked following code is executed:
String connectionString = txtConString.Text;
OdbcConnection conn = new OdbcConnection(connectionString);
string query = txtQuery.Text;
conn.Open();
string queryString = query;
OdbcCommand command = new OdbcCommand(queryString, conn);
OdbcDataReader rs = command.ExecuteReader();
GridView1.DataSource = rs;
GridView1.DataBind();
conn.Close();
Any assistance would be appreciated.
