I'm currently trying to create a program which is trying to get a directory i stored in a table in teradata then use the directory as a path for a unzipper of file, after i unzip the file i will save the directory name plus the zipfile name in a table again in teradata.
The problem is when i'm storing the directory plus the zipfile name it says duplicate in table... when i checked the table the directory was the only thing stored. the zipfile name connected is not stored.
Please try my code and please help me how to solve the duplication problem.
thanks you very much
P.S I tried using 2 different connections so as to try if there are changes with using one and seems no change..
CODE: TdCommand cmd = new TdCommand(); TdDataAdapter tda = new TdDataAdapter(); TdDataReader read; DataTable dt1 = new DataTable(); cmd.Connection = con; cmd.CommandType = CommandType.Text;
string dir = ""; string sqlpath = "select pathMcash from directory";//stored path in tdatabase