Forgive me for being confused here, but this actually won't work if you want to keep adding to the datatable based on multiple selections from the textboxes, listboxes and dropdownboxes - right? This will only populate the datagrid once and then re-populate it on each click of the Add button?
The control, when not selected, shows a comma separated list of newsletter topics. When you click the control it comes up with 4 columns of checkboxes in which you can select and deselect the newsletter topics you're interested in.
You wouldn't happen to have some html / ASP.NET markup would you (especially of the controls used within the DIV)?
The treeview is rendered as a table, so there is no easy way to get a count of nodes - the nodes are actually table rows and cells.
here is my query and i use it for making a crystal report when i run it in database MS Access it show the values but same query when i run it in sql server it show error "The text,ntext and image data type cannot be compared or sorted except when IS NULL or LIKE"
there are its datatypes TotalSale int
same datatype used in sqlserver and MS access. Plz help
SELECT Sum(b.TotalSale*b.Price) AS total, a.Category , a.[Transaction]
FROM TransactionType AS a INNER JOIN CouponTransaction AS b ON a.TransactionTypeID = b.TransactionTypeID
GROUP BY a.Category,a.[Transaction];