PrepareAddProduct
CategoryManager CategoryManager = new categoryManager ();
DataTable dt = categoryManager.getrootcategories ();
this.dropdownList1.dataSource = DT;
this.dropdownList1.DataTextField = "categoryName";
this.dropdownList1.DATABIND ();
CategoryManager .cs
Public DataTable getrootcategories () {
SqlConnection L_SqlConnenction = New SqlConnection ();
L_SqlConnenction.connectionstring = "Workstation ID = overmind; packet size = 4096; user ID = sa; password = sa; data source = overmind; persist security info = false; initial catalog = wztj;
l_sqlconnenction.open ();
String selectcommandtext = "select * from category";
Sqlcommand l_sqlcommand = new sqlcommand (selectcommandtext, l_sqlconnenction);
DataSet DataSet = New Dataset () ;;
SqldataAdapter adapter = new sqldataadapter ();
Adapter.selectCommand = l_sqlcommand;
Adapter.Fill (Dataset, "Category");
DataTable dt = dataset.tables ["category"];
Return DT;
l_sqlconnenction.close ();
}
