Hi
can any one suggest me how to get categoryname based on partno , its very helpful any one to send sample code for getting cateogoryname based on partno. here i just try this code not working dsipart is parno
if (string.IsNullOrEmpty(dispPart) != true)
{
string strsql = "SELECT a.CategoryName " +
" FROM CatalogsCategory AS a INNER JOIN" +
" PartsCategory AS b ON a.CategoryID = b.CategoryID " +
" WHERE b.PartNo = " + np.PartNo.ToString();
using (IDataReader theReader = DataFunctions.ExecuteReader(CommandType.Text, SQL, NPConnection.GblConnString))
{
while (theReader.Read())
{
catcatgory = theReader.GetString(0);
}
}
bcval = bcval + catcatgory + dispPart;
Regards
Kannan.D
Edited by: kannan desikan on Jan 11, 2008 6:05 AM
Edited by: kannan desikan on Jan 11, 2008 8:19 AM
Edited by: kannan desikan on Jan 11, 2008 8:20 AM