You should really parameterise your command. What you have here, if it worked, is suseptable to an injection attack.
cmdSql = New SqlCommand("Select * From Peripheral WHERE PCID=@PCID", myConnection)
cmdSql.Parameters.Add("@PCID",SqlDbType.VarChar, 10).Value = Tpcid
The above is much safer. (Remember to change the SqlDbType and field length values as appropriate)
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell Not getting the response you want from a question asked in an online forum: How to Ask Questions the Smart Way!