Hi,
The sql returns value since i select primary key (cannot be null), but when
i try to bind with combo box i get following error.. i cant see data. Iam
using ODBC connection from asp.net to talk to DB2 database. Any help gurus
System.Data.Odbc.OdbcException: NO_DATA - no error information available
OdbcDataReader ddDR2 = null;
OdbcConnection cn = new OdbcConnection("DSN=TeacherCert;UID=dexkme;
PWD=viji123;DBQ=db2t");
OdbcCommand ddSqlCommand2 = new OdbcCommand ("SELECT cd_district FROM
depdb.km_zip_district", cn);
cn.Open();
ddDR2 = ddSqlCommand2.ExecuteReader(CommandBehavior.CloseC onnection);
cboMajor.DataSource = ddDR2;
cboMajor.DataTextField = "cd_district";
cboMajor.DataValueField = "cd_district";
cboMajor.DataBind();
ddDR2.Close();
I have already applyed the info mentioned in microsoft kb article. It didnt
help
http://support.microsoft.com/default...;EN-US;q319243
Thanks,
Krish