Skip to Content
0
Former Member
Jan 11, 2008 at 04:24 AM

how to categoryname based on partno

21 Views

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